Data Warehouse Analysis: Top Products and Stores

Applying Analysis to Your Data Warehouse Using OLAP Queries

5of 77.DW analysisOnce the entire data has been loaded into DW, apply the following analysis to your DW using OLAP queries.Q1Determine the top 5 products in Dec 2019 in terms of totalsalesPRODUCT_NAMETOTAL_SALESRANKQ2Determine which store produced highest sales in the wholeyear?STORE_NAMETOTAL_SALESRANKQ3Determine the top 3 products for a month (say, Dec 2019), and for the 2 months before that, in terms of totalsales.PRODUCT_NAMESUM(TOTAL_SALES)RANKQ4Create a materialised view called “STOREANALYSIS” that presents the product-wise sales analysis for each store. The results should be ordered by StoreID and thenProductID