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
Data Source:
https://thegreatbritishbakeoff.co.uk/
Dataset:
Boom
