The purpose of this training session is to get the students familiar with concepts behind OLAP Analysis, by using MS Excel Pivot tables. The students should use a data set:
- SAMPDATA-1: Just the raw data.
-
- SAMPDATA-2: This excel file has some examples of analysis.
- SAMPDATA-3: In this excel file some columns were added to the raw data in to provide some extra analysis capabilities.
You should process the data in such a way that you can use it in the pivot table. Test the concepts of Slice, Drill down e Drill Up and use different aggregation functions. The available metrics are (Sales, Cost). Create the following metrics: Lucro, e Taxa de Lucro.Try to get the following graphical results
