Duration: 2 days
Price: $1,800
Expand your Tableau proficiency and differentiate yourself as a power user. Learn more advanced methods for connecting to data, working with calculations, building visualizations, applying analytics such as parameters, and customizing dashboards.
What you'll learn:
- Combine data from multiple tables using joins, unions, and relationships.
- Use extracts to improve performance.
- Build advanced chart types, including bar-in-bar and bullet graphs.
- Use advanced calculations and table calculations to modify data as needed for analysis.
- Use statistical techniques to analyze data.
- Use parameters and input controls to support audience analysis.
- Build better dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
Course Outline
Introduction and Review
- Introduction to Tableau Desktop II: Intermediate
- Using Measure Values and Measure Names in a View
- Working with Dates in Tableau
- Discrete Date Parts and Continuous Date Values
- Permissions in Tableau
- Navigating a Tableau Site
Creating and Connecting to Data Sources
- Data Connections Page
- Physical and Logical Layers
- Connecting to Single- and Multi-table Data Sources
- Migrated Data Sources
- The Data Pane User Interface
- View Data
- Joins (Inner, Left and Right, Full Outer)
- Unions
- Merging Fields
- Relationship Levels of Detail
- Setting up a Relationship Between Tables
- Joins vs. Relationships
- Creating Relationships Between Tables from Different Databases
- Relationships, Joins, Unions and Blends
- Combining Data Decision Tree
Data Extracts
- Using Data Extracts
- Configuring and Running an Extract
- Logical Table vs. Physical Table Extracts
Using Calculations in Tableau
- Understanding Where Calculations Occur
- Creating and Editing Calculated Fields
- Calculations and Aggregations
- Aggregating Dimensions in Calculations
- Join Calculations
- Level of Detail (LOD) Expressions
Comparing Measures
- Comparing Two Measures (Bar in Bar Chart)
- Comparing Progress Toward a Goal (Bullet Graph)
- Using Reference Lines (2 slides)
- Reference Bands
Viewing Distributions
- Bins and Histograms
- Box and Whisker Plots
Advanced Table Calculations
- Table Calculation Overview
- Tips for Learning Table Calculations
- Levels of Control
- Table Calculation Scope and Direction
- Table Calculation Specific Dimension
- Other Scope and Direction Options
- Null Values in Table Calculations
- Table Calculations for Statistical Analysis
Creating and Using Parameters
- Using Parameters
- Parameters and Filters
- Using Parameters with Reference Lines
Defining Subsets of Your Data
- Using Sets
- Combined Sets
- In and Out Sets
- Analyze an Outlier Using Explain Data
- Nested Sorting and Context Filters
Dashboards
- Planning Your Dashboard
- Building Your Dashboard
- Add Interactivity with Filters and Actions
- Adding Actions to Your Dashboard
- Additional Dashboard Actions
- Set Actions
- Parameter Actions
- Visual Best Practices
- Add Instructions & Annotations
- Tooltips
- Remove Chart Extras
- Publish Your Dashboard Online
This course is designed for proficient Tableau users who want to acquire more advanced skills. You should have either completed Tableau Desktop I: Fundamentals or have at least 3 months of product experience. Before taking this course, you should know how to connect to data, create visualizations using fields on shelves and the Marks card, filter data, sort data, and build a dashboard. Note: This course accommodates authoring in Tableau Desktop, Tableau Cloud, and Tableau Server.
There are no preparatory requirements.