In this module, we will look at how to create a data warehouse database and why you would want to.
You are going to create a simple data warehouse database using a simple OLTP database as its source. Please fill in the provide spreadsheet to plan the design of your data warehouse and then create a SQL script that creates the database you have designed. I have provided you with a starter spreadsheet called "BISolutionWorksheets.xlsx." Please use that for the assignment.
Follow these steps to complete the assignment:
1. Review and run the "1-NorthwindLite-This creates the OLTP DB.sql file."
2. Review and complete the "2-BISolutionWorksheets.xlsx spreadsheet."
3. Review and complete the "3-DWNorthwindLite_StarterScript.sql."
4. Place the resulting SQL script file and either the completed spreadsheet file into a folder, zip it, and submit it to Canvas.
This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.