TABLEAU ACT 1

These video links are Tableau official videos. Just for quick access I am posting here. If you want to download related material for that video, please visit Tableau Software official website.

CLICK HERE

Getting Started

Getting Started
The Tableau Interface
Distributing and Publishing

Connecting to Data

Getting Started with Data
Managing Metadata
Managing Extracts
Data Prep with Text and Excel Files
Saving and Publishing Data Sources
Join Types with Union
Cross-database Joins
Data Blending
Additional Data Blending Topics
Connecting to Cubes

Visual Analytics

Getting Started with Visual Analytics
Drill Down and Hierarchies
Sorting
Grouping
Additional Ways to Group
Creating Sets
Working with Sets
Ways to Filter
Using the Filter Shelf
Interactive Filters
Where Tableau Filters
Additional Filtering Topics
Parameters
Formatting
The Formatting Pane
Trend Lines
Reference Lines
Forecasting
Clustering
Analysis with Cubes and MDX

Dashboards and Stories

Getting Started with Dashboards and Stories
Building a Dashboard
Dashboard Layouts and Formatting
Device Designer
Dashboard Interactivity Using Actions
Story Points

Mapping

Getting Started with Mapping
Maps in Tableau
Editing Unrecognized Locations
Expanding Tableau's Mapping Capabilities
Custom Geocoding
Polygon Maps
Mapbox Integration
WMS: Web Mapping Services
Background Images

Calculations

Getting Started with Calculations
Calculation Syntax
Introduction to LOD Expressions
Intro to Table Calculations
Modifying Table Calculations
Aggregate Calculations
Date Calculations
Logic Calculations
Number Calculations
String Calculations
Type Calculations
Conceptual Topics with LOD Expressions
Aggregation and Replication with LOD Expressions
Nested LOD Expressions
How to Integrate R and Tableau
Using R within Tableau

Why is Tableau Doing That?

Understanding Pill Types
Aggregation, Granularity, and Ratio Calculations
When to Blend and When to Join
Fixing "Incorrect" Sorts
Filtering for Top Across Panes
Measure Names and Measure Values

How To

Using a Parameter to Change Fields
Cleaning Data by Bulk Re-aliasing
Bollinger Bands
Bump Charts
Control Charts
Funnel Charts
Pareto Charts
Waterfall Charts

Real Time Challenges

Unknown 06:01

Unknown

Real Time Challenges 0

Real Time Challenges

Do you feel that you are Tableau Expert? Then try this challenge 1
Do you feel that you are Tableau Expert? Then try this challenge 2
Do you feel that you are Tableau Expert? Then try this challenge 3
Do you feel that you are Tableau Expert? Then try this challenge 4
Do you feel that you are Tableau Expert? Then try this challenge 5
Do you feel that you are Tableau Expert? Then try this challenge 6
Do you feel that you are Tableau Expert? Then try this challenge 7
Do you feel that you are Tableau Expert? Then try this challenge 8
Do you feel that you are Tableau Expert? Then try this challenge 9
Do you feel that you are Tableau Expert? Then try this challenge 10
Do you feel that you are Tableau Expert? Then try this challenge 11
Do you feel that you are Tableau Expert? Then try this challenge 12

TABLEAU TODAY

Unknown 05:40

Unknown

TABLEAU TODAY 0

Do you feel that you are Tableau Expert? Then try this challenge 12

Using below data try to solve this challenge.

To download this data, click here

Below Image I am showing Year over year growth based on some rules. Please follow rules and try to solve this challenge.

Generally, Year over Year(YoY) growth calculated using below formula.
((Current Year Sales – Previous Year Sales) / Previous Year Sales) * 100

But I have some rules while calculating YoY Growth.

Note: we are computing data from left to right (means from 2016 to 2008) in above image.
Rule No 1:
If any year does not have sales, then YoY growth for following years should be NULL.
For example, in Central, 2016 does not have sales so 2016 onwards till 2008 there is no year over year growth.
Similarly, you can see South, 2014 onwards and West 2015 onwards YOY is empty.
Rule No 2:
While calculating YOY if there is not data for previous year then, you need to use before previous year data.
For example, in west region, 2016 we don’t have sales in 2015 so I took sales of 2014 and then calculated YoY.
((128-81) / 81) * 100 = 58%

If before to previous data is not there then you can display YoY as NULL for that year.
For Example, in south 2014 year, there is no sales in 2013 and at the same time there is no sales for 2012 also. So, YoY for 2014 is NULL.

See one more example below, Assume I have data till 2014. I just filtered above data for this example.

For Central 2014:
((157-180) / 180) *100 = -13%

For Central 2013:
((180 – 196) / 196) *100= -8% (According to Rule 2)

For Central 2012 onwards YoY is NULL (According to Rule 1)

Note: This is not very complex challenge. I just used only one calculation filed to display YoY. I am giving clue also. I used only 4 functions along with if statement. Out of four functions two functions that I used ISNULL and SUM.

For more challenges: CLICK HERE

Real Time Scenarios

Unknown 23:40

Unknown

Real Time Scenarios 0

Real Time Scenarios

Scenario 1 (Mapping 5 parameters to top 5 Quarters)
Scenario 2 (Gap Analysis using floating Bar chart)
Scenario 3 (Removing Subtotals for unwanted columns)
Scenario 4 (Applying filters only for numerator, not for denominator using FIXED () in Tableau 9)
Scenario 5 Showing inventory for selected day if not selected then show last day inventory by month wise
Scenario 6 Showing Sum(sales) for pane without repeating same value
Scenario 7 How to make % of Total Sales consistent after applying filter
Scenario 8 How to calculate Year over Year Growth when quarters are like 15Q1, 15Q2......
Scenario 9 Sometimes we will see synchronize axis option as disabled. why? And how to solve this?
Scenario 10: How to create empty extract?
Scenario 11: How to create Donut chart in tableau (Using one dimension and one measure)
Scenario 12: How to display Top N and Bottom N Customers by Sales in single sheet
Scenario 13: Create Sets for Top N and Others
Scenario 14: How to Show Pie Chart for Customers as Top 10, Top 11-20 and Others
Scenario 15: How to calculate time difference between In time and Out time in HH:MM: SS format?