TABLEAU
-
Lesson 1 – Business Intelligence & Data Science Introduction
- What is Business Intelligence?
- Flow of Business Intelligence
-
Lesson 2 – Let’s Meet Tableau
- Gartner Architecture
- Why Tableau is everywhere?
- Gartner Magic Quadrant Review
- Tableau History – When, Where & Why
- Overview of Different Tools Of Tableau
- Setup Environment –Install Tableau
-
Lesson 3 – Deep Drive Tableau Panels
- Getting Started with Tableau
- The Tableau Interface
- Connection Panel
- Data Source Panel
- Visualization Panel
- Your first Tableau Visualization
-
Lesson 4 – Detail Insight of Data Source Panel
- Connecting to Data
- Getting Started with Data
- Connecting to Databases and Advanced Features
- Using Custom SQL
- Analyzing the Project Data Warehouse
- Table/Sheet Panel
- Schema Panel
- Preview Data Source Panel
- Manage Metadata Panel
- Data Types Of Tableau
- Types of Joins
- Types of Cardinalities
- Data Prep with Excel Files
- Splitting
- Custom Splitting
- Pivot Fields
- Data Cleansing
- Editing Data Connections and Data Sources
- Editing Metadata and Saving Data Sources
- Using and Refreshing Extracts
- Aliases
- Hide / Unhide
- Difference Between Live & Extract
- Data Blending
-
Lesson 5 - Visual Insight
- Getting Started with Visual Analytics
- Different Panels of Visualization
- Dimension
- Measure
- Row Shelf
- Column Shelf
- Swap Row/Columns
- Colors of Pills
- Discrete & Continuous
- “Show Me” tool
- Hierarchies
- Date Hierarchy
- Different way of Sorting
- Grouping
- Visual Grouping
- Creating Sets
- Combined Sets
- Working with Bins
- Ways to Filter
- Using the Filter Shelf
- Difference Between Data Source and Visualization Filter
- Quick Filters
- General Filter
- Wildcard Filter
- Condition Filter
- Filtering for Top and Top N
- Context Filter
- Parameters
- Color
- Size
- Detail
- Tool Tip
- Label
-
Lesson 6 - Visual Analytics
- Reference Lines
- Reference Band
- Distribution Band
- Per Table / Per Pane / Per Cell
- Average Line / Constant Line
- Trend Lines
- Forecasting
- Worksheet Actions
- Filter Action
-
Lesson 7 - Maps
- Getting Started with Mapping
- Maps in Tableau
- Using Latitude & Longitude
- Playing with Various Features of Layers
- Unrecognized Locations
- Resolving Unrecognized Locations
-
Lesson 8 - Playing with Calculations
- Getting Started with Calculations
- Calculation Syntax
- Logical / Conditional Calculations
- Arithmetic Calculations
- Aggregate Calculations
- Date Calculations
- Number Calculations
- String Calculations
- LOD Calculation (Include / Exclude / Fixed)
- Quick Table Calculations
- Calculation based on Quick Table Calculations
-
Lesson 9 - Dashboards and Stories
- Getting Started with Dashboards and Stories
- Building a Dashboard
- Image Component
- Text Component
- Web Page Component
- Tile & Floating
- Dashboard Layouts and Formattings
- Relationship between WS, D, S
- Dashboard Interactivity using Actions
- Highlight Action
- URL Action
- Filter Action
- Select, Hover, Menu
- “Clearing the selection will” option
- Dashboard Best Practices
- Story Points
-
Lesson 10 – Different Type of Charts
- Vertical Bar Chart
- Horizontal Bar Chart
- Stacked Bar Chart
- Graduated Color Bar Chart
- Bar In Bar Chart
- Line Chart
- Multiple Lines Chart
- Graduated Color Line Chart
- Area Chart
- Stacked Area Chart
- Unstacked Area Chart
- Forecast Chart
- Single Pie Chart
- Multiple Pie Chart
- Pie Mark Type Chart
- Crosstab W/Total
- Crosstab Measure Color Coded
- Crosstab Dimension Color Coded
- Crosstab Measure Names/Values
- Scatter Plot
- Disaggregated Scatter Plot
- Small Multiple Scatter Plot
- Bubble (Scatter Plot Mod)
- Bubble (New)
- Tree Map
- Word Cloud
-
Lesson 11 – Publishing & Projects
- Tableau Online
- Publish Dashboard Contents
- Projects
- Submitting Interview Questions
-
Lesson 12 – Final Conclusion
- Interview Tips
- IT Companies Project Flow
- Agile/Scrum & Waterfall