DWH Modeling Process

Your task is to design a data warehouse, taking into consideration your best knowledge and expertise. We are also interested in understanding the reasoning behind your design decisions, your overall thought process, and any assumptions you have made.

What I expect is:
Logical data model
Explain etl loading of the star schema
SQL based on your data model in order to answer the questions in the test