From the course: Cleaning, Transforming and Prepping Your Data With Tableau Prep
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Challenge 3: Cleaning data - Tableau Tutorial
From the course: Cleaning, Transforming and Prepping Your Data With Tableau Prep
Challenge 3: Cleaning data
- [Instructor] Here's a challenge to practice cleaning the data. We're looking at our airline data, and we've discovered that there's some things that need cleaning. So first we're going to use a custom split to change the Airline Description into the Airline and the Airline Code. Second, we're then going to go through the Airline and group all of the values together because Southwest has several different spellings. Finally, exclude any of the other data that looks incorrect. This should take you around five minutes.
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)
Splitting fields into new ones3m 34s
-
(Locked)
Removing and renaming fields2m 40s
-
(Locked)
Cleaning data using calculated fields3m 33s
-
(Locked)
Filtering data3m 48s
-
(Locked)
Grouping values3m 48s
-
(Locked)
Replacing values3m 49s
-
(Locked)
Keeping track of changes4m 23s
-
(Locked)
Challenge 3: Cleaning data33s
-
(Locked)
Solution 3: Cleaning data2m 43s
-
(Locked)
-
-
-
-
-
-