design database -- 2
Budget: $30 – $250 USD
Represent any system from your choice (every student should give different examples) to build a data warehouse
1. Design your own data warehouse having at a minimum one fact table and four dimensions tables.
Some examples might be, student data, banking, insurance, real estate, travel etc
2. Create the bus matrix of Business Processes and Common Dimensions (example below)
Enterprise Data Warehouse Bus Architecture - Kimball Group
3. What are 5 Key Performance Indicators (KPI’s) you would measure based on your design?
4. Design the logical schema
5. Create fact and dimensions text files with at a minimum 10 rows of data (fictitious data)
6. Create a physical schema and load records
Deliverables:
7. Submit a word document with (Bus Matrix, KPIs, ERD, Screenshot of loaded tables) - 60 points
8. Submit the .sql file used to create a database tables – 20 points
9. Submit Tableau prep file for your ETL – 20 points
1. Design your own data warehouse having at a minimum one fact table and four dimensions tables.
Some examples might be, student data, banking, insurance, real estate, travel etc
2. Create the bus matrix of Business Processes and Common Dimensions (example below)
Enterprise Data Warehouse Bus Architecture - Kimball Group
3. What are 5 Key Performance Indicators (KPI’s) you would measure based on your design?
4. Design the logical schema
5. Create fact and dimensions text files with at a minimum 10 rows of data (fictitious data)
6. Create a physical schema and load records
Deliverables:
7. Submit a word document with (Bus Matrix, KPIs, ERD, Screenshot of loaded tables) - 60 points
8. Submit the .sql file used to create a database tables – 20 points
9. Submit Tableau prep file for your ETL – 20 points