Overview

In Tableau Desktop, you have a data visualisation tool that enables you to connect to and query data from files and databases using preconfigured connectors. From the datasets you define, you can create worksheets and Visualizations which can then be shared with your end users directly or compiled with filters and actions into interactive dashboards.

This course introduces Tableau Desktop concepts, the interface and terminology. You will connect to data, prepare data for analysis, create charts and tables, learn about publishing and permissions. This course is perfect for starting your journey with Tableau and working towards your first Tableau certification.

Read more +

Prerequisites

Please note that this course is not suitable for new Excel users

  • An understanding of basic data concepts
  • Ability to create, format charts in Excel or other visualisation tool
  • Be able to create formulas using standard aggregate functions

Target Audience

Anyone who needs to work with data to be able to connect, process and analyse the data to produce insight for an organisation.

It is assumed that attendees on the course are already familiar with charts and fundamental data processing concepts.

Read more +

Delegates will learn how to

  • Tableau Desktop concepts and main features
  • Data Sources compatible with Tableau Desktop
  • The process to connect data with Tableau Desktop
  • Data preparation and transformation functionality
  • How Tableau Desktop organises data into dimensions and measures
  • Techniques to model and prepare data in Tableau Desktop including relationships and unions
  • How to create visualisations and apply options
  • Core concepts used to create calculated fields and table calculations
  • Work with worksheet formats and elements
  • Create a dashboard and a story
Read more +

Outline

Lesson 1: Getting Started with Tableau Desktop

Tableau Desktop Concepts and Overview

Introduction to Main Features

Workbook elements and application structure

Connections

Visualizations

Output options

Dashboards

Stories

File types

Lesson 2: Connecting to Data Sources with Tableau Desktop

Data Sources Tableau Desktop will connect to

Field classifications

Data Types and Roles in Tableau Desktop

Dimensions and Measures

Qualitative and quantitative data

Continuous (Green) and discrete (Blue) classifications

Bringing in the data

Add a Connection

Working in the Data Source view

Commands and icons

Preparing the Data

Setting data types manually

Selecting the fields to include and exclude

Applying filters to a connection

Use Aliases in fields

Clean, Trim and Format

Split Column or Extract Using Delimiters

Lesson 3: Combining Data Source

Introducing Relationships, Unions and Joins

Overview

Relationship or Union – Use Cases

Creating and Defining Table Relationships

Combine tables using a Union

Lesson 4: Visualising the Data

Overview of Data Visualisations

Worksheet structure

Pages, Filters and Marks

Columns, Rows, Pills and Shelf

Show Me

Data and Analytics pane

Key menus – Worksheet, Format and Analysis

Crosstab and text visuals

Creating a visual

Working with Marks options

Colour - applying Conditional Formats

Text and Detail – adding data to a visual

Tooltip – adding contextual information to tooltips

Sorting a visual

Formatting options

Adding Table Calculations using Analysis and the Marks card

Quick Table Calculations

Totals

Percent Of

Difference

Rank

Charts

Types

Setting chart options using Marks

Measure calculations

Conditional colours

Details, labels and tooltips

Adding filters to visuals

Setting filter controls and options

Using filters across multiple worksheets

View Data to see underlying data in a Viz

Working with Hierarchies

Analytics in Visualizations

Summarise Lines and Total

Using Groups and Bins in Visualizations

Create Calculated Fields and Measures

Create a KPI Visualization

Geo-Data Roles and Maps

Lesson 5: Workbook and Worksheets

Format the Workbook

Fonts, Lines and Colours

Setting worksheet options

The Show Settings

Export, Copy and Updates

Format elements

Lesson 6: Dashboards and Stories

Build a Dashboard

Adding Sheets

Working with Device Layouts

Adding Objects to a Dashboard

Format the Dashboard

Test in Presentation Mode

Build a Story

Add sheets

Set captions

Test in Presentation Mode

Read more +

Why choose QA

Special Notices

Please Note: This course is currently under development. As such, elements of this syllabus could be subject to change.

Dates & Locations

Data for Business Users learning paths

= Required
= Certification
Microsoft Excel
Google Sheets
Microsoft Power BI
Microsoft Access
Tableau
Need to know

Frequently asked questions

How can I create an account on myQA.com?

There are a number of ways to create an account. If you are a self-funder, simply select the "Create account" option on the login page.

If you have been booked onto a course by your company, you will receive a confirmation email. From this email, select "Sign into myQA" and you will be taken to the "Create account" page. Complete all of the details and select "Create account".

If you have the booking number you can also go here and select the "I have a booking number" option. Enter the booking reference and your surname. If the details match, you will be taken to the "Create account" page from where you can enter your details and confirm your account.

Find more answers to frequently asked questions in our FAQs: Bookings & Cancellations page.

How do QA’s virtual classroom courses work?

Our virtual classroom courses allow you to access award-winning classroom training, without leaving your home or office. Our learning professionals are specially trained on how to interact with remote attendees and our remote labs ensure all participants can take part in hands-on exercises wherever they are.

We use the WebEx video conferencing platform by Cisco. Before you book, check that you meet the WebEx system requirements and run a test meeting (more details in the link below) to ensure the software is compatible with your firewall settings. If it doesn’t work, try adjusting your settings or contact your IT department about permitting the website.

How do QA’s online courses work?

QA online courses, also commonly known as distance learning courses or elearning courses, take the form of interactive software designed for individual learning, but you will also have access to full support from our subject-matter experts for the duration of your course. When you book a QA online learning course you will receive immediate access to it through our e-learning platform and you can start to learn straight away, from any compatible device. Access to the online learning platform is valid for one year from the booking date.

All courses are built around case studies and presented in an engaging format, which includes storytelling elements, video, audio and humour. Every case study is supported by sample documents and a collection of Knowledge Nuggets that provide more in-depth detail on the wider processes.

When will I receive my joining instructions?

Joining instructions for QA courses are sent two weeks prior to the course start date, or immediately if the booking is confirmed within this timeframe. For course bookings made via QA but delivered by a third-party supplier, joining instructions are sent to attendees prior to the training course, but timescales vary depending on each supplier’s terms. Read more FAQs.

When will I receive my certificate?

Certificates of Achievement are issued at the end the course, either as a hard copy or via email. Read more here.

Let's talk

By submitting this form, you agree to QA processing your data in accordance with our Privacy Policy and Terms & Conditions. You can unsubscribe at any time by clicking the link in our emails or contacting us directly.