Course Description
Take your Tableau Desktop skills to the next level with ExistBI’s two-day Tableau Intermediate Training course (Tableau Desktop II: Intermediate – TTD201).
Designed for business analysts, data analysts, reporting professionals and experienced Tableau users, this live instructor-led course builds on foundational Tableau knowledge to develop more advanced data analysis, visualisation and dashboard development skills.
Participants learn how to combine data from multiple sources using joins, unions and relationships, optimise data extracts, create advanced calculations and level of detail (LOD) expressions, and develop sophisticated visualisations.
The course also explores advanced table calculations, parameters, sets, filters and interactive dashboard techniques that enable users to analyse complex datasets and communicate meaningful business insights.
Our experienced Tableau instructors provide practical demonstrations, comprehensive course materials and extensive hands-on exercises using a licensed Tableau training environment.
Prerequisites: Tableau Desktop Fundamentals training or equivalent practical experience.
Flexible Training Options
Choose from regularly scheduled public online classes or private corporate Tableau training delivered virtually or onsite.
Private training can be customised to your organisation’s requirements, including course content, duration, hands-on exercises and the use of your own business data.
After completing this two-day Tableau Intermediate training course, you will be able to:
- Combine data from multiple tables and sources using joins, unions and relationships.
- Create and manage Tableau data extracts to improve performance.
- Develop advanced calculations, including level of detail (LOD) expressions.
- Apply advanced table calculations to analyse trends, rankings and statistical measures.
- Create sophisticated visualisations, including bullet charts, histograms and box plots.
- Use parameters, sets and filters to develop flexible, interactive analyses.
- Understand Tableau’s order of operations and apply context filters.
- Use reference lines and bands to support comparative analysis.
- Design interactive dashboards using filter, set and parameter actions.
- Apply Tableau visualisation best practices to communicate complex information effectively.
- Publish and share Tableau dashboards.
Course Outline Below
Course Summary
Next Public Course Dates | |
| Course Name | Tableau Desktop II: Intermediate – TTD201 |
| Level | Intermediate |
| Duration |
|
| Prerequisites |
|
| Delivery | Live Instructor-Led Online or Private Onsite |
| Hands-On Labs | Included |
| Course Materials | Included |
| Post Training Support | Yes, our certified Tableau trainers will be available for additional questions once you start working on your own data and dashboards. |
Course Outline (10 modules)
This course includes a workbook containing key concepts on each topic covered and hands-on activities to reinforce the skills and knowledge attained. It also includes a digital student resources folder containing Tableau workbooks and data sources to support the hands-on activities.
Introduction and Review
- Meet Tableau Desktop II: Intermediate
- Use Measure Values and Names in a View
- Work with Dates in Tableau
- Define Discrete Date Parts and Continuous Date Values
Data Source Creation and Connection
- Access the Data Connections Page
- Build Physical and Logical Layers
- Connect to Single- and Multi-Table Data Sources
- Migrate Data Sources
- Navigate The Data Pane User Interface
- View Data
- Build Joins
- Generate Unions
- Merge Fields
- Establish Relationship Levels of Detail
- Set Up a Relationship Between Tables
- Contrast Joins and Relationships
- Combine a Data Decision Tree
- Create Relationships Between Tables from Different Databases
Data Extracts
- Use Data Extracts
- Configure and Run an Extract
- Distinguish Between Logical and Physical Table Extracts
Tableau Calculations
- Understand Where Calculations Occur
- Create and Edit Calculated Fields
- Build Calculations and Aggregations
- Aggregate Dimensions in Calculations
- Join Calculations
- Define Level of Detail (LOD) Expressions
Measure Comparisons
- Compare Two Measures (Bar in Bar Chart)
- Assess Progress Toward a Goal (Bullet Graph)
- Use Reference Lines
- Build Reference Bands
Distribution Views
- Build Bins and Histograms
- Generate Box and Whisker Plots
Testimonials
“The content was great for an introduction to Tableau. I truly appreciate the way Michael was able to explain everything, and would recommend this class to anyone needing to get their feet wet with Tableau.”
- Shianne DeGeorge, Business Intelligence Group, Kaiser Permanente
“Great Tableau Course. Lots of information packed into short period.”
- Matt, Data Analyst, Fortune Brands
“Your private Tableau Desktop Bootcamp I for Beginners training was excellent, our 15 staff members thoroughly enjoyed it!”
- David Sonntag, US Airforce
