Use Adventure Work OLTP logical schema to build data warehouse tables in SQL 

CEO of Adventure Work Inc. wants to keep track of performance of their stores. Particularly, he wants to know the total number of products produced monthly and total number of products stored in inventory monthly. In addition, he wants to know yearly net profit margin (calculated by using product list price divided by product standard cost). Provide 4-step dimensional model in the SQL comment section and create data warehouse solution in SQL for the dimensional model that you propose

Answer rating: 100% (QA)

Creating a data warehouse solution based on Adventure Works OLTP data to track performance requires a 4step dimensional model Heres the dimensional mo... View the full answer