Cover
Copyright
Contributors
Table of Contents
Preface
Chapter 1: Reviewing the Basics
Creating worksheets and dashboards
Creating worksheets
Creating a visualization
Beyond the default behavior
Show Me
Creating dashboards
Building a dashboard
Adding interactivity to a dashboard
Connecting Tableau to your data
Connecting to a file
Connecting to Tableau Server
Connecting to saved data sources
Measure Names and Measure Values
Measure Names and Measure Values shortcuts
Three essential Tableau concepts
Dimensions and measures
Row-level, aggregate-level, and table-level calculations
Continuous and discrete
Exporting data to other devices
Exporting data to a mobile phone
Tableau Mobile
Summary
Chapter 2: Getting Your Data Ready
Understanding Hyper
The Tableau data-handling engine
Hyper takeaways
Focusing on data preparation
Surveying data
Establishing null values
Extrapolating data
Cleaning messy data
Cleaning the data
Extracting data
Summary
Chapter 3: Using Tableau Prep Builder
Connecting to data
The Prep GUI
Getting to know Prep
Data quality
Cleaning data
Unions and joins
Adding unions
Wildcard unions
Adding joins
Aggregating
Pivoting
Scripting
Additional options with Prep
Insert Flow
Incremental refresh
Bulk rename
Tableau Prep Conductor
Exporting data
Summary
Chapter 4: Learning about Joins, Blends, and Data Structures
Relationships
Joins
Join queries
Join calculations
Spatial joins
Unions
Blends
Exploring the order of operations
Adding secondary dimensions
Introducing scaffolding
Understanding data structures
Summary
Chapter 5: Introducing Table Calculations
Partition and direction of addressing
Directional and non-directional addressing
Exploring each unique table calculation function
Lookup and Total
Previous Value
Running
Window
First and Last
Index
Rank
Size
Application of functions
Building a playground
Partitioning and addressing with one dimension
Partitioning and addressing with two dimensions
Partitioning and addressing with three dimensions
Guidelines: a reminder
Summary
Chapter 6: Utilizing OData, Data Densification, Big Data, and Google BigQuery
Using the OData connector
Introducing data densification
Domain completion
Deploying domain completion
The usefulness of domain completion
Removing unwanted domain completion
Domain padding
Deploying domain padding
The usefulness of domain padding
Problems of domain padding
Data densification in predictive modeling
Tableau and big data
Building a visualization with Google BigQuery
Summary
Chapter 7: Practicing Level of Detail Calculations
Introducing LODs