BIData 201A: Assignment 07: Design and Begin Documentation

Design and Begin Documentation (Due by class 8)

In milestone 01 you must create developer design documentation using an Excel spreadsheet and the beginning of the formal design documentation in a Word docx file. The steps to do this covered in first 3 modules of this class. 

·       Module 1:  An Overview of BI Projects and Solutions (Ch. 1 and 2)

·       Module 2: Planning and Documentation (Ch. 3)

·       Module 3: Designing the Data Warehouse (Ch. 4)

Watched this video on bad designs. Centipede vs Star vs Snowflake

STEP 1: Restore DB

restored successfully

Changed permission to grab database diagram forum to aid this here

OLTP Project

STEP 2: Create Excel Document

I used the instructor provided doc. Then made changes to it