Business scenario: In this assignment, we will learn how to create dimensional models for OLAP database by applying a 4-steps dimensional model. Please install the Adventure Works database, read the Adventure Works case study,and analyze the ERD OLTP schema that you can find in this week assignment before starting this assignment.Q1:The CEO of AdventureWorks Inc. wants to build a data mart to keep track of the sale orders’ lifecycle. Specificall
Business scenario: In this assignment, we will learn how to create dimensional models for OLAP database by applying a 4-steps dimensional model. Please install the Adventure Works database, read the Adventure Works case study,and analyze the ERD OLTP schema that you can find in this week assignment before starting this assignment.Q1:The CEO of AdventureWorks Inc. […]