From the course: Tableau Certified Data Analyst Cert Prep
Unlock the full course today
Join today to access over 24,600 courses taught by industry experts.
Combining multiple data sources by data blending - Tableau Tutorial
From the course: Tableau Certified Data Analyst Cert Prep
Combining multiple data sources by data blending
- [Presenter] In the previous videos, you saw multiple ways of combining data sources that you have full control over. But what if you do not have full control over all your data sources? What do you do then? Let's say I want to use a published data source and bring in additional data. Let me do that real quick. I add a new data source from Tableau Server, which will be my KinetEco without returns. Now, because this data source does not contain returns, I need a different data source, which will be a CSV file that does contain all of my returns. Let's return to the sheet. Because this one data source has been published, I cannot create joins or relationships anymore. Data blending is my only way of combining a published data source with other data sources. So let's talk about data blending. Blends, unlike relationships or joints, never combine the data directly. Instead, data blending queries, each data source independently then aggregates the results to the appropriate level and…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
Connecting to data6m 41s
-
(Locked)
Combining multiple data sources by union4m 48s
-
(Locked)
Combining multiple data sources by physical join6m 50s
-
(Locked)
Combining multiple data sources by logical relationship3m 21s
-
(Locked)
Combining multiple data sources by data blending6m 5s
-
(Locked)
Preparing the data7m 47s
-
(Locked)
Extracting your data7m 47s
-
(Locked)
Changing the data6m 8s
-
(Locked)
Organizing the data pane7m 3s
-
-
-
-
-
-
-
-
-
-
-