Best of the web for Alteryx , Tableau and AWS Redshift

Bookmark of the best of the web for Tableau, Alteryx and Redshift

ALTERYX

Alteryx inspire conference material

http://www.alteryx.com/inspire-2015-tracks

Crew macros – The best

http://www.chaosreignswithin.com/

Scaling Alteryx server (after 25 mins)
Alteryx gallery use case on AWS EC2

Click to access Alteryx_Analytics_Gallery_Server_Use_Case.pdf

Scaling private server

http://community.alteryx.com/t5/Engine-Works-Blog/Scaling-a-Private-Server-Five-steps-to-greater-throughput/ba-p/9991

Troubleshooting alteryx server

http://community.alteryx.com/t5/Engine-Works-Blog/Tips-and-Tools-for-Troubleshooting-Private-Server/bc-p/17992#M394

Alteryx server RunAs setting

http://community.alteryx.com/t5/Alteryx-Knowledge-Base/Run-As-Settings/ta-p/17830/message-revision/17830%3A1

Alteryx scheduler query

http://community.alteryx.com/t5/Alteryx-Knowledge-Base/Query-Scheduler-Database-from-Alteryx/ta-p/10534

Installing alteryx server with SSL
http://community.alteryx.com/t5/Alteryx-Knowledge-Base/Configuring-Alteryx-Server-for-SSL-Obtaining-and-Installing/ta-p/15577

Chained analytic apps

http://community.alteryx.com/t5/Alteryx-Knowledge-Base/Chained-Alteryx-Analytic-Applications/ta-p/7597

Developer apps

http://community.alteryx.com/t5/Engine-Works-Blog/I-Am-The-Developer-Toolset-And-So-Can-You/ba-p/11577

Dynamic incremental updates

http://blog.concentra.co.uk/2015/02/23/alteryx-perform-dynamic-incremental-data-extracts/

Consistent DNS

http://community.alteryx.com/t5/Alteryx-Knowledge-Base/Guide-to-Setting-up-Consistent-DSN-s-Alias-Manager/ta-p/17697/message-revision/17697%3A1

Alteryx setup gallery Q&A

http://community.alteryx.com/t5/Setup-Configuration/Alteryx-Gallery-Setup-amp-Administration-General-Questions/m-p/15229#M736

FTP load/unload

http://community.alteryx.com/t5/Alteryx-Knowledge-Base/FTP-UnZip-Load-Module/ta-p/1282

Producing a denormalized output

http://community.alteryx.com/t5/Data-Preparation-Blending/Producing-a-denormalised-output-from-Hierarchial-Data/m-p/5164

Pharsing an unknown number of fields

http://community.alteryx.com/t5/Alteryx-Knowledge-Base/Parsing-Data-with-Unknown-Number-of-Fields/ta-p/4695

Optimising spatial calcs 

http://community.alteryx.com/t5/Alteryx-Knowledge-Base/Alternative-to-Find-Nearest-Tool-that-Could-Help-Optimize-your/ta-p/5187
http://community.alteryx.com/t5/Alteryx-Knowledge-Base/Alteryx-Designer-Best-Practices-Spatial-Matching/ta-p/1176
Direct publishing to tableau server

http://community.alteryx.com/t5/Analytics-Blog/Publish-Data-Sources-to-Tableau-with-Alteryx-10-1/ba-p/8957

Trends in big data blending

http://community.alteryx.com/t5/Analytics-Blog/Recent-Trends-in-Big-Data-Analysis-and-Data-Blending/ba-p/4614

Alteryx pushing to tableau 9.3

http://inviso.dk/2016/fix-xml-endpoints-no-longer-available-in-tableau-server-9-3

 

Alteryx iterative macro training

https://community.alteryx.com/t5/Live-Training/Live-Training-Advanced-Macro-Development/m-p/43862#U43862

 

TABLEAU TIPS AND TRICKS

Tableau server on AWS Tips

AWS EC2 General Purpose (gp2) disks and Tableau Server: mostly awesome.

Choosing right calculation type

Choosing the right calculation type…

Jitter plots with Random function

http://ugamarkj.blogspot.com.au/2015/01/improving-jitter-plots-with-hidden.html

Tableau dual axis

http://vizwiz.blogspot.com.au/2015/12/dual-axis.html

http://kb.tableau.com/articles/knowledgebase/synchronizing-axes

Donut charts

http://vizwiz.blogspot.com.au/2014/12/donutcharts.html

Combination chart overlapping lines

http://vizwiz.blogspot.com.au/2015/12/multi-format-ref-lines.html

Exporting to csv

http://vizwiz.blogspot.com.au/2014/03/the-greatest-tableau-tip-ever-exporting.html

Tableau sorting issue fixed using index

http://www.tableau.com/learn/tutorials/on-demand/fixing-incorrect-sorts-index

Marketing attribution in tableau

https://vts.inxpo.com/scripts/Server.nxp?LASCmd=AI:1;F:SF!42000&EventKey=166559

R with Tableau

http://community.tableau.com/docs/DOC-5313

Dynamically set default values in Tableau

http://vizpainter.com/dynamically-set-default-values-for-quick-filters-in-tableau/

Stacked bars

http://vizwiz.blogspot.com.au/2015/05/stackedbars.html

Optimizing redshift with tableau

https://www.slalom.com/thinking/how-to-optimize-data-platforms-with-amazon-redshift-and-tableau


SPARK

Viacom use of spark

http://www.slideshare.net/SparkSummit/building-a-just-in-time-data-warehouse-by-dan-morris-and-jason-pohl

TABLEAU CUSTOMER STORIES

Tableau at Govt of interior

http://www.tableau.com/learn/webinars/improving-financial-reporting-department-interior?signin=bb076b83e16894163bee499a2829f1b1

Tableau is an authoring tool

http://tableaufriction.blogspot.com.au/2015/05/tableau-wasted.html

Architecture: Tableau at netflix

https://vts.inxpo.com/scripts/Server.nxp?LASCmd=AI:1;F:SF!42000&EventKey=166317

 

 

AMAZON WEBS SERVICES

AWS big data redshift blog

https://blogs.aws.amazon.com/bigdata

GPT All in AWS

http://www.itnews.com.au/cxochallenge/why-gpt-group-put-all-its-it-into-aws-401106

UTS analytics shift

http://www.itnews.com.au/news/inside-uts-data-analytics-shift-412364

 

Machine learning conference

http://mlconf.com/mlconf-2015-sf/

 

CONSULTING PAPERS

BCG Getting started with big data

https://www.bcgperspectives.com/content/articles/it_strategy_retail_how_to_get_started_with_big_data/

http://www.forbes.com/sites/baininsights/2015/04/20/to-benefit-from-big-data-resist-the-three-false-promises/

DATA SCIENCE

https://www.edx.org/course/data-science-machine-learning-essentials-microsoft-dat203x#

SPARK 

 

ORG STRUCTURES

http://iveybusinessjournal.com/publication/big-data-and-analytics-go-big-or-go-home/

https://www.bcgperspectives.com/content/commentary/digital_economy_strategic_planning_buluswar_reeves_aig_moved_evidence_based_decision_making/

Building an analytics based organisation

https://t.co/WDok4dOmbu

How the iconic went from excel to realtime customer insights

http://www.itnews.com.au/news/how-the-iconic-got-from-excel-spreadsheets-to-real-time-customer-insight-411410

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s