Book Image

Learning Tableau 2019 - Third Edition

By : Joshua N. Milligan
Book Image

Learning Tableau 2019 - Third Edition

By: Joshua N. Milligan

Overview of this book

Tableau is the gold standard of business intelligence and visual analytics tools in every industry. It enables rapid data visualization and interpretation with charts, graphs, dashboards, and much more. Updated with the latest features of Tableau, this book takes you from the foundations of the Tableau 2019 paradigm through to advanced topics. This third edition of the bestselling guide by Tableau Zen Master, Joshua Milligan, will help you come to grips with updated features, such as set actions and transparent views. Beginning with installation, you'll create your first visualizations with Tableau and then explore practical examples and advanced techniques. You'll create bar charts, tree maps, scatterplots, time series, and a variety of other visualizations. Next, you'll discover techniques to overcome challenges presented by data structure and quality and engage in effective data storytelling and decision making with business critical information. Finally, you'll be introduced to Tableau Prep, and learn how to use it to integrate and shape data for analysis. By the end of this book, you will be equipped to leverage the powerful features of Tableau 2019 for decision making.
Table of Contents (18 chapters)
Free Chapter
1
Section 1: Tableau Foundations
5
Section 2: Leveraging the Full Power of Tableau
10
Digging Deeper - Trends, Clustering, Distributions, and Forecasting
11
Section 3: Data Prep and Structuring
14
Section 4: Advanced Techniques and Sharing with Others

Quick Table Calculations

Quick Table Calculations are predefined Table Calculations that can be applied to any field used as a measure in the view. These calculations include common and useful calculations such as running total, difference, percent difference, percent of total, rank, percentile, moving average, YTD total, compound growth rate, Year over Year Growth, and YTD growth. You'll find applicable options on the drop-down list on a field used as a measure in the view, as shown in the following screenshot:

Consider the following example using the sample Superstore Sales data:

Here, Sales over time are shown. Sales has been placed on the Rows shelf twice and the second SUM(Sales) field has had the Running Total Quick Table Calculation applied. Using the Quick Table Calculation avoided writing any code.

You can actually see the code that the Quick Table Calculations...