First, I need to apologize to DS22. Wednesday was much harder than I thought it would be. So today, I'm not going to require them to use Power BI as was the plan. They haven't had much time to actually build dashboards, which kind of defeats the purpose of dashboard week. DS22 should be quite proud of how hard they've worked and how much they've learned.
For day 4, the team will create a dashboard about food waste from OECD. From the OECD website:
The OECD food waste dataset is a compilation of available data related to food loss and food waste for 32 countries. The period covered may vary across different countries depending on data availability (globally ranging from 1993 to 2013).
The data definitely needs some cleaning, which I would like them to at least have a go at. Let's say that if they don't have the data prep done by 10:30am, then they can download the cleaned data set here, thanks for Valerija. I do expect them to present their workflows to see if they've completed the data prep or how far they were able to get. Bonus points for uploading the data to Snowflake as well, but this is not a requirement.
That then leaves plenty of time to create a dashboard. With this much time, surely they'll create something beautiful. Remember to work alone, write a blog post, use any tool you'd like to prep the data and use whatever tool you'd like to create the dashboard. Presentations at 3pm.