Tableau Course: Level 1B
Data analysis and analytics. Uncover insights and transform your organisation.
This Tableau course is suitable for those wanting to further develop their Tableau skills and build out their introductory Tableau skill set. Turn your data into actionable insights with Tableau’s data management, visualisation, interactive dashboard and online sharing capabilities.
This course will take you beyond the initial steps in mastering Tableau. It is assumed you have already acquired basic skills with Tableau charts, commands and data functions. We encourage you to complete the Introduction to Tableau Course: Level 1A, or check you can complete the learning outcomes in the Level 1A course before enrolling.
This course is also suitable for people who have some basic prior experience with Tableau and now wish to become more savvy, when analysing and visualising data. This is achieved through hands-on exercises so that you have a set of steps for achieving similar outcomes in your workplace.
This instructor-led short course will give you the confidence to take a range of different data sets, prepare the data and then produce meaningful data visualisations and charts. You will learn Tableau's data connection capabilities and visualisation features, which go far beyond those that can be found in spreadsheets, allowing you to create compelling and interactive worksheets, dashboards and stories that bring your data to life and allow you to take thoughtful action.
You will also work with Tableau’s wizards and shortcuts, for the purpose of creating beautiful Business Intelligence visualisations quickly and with the least amount of effort, thereby enabling your organisation to make smarter and more informed decisions.
Please use the CCE Tableau self-assessment tool if you are unsure which course level to enrol in.Â
Please ensure Tableau Public is installed on your device before class. For further details, see 'Before the course'.
Aims
This course aims to build your skills in:
- preparing and cleaning data in Tableau to efficiently find answers
- creating advanced visualisations with Tableau that explain complexity with clarity and style
- using data storytelling to aid decision-making.
Outcomes
By the end of this course, you should be able to:
- proficiently navigate Tableau using a full suite of commands
- analyse data and calculate with tables using Tableau commands
- generate the most meaningful visualisations
- develop interactive dashboards
- deliver insightful stories visually in addressing a business problem.
Content
Preparing & connecting Data in Tableau
- Connecting to different types of data sources (Excel, CSV, Access, MS SQL, Tableau Server)
- Structuring data for Tableau
- Manage Data Source Metadata
- Cross database joins
- Data Blending – integrating different data sources
Analysing data
- Create a visual group
- Create a calculated field (eg string, date, simple arithmetic)
- Add a parameter
- Totals and Subtotals
Calculate with tables
- Explaining a table calculation
- Aggregating and disaggregating data
- Forecasting
Building Interactive Dashboard
- How to create a dashboard
- How to perform navigation in dashboards
- Combining multiple visualisations into a dashboard
Visualising Distributions and Multiple Axes to Compare Different Measures
- Making your worksheet interactive by using actions and filters
- Using Background Images
- Animation
Telling a Data Story
- Working with Labels and Annotations
- Visualising Dates and Times
- Custom chart types - KPI matrix, Gantt, Pareto, Trend lines
- Sharing Insights
Sharing and Publishing Workbooks
- Publish to Reader
- Publish to Office
- Publish to PDF
- Publish to Tableau Server and Sharing over the Web
Intended audience
This course is designed for the Tableau user who has moved beyond the beginner stage and has some prior experience with Tableau.
Prerequisites
It is assumed you have completed Tableau Course: Level 1A, or have equivalent knowledge.
Delivery modes
- Face-to-face, presenter-taught training using your own device
- Online training via the platform Zoom
Delivery style
Face-to-face classes
These classes run in a classroom and you need to bring your own device with Tableau installed. You should ensure it is fully charged as access to power is limited. Please note that the University does not carry any responsibility for your lost, stolen, or damaged devices whilst on the University premises.
Online classes
You will need your own device with Tableau installed.
Materials
Training materials, including a mixture of step-by-step instructions and exercises are provided electronically using Dropbox. These materials will serve as a useful reference when working with Tableau in the future.
Before the course
Tableau software is required and should be downloaded free of charge from Tableau Public before class.