DATA WAREHOUSE DESIGN DOCUMENT

Running head: DATA WAREHOUSE DESIGN DOCUMENT 1 Your Company Name Data Warehouse Design Document (Name) (Date) Data Warehouses: CS683 DATA WAREHOUSE DESIGN DOCUMENT 2 Table of Contents Data Warehouse Requirements (Week 1)......................................................................................................................3 Company Profile.......................................................................................................................................................3 Data Requirements ...................................................................................................................................................3 Design Requirements (Week 2)....................................................................................................................................5 Load Data (Week 3) .....................................................................................................................................................6 Data Analysis (Week 4)................................................................................................................................................8 Maintenance and SQL Script Creation (Week 5) ..........................................................................................................9 Sample Table to Implement the Sky Products Data Warehouse..............................................................................10 Sample Scripts to Implement the Sky Products Data Warehouse............................................................................11 References ..................................................................................................................................................................22 Running head: DATA WAREHOUSE DESIGN DOCUMENT 3 Data Warehouse Requirements (Week 1) Company Profile Provide a brief description of the company (can be hypothetical) where the Data Warehouse Design Document will be...