Table of Contents
Section 1 – Connecting to Data – Introduction
Opening Tableau
1) Connect to an Excel data source
2) Web Sources
3) MS Access
4) Creating Joins
5) Data Extracts
6) MS SQL
7) Replace References
8) Exporting a Tableau Data Source
9) Bookmark
Test Questions
Section 2 – Basic Training
1) Excel
2) Data Roles – Dimensions and Measures
3) Data Window and Right-click Options
4) Excel Visual With Modified Defaults
5) Tabular View
6) Show Me<
7) Formatting Text Visuals
8) Geo-Coding
9) Geo-Coding Filled Maps
10) Scatter Charts
11) Time Series – Trend Lines
12) Visual Filtering
13) Sorting
14) Filtering
15) Map Filters<
16) Percentages and Totals
17) First Dashboard
Test Questions
Section 3 – Intermediate
1) Data Roles and Options
2) Changing Data Roles
3) Maps
4) Dates and Times
5) Dates with Calculations –Gantt Chart
6) Grouping
7) Bins and Histograms
8) Sets within Scatter Charts
9) Concatenated Sets
10) Sorting with Sets
11) Quick Table Calculations
12) Secondary Table Calculations
13) Create Calculated Fields
14) Histogram with Running Totals
15) Trend Lines
16) Reference Lines
17) Performance
Test Questions
Section 4 – Advanced Features
1) Combination Charts
2) Trends and Motions
3) Data Blending
4) Parameters
5) Shipping Parameters
6) Area Charts
Test Questions
Section 5 – Masters
1) Heat Maps
2) Box Plots<
3) Pareto Or the 20 – 80 Rule
4) Bullet Chart
5) Bar In A Bar
6) Standard Deviations
7) Reference Lines with Banding
8) Groups and Sets
9) Dashboard
Test Questions
Section 6 – Dashboards and Guided Analytics
(A complete lesson on building out a dashboard with Actions and Filters from scratch)
Section 7 – Calculations, Dates, KPIs, IF Statements
1) Conditional Filters
2) Calculated Fields<
3) Logical Statements – KPI Bars
4) Date Function
5) DATEDIFF<
6) Truncated Date Functions
7) Color Conditioned Tables
Section 8 – Collaboration
1) PDF
2) PowerPoint
3) Export Images
4) Tableau Reader and Outlook