Business intelligent study

July 9, 2016

  Julia spent over years to work on Microsoft Excel, powerpivot table and vertipaq engine to do data analysis. Now, she likes to do some study on Tableau:

  She could not recall the engine name - vertipaq, so she googled and then found this article -
1. http://searchsqlserver.techtarget.com/feature/Importing-SQL-Server-data-into-PowerPivot-for-Excel


Tableau - Spend a few hours to read and then learn something about Tableau products:

Read blogs:
2. http://www.36dsj.com/archives/42081

Take some notes here from the blog:
Business intelligence (BI)

a list of features: "A B C D E S"

1. A = Automation
   To collect, analyze data, it takes time to work on

2. B = Big Data
   Hadoop based
Tableau supports Hadoop, Spark.

3. C = Complex Analysis  - Include Machine Learning, predictive modeling

4.  D = Data Integration/ Connection

5. E = Easy-to-use.

6. W = Workflow Embedded

3.
http://www.36dsj.com/archives/46378

4. Learn how to read a  graph using Tableau:
Sankey Diagram:
  Others call DecisionTree/ Flow Diagram/ Alluvial Diagram

http://www.36dsj.com/archives/22337

http://www.36dsj.com/archives/16647

5. Podcast - Tableau - Vancouver
http://www.vancouvertechpodcast.ca/episodes/41291-episode-33-tableau-software

Last 20 minutes, Jesse Calderon talked about everything about Tableau - how team works together, how new project is organized etc. 
6.  A lot of great insights - how to think about venture capital/ product/ problem solving? 
https://www.youtube.com/watch?v=d8o20TP7270
7. Tableau - Visual Analysis
https://www.youtube.com/watch?v=hoAbjerDak4

Podcast: Microsoft Canada project manager talk:
http://www.vancouvertechpodcast.ca/episodes/40343-episode-31-microsoft#0:27:53