Dimensional modeling and SQL
Project 6 Dimensional modeling
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.