Book Image

The Tableau Workshop

By : Sumit Gupta, Sylvester Pinto, Shweta Sankhe-Savale, JC Gillet, Kenneth Michael Cherven
Book Image

The Tableau Workshop

By: Sumit Gupta, Sylvester Pinto, Shweta Sankhe-Savale, JC Gillet, Kenneth Michael Cherven

Overview of this book

Learning Tableau has never been easier, thanks to this practical introduction to storytelling with data. The Tableau Workshop breaks down the analytical process into five steps: data preparation, data exploration, data analysis, interactivity, and distribution of dashboards. Each stage is addressed with a clear walkthrough of the key tools and techniques you'll need, as well as engaging real-world examples, meaningful data, and practical exercises to give you valuable hands-on experience. As you work through the book, you'll learn Tableau step by step, studying how to clean, shape, and combine data, as well as how to choose the most suitable charts for any given scenario. You'll load data from various sources and formats, perform data engineering to create new data that delivers deeper insights, and create interactive dashboards that engage end-users. All concepts are introduced with clear, simple explanations and demonstrated through realistic example scenarios. You'll simulate real-world data science projects with use cases such as traffic violations, urban populations, coffee store sales, and air travel delays. By the end of this Tableau book, you'll have the skills and knowledge to confidently present analytical results and make data-driven decisions.

Related Content you might be interested in

Current Title:

Small book image
The Tableau Workshop
Sumit Gupta | Sylvester Pinto | Shweta Sankhe-Savale | JC Gillet | Kenneth Michael Cherven
Apr, 2022 | 822 pages
Small book image
Tableau Desktop Certified Associate: Exam Guide
Dmitry Anoshin | Gleb Makarenko | Fabian Peri | JC Gillet | Radhika Biyani
Dec, 2019 | 370 pages
Small book image
Learning Tableau 2020
Joshua N Milligan
Aug, 2020 | 576 pages
Small book image
Learning Tableau 2022
Joshua N Milligan
Aug, 2022 | 568 pages
Table of Contents (12 chapters)
Preface
About the Book
1
1. Introduction: Visual Analytics with Tableau
1. Introduction: Visual Analytics with Tableau
Introduction
The Importance of Visual Analytics
The Tableau Product Suite
Introduction to Tableau Desktop
Data Visualization Using Tableau Desktop
Saving and Sharing Your Work
Summary
Free Chapter
2
2. Data Preparation: Using Tableau Desktop
2. Data Preparation: Using Tableau Desktop
Introduction
Connecting to a Data Source
Various Joins in Tableau
Data Transformation in the Data Pane
Data Blending
Summary
3
3. Data Preparation: Using Tableau Prep
3. Data Preparation: Using Tableau Prep
Introduction
Prep Interface
Adding Data in the Flow
Data Source Profile
Data Preparation Using Clean, Groups, and Split
Aggregation, Pivot, Join, and Union
Flow and Data Exports
Summary
4
4. Data Exploration: Comparison and Composition
4. Data Exploration: Comparison and Composition
Introduction
Exploring Comparisons across Dimensional Items
Exploring Comparisons over Time
Exploring Comparison across Measures
Exploring Composition Snapshots – Stacked Bar Charts
Exploring Composition Snapshots – Pie Charts
Exploring Compositions for Trended Data
Summary
5
5. Data Exploration: Distributions and Relationships
5. Data Exploration: Distributions and Relationships
Introduction
Exploring Distribution for a Single Measure
Relationship and Distribution with Multiple Measures
Scatter Plots with Trend Lines
Advanced Charts
Summary
6
6. Data Exploration: Exploring Geographical Data
6. Data Exploration: Exploring Geographical Data
Introduction
Importing Spatial Data
Importing Non-Spatial Geographic Data Sources
Managing Location Data
Creating Maps in Tableau
Summary
7
7. Data Analysis: Creating and Using Calculations
7. Data Analysis: Creating and Using Calculations
Introduction
Creating and Using Ad hoc / Edit in Shelf Calculations
Creating and Using Different Types of Calculations
Handling Null Values while Creating and Using Calculations
Creating Calculations across Data Sources
Summary
8
8. Data Analysis: Creating and Using Table Calculations
8. Data Analysis: Creating and Using Table Calculations
Introduction
Quick Table Calculations
Table Calculation Application: Addressing and Partitioning
Creating, Editing, and Removing Table Calculations
Summary
9
9. Data Analysis: Creating and Using Level of Details (LOD) Calculations
9. Data Analysis: Creating and Using Level of Details (LOD) Calculations
Introduction
Types of LOD Calculations
LOD Calculations: Dimensions or Measures?
Effects of Filters on LOD Calculations
Summary
10
10. Dashboards and Storyboards
10. Dashboards and Storyboards
Introduction
The Who, What, and Why of the Dashboard
Designing a Dashboard
Creating Storyboards
Summary
11
11. Tableau Interactivity: Part 1
11. Tableau Interactivity: Part 1
Introduction
Grouping Data
Hierarchies
Filters: The Heart and Soul of Tableau
Sets
Parameters
Summary

Introduction

In the previous chapter, you performed some fundamental data transformations such as joins, filtering, and groups using Tableau Desktop. However, Tableau Desktop only performs basic data manipulation. It may not be able to handle raw unprocessed/unclean data, like data containing multiple entries, missing entries, or inconsistent formats. Now, you will learn about more advanced methods, better suited to these trickier scenarios.

Tableau Prep is a tool specifically designed to perform data transformation so we can use the data for our visualizations. It consists of advanced algorithms that help detect data inconsistencies and fix them. This can be done automatically as well as manually, depending on the requirements.

In this chapter, you will learn about the Prep interface, along with data operations like adding data sources, data profiling, and applying transformations such as cleaning, splitting, adding pivots, joining data sources, and applying unions. Finally...

Previous Section
End of Section 2
Next Section