Tableau 2019.x Cookbook电子书

Title Page

Copyright and Credits

Tableau 2019.x Cookbook

About Packt

Why subscribe?

Packt.com

Foreword

Dedication

Contributors

About the authors

About the reviewers

Packt is searching for authors like you

Preface

Who this book is for

What this book covers

To get the most out of this book

Download the example code files

Download the color images

Conventions used

Sections

Getting ready

How to do it…

How it works…

There's more…

See also

Get in touch

Reviews

Getting Started with Tableau Software

Technical requirements

Introduction to Tableau

Connecting to the data

Getting ready

How to do it…

How it works...

There's more…

See also

Building a bar chart using Show Me

Getting ready

How to do it…

Creating a chart using Show Me

Sorting the chart

How it works...

There's more…

See also

Building a text table

Getting ready

How to do it…

How it works...

There's more…

See also

Adding filters

Getting ready

How to do it…

How it works...

There's more…

See also

Adding color

Getting ready

How to do it…

How it works...

There's more…

See also

Building a tree map

Getting ready

How to do it...

How it works...

There's more…

See also

Building a map

Getting ready

How to do it…

Creating a map with circles

Creating a map with a color gradient

How it works...

There's more…

See also

Building a dual-axis map

Getting ready

How to do it…

How it works...

There's more…

See also

Customizing tooltips

Getting ready

How to do it…

How it works...

There's more…

See also

Data Manipulation

Technical requirements

Introduction

Joining data sources

Getting ready

How to do it…

How it works...

There's more…

See also

Adding a secondary data source

Getting ready

How to do it…

How it works...

There's more…

See also

Data blending

Getting ready

How to do it…

How it works...

There's more…

See also

Data union

Getting ready

How to do it…

How it works...

There's more…

See also

Using Tableau Pivot

Getting ready

How to do it…

How it works...

There's more…

See also

Preparing data

Getting ready

How to do it…

Splitting fields

Converting measures into dimensions

Renaming fields

Adding aliases

How it works...

There's more…

See also

Tableau Extracts

Introduction

Overview of different file formats in Tableau

How to do it...

Tableau Workbook (TWB)

Tableau Packaged Workbook

Tableau Bookmark

Tableau Data Extract

Hyper

How it works...

Tableau Workbook

Tableau Packaged Workbook (TWBX)

Tableau Bookmark (TBM)

Creating a data source extract

Getting ready

How to do it...

Connecting to data

Creating an extract

Optional settings for extracts

How it works...

There's more...

See also

Configuring an incremental extract

Getting ready

How to do it...

How it works...

There's more...

See also

Upgrading to Hyper

Getting ready

How to do it...

How it works...

See also

Creating extracts using cross-database joins

Getting ready

How to do it...

How it works...

See also

Troubleshooting extracts with Tableau Server

Getting ready

How to do it...

How it works...

There's more...

See also

Tableau Desktop Advanced Calculations

Technical requirements

Introduction

Creating calculated fields

Getting ready

How to do it…

How it works...

There's more…

See also

Implementing quick table calculations

Getting ready

How to do it…

How it works...

There's more…

See also

Creating and using groups

Getting ready

How to do it…

How it works...

There's more…

See also

Creating and using sets

Getting ready

How to do it…

How it works...

There's more…

See also

Creating and using parameters

Getting ready

How to do it…

How it works...

There's more…

See also

Implementing the basics of level of detail expressions

Getting ready

How to do it…

How it works...

There's more…

See also

Using custom geocoding

Getting ready

How to do it…

How it works...

There's more…

See also

Using polygons for analytics

Getting ready

How to do it…

How it works...

There's more…

See also

Tableau Desktop Advanced Filtering

Technical requirements

Introduction

Implementing a top N filter

Getting ready

How to do it…

How it works...

There's more…

See also

Adding filters to context

Getting ready

How to do it…

How it works...

There's more…

See also

Creating a measure filter

Getting ready

How to do it…

How it works...

There’s more…

See also

Creating date range filters

Getting ready

How to do it…

How it works...

There's more…

See also

Creating relative dates filters

Getting ready

How to do it…

How it works...

There's more…

See also

Implementing table calculation filters

Getting ready

How to do it…

How it works...

There's more…

See also

Implementing action filters

Getting ready

How to do it…

How it works...

There's more…

See also

Building Dashboards

Technical requirements

Introduction

Creating a dashboard

Getting ready

How to do it…

How it works...

There's more…

See also

Formatting a dashboard

Getting ready

How to do it…

Setting and formatting dashboard title

Formatting worksheet titles

Formatting text objects

Formatting the dashboard background

How it works...

There's more…

See also

Setting filters

Getting ready

How to do it…

Setting filters through the dashboard

Setting filters through the worksheet

Filtering by worksheets in the dashboard – action filters

How it works...

There's more…

See also

Setting filters across various data sources

Getting ready

How to do it…

How it works...

There's more…

See also

Adding highlight actions

Getting ready

How to do it…

How it works...

There's more…

See also

Setting layouts

Getting ready

How to do it…

Setting a fixed size

Setting the automatic size

Setting the range size

Adding a device layout

Customizing the device layout

How it works...

There's more…

See also

Building a self-service dashboard

Getting ready

How to do it…

Switching between dimensions with parameters

Adding a hyperlink to an image object

Adding a web page to the dashboard

Adding an action filter

How it works...

There's more…

See also

Telling a Story with Tableau

Technical requirements

Introduction

Creating a Tableau story

Getting ready

How to do it…

How it works...

There's more...

See also

Setting the narrative of the Story

Getting ready

Conflict

How to do it…

