Dimensional Model Hands On Project

Resource: Business and Management Scenario assignment (attached) Write a 3- to 4-page paper addressing the following: Create the following components:

• Refined dimensional model • Database table structure

Design and document appropriate ETL processes that populate your dimensional model database. Create reports against your data warehouse that will help management analyze, solve, and monitor the issues.