Syllabus of Tableau Training – Next Generation Dashboard – 15 Hours Training

Tableau 9 A-Z: Hands-On Tableau Training For Data Science!

What you’ll learn

Install Tableau Desktop 9 & 10 | Connect Tableau to various Datasets: Excel and CSV files | Create Bar charts | Create Area Charts | Create Maps | Create Scatterplots | Create Pie charts | Create Tree maps | Create Interactive Dashboards | Create Storylines |Understand Types of Joins and how they work | Work with Data Blending in Tableau | Create Table Calculations |Work with Parameters |Create Dual Axis Charts |Create Calculated Fields | Create Calculated Fields in a Blend |Export Results from Tableau into PowerPoint, Word, and other software | Work with Timeseries Data (two methods) | Creating Data Extracts in Tableau |Understand Aggregation, Granularity, and Level of Detail |Adding Filters and Quick Filters |Create Data Hierarchies |Adding Actions to Dashboards (filters & highlighting) |Assigning Geographical Roles to Data Elements |Advanced Data Preparation (including latest updates in Tableau 9)

What is Tableau & Course Overview

Installation – (Tableau Professional & Public Version)

How Tableau Works

Connecting Tableau to a Data File – CSV File, Excel, Access etc.

Navigating Tableau

Creating Calculated Fields

Adding Colours

Adding Labels and Formatting

Exporting Your Worksheet

Section Intro

Working with Data Extracts in Tableau

Working with Time Series

Understanding Aggregation, Granularity, and Level of Detail

Creating an Area Chart & Learning About Highlighting

Adding a Filter and Quick Filter

Joining Data in Tableau

Creating a Map, Working with Hierarchies

Creating a Scatter Plot, Applying Filters to Multiple Worksheets

Let’s Create our First Dashboard!

Adding an Interactive Action – Filter

Adding an Interactive Action – Highlighting

Understanding how LEFT, RIGHT, INNER, and OUTER Joins Work

Joins with Duplicate Values

Joining on Multiple Fields

Joining Data & Blending Data in Tableau

Data Blending in Tableau

Dual Axis Chart

Creating Calculated Fields in a Blend (Advanced Topic)

Downloading the Dataset and Connecting to Tableau

Mapping: how to Set Geographical Roles

Creating Table Calculations for Gender

Creating Bins and Distributions for Age

Leveraging the Power of Parameters

How to Create a Tree Map Chart

Creating a Customer Segmentation Dashboard

Advanced Dashboard Interactivity

Analyzing the Customer Segmentation Dashboard

Creating a Storyline

What Format Your Data Should Be in

Data Interpreter

Pivot – New Features in Tableau 9

Splitting a Column into Multiple Columns

Meta Data Grid

Fixing Geographical Data Errors in Tableau

The Challenge: Start-up Expansion Analytics

Custom Territories Via Groups

Custom Territories Via Geographic Roles

Adding a Highlighter

Clustering in Tableau

Cross-Database Joins

Modelling with Clusters

Saving Your Clusters

New Design Features

New Mobile Features

Section Recap

Our session will not just stop with teaching you the above options; we go beyond to make you an expert in using the various options in real time scenario.

Introduction

Connecting to data

Simplifying and sorting your data

Organizing your data

Slicing your data by date

Using multiple measures in a view

Showing the relationship between numerical values

Mapping data geographically

Viewing specific values

Customizing your data

Analysing data with quick table calculations

Showing breakdowns of the whole

Highlighting data with reference lines

Making your views available

Creating and connecting to data sources

Defining subsets of your data

Using calculations in Tableau

Advanced table calculations

Creating and using parameters

Data extracts

Comparing measures

Tableau geocoding

Viewing distributions

Statistics and forecasting

Dashboards and stories