Course description:

This course covers more advanced Tableau Desktop skills required for Tableau users who wish to take their skills to a higher level so that they get the most out of their data. It starts with a section on Tableau best practices, followed by data connections and data sources, a review of Tableau Desktop/Intermediate, usage of custom SQL, context filters, advanced calculations, bars on tooltip, advanced parameters, advanced mapping and advanced chart types. The course is provided with data and workbooks enabling the participants to fine tune their advanced Tableau skills.


Tableau end users and analysts particularly those that want to become power users or who have more complex issues to solve.


Tableau Desktop and Tableau Intermediate courses and/or equivalent experience are required.


Tell Me, I’ll ForgetShow MeI’ll RememberLet Me Do It, I’ll Understand.

Course Content:

Tableau Best Practices

  • How best to create data visualisations?
  • When not to use Tableau
  • The different types of visualisation
  • Common data visualisation problems
  • Data integrity (typical political tricks!)

Data Connections and Data Sources

  • Files
  • Relational Databases
  • OLAP Databases
  • Big Data Sources
  • Cloud Data Sources
  • Tableau Data Server

Review of Tableau Desktop and Intermediate

  • Bar chart
  • Line chart
  • Scatter Plot
  • Geographic Map
  • Filled Map
  • Crosstab Report
  • Side by Side Bar
  • Combined Axis
  • Stacked Bar
  • Dual Axis
  • Bar in Bar
  • Heat Map
  • Highlight Table
  • Pie Chart
  • Motion Chart
  • Histogram
  • Dashboard
  • Groups
  • Sets
  • Dates
  • Calculations
  • Quick Table Calculations
  • Parameters
  • Reference Lines

Custom SQL

  • Convert to custom SQL

Context Filter

  • Why create a Context Filter?
  • Create a Context Filter

Advanced Calculations

  • Split / Custom Split
  • Profitability as a percent of total
  • Level of Detail
  • Size

Bars on Tooltip

  • Bars on Tooltip

Advanced Parameters

  • Multiple Views in a Container
  • Dynamic Hierarchies, Colouring, Sorting and Measure Values

Advanced Mapping

  • Point to point maps
  • Calculate the distance between two points on a map
  • Dual Axis Map
  • Map Australian LGAs
  • Australian Locations

Advanced Chart Types

  • Bump Chart
  • Hockey Stick Chart
  • Pareto Chart
  • Gantt Bar chart
  • Waterfall chart
  • Sparklines
  • Market Basket Analysis
  • Multiple Bars and Lines
  • Benford’s Law


31 Oct 2019 - 01 Nov 2019


9:00 am - 5:00 pm




Tableau Advanced


Level 14, 9 Hunter Street, Sydney