As a group, identify interesting data that is available via a Google Cloud public dataset or API. Then, your task in this homework is to use SQL to create new tables from the data that are amenable to visualization, and then create a dashboard of your visualizations and analyis using Looker/Data Studio.
For example, a previous group once visualized the link between the Covid economic slowdown and a drop in carbon intensity in the air in the UK. Here is an example notebook (note that the Data Studio dashboard linked in this notebook is not available as it requires the use of tables hosted in Google Cloud which rely on credits that have been exhausted).
- Submit a colaboratory notebook telling the story of why that data is of interest to your group, explain your choice of API, your process for extracting and transforming the data, as well as provide the link to your Data Studio dashboard and to all of the tables that the dashboard relies upon (stored in Google Cloud).
- Utilization of data includes points for groups which produce easily reproducible projects. That is, projects which anyone in the class can open and begin modifying to answer variations on questions that were asked.
- After the projects have been graded, groups will be invited to share their notebooks with the class by providing the link. This is voluntary. The shared notebooks will be available as an internal blog for the class to use to learn from.