(Answered):Mis450 Portfolio Milestone 6 . . . .

Question Description

Option #1: Northwind Data Mining and Statistical Analysis – Data Warehouse

The purpose of this milestone assignment is to complete the tasks described below in preparation for your final project delivery.

1. Data Warehouse:
   • Create a data warehouse database, including the fact and dimension tables (star schema).
   • Create the schema for each table.
   • Populate the tables using either ETL (Pentaho) or SQL (PostgreSQL).
2. Preprocessing for SAS:
   • Extract data from the data warehouse, creating a file for input into SAS. The format of the file is your choice. Ensure SAS University Edition accepts your selected format.

You should use the plan formulated in Milestone 1 of Module 3