Technical Links
Tableau
public.tableau.com – Tips and Tricks
drawingwithnumbers.artisart.org
theinformationlab.co.uk/2011/09/23/blue-things-and-green-things/ – Forget the red pill Neo, understand the blue and green pills!
- Blue = Discrete, Tableau Header
- Green = Continuous, Axis
steineranalytics.com/2014/05/04/3-ways-to-organize-data-in-tableau-groups-hierarchies-and-sets/ – Groups, Hierarchies and Sets
breaking-bi.blogspot.com/2013/05/what-if-analysis-in-tableau.html – Great example of a Tableau What If Scenario
kb.tableausoftware.com/articles/knowledgebase/using-table-calculations – Table calculations are a powerful feature of Tableau, take the time to understand table|across|down: the various permutations and pane, cell and dimension.
Wait a minute! Need a table calc? TRY LOD! http://www.tableau.com/about/blog/LOD-expressions
Alteryx
competitiveanalytics.com/alteryx-videos/
Cloudera
Cloudera Quick Start VM – VM with CDH, Cloudera Manager, Cloudera Impala, and Cloudera Search.
Cloudera Live – With a one-button deployment option, you can spin up a four-node cluster of CDH, Cloudera’s open source Hadoop platform, within minutes. This is a free, cloud-based Hadoop environment. After 14 days, you will need to pay to keep your gogrid cluster.
Cloudera Tutorial Listing – a comprehensive list.
Hue Demo- Nice when it works, but often there are issues, probably due to excessive usage of this free sand box.
HortonWorks
Horton Works Sandbox – A VM to get you up and running fast. Nice interface, easy to follow pig tutorial.
Horton Works Tutorials – a great place to start.
Hive on HDInsight – Tutorial – HDInsight on Azure – Great Primer on this Hortonworks/MS collaboration – Only requires a free azure trial subscription.
Sqoop
Hive Tips
http://www.qubole.com/5-tips-for-efficient-hive-queries/
https://speakerdeck.com/philiptromans/hive-optimisation-tips-tricks
Hive Cheat sheets and functions
http://www.qubole.com/hive-function-cheat-sheet/
http://docs.treasuredata.com/articles/hive-functions
http://www.qubole.com/wp-content/uploads/2014/01/hive-function-cheat-sheet.pdf
http://www.folkstalk.com/2011/11/data-types-in-hive.html
Pig
http://hortonworks.com/hadoop-tutorial/how-to-use-basic-pig-commands/ – The classic Horton pig tutorial, requires the HortonWorks VM or can be emulated on Cloudera VM, Qubole, MortarData or TreasureData free trials.
Lester Martin’s Blog: Look mom, no delimiters. Use Pig to load a fixed width formatted files into Hive.
Miscellaneous Hadoop
http://www.coreservlets.com/hadoop-tutorial/ – Core Servlets: Hive, Pig, Hbase and Hadoop Lessons.
http://wiki.apache.org/hadoop/HadoopJavaVersions – Important, when setting up your own cluster.
SSAS/MDX
Quick Start MDX – http://www.mssqltips.com/sqlservertip/2865/a-quick-way-to-start-learning-sql-server-mdx/
Katie and Emil build a basic cube in SSAS 2012: https://www.katieandemil.com/video-ssas-tutorial-for-beginners-basics-of-multidimensional-cube-example-ssas-2012?tab=video
SSIS
Robert Sheldon’s clear explanation of using XML config files in SSIS:
https://www.simple-talk.com/sql/ssis/xml-configuration-files-in-sql-server-integration-services/