This course aims to teach learners how to analyze and visualize data using Tableau, a popular tool for creating interactive dashboards and custom reports. By the end of the course, students will be able to create visualizations and dashboards, work with different types of data calculations, refine visualizations, analyze trends and distributions, and share data stories effectively. The course covers topics such as row-level and aggregate calculations, table calculations, and advanced Tableau tips and tricks. The intended audience for this course includes data analysts, business intelligence professionals, and individuals working with Big Data regularly. The teaching method involves a 4-part series that progressively builds on Tableau skills, with hands-on exercises and practical examples to enhance learning.
Overview
Syllabus
Start
Introduction
Introduction to Moving to Advanced Visualizations
Dimensions, Measures, Discrete, and Continuous
Comparing Values Across Dimensions with Crosstabs
Changing the Data Type of a Date to Date-Time
Changing the Date Format in Workbooks
More on Discrete and Continuous
Percentage of Total National Sales Made in Each Region
Adding Distribution Bands to Visualizations
Viewing Actual Value of Distribution Percentages
Using Dual Axis to Display Differing Scales
Moving to Advanced Visualizations Recap
Introduction to Row-Level and Aggregate Calculations
Three Levels of Calculation
Creating Row-Level Calculations
Creating Aggregate Calculations
Changing Measure to Continuous
Adding Another Measure and Dimension for More Detail
Changing Visualization Type and Line Colors
Displaying More Granularity in Visualizations
Changing Background Colors
Changing Filter Body Colors
Creating and Duplicating Parameters
Creating and Duplicating Calculated Fields Referencing Parameters
Creating Visualizations with Calculated Fields
Updating Labels Based on Parameter Choices
Creating Key Performance Indicators - Step 1
Creating Key Performance Indicators - Step 2
Creating Key Performance Indicators - Step 3
Creating Ad-Hoc Calculations
Performance Considerations
Row-Level and Aggregate Calculations Recap
Introduction to Table Calculations
Quick Table Calculations Available in Tableau
Using Quick Table Calculations
Table Calculations - Scope, Partitioning, Direction, and Addressing
Creating Table Calculations - Difference From
Creating Custom Number Formats for Tables
Creating Sheets with Raw Data to Compare to Running Total Quick Calculations
Creating Table Calculations Using Specific Dimensions
Creating Table Calculations - Changing the Addressing
Creating Table Calculations with Secondary Calculations
Table Calculations Recap
Conclusion
Taught by
Learnit Training
