Dimensional modeling and SQL

Individual Project

Instructions

Review the data set of the project. It includes a sample report (rows 1 to 4) a set of business rules (five) and six business questions.

Design a dimensional model that support the generation of the report and observe the business rules. In addition, the model should be able to be used to answer the business questions.