Complete the 4 steps of the Dimensional Modeling Process and then build a draft schema for a fantasy soccer league to answer the following questions.
You have been asked to design a data warehouse for your online retail company consisting of numerous websites selling the same product set.
You need to design a data warehouse that will allow the following questions to be answered at a minimum:

• What is the average dollar sales per order?
• How many items in the sweater category did we sell in January?
• What is the most popular brand of t-shirt sold this year?
• Which website sold the largest number of items last month?

 

Create the schema in Visio or draw.io