Mastering Tableau 2018.1, Second Edition

Mastering Tableau 2018.1, Second Edition

English | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 6h 13m | 849 MB

Find new opportunities in your business that you have never seen before by learning advanced data analytics with Tableau

Tableau has brought the world of visual analytics within the reach of many nonplussed by Excel charts and graphs. But after acquiring the basic skills, there is a learning curve that gets in the way of using Tableau to its full potential.

This course will give you the tools to use Tableau to its fullest and make optimal business decisions with rich analytics. If you want to be more feature-ready to use Tableau and perform effective data visualizations and analysis, then this course is for you. After taking this course, you will be confident enough to use advanced Tableau features and other tools. You will develop the skills to perform in-depth analyses for effective business decision making. Your skills will no longer be at an intermediate level; you will now be a master of data analysis using Tableau. You will be able to connect to data sources; summarize data; and create, manipulate, and share data visualizations including highlight tables, charts, scatter-plots, histograms, maps, dashboards, and more.

By the end of this course, you will be able to build useful, thoughtful, and beautiful visualizations that will help you make databases and spreadsheets understandable to ordinary people.

We use a step-by-step, hands-on, practical approach to build on your knowledge of Tableau. The course covers advanced topics to help you master Tableau and includes examples and business case studies.

What You Will Learn

  • Build advanced chart types into your visualizations
  • Apply advanced calculations for further insights into data
  • Use spatial data to build maps based on custom geocodes
  • Pull multiple data sources into Tableau using joins
  • Explore the use of sets to analyze a subset of data
  • Build advanced analysis that leverages statistics and other analytic tools
  • Format your work by incorporating visualization best practices
  • Build dashboards and stories that can be shared with external audiences
Table of Contents

Getting Started with Tableau 2018.1
1 The Course Overview
2 Exploring Tableau and Data Visualization
3 Understanding Tableau File Types and Workspace
4 Business Case for Visualizations with an Advanced Practical Example

Connect with Single Data Sources
5 Understanding the Connect Page and Global Superstore Dataset
6 Connecting to the Global Superstore Dataset
7 Saving Data Sources and Workbooks, Live, or Extracts

Clean and Prepare Your Data
8 Data Preparation and Cleaning Data Sources with Dates and Numbers
9 Data Preparation and Cleaning Data Sources with Text and Geography
10 Using the Data Interpreter

Combine and Transform Data with Multiple Data Sources
11 Joining Your Data
12 Data Blending with Tableau
13 Combining Your Data with Union
14 Creating Charts from Multiple Data Sources

Filtering and Sorting with Tableau Data
15 Creating Your First Visual
16 Working with Selection Filters
17 Creating a Wildcard Filter
18 Creating a Condition Filter
19 Creating a Top Filter
20 Working with Colors and Shapes
21 Working with Data Labels and the Tooltip
22 Understanding Aggregations
23 Working with Sorting and Nested Sorting

Groups, Sets, and Hierarchies
24 Working with Grouping, Drill Down, and Date Hierarchies
25 Working with Sets
26 Using Parameters to Control Visualization Interactivity

Create Custom Calculations and Fields
27 Working with Table Calculations
28 Quick Table Calculations – Running Total and Difference
29 Quick Table Calculations – Percent Difference and Percent of Total
30 Quick Table Calculations – Rank
31 Understanding Window Table Calculations
32 Nested Table Calculations in Tableau
33 Creating Ad-hoc Calculations

Reference Lines, Parameters, and Analysis
34 Using Reference Lines
35 Using Parameters to Create and Control Reference Lines
36 Using Step and Jump Lines
37 Clustering Data in Tableau
38 Creating Pareto Charts in Tableau
39 Visualize Benford’s Law

Run Complex Queries with Level-of-Detail Expressions
40 Exploring Level-of-Detail (LOD) Expressions
41 Going from Regular Expressions to Level-of-Detail Expressions
42 Working with Fixed, Include, Exclude Expressions
43 Using Nested LOD Expressions
44 Using Filters and LODs

Spatial Analysis, Mapping Geographical Data, and Geocoding
45 Connecting to Existing Spatial Data
46 Develop Geographic Visualizations Using Colors, Shapes, and Filtering
47 Dual Layer Mapping
48 Custom Geocoding
49 Working with Pathway and Territories

Create Dashboards and Actions
50 Data Visualization Best Practices for Effective Dashboards
51 Formatting Data with Different Formatting Techniques
52 Design Tricks for Great Dashboards
53 Actions and Highlighting on Dashboards
54 Storyboarding