DATA WAREHOUSING CONCEPTS – Class 0 (Complimentary)
•Basic data warehousing sessions
•Slowly changing dimensions
•Data marts
•Normalization denormalization
Tableau Class 1 - Introduction to Data Visualization with Tableau
Learning Objectives - In this module, you will learn about Data Visualization and Introduction to Tableau.
Topics -
•Why is Data Visualization needed
•How to make sense out of numbers
•Uses of Tableau
•Installation
•Architecture, and Features of Tableau
Tableau Class 2 – Basic Visualization design
Learning Objectives - In this module, you will learn to connect to the databases and make basic charts and graphs.
Topics -
•Exporting Data
•Connecting Sheets
•Loading into Tableau visualization engine
•Basic visualizations like Text Tables, Bar, Line, Pie charts, basic maps and interpreting the same
Tableau Class 3 – Visualizations Deep Dive
Learning Objectives - In this module, you will learn to make Advance Charts and Graphs.
Topics –
•Highlight Tables
•Heat Maps
•Circle Plots
•Side by Side Bars
•Continues Lines
•Scatter Plots
•Dual Charts
•Area Charts
•Tree Maps
•
Tableau Class 4 – Data organization and scripting
Learning Objectives - In this module, you will learn scripting functionality and organizing data for effective results.
Topics -
•Calculated Metrics
•Sorting
•Filtering
•Totals and Sub Totals
•Various Aggregated Measures
•Percentages
•Data Spotlighting
•Summary Card
•Date and time functions
•String Functions and logical functions
•Data Items
•Data behind your views
•Hierarchies
•Sets
•Groups
•Bins
•
Tableau Class 5 – The world is your visualization
Learning Objectives - In this module, you will learn about more advanced visualizations for various analytical requirements
Topics -
•Dual Charts
•Dual Axis
•Combination charts
•Gantt Charts for activity tracking
•Motion Charts
•Box and Whisker Plots
•Reference Lines
•Reference Bands
•Pareto Analysis
•Water Fall Charts
•Market Basket Analysis
Tableau Class 6 – Playing with Time dimension
Learning Objectives - In this module, you will learn to create Time based calculations.
Topics -
•Quick Table Calculations
•Custom Table Calculations
•YTD
•Parallel Period
•Moving Averages
•Running totals
•Window Averages
•Trend Lines and Predictive Models
•
Tableau Class 7 – What is your location
Learning Objectives - In this module, you will learn about location analytics capabilities to put geographic And other spatial context to your analysis.
Topics -
•Filled Maps
•Symbol Maps
•Geo Coding
•Online Maps
•Sorting in Maps
•Background Maps
Tableau Class 8 – Incremental loading and Blending
Learning Objectives - In this module, you will be learn how to blend and arrange your data from multiple source systems for effective analysis.
Topics -
•Data Blending from multiple source systems
•Custom SQL Queries
•Creating Incremental Loads
•Creating File Extractions
•Parameters
Tableau Class 9 – Analytics with Tableau and R
Learning Objectives - In this module, you will be learn how to integrate Tableau and R.
Topics -
Clustering
Forecasting
Integration with R
Tableau Class 10 – Project
Learning Objectives - In this module, you will learn how to work in real time environment for Tableau Projects. One mini project will be provided with business scenarios. Understand the requirement and creating various dashboards, story boards, deploying your dashboards for the project.
Topics -
•end-end project with Business case study
•Interactive Dashboards
•Action Filters
•Story Boards
•Best Practices
•Cover Pages
•Annotations
•Tool Tips
•Legends
•Sharing your work
•Deploying to server
•Tableau Online
•Tableau Reader
•Tableau Public