From the course: Complete Guide to Tableau for Data Scientists
Unlock the full course today
Join today to access over 24,700 courses taught by industry experts.
Challenge: Combining data, part 1 - Tableau Tutorial
From the course: Complete Guide to Tableau for Data Scientists
Challenge: Combining data, part 1
(upbeat music) - [Instructor] Here's another email we're going to have to deal with. "Can we have those graphs again but with the city name? Here's some extra data that might help. I'll be sending more questions, so add all the data you have." Okay, so it looks like we're going to need to do some combining of our data. So how are we going to achieve this? So the first thing we're going to have to do is add the other four Landon data files into the same single data source. We're not correcting new data sources, we're adding data connections. It's probably a good idea to rename all those internal connections so it reflects the data and be easier to read. And we should check that all the field names make sense and there aren't any duplicates. And let's set some default values where appropriate, things like currencies. Replace the hotel ID with the city name in that visualization. And then let's save the workbook because it sounds like we're going to be using it again.
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
-
-
-
-
-
Combining data using relationships4m 2s
-
(Locked)
What are the different ways of joining data?6m 58s
-
(Locked)
How to join tables in the same data connection6m 39s
-
(Locked)
How to join tables in two using a cross database join5m 22s
-
(Locked)
How to append one data source to another using unions6m 51s
-
(Locked)
Challenge: Combining data, part 157s
-
(Locked)
Solution: Combining data, part 19m 21s
-
(Locked)
Challenge: Combining data, part 242s
-
(Locked)
Solution: Combining data, part 27m 35s
-
-
-
-
-
-
-
-
-
-