Course Description
This comprehensive workshop aims to equip participants with the necessary skills to proficiently utilize Tableau for data visualization and analytics, catering to both basic and advanced users. Each session will be instructor-led and cover a range of topics tailored to enhance Tableau proficiency.
Tableau Overview and Introduction
Overview of Tableau
Importance of Tableau in Data Analytics
Introduction to Tableau Products
Installation of Tableau Desktop
Configuration of Tableau Prep Builder
Understanding Basic Concepts: Dimensions & Measures, Discrete & Continuous, Rows & Columns
Live Vs Extract Data Sources
Data Source Filters
Utilizing Marks Labels to Enhance Information in Reports
Understanding Query Pipeline Order
Lab1: Handson Exercise (Fundamentals of reporting & Visualization)
Day 1 covers an overview and introduction to Tableau, including installation, configuration, and fundamental concepts. Participants engage in hands-on exercises to strengthen reporting and visualization skills.
Data Modelling Insights
Understanding Data Models
Layers of Data Model: Logical Vs Physical
Single & Multi-table Models
Data Model Schemas
Connecting with Different Data Sources: Planning, Data Joins, Blending, Union, Custom SQL Query, Data Pivoting
Data Source Management: Editing, Refreshing, Exporting
Advanced Data Modelling Techniques & Functions: Number, Type Conversion, Logical, Aggregate, Table Calculation
Advanced Spatial Analysis: Spatial Data Integration/Calculation, Visualization Techniques, Predictive Modelling, Clustering, Maps & Geographic Data Analysis
Lab2: Handson Exercise (Structure your data)
Day 2 focuses on data modeling insights, covering logical and physical data models, data source connections, and advanced data modeling techniques. Participants practice structuring data through hands-on exercises.
Data Preparation
Data Preparation with Tableau Prep & Desktop.
Handling NULL Values
Data Types and Conversions
Sorting and Filtering Data
Field Organization and Customization: Folders, Sorting, Renaming, Hiding, Combining
Calculated Fields
Hierarchies Creation
ETL using Tableau Prep (Design complex flows, transform data, remove inconsistencies)
Create & Configure output of prepared data.
Lab3: Handson Exercise (Combine, Shape and Clean your data)
Capstone: Project Kickoff with industry standard data covering basic to advanced features
Day 3 is dedicated to data preparation using Tableau Prep and Desktop. Participants learn techniques for handling data, creating calculated fields, and ETL processes. The day concludes with a capstone project kickoff.
Building Visuals & Dashboards
Building Common Chart Types
Combination Chart, Heat Map, Area Chart, Scatter Plot, Histogram, Bar Chart, Line Chart, Packed Bubble Chart, Pie Chart, Bullet Graph, Box Plot, Text Table
Advanced Chart Types: Pareto Chart, Calculated Column, Bins Creation
Level of Detail Expressions (LODs) & Use Cases
Groups and Sets: Fixed, Dynamic, Combined
Enhancing User Interactivity through Parameters, Page Shelf, and Advanced Filter Calculations
Interactive Filters
Lab4: Handson Exercise (Visual Analytics)
Day 4 covers the building of visuals and dashboards, exploring various chart types, advanced charting techniques, and interactivity features. Participants engage in hands-on exercises to strengthen visual analytics skills.
Mastering Visualization & Storytelling
Complete Tableau Overview
Advanced Dashboard Creation
Viewing Insights
Business Story Creation
Capstone Implementation
Presentations
Certification Roadmap
Career Counseling
Day 5 focuses on mastering visualization and storytelling, providing a complete Tableau overview, advanced dashboard creation, and insights viewing. The day concludes with the implementation of the capstone project, presentations, and guidance on certification and career paths.


Duration
Timings
Hours