Course Description
My name is Kirill Eremenko and I am a Data Scientist with over 6 years of experience in finance, retail, transport and other industries. I was trained by the best analytics mentors at Deloitte Australia and today I leverage Big Data to drive business strategy, revamp customer experience and revolutionize existing operational processes.
From my Tableau course, you will straight away notice how I combine my real-life experience and academic background in Physics and Mathematics to deliver professional step-by-step coaching in the space of Data Science and Business Intelligence. I am also passionate about public speaking, and regularly present on Big Data at leading Australian universities and industry events.
Because every module of this course is independent, you can start in whatever section you wish, and you can do as much or as little as you like.
Each module provides a new data set and exercises that will challenge you so you can learn by immediately applying what you're learning.
Contents and Overview
This Tableau training begins with Tableau basics. You will navigate the software, connect it to a data file, and export a worksheet, so even beginners will feel completely at ease.
To be able to find trends in your data and make accurate forecasts, you'll learn how to work with data extracts and timeseries.
Also, to make data easier to digest, you'll tackle how to use aggregations to summarize information. You will also use granularity to ensure accurate calculations.
In order to begin visualizing data, you'll cover how to create various charts, maps, scatterplots, and interactive dashboards for each of your projects.
You'll even learn tableau data blending and joining in order to work with and present information from multiple sources.
Finally, you'll cover the latest and most advanced features of data preparation and updates in tableau 10 where you will create table calculations, treemap charts, and storylines.
By the time you complete this Tableau course, you'll be a highly proficient Tableau user. You will be using your skills as a data scientist to extract knowledge from data so you can analyze and visualize complex questions with ease.
You'll be fully prepared to collect, examine, and present data for any purpose, whether you're working with scientific data or you want to make forecasts about buying trends to increase profits.
What am I going to get from this course?
- Install Tableau Desktop
- Connect Tableau to various Datasets: Excel and CSV files
- Create Barcharts
- Create Area Charts
- Create Maps
- Create Scatterplots
- Create Piecharts
- Create Treemaps
- Create Interactive Dashboards
- Create Storylines
- Understand Types of Joins and how they work
- Work with Data Blending in Tableau
- Create Table Calculations
- Work with Parameters
- Create Dual Axis Charts
- Create Calculated Fields
- Create Calculated Fields in a Blend
- Export Results from Tableau into Powerpoint, Word, and other software
- Work with Timeseries Data (two methods)
- Creating Data Extracts in Tableau
- Understand Aggregation, Granularity, and Level of Detail
- Adding Filters and Quick Filters
- Create Data Hierarchies
- Adding Actions to Dashboards (filters & highlighting)
- Assigning Geographical Roles to Data Elements
- Advanced Data Preparation (including latest updates in Tableau 9)
- Create and use Groups
- Understand the difference between Groups and Sets
- Create and use Static Sets
- Create and use Dynamic Sets
- Combine Sets into more Sets
- Use Sets as filters
- Create Sets via Formulas
- Control Sets with Parameters
- Control Reference Lines with Parameters
- Use multiple fields in the colour property
- Create highly interactive Dashboards
- Develop an intrinsic understanding of how table calculations work
- Use Quick Table calculations
- Write your own Table calculations
- Combine multiple layers of Table Calculations
- Use Table Calculations as filters
- Use trendlines to interrogate data
- Perform Data Mining in Tableau
- Create powerful storylines for presentation to Executives
- Convert Raw Data Into Compelling Data Visualizations Using Tableau 10
Curriculum
Module 1: Part 1 Basics - Getting Started
15:41
Lecture 1
Introduction : Tableau and Course Overview
06:14
Lecture 2
Installing Tableau
04:26
Lecture 3
The First Exercise - Get Excited!
05:01
Module 2: Tableau Basics - Your First Bar Chart
51:49
Lecture 4
The Business Challenge - Who Gets the Annual Bonus?
03:43
Lecture 5
Connecting Tableau to a Data file - CSV file
06:10
Lecture 6
Navigating Tableau
08:54
Lecture 7
Creating Calculated Fields
06:27
Lecture 8
Adding Colors
07:47
Lecture 9
Adding Labels and Formatting
11:09
Lecture 10
Exporting Your Worksheet
06:26
Lecture 11
Get The Viz
01:13
Quiz 1
Tableau Basics Quiz
Module 3: Time series, Aggregation, and Filters
46:30
Lecture 12
Module Introduction
02:15
Lecture 13
Working with Data Extracts in Tableau
08:07
Lecture 14
Working with Time Series
09:42
Lecture 15
Understanding Aggregation, Granularity, and Level of Detail
09:29
Lecture 16
Creating an Area Chart and Learning About Highlighting
08:55
Lecture 17
Adding a Filter and Quick Filter
08:02
Quiz 2
Time series, Aggregation, and Filters Quiz
Module 4: Maps, Scatterplots, and Your First Dashboard
58:15
Lecture 18
Module Intro
01:14
Lecture 19
Joining Data in Tableau
10:01
Lecture 20
Creating a Map, Working with Hierarchies
11:09
Lecture 21
Creating a Scatter Plot, Applying Filters to Multiple Worksheets
10:24
Lecture 22
Let's Create Our First Dashboard!
07:25
Lecture 23
Adding an Interactive Action - Filter
08:29
Lecture 24
Adding an Interactive Action - Highlighting
09:33
Quiz 3
Maps, Scatterplots, and Your First Dashboard Quiz
Module 5: Joining and Blending Data, PLUS: Dual Axis Charts
01:17:24
Lecture 25
Module Intro
04:26
Lecture 26
Understanding How LEFT, RIGHT, INNER, and OUTER Joins Work
06:26
Lecture 27
Joins with Duplicate Values
02:41
Lecture 28
Joining on Multiple Fields
05:31
Lecture 29
Data Blending in Tableau
15:25
Lecture 30
The Showdown: Joining Data vs Blending Data in Tableau
10:57
Lecture 31
Dual Axis Chart
12:16
Lecture 32
Creating Calculated Fields in a Blend (Advanced Topic)
13:24
Lecture 33
Section Recap
06:18
Quiz 4
Joining and Blending Data, PLUS: Dual Axis Charts Quiz
Module 6: Table Calculations, Advanced Dashboards, Storytelling
01:07:13
Lecture 34
Module Intro
00:56
Lecture 35
Downloading the Dataset and Connecting Tableau
04:02
Lecture 36
Mapping: How to Set Geographical Roles
06:38
Lecture 37
Creating Table Calculations
05:09
Lecture 38
Creating Bins and Distributions
06:38
Lecture 39
Leveraging the Power of Parameters
08:00
Lecture 40
How to Create a Tree Map Chart
02:21
Lecture 41
Creating a Customer Segmentation Dashboard
06:11
Lecture 42
Advanced Dashboard Interactivity and Coloring
04:21
Lecture 43
Analyzing the Customer Segmentation Dashboard
10:57
Lecture 44
Creating a Storyline
12:00
Quiz 5
Table Calculations, Advanced Dashboards, Storytelling Quiz
Module 7: Advanced Data Preparation
39:40
Lecture 45
Module Intro
02:11
Lecture 46
What Format Your Data Should Be In
05:19
Lecture 47
Data Interpreter
11:33
Lecture 49
Splitting a Column into Multiple Columns
03:21
Lecture 50
MetaData Grid
07:04
Lecture 51
Fixing Geographical Data Errors in Tableau
07:25
Quiz 6
Advanced Data Preparation Quiz
Module 8: What's new in Tableau 10
01:18:44
Lecture 53
The Challenge: Startup Expansion Analytics
08:13
Lecture 54
Custom Territories via Groups
09:17
Lecture 55
Custom Territories via Geographic Roles
04:31
Lecture 56
Adding a Highlighter
05:48
Lecture 57
Clustering in Tableau 10
07:10
Lecture 58
Cross-Database Joins
08:22
Lecture 59
Modeling With Clusters
12:20
Lecture 60
Saving Your Clusters
03:43
Lecture 61
New Design Features
04:23
Lecture 62
New Mobile Features
04:19
Lecture 63
Section Recap
04:00
Quiz 7
What's new in Tableau 10
Module 9: Part 2 Advanced Tableau - Groups and Sets
01:25:16
Lecture 64
Module Intro
00:51
Lecture 65
Project Brief: 1,000 Startups
07:07
Lecture 66
Working with Groups
11:09
Lecture 67
Creating Static Sets
12:24
Lecture 68
Creating Dynamic Sets
07:26
Lecture 69
Combining Sets
06:02
Lecture 70
Controlling Sets With Parameters
07:18
Lecture 71
Dashboard: The Startup Quadrant
11:38
Lecture 72
Dashboard Tricks: Reference Lines, Droplines, and Tooltips
15:48
Lecture 73
Section Recap
05:33
Quiz 8
Groups and Sets Quiz
Module 10: Advanced Table Calculations
02:26:26
Lecture 74
Section Intro
01:12
Lecture 75
Project Brief: Coal Terminal Utilization Analysis
16:54
Lecture 76
Data Connection - Multiple Joins
10:30
Lecture 77
Calculated Fields vs Table Calculations
09:08
Lecture 78
Creating Advanced Table Calculations
12:55
Lecture 79
Saving a Quick Table Calculation
08:49
Lecture 80
Explicitly Specifying Direction of Computation
10:07
Lecture 81
Writing Your Own Table Calculations
19:07
Lecture 82
Adding a Second Layer Moving Average
08:18
Lecture 83
Quality Assurance For Table Calculations
13:07
Lecture 84
Trendlines for Power-Insights
14:36
Lecture 85
Creating a Storyline to Visually Present your Insights
16:13
Lecture 86
Executive Report is Ready
05:30
Quiz 9
Advanced Table Calculations
Module 11: Advanced Data Prep + Analytics In Tableau
02:06:05
Lecture 87
Section Intro
01:01
Lecture 88
Project Brief: Retail Sector Forecasts
05:01
Lecture 89
Building Box Plots in Tableau
07:21
Lecture 90
Analyzing Box Plots
13:42
Lecture 91
Working with Large Data Sources in Tableau
12:35
Lecture 92
Pivot and Split
02:43
Lecture 93
What Does Real World Retail Look Like?
11:03
Lecture 94
Primary Use Case For Data Source Filters
06:49
Lecture 95
Trendlines
10:38
Lecture 96
Data Prep Exercise
06:05
Lecture 97
Advanced Time Series Blending
15:51
Lecture 98
Calculating Sales Per Capita
10:04
Lecture 99
Forecasting in Tableau
11:24
Lecture 100
How to Present a Storyline
11:48
Quiz 10
Advanced Data Prep + Analytics In Tableau
Module 12: Creating Animations in Tableau
46:45
Lecture 101
Section Intro
01:01
Lecture 102
Project Brief: World Health Trends Investigation
05:20
Lecture 103
Editing Blending Relationships
08:08
Lecture 104
Building the Visualization
05:31
Lecture 105
Adding Animation
07:30
Lecture 106
Manually Sorting Blended Data (Advanced Technique)
03:57
Lecture 107
Leaving a Trail in Your Animations
08:58
Lecture 108
Finalizing the Dashboard
06:20
Quiz 11
Animations in Tableau Quiz
Module 13: Level of Detail Calculations (LOD)
01:36:01
Lecture 109
Section Intro
Lecture 110
Project Brief: Regional Profit Analysis
03:52
Lecture 111
Preparing the Workbook
04:30
Lecture 112
Aggregation and Granularity (refresher)
03:54
Lecture 113
LOD Calculations Intuition
10:34
Lecture 114
LOD Type 1: INCLUDE
13:21
Lecture 115
Understanding ATTR() in Tableau
07:41
Lecture 116
LOD Type 2: EXCLUDE (Part 1)
13:44
Lecture 117
LOD Type 2: EXCLUDE (Part 2)
13:49
Lecture 118
Multiple Fields in an LOD Calculation
06:27
Lecture 119
LOD Type 3: FIXED
11:49
Lecture 120
Finalizing the Visualization
06:20
Quiz 12
Level of Detail Calculations
Module 14: Conclusion & Recap
08:03
Lecture 121
Concluding Lecture
08:03
