Curriculum

5 Topics
Introduction to Tableau Fundamentals
Course Objectives
Creating a Tableau Public Profile
Download Tableau Public
Downloadable Files

32 Topics
Transforming Data Objectives
Case Study Overview
Fact vs. Dimension Tables
Tables Used in Our Case Study
Overview of Course Files
Importing a CSV/TXT Fact Table
Importing an Excel File
Deleting a Connection
Naming the Dataset
The Data Pane
Rules of Good Data
The Data Interpreter
Saving Your Work
Using Files from Tableau Public
Opening Pre-populated Tableau Course Files
Splitting Columns
Column Types
Replacing Values Using Aliases
Hiding Columns
Working with Multiple Tables Using JOINS
Types of JOIN
Importing Dimension Tables
Performing JOINS in Tableau
Admin after Performing JOINS
A Quick Word on Relationships
Stacking Table Rows with UNIONS
Inspecting Tables
Performing a Manual UNION
The Automatic UNION Method
Creating a Data Source Filter
Transforming Data Student Exercise
Transforming Data Student Exercise Review

28 Topics
Mastering Calculations Objectives
The Tableau Interface
Creating a Visual
Calculated Fields
Basic Calculations - Profit Ratio
Common Mistakes with Aggregation and Granularity
Solving the Aggregation Problem
Common Text Functions
Extract Postal Code Using LEFT Function
Common Number Functions
The MAX Function
Discrete vs. Continuous Dates
Discrete vs. Continuous Dates - Applied Example
Common Date Functions
Calculating Days to Ship with DATEDIFF
Checking the Aggregation
Common Comparison Operators
Testing a Sales Threshold Using a Comparison Operator
Using Conditions to Filter or Highlight Data
Manipulating Conditions with Logical Functions
Testing Multiple Conditions With AND
Controlling Condition Outcomes with IF
Table Calculations - % of TableTotal
Table Calculation Options
Table Calculations - Running Totals
ALWAYS Tables Before Charts
Mastering Calculations Student Exercise
Mastering Calculations Student Exercise Review

47 Topics
Creating Visuals Objectives
The Office Store - Dashboard Requirements
Creating Visuals Cheatsheet
Creating a Basic Table for Our Dashboard
Basic Table Formatting
Heatmap Basics
Custom Colors
Line Chart Basics
Line Chart with Multiple Series
Creating a Swapping Parameter
Making the Axis Title Dynamic
Creating a Highlight Parameter
Dynamic Chart Titles
Editing Tooltips
Line Chart Final Touches
Bar Chart Basics
Category Subcategory Hierarchy
Bar Chart Tooltips Using Table Calculations
Bar Chart Formatting
Lollipop Chart Basics
Top N Parameters
Dynamic Chart Title
Lollipop Formatting
Scatterplot Basics
Profitable vs. Unprofitable
Scatter Formatting
Treemap Basics
Treemap Top 10
Treemap Formatting
Map Basics
Map Formatting
Big Number Basics
Big Number Formatting
Pie Chart Basics
Pie Chart Formatting
Data Source Filters
Context Filters Using Slicers
Filters - Order of Operation
Color Coding Sheets
Promoting a Dimension Filter to a Context Filter
Copying Filters Across Visuals
Creating a Timeline Filter
Creating Visuals Student Exercise
Creating Visuals Student Exercise Review - Part 1
Creating Visuals Student Exercise Review - Part 2
Creating Visuals Student Exercise Review - Part 3
Creating Visuals Student Exercise Review - Part 4

19 Topics
Dashboard Design Objectives
Creating a New Dashboard
Dashboard Sizing
Tiled vs. Floating Layout
Layering
Sales Dashboard - Placing Visuals and Objects
Sales Dashboard - Placing Filters and Parameters
Sales Dashboard - Formatting
Location Dashboard - Placing Visuals and Objects
Location Dashboard - Formatting
Creating a Collapsible Container for a Pie Chart
Modifying a Button
Collapsible Container for Heatmap
Collapsible Container for Sales Table
Using a Filter Action for Cross Filtering
Ensuring Slicers Work Correctly by Promoting Filters
Action Filters with Top N
Dashboard Design Student Exercise
Dashboard Design Student Exercise Review

6 Topics
Chapter Objectives
Relationships
Relationships Cardinality
Referential Integrity
Task - Creating Visuals
Task Review - Creating Visuals

4 Topics
Course Summary
Qualified Assessment Exercise
Download Assessment Files
Assessment

  Write a Review

Tableau Fundamentals

Go to Free Course