Book Image

Tableau Dashboard Cookbook

By : Jen Stirrup
Book Image

Tableau Dashboard Cookbook

By: Jen Stirrup

Overview of this book

<p>With increasing interest and enthusiasm for data visualization in the media, businesses are looking to create effective dashboards that engage as well as communicate the truth of data. Tableau makes data accessible to everyone, and is a great way of sharing enterprise dashboards across the business. The deceptively simple Tableau interface hides a variety and complexity of features available for dashboarding, and this book will help you to become familiar with these features.</p> <p>Tableau offers an easy-to-use and fun way of designing, constructing, and sharing your dashboards. This book will familiarize you with its features and enable you to develop and enhance your dashboard skills, starting with an overview of what dashboard is followed by how you can collect data using various mathematical formulas. Next you'll learn to filter and group data, as well as how to use various functions to present the data in an appealing and accurate way. The book will also teach you how to use the key advanced string functions to play with data and images. You will be walked through the various features of Tableau including dual axes, scatterplot matrices, heat maps, and sizing. Finally, this book will help you consider what to do next with your dashboard, whether it's on a server or in collaboration with other tools.</p>
Table of Contents (16 chapters)
Tableau Dashboard Cookbook
Credits
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Index

Blending data


If a workbook uses data from more than one data source, you can blend data. Blending data is different from joining tables. It enables you to combine data from different sources. Tableau makes it very simple to perform this activity.

If you have more than one source of data, you can blend it together in Tableau. Alternatively, you might want to blend the data in a data warehouse or a data store in a single place, outside of the Tableau software.

Sometimes, when we put data together, we get an error message saying Fields cannot be used from the data source…. This means Tableau could not associate the new imported file with the existing file because it could not match any of the column names. This recipe will explain how to get around this issue.

Getting ready

For the exercises in this recipe, let's continue working on the Chapter 6 workbook.

How to do it…

  1. Duplicate the Golden Record worksheet and rename the copy to Blending Example.

  2. Next, import the HDI.xlsx file by going to the Data...