We have a multidimensional data model with the fact table Sales and the dimension tables Customers, Products, and Salespeople. The sales table below represents sales data for 1st January 2010: SALES...

I need a perfect answer and detailed explanation for this question. So that it is easier for me to understand. And easy for me to do revision.

Assignment Data Warehouse (see image)

i) Draw a 3D picture of a data cube. Assume that all values that are missing from theSalestable are 0.

ii) Show an example of a slice from the data cube in (i).

Extracted text: We have a multidimensional data model with the fact table Sales and the dimension tables Customers, Products, and Salespeople. The sales table below represents sales data for 1st January 2010: SALES CUSTID PRODID STAFFID QUANTITY 20 PRODUCT 101 1 10 101 11 10 Price Prodid Name 10 101 3 10 Аpple |Orange 15 Banana 12 102 2 11 8 1 102 3 10 24 103 103 | 103 2 3 1 11 50 11 45 3 10 30 SALESPEOPLE Custid Name Address Staffid Name Position CUSTOMER 101 Kamal London 10 Sarah Salesman 102 Mokthar New York Bukhairi Paris 11 Jamal Manager 103