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.
Table of Contents (12 chapters)
Preface

Effects of Filters on LOD Calculations

There are different kinds of filters in Tableau. Since LOD calculations modify the aggregation levels based on the view, the filters applied in the view are executed based on the kind of LOD calculation applied. The following chart describes how filters are executed in the view:

Figure 9.29: Order of filter execution

These are defined in greater detail below:

  • Extract Filters: Extract filters are applied when you extract the data, as highlighted in the following figure:

Figure 9.30: Adding an extract filter

Extract filters are executed before LOD calculations.

  • Data Source Filters: These filters are applied when you add data in the Data Explorer tab, as highlighted in the following figure:

Figure 9.31: Adding a data source filter

Like extract filters, data source filters are applied before the LOD calculations execute.

  • Context filters...