Book Image

Tableau 10 Business Intelligence Cookbook

By : Donabel Santos, Paul Banoub
Book Image

Tableau 10 Business Intelligence Cookbook

By: Donabel Santos, Paul Banoub

Overview of this book

Tableau is a software tool that can speed up data analysis through its rich visualization capabilities, and help uncover insights for better and smarter decision making. This book is for the business, technology, data and analytics professionals who use and analyze data and data-driven approaches to support business operations and strategic initiatives in their organizations. This book provides easy-to-follow recipes to get the reader up and running with Tableau 10, and covers basic to advanced use cases and scenarios. The book starts with building basic charts in Tableau and moves on to building more complex charts by incorporating different Tableau features and interactivity components. There is an entire chapter dedicated to dashboard techniques and best practices. A number of recipes specifically for geospatial visualization, analytics, and data preparation are also covered. By the end of this book, you’ll have gained confidence and competence to analyze and communicate data and insights more efficiently and effectively by creating compelling interactive charts, dashboards, and stories in Tableau.
Table of Contents (17 chapters)
Tableau 10 Business Intelligence Cookbook
Credits
About the Author
Acknowledgements
About the Reviewer
www.PacktPub.com
Preface
Index

Using blend


In this recipe, we will combine the records from a text file and an Excel file using a blend.

Getting ready

To follow this recipe, download this chapter's files from the Packt website and use the following files:

  • The Airport Geocode—Blend.csv file

  • The Worlds Busiest Airports—Blend.xlsx file

This is the content of the Airport Geocode—Blend.csv file:

These are the records in the Worlds Busiest Airports - Blend.xlsx file:

How to do it...

Here are the steps to blend the two data sources:

  1. Connect to the Excel file in this recipe. Make sure you choose Excel from the To a File section:

  2. Go to new worksheet:

  3. Click on the New Data Source icon, and this time connect to a Text file. Connect to the text file in this recipe:

  4. If you are directed back to the initial connection screen, go back to sheet 1.

  5. Under the Data menu, click on Edit Relationships:

  6. While Airport Geocode—Blend is selected as the Primary data source, click on Custom and match up the Airport Code field to Airport:

  7. Click on OK when done.

  8. While...