DBM 460 Week 3 Dimensional Model Hands On Project

DBM 460 Week 3 Dimensional Model Hands On Project

This is Part Two of the three-part assignment. For this week, you will complete the following:

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.