The Complete Tableau Analyst Bootcamp 2024

Course Curriculum

Chapter 1: Introduction to Tableau

Lecture 1: What does the course cover

Lecture 2: Why use Tableau: Make your data make an impact

Lecture 3: Let's download Tableau Public

Lecture 4: Connecting data in Tableau

Lecture 5: Exploring Tableau's interface

Lecture 6: Let's create our first chart in Tableau!

Lecture 7: Duplicating a sheet

Lecture 8: Creating a table

Lecture 9: Creating custom fields

Lecture 10: Creating a custom field and adding calculations to a table

Lecture 11: Adding totals and subtotals

Lecture 12: Adding a custom calculation

Lecture 13: Inserting a filter

Lecture 14: Working with joins in Tableau

Chapter 2: Creating a Tableau Dashboard

Lecture 1: Introduction to the exercise

Lecture 2: Let's create a dashboard – Visualizing the three charts we want to create

Lecture 3: Using Joins in Tableau

Lecture 4: Performing a Numbers Check – Attempt #1

Lecture 5: Blending Data in Tableau

Lecture 6: Performing a Numbers Check – Attempt #2

Lecture 7: First chart

Lecture 8: Second chart

Lecture 9: Third Chart

Lecture 10: Creating and Formatting a Dashboard

Lecture 11: Adding Interactive Filters for Improved Analysis

Lecture 12: Interactive filters – fix

Chapter 3: Introduction To The Sign-Up Flow Optimization Analysis Case Study

Lecture 1: Motivation

Lecture 2: Understanding the 365's Sign-Up Process

Lecture 3: Basic Terminology

Lecture 4: Defining the Key Aspects of the Sign-Up Process

Lecture 5: Sketching the Story

Chapter 4: SQL: Data Retrieving

Lecture 1: Types of Data Access

Lecture 2: Getting to know the Database

Lecture 3: SQL Query 1: Sign-Up Conversion Rate

Lecture 4: SQL Query 2: Sign-Up Types and Errors – Part 1

Lecture 5: SQL Query 2: Sign-Up Types and Erros – Part 2

Lecture 6: SQL Query 3: Login Types and Errors – Homework

Chapter 5: Tableau: Dashboard Sheets And Creating The Story

Lecture 1: SQL and Tableau

Lecture 2: Sign-Up Conversion Rate

Lecture 3: Device and Operating System Distribution

Lecture 4: Preferred Devices Horizontal Bar Chart

Lecture 5: Preferred Operating System Horizontal Bar Chart

Lecture 6: Sign-Up Types and Errors Bar Chart

Lecture 7: Login Types and Errors Bar Charts – Homework

Lecture 8: Creating Dashboards: Getting Familiar with the Canvas

Lecture 9: Sign-Up Conversion Rates: Sheet Swapping with Parameters

Lecture 10: Sign-Up Conversion Rates: Containers

Lecture 11: Preferred Sign-Up Devices and Operating Systems

Lecture 12: Sign-Up Types and Errors

Lecture 13: Login Types and Errors – Homework

Lecture 14: Formatting the Tableau Story – Part 1

Lecture 15: Formatting the Tableau Story – Part 2

Chapter 6: Analysis Report and A/B Testing

Lecture 1: Dashboard Application for an Analysis Report

Lecture 2: Current State of Affairs: Observing Story Point 1 – Conversion Rate

Lecture 3: Current State of Affairs: Observing Story Point 2 – Sign-Up Types

Lecture 4: Current State of Affairs: Observing Story Point 2 – Success Rate

Lecture 5: Current State of Affairs: Observing Story Point 3 – Login Types

Lecture 6: Business Objective

Lecture 7: Hypothesis and Opportunity Sizing – Part 1

Lecture 8: Hypothesis and Opportunity Sizing – Part 2

Lecture 9: Actionable Insights Based on the Analysis

Lecture 10: Understanding the Fundamentals of A/B Testing

Lecture 11: Setting Up an A/B Test: Confidence, Significance, and p-values

Lecture 12: Setting Up an A/B Test: Minimum Detectable Effect and Statistical Power

Lecture 13: Running an A/B Test: Execution and Analysing the Results

Lecture 14: Discussion on the Observations

Chapter 7: Discussion And Further Analysis Of A Website Sign-Up Flow

Lecture 1: Conclusions and Recommendations

Chapter 8: Introduction to The Customer Churn Analysis Case Study

Lecture 1: Introduction to the business case

Lecture 2: Basic Terminology – Net Revenue, Refunds, New vs Recurring Revenue

Lecture 3: Types of customers

Lecture 4: Basic Terminology – Customer Churn and Customer Retention

Lecture 5: Defining key questions for the customer churn analysis

Lecture 6: Creating an outline of the dashboard

Lecture 7: Query 1 – Net Revenue

Lecture 8: How to export data from Workbench

Lecture 9: Query 2 – User Resurrections and how to export data from Workbench

Chapter 9: Creating a Customer Churn Story in Tableau

Lecture 1: Bar Chart – Net Revenue and Refunds

Lecture 2: Charts Formatting: Styling Tips for Business Dashboards in Tableau

Lecture 3: Customer Churn—Line Chart in Tableau

Lecture 4: Telling a Story with Data: Create a Dashboard to Add to the Tableau Story

Lecture 5: New vs Recurring Revenue—Combination Charts in Tableau

Lecture 6: Revenue by Country—Map Charts in Tableau

Lecture 7: Top 10 Countries by Revenue—Tables in Tableau

Lecture 8: Chart Formatting and Creating the Dashboard in Tableau

Lecture 9: User Resurrections – Bubble Chart in Tableau

Lecture 10: User Resurrections – Bar Chart in Tableau

Lecture 11: Assignment 2 – User Upgrades Bubble and Bar Chart

Lecture 12: Building the Tableau Dashboard – Page 5

Lecture 13: Annual Subscribers – Order Frequency Combination Chart in Tableau

Lecture 14: Annual Subscribers – Cohort Analysis Table in Tableau