DBM 460 Week 3 Part two-Dimensional Model Hands-On Project

DBM 460 Week 3 Part two-Dimensional Model Hands-On Project 

Riordan Manufacturing

This is Part Two of the three-part assignment.

Resource: Business and Management Scenario assignment

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