Here's the deal. I have my assignment from last week, and some data about the virtual (fictional) organization that I'm working with. The paper needs to expand on the previous assignment, and include the requirements below, using the data from the included attachments.
Previous assignment: Week 2 Assignment.docx
Kudler Foods resource material: kudler.mdb and databaseDiagram.png
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 (Microsoft SQL)