1. Tableau
- Tableau Software is an American interactive data visualization software company founded in January 2003 by Christian Chabot, Pat Hanrahan and Chris Stolte, in Mountain View, California. The company is currently headquartered in Seattle, Washington, United States focused on business intelligence
- Recently Sales Force acquired it
- Source : Wikipedia
2. Key Products of Tableau
- Tableau Desktop
- Tableau Server
- Tableau Online
- Tableau Reader
- Tableau Public
Recently, they launched below:
- Tableau Catalog
- Tableau Prep
3. Latest version of Tableau & its features
- 2020.2 – Latest version as of May, 16th 2020
- https://www.tableau.com/products/new-features
- Relationships
- Metrics
- Set Control
4. Types of Filters
A filter restricts data , it shows the exact data that we want for our analysis. They are of 3 types:
- Quick Filter
- Context Filter
- Data Source Filter
Other filters that are available on top of above these 3 concepts are below:
- Extract Filter
- Dimension Filter
- Measure Filter
- Table Calculation Filter
5. Order of operations for Filters
- Extract Filter
- Data Source Filter
- Context Filter
- Dimension Filter
- Measure Filter
- Table Calculation Filter
6. Dimensions Filter Modes
- Single Value (List)
- Single Value (Drop Down)
- Single Value (Slider)
- Multiple Values (List)
- Multiple Values (Drop Down)
- Multiple Values (Custom List)
- Wildcard Match
7. Measure Filter Modes
- Range of Values/Dates
- At Least/Starting Date
- At Most/Ending Date
- Relative to Now
- Browse Periods
8. Connect to PDF – Is it possible ?
Can we connect to PDF as source in Tableau ? YES
Connect à PDF File à Select the PDF which has Table within it à Page Picker appears to select whole document or specific page or range of page à “Use Data Interpreter” for better wrangling of PDF Data
Help : https://www.tableau.com/learn/tutorials/on-demand/connecting-pdfs?playlist=484036
9. Maximum Number of Tables we can join in Tableau
32 Tables
10. What are Dimensions & Facts ?
- Dimensions are descriptive text columns or Dates
- Example : Category, Product, Item, Customer, Transaction Date
- Facts are measures or numerical values
- Example : Profit, Revenue, Net Sales, # of Customers, # of Orders
Enjoy Reading & Learning!!