Weekly Challenges

AYXAcademy

Hello Community Members,

A solution to last week’s challenge can be found here.

This week’s challenge was created by Jennifer Fugita @Fugi. Thanks, Jennifer, for this fun challenge!

The Great British Baking Show is an iconic baking competition and has been a staple of TV entertainment for 14 seasons. Fans everywhere have been whisking up some burning questions. From age breakdowns to star bakers, handshakes, and more, there is a lot of data to uncover behind the flour, frosting, and fierce competition.

There are five datasets for this challenge:

Bakers.csv includes information about the participants of each season.
Episodes.csv details information about each episode, such as their themes; signature; technical and showstopper baking challenges; and timing to complete each challenge.
The Standardize Themes Text Input tool reveals the baking challenges’ themes and theme categories.
Outcomes.csv includes season episodes, bakers’ names, and how they performed in each episode.
Seasons.csv outlines information about each season’s hosts; judges; winners and the year they won; and information about the network and streaming services where the show is available.

So, grab your apron and your Designer data analytics tools to complete the following tasks:

Calculate the youngest, oldest, and average age of bakers for each gender.
Count how many episodes were in each season and determine which season had the fewest episodes.
Determine the top three baking theme categories across the regular episodes of the 14 seasons. Note that the last episode of each season is a special episode final bake-off. HINT: Exclude the Final theme from the Theme field.
Combine the Outcomes and Seasons datasets to find out the name of the winner who had the most star baker and handshakes combined. HINT: Beware of duplicate values in the Seasons dataset!

Need a refresher? Review the following lessons in Academy to gear up:

Good luck!

The Academy Team

Download Start File

Download Solution File

Data Source:

https://thegreatbritishbakeoff.co.uk/

Dataset:

https://public.tableau.com/app/learn/sample-data