Tableau
Tableau
A brief summary of the topics covered in this Tableau course is as below. This is 16 hours course, it is suggested to complete this course in 1 week.
Basic Visualization using Tableau
- Introduction to Tableau
- Introduction to UI Interface
- What is Data Analytics?
- Why Data Visualization?
- Why Tableau?
- Tableau vs Excel and Power BI
- Exploratory vs Explanatory Analysis
- Getting Started with Tableau
Introduction and installation
- Dashboarding & storytelling using Tableau
- Talking about Business Intelligence
- Tools and Methodologies used in BI
- Why Visualization is getting more popular
- Tableau Products
- Tableau Architecture
- BI Project Execution
- Tableau Installation in local system
- Introduction to Tableau Prep
- Tableau Prep Builder User Interface
- Data Preparation techniques using Tableau Prep Builder tool
- How to connect Tableau with different data source
Visualizing and Analyzing Data with Tableau
- Introduction
- Bar Charts
- Line Charts and Filters
- Area Charts
- Box Plots and Pivoting
- Maps and Hierarchies
- Pie Charts
- Treemaps and Grouping
- Dashboards – I
- Visual Segments
- Visual Analytics in depth
- Filters, Parameters & Sets
- Tableau Calculations using functions
- Tableau Joins
- Working with multiple data source (Data Blending)
- Building Predictive Models
- Dynamic Dashboards and Stories
- Sharing your Reports
- Tableau Server
- User Security
- Scheduling
- Joins and Splits
- Numeric and String Functions
- Logical and Date Functions
- Histograms and Parameters
- Scatter Plots
- Dual Axis Charts
- Top N Parameters and Calculated Fields
- Stacked Bar Charts
- Dashboards – II and Filter Actions
- Storytelling
- Batting Performance Analysis
- Additional Reading
- Connecting to MySQL Workbench
LOD (Level of Details)
Data Mining With Tableau
- Get the Dataset + Project Overview
- Connecting Tableau to an Excel File
- How to visualize an ad-hoc A-B test in Tableau
- Working with Aliases
- Adding a Reference Line
- Looking for anomalies
- Handy trick to validate your approach / data
- Creating bins & Visualizing distributions
- Creating a classification test for a numeric variable
- Combining two charts and working with them in Tableau
- Validating Tableau Data Mining with a Chi-Squared test
- Chi-Squared test when there is more than 2 categories
- Visualising Balance and Estimated Salary distribution
- Chi-Squared Test
- Section Recap
Data Storytelling
- Introduction to Data Storytelling
- Introduction to the Module
- Pre-Read Assignment
- What is Data Storytelling?
- Importance of Data Storytelling
- Characteristics of a Good Story with Data
- What Makes Data Storytelling Difficult?
Components of a Good Story with Data
- Essential Components of a Good Story with Data
- Importance of Objective and Agenda
- Five Patterns of Insights
- Analysis Approach: Deriving New Columns
- Analysis Approach: Summarizing Rows
- Insight Overview
- Structure and Flow
- Pyramid Principle
- Visuals
- Importance of Visualization
- Visualization of Quantitative Data
- Visualization of Qualitative Variables
- Visualization of Other Types of Information
- Visualization of Advanced Analytical Techniques
Golden Rules for an Effective Data Storytelling
- Introduction
- Visual Design Principles and Storyboarding
- Best Practices for Data Storytelling
- Ideal Solution for the Home Loans Case Study