Course Highlights
  • Take three full-length practice exams for the Tableau Data Analyst Certification
  • Sort, filter, slice, pivot, and graph using a Tableau Public, a free version of the market leading visualization tool.
  • Combine multiple tables using SQL joins and unions, blends and relationships
  • Create bar charts, pie charts, and line graphs.
  • Create calculated fields with conditional logic.
  • Map your data to quickly detect geographic variation.
  • Create a dynamic dashboards combining multiple worksheets.
  • Create trendlines and understand the relevant statistical metrics such as p-value and R-squared.
  • Create forecasts with prediction intervals, accounting for seasonal variability.
  • Use publicly available data to create visualizations on topics that interest you - anything from the economy to the Olympics.
  • Create regression trend lines and time-series forecasts
  • Perform analysis based on realistic business scenarios
Curriculum

7 Topics
Installing Tableau Public the free version of Tableau Desktop
Tableau Versions
A First Look at Tableau
First Hands-on Question
Solution to First Hands-on Question
Starting New Workbooks and Worksheets
Suggestions for Viewing the Course Videos

2 Topics
Download the datasets used in this course
Data Analyst Certification Study Guide

32 Topics
Explain the difference between measures and dimensions
Measures and Dimensions Quiz
Explain the difference between discrete and continuous fields
Discrete vs Continuous Quiz
Explain how to utilize Tableau-generated fields
Field Types Review
Histograms
Hands On Histogram Question
Hands-on Histogram Solution
Heat Maps & Tree Maps
Bar Charts
Hands-on Bar Chart Question
Hands-On Bar Chart Solution
Bullet Graphs
Line and Area Charts including Dual Axis Charts
Hands-On Line Graph Question
Hands-On Line Chart Solution
Combined axis charts and Dual axis charts
Scatter Plots
Hands-on Scatter Plot Question
Bar in bar charts
Box-and-Whisker Plots
Box-and-whisker plot questions
Hands-on Box-and whisker solution
Charts and Graphs Review
Charts and Graphs Review Hands-on Question Solution
Use titles captions and tooltips effectively
Titles Captions and Tooltips Quiz
Edit Axes
Edit Axes Quiz
Use mark labels and annotations
Mark Labels and Annotations Quiz

14 Topics
Intro to Mapping
Ambiguous Locations
Navigating Maps: Pan & Zoom Filter Map layering Custom territories • Search
Measuring Distance with the Radial Selection Tool
Hands-on Maps Question
Hands-On Map Solution
Hands on Map Question #2 - Distance between locations
Solution for Hands on Map Question #2 - Distance between locations
[Optional] Note on Creating DiceJobs.csv
[Optional] Map Paths
Import and Manage Custom Geocoding
Blending Geographic Data
Use a background image map
Connect to Spatial Files

11 Topics
Sorting
Hands-on Sorting Question
Solution for Hands-on Sorting Question
Filters
Filters Quiz
Filters Quiz Solution
Groups Sets and Hierarchies
Sets with Context Filters
Context Filters Quiz
Context Filters Solution
Organizing & Simplifying Data Review

20 Topics
Aggregate Calculations: Sum & Average
Hands-on Sum Question
Hands-On Sum Solution
Aggregate Calculations with the "Create a Calculated Field" Dialog Box
Ratio Calculations
Hands-on Ratio Question
Solution for Hands-On Ratio Question
Count Distinct
Hands-on Count Distinct Question
Count Distinct Solution
Date Calculations
If Statements
String Functions
Quick Table Calculations - Percents
Table Down and Table Accross
More Table Calculations - Rank Running Total & Moving Average
Totals and Subtotals
Hands on Totals Question
Calculations Review
Calculations Review Solutions

13 Topics
Fixed Level of Detail
More on Fixed Level of Detail
Hands-on Level of Detail #1
Level of Detail Solution
LOD expressions for Customer order frequency and Daily profit KPI
Hands-on Level of Detail #2
Level of Detail #2 Solutions
Percent of Total using LOD
Hands-on Level of Detail #3
Level of Detail #3 Solutions
Exclude LOD Example
Hands-on Level of Detail #4
Level of Detail #4 Solutions

26 Topics
The Data Source Page
Connect to Tableau Server
Data Source Page Questions
SQL Inner Joins
SQL Right Left and Outer Joins
Join Questions
Hand-on Join Solution
Duplication with SQL Joins
Combine Tables with Blending
Combine Tables Relationships
Relationships Questions
Appending rows with SQL Unions
SQL Union Questions
Solution for Hands-on SQL Union Question
Migrated Data (workbooks created prior to 2020.2)
Analysis with Combined Tables Part 1
Analysis with Combined Tables Part 2
Hands-on question on Analysis with Combined Tables
Solution for Hands-on question on Analysis with Combined Tables
Second Hands-on question on Analysis with Combined Tables
Solution for Second Hands-on question on Analysis with Combined Tables
Data Interpreter Pivoting and Automatic & Custom Split
Create extracts with multiple tables
Explain data extract formats and capabilities
Explain performance considerations for blends joins and cross-database joins
[Optional] Performance Optimization (topic removed from CA exam guide)

1 Topic
Creating a Dashboard

10 Topics
Intro to Trend Lines
Hands-on Trend Line Question
Solution for Hands-on Trend Line Question
P-Values
Hands On P-Value Question
Hands On P-Value Solution
Defining the Best Fit
R-Squared
Hands On R-Squared Question
Hands-On R-Squared Solution

6 Topics
Intro to Forecasting
Hands-on Forecasting Question
Displaying the Forecast Prediction Interval
Hands-on Forecasting Question - Prediction Interval
Hands-on Forecasting Question - Prediction Interval Solution
Ignore Last Month By Default

6 Topics
About the new Data Analyst Certification
Comparing the Data Analyst and Certified Associate exams
Data Analyst Practice Exam #1 Knowledge Based Questions
Data Analyst Practice Exam #1 Lab Questions
Data Analyst Practice Exam #2 Knowledge-based Questions
Data Analyst Practice Exam #2 Lab Questions

16 Topics
First Problem Set for Certification Prep
First Problem Set Review
Second Problem Set for Certification Prep
Second Problem Set Review
Third Problem Set for Certification Prep
Third Problem Set Review
[Trend Lines] Fourth Problem Set for Certification Prep
Fourth Problem Set Review
Additional Data for Problem Set 5
Fifth Problem Set for Certification Prep
Fifth Problem Set Review
Level of Detail Problem Set
Level of Detail Problem Set Review
Alternate Explanation for LOD Problem Set Question 1
Second Level of Detail Problem Set
Second Level of Detail Problem Set Solutions

4 Topics
A Note on the Certified Associate Practice Exams
Practice Certified Associate Certification Exam
Practice Certified Associate Certification Exam - Version 2
Practice Certified Association Exam - Version 3

5 Topics
Create Publish and Share a Viz on a Topic that Interests You
Publicly Available Data Sources for Awesome Visualizations
Twitter Data in Tableau
Sharing your Visualizations
Get feedback on your visualization

4 Topics
The Tableau Job Market
Suggestions for Further Study
Certificate of Completion
CLAIM YOUR BONUS

  Write a Review

Tableau Certified Data Analyst: Top Exam Prep Course

Go to Paid Course