The CEO of Adventure Works Inc. wants to build a data mart to keep track of the product purchase orders' lifecycle. Specifically, he wants to know how often the product purchase orders takes more than 9 days to move from ordered status to shipped status. Provide a 4-steps dimensional model in the SQL comment section, create adata mart solution in SQL for the dimension model that you propose (5 points), and provide SQL commands to answer the question above

Answer rating: 100% (QA)

Sure lets start by outlining a simple 4step dimensional model for the data mart Well use the Kimball methodology for dimensional modeling The main fact table will be the PurchaseOrder fact table Step ... View the full answer