Tackling the Descriptive (What happened?) and Diagnostic Analysis (Why did it happen?)

Tableau is a BI (Business Intelligence) tool

Tableau Suite

Notes

Qualitative data is dimensions

Quantitative data is measures

The dimensions of the dataset are colored in blue. whereas the measures are colored in green

Dimensions

Measures

All measures can be aggregated and italicized ones are auto-generated

Question

Which product category has the highest sales in the East region??

Hierarchy, drill up and drill down

Data Cube: Combination of dimension and measures

Crime dataset

1. Find out the city with the highest crime rate.
2. Which city has the least crime rate?
3. Compare population of the state wrt to the crime rate and give me your insights

Tableau Architecture

1. List of Data Sources

2. Tableau Server

   1. Security
   2. Cache
   3. Repository
   4. Present
   5. Management / Automation

   VizQL server is responsible for creating the visualization