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:
Prepare an analysis report.