Course Outline
Introduction and Getting Started
Filtering, Sorting & Grouping
- Advanced options for filtering and hiding data
- Understanding the many options for ordering and grouping your data
- Sorting, groups, bins and sets
- How all these options interrelate
Working with Data in Tableau
- Dimensions versus measures
- Data types: discrete versus continuous
- Joining database sources
- Inner, left and right joins
- Blending different data sources within a single worksheet
- Working with extracts instead of live connections
- Data quality issues
- 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 what happens behind the scenes
- Advanced statistics
- Working with dates and times
Table Calculations
- Quick table calculations
- Scope and direction
- Addressing and partitioning
- Advanced table calculations
Advanced Geospatial Techniques
- Building basic maps
- Geographic fields and map options
- Customising a geographic view
- Web Map Service
- Visualising non-geographic data using background images
- Mapping tips
- Distance calculations
Parameters in Tableau
- Creating parameters
- Using parameters in calculated fields
- Parameter control options
- Enhancing analysis and visualisations with parameters
Building Advanced Chart Visualisations
- Bar chart variations – bullet charts, bar-in-bar, highlight charts
- Date and time visualisations, Gantt charts
- Stacked bars, treemaps, area charts and pie charts
- Heat maps
- KPI charts
- Pareto charts
- Bullet charts
Advanced Formatting
- Labels
- Legends
- Highlighting
- Annotations
Telling a Data Story with Dashboards
- Dashboard framework
- Filter actions
- Highlight actions
- URL actions
- Cascading filters
Trends and Forecasting
- Understanding and customising trend lines
- Distributions
- Forecasting
Integrating Tableau and R for Advanced Data Analytics
- Option to include various data analytics methods in R, based on participant request
Requirements
- A solid understanding of Tableau fundamentals, including data connections and basic visualisations
- Experience creating dashboards and worksheets in Tableau
- Foundational knowledge of data analysis and data visualisation concepts
Audience
- Data analysts seeking to deepen their Tableau skills
- Business intelligence professionals working with data visualisation
- Advanced Excel or reporting users transitioning 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