From a product analytics perspective I’d suggest :
1. Think of a product that exists. Define a goal for the product and success metrics you will use. Dau, mau, user retention,incremental revenue etc.
2. Come up with gaurd rail metrics
3. Define performance and reliability metrics as well.
Now try to figure out how you would construct queries to answer these questions. And how would you visualize this info.
Then if you can find datasets or create synthetic data sets to actually write these queries or better yet create pipelines that ultimately feed a dashboard I think would be worthwhile.
