Assignment task:
Objective(s): Using Multidimensional Analysis (i.e., OLAP - Online Analytical Processing) you will analyze a multidimensional cube and make recommendations for improving profit. The multidimensional cube that you will analyze is AdventureWorks.
Methodology: You will analyze a cube built from the AdventureWorks Data Warehouse. The AdventureWorks cube was built using Microsoft's SQL Server Analysis Services (SSAS). Playing the role of a Middle-Level Sales Manager at AdventureWorks, you will analyze your cube using Microsoft Excel and make three (3) recommendations for improving profitability. You will use what you have learned about OLAP in Chapter 3 of your textbook and from the video tutorials to analyze your cube's data and make your recommendations.
Deliverable(s): You will submit a 1 to 2 page write-up containing your three (3) recommendations for improving AdventureWork's profit, along with supporting reasons for each recommendation. In addition, please include any and all cube views (i.e., reports or charts from Excel) that helped you to develop each recommendation.