Hello Community members,
A solution to last week’s challenge can be found here.
This is Part 2 of the challenge created by James Gust. Thank you again, James, for this spicy challenge!
In Part 1, you successfully determined the flavor and viscosity labels for each sauce. Now it’s time to take things to the next level and uncover which sauces are the highest-rated!
For this challenge, you are provided with two datasets:
- Hot Sauce Data.xlsx: Contains sauce details, manufacturer, location, and overall ratings, where 5 is the highest and 1 is the lowest.
- Viscosity and Flavor Data Text Input: Lists viscosity and flavor descriptions per Sauce ID.
Your challenge is to create a workflow that displays the highest-rated sauces, meaning that any sauce with an Overall Rating of 5 should be included in the final output.
Also include in your output file:
- Manufacturer name and location
- Sauce name
- Heat sources
- Average overall rating
- Percentage of tasters that "loved" the sauce
- Average spiciness
- Flavor notes and viscosity
Need a refresher? Review the following lessons in Academy to gear up:
Good luck!
The Academy Team
Saucy Challenge
Mildly confusing because the data already has an 'Overall Rating' field and the instructions say 'Any sauces with an overall rating of 5' when the intended was Average Overall Rating.
Or maybe i haven't had my coffee yet...
You will also be reminded you must never use Double data type fields in Joins. 😗
This one had my tongue tingling.
