Course Outline
Introduction and Getting Started
Filtering, Sorting & Grouping
- Advanced options for filtering and hiding data
- Understanding various options for ordering and grouping your data
- Sorts, Groups, Bins, and Sets
- Interrelationships between all available options
Working with Data in Tableau
- Differentiating between Dimensions and Measures
- Data types: Discrete versus Continuous
- Joining database sources
- Inner, Left, and Right joins
- Blending different data sources within a single worksheet
- Using extracts instead of live connections
- Addressing data quality issues
- Managing metadata and sharing connections
Calculations on Data and Statistics
- Row-level calculations
- Aggregate calculations
- Arithmetic, string, and date calculations
- Custom aggregations and calculated fields
- Control-flow calculations
- Understanding the underlying mechanics
- Advanced statistics
- Working with dates and times
Table Calculations
- Quick table calculations
- Scope and direction settings
- Addressing and partitioning concepts
- Advanced table calculations
Advanced Geographic Techniques
- Creating basic maps
- Geographic fields and map options
- Customizing geographic views
- Web Map Service (WMS)
- Visualizing non-geographical data using background images
- Mapping tips and tricks
- Distance calculations
Parameters in Tableau
- Creating parameters
- Using parameters in calculated fields
- Parameter control options
- Enhancing analysis and visualizations with parameters
Building Advanced Chart Visualizations
- Bar chart variations – bullet charts, bar-in-bar, highlights charts
- Date and time visualizations, Gantt charts
- Stacked bars, treemaps, area charts, pie charts
- Heat maps
- KPI charts
- Pareto charts
- Bullet charts
Advanced Formatting
- Labels
- Legends
- Highlighting techniques
- Annotations
Telling a Data Story with Dashboards
- Dashboard framework structure
- Filter actions
- Highlight actions
- URL actions
- Cascading filters
Trends and Forecasting
- Understanding and customizing trend lines
- Distributions
- Forecasting techniques
Integrating Tableau and R for Advanced Data Analytics
- Opportunities to include various data analytics methods in R, as requested by participants
Requirements
- Familiarity with Tableau fundamentals, including data connections and basic visualizations.
- Experience in creating worksheets and dashboards in Tableau.
- Understanding of basic concepts related to data analysis and visualization.
Audience
- Data analysts looking to expand their expertise in Tableau.
- Business intelligence professionals working with data visualization tools.
- Users transitioning from advanced Excel or traditional reporting methods to Tableau.
Testimonials (7)
Great knowledge of the content, good examples, great rapport with the class and very understanding if anyone needed extra help. Willing to stop and go back to explain things again and in a manner in which could be easily understood.
Martina O'Neill - Tech NorthWest Skillnet
Course - Tableau Advanced
Ability to direct the content covered to suit individual needs
Stefan Wroblewski - Tech NorthWest Skillnet
Course - Tableau Advanced
Ability to direct the content covered to suit individual needs
Stefan Wroblewski - Tech NorthWest Skillnet
Course - Tableau Advanced
The number of working examples.
Sharon Clarke - Tech NorthWest Skillnet
Course - Tableau Advanced
The number of working examples.
Sharon Clarke - Tech NorthWest Skillnet
Course - Tableau Advanced
Learning the different ways to present data
Katie Matthews - Quofox GmbH
Course - Tableau Advanced
all the materials and how the trainer teach