From the course: Tableau 10 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Joining related data sources - Tableau Tutorial
From the course: Tableau 10 Essential Training
Joining related data sources
- [Instructor] One of the fundamental principles of good data design is spreading your data out so that individual tables store information about a particular business entity. For example, you might have a set of hotels that are in different cities and each one of those hotels could have a property ID, the property city and then the property state. Another table might have a list of employees for the entire company with a field indicating which property they work at. You could then link those two tables together based on the common field of the property ID. In this movie, I will show you how to create a connection between related tables within a data source. I have run Tableau, but I haven't created a workbook yet. What I want to do is connect to a data source that contains multiple tables. So here on the start screen, I will go over to the connect pane and click excel. Doing so displays the exercise files folder and the chapter two sub folder, and what I want to do is to connect…
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
-
-
-
-
(Locked)
Connecting to a data source1m 56s
-
(Locked)
Joining related data sources3m 27s
-
Joining related fields with inconsistent names2m 58s
-
(Locked)
Cleaning up source data2m 37s
-
(Locked)
Creating a visualization using Show Me2m 42s
-
(Locked)
Changing the order of the fields in a visualization2m 53s
-
(Locked)
Changing the summary operation2m 51s
-
(Locked)
Splitting text into multiple columns2m 31s
-
(Locked)
Presenting data using Storylines5m 24s
-
(Locked)
-
-
-
-
-
-
-
-
-
-
-
-
-