Exercise – Scenario 3

As a final activity in this chapter, you can do a self-assessment exercise to solve an additional business question from business users. Our operational user from scenario 2 wants to ask this additional question:

Show me the top three regions that have the most female riders as of the most recent date (2018-01-02).

Because the gender of members is not yet included in our fact and dimension table, you need to create a different fact and dimension table for this. 

Remember that the data model is subjective, especially in the Kimball method. There is no right or wrong answer to the question. As we've discussed in this chapter, everyone can have different data models to represent the real world. 

Try to solve it yourself and compare it to the solution in the Git code example:

• Chapter-3\code\bigquery_self_excercise_create_dim_table_regions.py
• Chapter-3\code\bigquery_self_excercise_create_fact_table_daily_by_gender_region...