From the course: Cleaning, Transforming and Prepping Your Data With Tableau Prep

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Challenge 5: Aggregate data

Challenge 5: Aggregate data - Tableau Tutorial

From the course: Cleaning, Transforming and Prepping Your Data With Tableau Prep

Start my 1-month free trial

Challenge 5: Aggregate data

“

- [Instructor] Here's a challenge all about aggregations. First, you're going to open up Challenge 06_03 in your Exercise folder. You're going to import the data from the Full Flight Delays.csv file. This is about half a million records. Next, you're going to need to aggregate that flight delay data to only show the average delay by the Unique Carrier and the Tail Number. Now I want to combine this data to our flight data we've been using previously. We want to join the result of the aggregation to a branch after the union in the existing flight. Finally, compare the results of the aggregation and the join to the shorter, smaller data set that we used before. Can you see any differences between the two? This should take you around five minutes.

Contents