Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Tableau 10 Business Intelligence Cookbook
  • Toc
  • feedback
Tableau 10 Business Intelligence Cookbook

Tableau 10 Business Intelligence Cookbook

By : Donabel Santos, Paul Banoub
3.8 (5)
close
Tableau 10 Business Intelligence Cookbook

Tableau 10 Business Intelligence Cookbook

3.8 (5)
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 (11 chapters)
close
10
Index

Using union


In this recipe, we will combine a number of comma separated value (CSV) files into a single data set in Tableau.

Getting ready

To follow this recipe, download the business license files from the City of Vancouver's website from http://data.vancouver.ca/datacatalogue/businessLicence.htm:

Download the CSV version, and save all the files in a local directory in your computer:

How to do it...

Here are the steps to prepare the data files:

  1. Click on New Data Source icon and connect to business_licenses.csv which contains the most recent year's records:

  2. Drag New Union to just underneath the business_licenses.csv until you see the Drag table to union message:

  3. Select all other CSV files from the Files pane and drag them to the Union window:

  4. Click on OK after you confirm that all the files have been added to the Union window:

  5. Add a new sheet and create your visualization using this data set.

How it works...

A union operation allows multiple sets of data to be appended to each other, that is, new records...

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
bookmark search playlist download font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete