create a data warehouse database including the fact and dimension tables star schema 5346069

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: o Create a data warehouse database, including the fact and dimension tables (star schema). o Create the schema for each table. o Populate the tables using either ETL (Pentaho) or SQL (PostgreSQL). 2. Preprocessing for SAS: o 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 for the detailed steps you intend to follow. For this milestone assignment, you are expected to submit: • Screenshots of the populated data warehouse • Star schema design, either a drawing or screenshot • Row counts for the fact and dimension tables • Brief description of your key learnings from completing this assignment Your assignment must meet the following requirements: Be 2-4 pages in length, not including the cover and references pages. Your paper should include an introduction, a body with at least two fully developed paragraphs, and a conclusion. Be supported with at least two scholarly journal articles (at least one of which is peer-reviewed).

"Get 15% discount on your first 3 orders with us"
Use the following coupon

Order Now