The CEO of AdventureWorks Inc. wants to build a data mart to keep track of the sales orders' lifecycle. Specifically, he wants to know the total number of orders when they are ordered, due, and shipped to the customer. Provide a 4-step dimensional model in the SQL comment section (1 point) and create a data mart solution in SQL for the dimension model that you propose (2 points). Q3: The CEO of AdventureWorks Inc. wants to build a data mart to keep track of the store's monthly sales performance. Specifically, he wants to keep track of the monthly tax effectiveness (defined by Tax Amount divided by Sales SubTotal) and monthly sales amount. Provide a 4-step dimensional model in the SQL comment section (1 point) and create data mart solutions in SQL for the dimension model that you propose (3 points). Link: https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworksQ2: The CEO of AdventureWorks Inc. wants to build a data mart to keep track of the sales orders' lifecycle. Specifically, he wants to know the total number of orders when they are ordered, due, and shipped to the customer. Provide a 4-step dimensional model in the SQL comment section (1 point) and create a data mart solution in SQL for the dimension model that you propose (2 points).

Q3: The CEO of AdventureWorks Inc. wants to build a data mart to keep track of the store's monthly sales performance. Specifically, he wants to keep track of the monthly tax effectiveness (defined by Tax Amount divided by Sales SubTotal) and monthly sales amount. Provide a 4-step dimensional model in the SQL comment section (1 point) and create data mart solutions in SQL for the dimension model that you propose (3 points).

I want this in visual studio.

Answer rating: 100% (QA)

To address the CEOs request for AdventureWorks Inc were going to tackle both requirements one by one beginning with the sales orders lifecycle and fol... View the full answer