Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Learning Tableau 2022

You're reading from   Learning Tableau 2022 Create effective data visualizations, build interactive visual analytics, and improve your data storytelling capabilities

Arrow left icon
Product type Paperback
Published in Aug 2022
Publisher Packt
ISBN-13 9781801072328
Length 568 pages
Edition 5th Edition
Tools
Arrow right icon
Author (1):
Arrow left icon
Joshua N. Milligan Joshua N. Milligan
Author Profile Icon Joshua N. Milligan
Joshua N. Milligan
Arrow right icon
View More author details
Toc

Table of Contents (20) Chapters Close

Preface 1. Taking Off with Tableau FREE CHAPTER 2. Connecting to Data in Tableau 3. Moving Beyond Basic Visualizations 4. Starting an Adventure with Calculations and Parameters 5. Leveraging Level of Detail Calculations 6. Diving Deep with Table Calculations 7. Making Visualizations that Look Great and Work Well 8. Telling a Data Story with Dashboards 9. Visual Analytics: Trends, Clustering, Distributions, and Forecasting 10. Advanced Visualizations 11. Dynamic Dashboards 12. Exploring Mapping and Advanced Geospatial Features 13. Integrating Advanced Features: Extensions, Scripts, and AI 14. Understanding the Tableau Data Model, Joins, and Blends 15. Structuring Messy Data to Work Well in Tableau 16. Taming Data with Tableau Prep 17. Sharing Your Data Story 18. Other Books You May Enjoy
19. Index

Using blends

Data blending allows you to use data from multiple data sources in the same view. Often, these sources may be of different types. For example, you can blend data from Oracle with data from Excel. You can blend Google Analytics data with a spatial file. Data blending also allows you to compare data at different levels of detail. Let’s consider the basics and a simple example.

Data blending is done at an aggregate level and involves different queries sent to each data source, unlike joining, which is done at the row level and (conceptually) involves a single query to a single data source. A simple data blending process involves several steps, as shown in the following diagram:

Figure 14.26: How Tableau accomplishes blending

We can see the following from the preceding diagram:

  1. Tableau issues a query to the primary data source.
  2. The underlying data engine returns aggregate results.
  3. Tableau issues another query to the secondary...
lock icon The rest of the chapter is locked
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.
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 $19.99/month. Cancel anytime