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.