How it works...

Development

How to do it…

How it works...

Climax

How to do it…

How it works...

Resolution

How to do it…

How it works...

There's more...

See also

Choosing the right charts

Getting ready

How to do it…

How it works

There’s more…

See also

Writing effective headlines

Getting ready

How to do it…

How it works...

Recommendation and executive summary

Getting ready

How to do it…

How it works...

There's more…

See also

Formatting the Story

Getting ready

How to do it…

How it works...

There's more...

See also

Tableau Visualization

Technical requirements

Introduction

Dual axis waterfall chart

Getting ready

How to do it...

How it works...

There's more...

See also

Pareto chart

Getting ready

How to do it...

How it works...

There's more...

See also

Bump chart

Getting ready

How to do it...

How it works...

There's more...

See also

Sparklines chart

Getting ready

How to do it...

How it works...

There's more...

See also

Donut chart

Getting ready

How to do it...

How it works...

There's more...

See also

Motion chart

Getting ready

How to do it...

How it works...

There's more...

See also

Tableau Advanced Visualization

Technical requirements

Introduction

Lollipop charts

Getting ready

How to do it...

How it works...

There's more...

See also

Sankey diagrams

Getting ready

How to do it...

How it works...

See also

Marimekko charts

Getting ready

How to do it...

How it works...

There's more...

Hex-Tile maps

Getting ready

How to do it...

How it works...

See also

Waffle charts

Getting ready

How to do it...

How it works...

There's more...

See also

Tableau for Big Data

Technical requirements

Introduction

Connecting with Amazon Redshift

Getting ready

How to do it…

Creating an AWS account

Creating an IAM role

How it works…

Launching an Amazon Redshift cluster

How to do it…

How it works…

There's more…

Connecting a Redshift cluster

How to do it…

How it works…

There's more…

Loading sample data into the Redshift cluster

How to do it…

How it works…

There's more…

Connecting Redshift with Tableau

How to do it…

How it works…

Creating a Tableau report

How to do it…

How it works…

There's more…

Tuning Redshift for efficient Tableau performance

How to do it...

How it works...

There's more…

See also

Connecting to Amazon Redshift Spectrum

Getting ready

How to do it…

How it works...

There's more…

See also

Connecting to Snowflake

Getting ready

How to do it…

How it works...

Using SnowSQL CLI

How to do it…

How it works…

Connecting Tableau to Snowflake

How to do it…

How it works…

Connecting big data

How to do it…

How it works…

There's more…

Accessing semi–structured data

How to do it…

How it works...

There's more…

See also

Connecting Amazon Elastic MapReduce with Apache Hive

Getting ready

How to do it...

How it works...

Creating sample data

How to do it...

How it works...

There’s more…

See also

Connect Tableau with Apache Hive

How to do it…

How it works…

There's more…

See also

Forecasting with Tableau

Technical requirements

Introduction

Basic forecasting and statistical inference

Getting ready

How to do it…

How it works...

There's more…

See also

Forecasting on a dataset with outliers

Getting ready

How to do it…

How it works...

There's more…

See also

Using R within Tableau

Getting ready

How to do it…

How it works...

There's more...

See also

Forecasting based on multiple regression

Getting ready

How to do it…

How it works...

There's more…

See also

Regression with random forest

Getting ready

How to do it…

How it works...

There's more…

See also

Time series forecasting

Getting ready

How to do it…

How it works...

There's more…

See also

Advanced Analytics with Tableau

Technical requirements

Introduction

Running segmentation analysis

Getting ready

How to do it…

How it works...

There's more...

See also

Discovering the latent structure of the dataset

Getting ready

How to do it…

How it works...

There's more…

See also

Extracting the structure beneath discrete variables

Getting ready

How to do it…

How it works...

There's more...

See also

Data mining with tree-based models

Getting ready

How to do it…

How it works...

There's more

See also

Identifying anomalies in data

Getting ready

How to do it…

How it works...

There's more...

See also

Deploy Tableau Server

Technical requirements

Introduction

Deploying Tableau Server in Windows

Getting ready

How to do it...

How it works…

There's more…

See also

Deploying to Tableau Server

Getting ready

How to do it...

How it works...

There's more…

See also

Deploying Tableau Server on Linux using AWS

Getting ready

How to do it...

How it works...

There's more…

See also

Getting started with Tabcmd

Getting ready

How to do it...

How it works...

There's more…

See also

Tableau Troubleshooting

Technical requirements

Introduction

Performance recording

Getting ready

How to do it...

How it works...

There's more...

See also

Performance troubleshooting and best practices

How to do it...

Limiting your data source

Filtering out cases in the database

Filtering out variables

Making extracts

Being cautious with filters

Keeping an eye on the calculations

Optimizing your visualizations

How it works...

There's more...

See also

Troubleshooting through log files

How to do it...

Accessing logs

Submitting logs to the support team

There's more...

See also

Preparing Data for Analysis with Tableau Prep

Introduction

Technical requirements

Installing Tableau Prep

Getting ready

How to do it…

How it works…

There's more…

Building the first flow with Tableau Prep

Getting ready

How to do it...

Connecting the data

Transforming the data

Publishing the result

How it works…

There's more…

Working with big data

Getting ready

How to do it…

How it works…

There's more…

See also…

ETL Best Practices for Tableau

Introduction

Technical requirements

Getting started with Matillion ETL

How to do it...

How it works...

There's more...

Deploying Tabcmd on Linux

How to do it...

How it works...

There's more...

Creating Matillion Shared Jobs

How to do it...

How it works...

Other Books You May Enjoy

Leave a review - let other readers know what you think