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

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.

Contents