Tableau Cookbook – Recipes for Data Visualization

Chapter 7. The Right MIX – Blending Multiple Data Sources

In this chapter, we will focus on various aspects of connecting to data and we will cover the following recipes:

• Understanding Multiple Table Join within a single database
• Understanding Multiple Table Join across databases
• Understanding Data Blending
• Understanding and using Unions
• Using Custom SQL Query to fetch data
• Working with Tableau Extracts

Introduction

So far, in all the previous chapters, we've created various visualizations. For each of these visualizations or sheets, we connected to a single data source at a time using the Live connect option in Tableau. However, there are going to be circumstances when data from a single database table or even for that matter a single database may not ...