Northwind Data Mining and Statistical Analysis Project – Planning

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).
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.
Statistical Analysis Using SAS:

Import data created in the preprocessing step.
Conduct statistical analysis using the appropriate statistics from each category:
Summary statistics
Prepare an analysis report.