Reader small image

You're reading from  Tableau Cookbook - Recipes for Data Visualization

Product typeBook
Published inDec 2016
PublisherPackt
ISBN-139781784395513
Edition1st Edition
Tools
Right arrow
Author (1)
Shweta Sankhe-Savale
Shweta Sankhe-Savale
author image
Shweta Sankhe-Savale

Shweta Sankhe-Savale is the Co-founder and Head of Client Engagements at Syvylyze Analytics (pronounced as "civilize"), a boutique business analytics firm specializing in visual analytics. Shweta is a Tableau Desktop Qualified Associate and a Tableau Accredited Trainer. Being one of the leading experts on Tableau in India, Shweta has translated her experience and expertise into successfully rendering analytics and data visualization services for numerous clients across a wide range of industry verticals. She has taken up numerous training as well as consulting assignments for customers across various sectors like BFSI, FMCG, Retail, E-commerce, Consulting & Professional Services, Manufacturing, Healthcare & Pharma, ITeS etc. She even had the privilege of working with some of the renowned Government and UN agencies as well. Combining her ability to breakdown complex concepts, with her expertise on Tableau's visual analytics platforms, Shweta has successfully trained over a 1300+ participants from 85+ companies.
Read more about Shweta Sankhe-Savale

Right arrow

Chapter 6. Serve It on a Dashboard!

In this chapter, we will cover the following recipes:

  • Combining multiple visualizations into a dashboard

  • Using the filter action

  • Using the highlight action

  • Using the URL action

Introduction


In all the previous chapters, we've created various visualizations and all these visualizations are either individual charts or analysis. Individual charts or analytics provide specific and limited information, like a single piece of a larger puzzle. As we put the pieces together, a larger picture takes shape. This is what we do on a dashboard. A dashboard is a collection of several worksheets and their supporting information put together to convey a broader perspective. A dashboard allows us to facilitate interactivity between individual worksheets, provides a unified view to present or to compare a variety of information and disseminate this information in a structured and fluent manner.

Combining multiple visualizations into a dashboard


A very important yet often neglected aspect of dashboard design is its ability to communicate information in a seamless and coherent manner; without this, a dashboard becomes nothing more than a series of unrelated views and scattered information.

In order to make the dashboard more holistic and useful, it needs to be designed with a specific purpose in mind. Different people in an organization will need different slices of information and each resulting dashboard should be aligned to this specific purpose. For example, a CXO will typically want to look at a higher or macro level of information that gives him a pulse of the overall health of the business, whereas a marketing head would want to look at a more granular perspective, of say his customer segmentation and transactional behavior, in order to plan a more effective marketing strategy.

To create and use dashboards in Tableau, let us follow the recipe given here.

Getting ready

In order...

Using the filter action


As the name suggests, this action will help us drill down from a master view to show related and more detailed information in one or more target sheets. For example, drilling down to show relevant States by selecting a particular Region and further drilling down to show relevant cities by selecting a particular State from the filtered view. This kind of a structured drill down is often referred to as guided analytics. Let us understand how to create and use filter actions in Tableau.

Getting ready

We will use the already built dashboard for this recipe. We will begin by duplicating this dashboard and then creating the filter action to drill down from Sales distribution by Region sheet to Sales distribution by State as well as Sales distribution by Region and Category sheet. Let's get started.

How to do it…

  1. Begin by right-clicking on the Dashboard tab which says My first Tableau Dashboard and selecting the Duplicate Sheet option. Refer to the following screenshot:

  2. Rename...

Using the highlight action


In the previous recipe, we saw the filter action which basically filters the view based on the selection. However, if you don't wish to filter the view but instead just draw attention to certain marks that are of interest, then a great way to do so is to simply color them and dim the rest. This is what we use highlight actions for. As the names suggests, this action highlights the marks based on a certain selection while dimming the other marks. This way we can draw attention to the points of interest while being able to compare them with the other marks as well.

Let us see how to create and use a highlight action.

Getting ready

We will use the already built dashboard for this recipe. We will begin by duplicating the My first Tableau Dashboard and then creating the highlight action from Sales distribution by Region sheet to Sales distribution by State as well as Sales distribution by Region and Category sheet to highlight only the selected region. Let's get started...

Using the URL action


There are times when we would want to access more information about data that maybe hosted outside our data source. This information could either be on a web page, file, or other web-based resources that are outside of Tableau. To access these from our Tableau workbook, we will need to create hyperlinks. These hyperlinks can be created using a URL action. Thus, a URL action is a hyperlink that points to a web page, file, or other web-based resources that are outside of Tableau.

Further, we can pass values and replace the field values in the URL to make the link more relevant to our data. Let us follow the recipe that is given here, to understand the URL action better.

Getting ready

For this recipe, we will first create a new dashboard which has a map that shows state-level information. We will then embed a web page which will be a Wikipedia page and try to pass values from our Tableau view to show the relevant information on the web page. Let's get started.

How to do it...

lock icon
The rest of the chapter is locked
You have been reading a chapter from
Tableau Cookbook - Recipes for Data Visualization
Published in: Dec 2016Publisher: PacktISBN-13: 9781784395513
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
undefined
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime

Author (1)

author image
Shweta Sankhe-Savale

Shweta Sankhe-Savale is the Co-founder and Head of Client Engagements at Syvylyze Analytics (pronounced as "civilize"), a boutique business analytics firm specializing in visual analytics. Shweta is a Tableau Desktop Qualified Associate and a Tableau Accredited Trainer. Being one of the leading experts on Tableau in India, Shweta has translated her experience and expertise into successfully rendering analytics and data visualization services for numerous clients across a wide range of industry verticals. She has taken up numerous training as well as consulting assignments for customers across various sectors like BFSI, FMCG, Retail, E-commerce, Consulting & Professional Services, Manufacturing, Healthcare & Pharma, ITeS etc. She even had the privilege of working with some of the renowned Government and UN agencies as well. Combining her ability to breakdown complex concepts, with her expertise on Tableau's visual analytics platforms, Shweta has successfully trained over a 1300+ participants from 85+ companies.
Read more about Shweta Sankhe-Savale