Design a data warehouse star schema using the Northwind OLTP (online transaction processing) database design. You are expected to follow the four-step process discussed in the textbook:
Identify the business process: which business process in the Northwind database design will you use to develop the dimensional model. Also, develop a set of business questions that should be answered via queries against the data warehouse.
Identify the grain of the fact table: determine how granular a row in the fact table must be.
Identify the dimension tables, their variables, and attributes
Identify the fact table, its variables, and attributes
The deliverable for this milestone is a paper. The following must be discussed in your paper:
Describe the business process and business questions
Describe the grain of the fact table and why
List the dimension tables, their variables, and attributes
Describe the fact table, its variables, and attributes