Last but not least, I suggest you to put into practice some of the ideas that we have looked at in this example. 数据挖掘研究院
The "Pivot Table" tool in Microsoft Excel has some similarities with OLAP tools.
To convince you if you aren′t already familiar with this function, try to create a small table with 5 columns (time, style, shop, value and quantity, as in our example). Load some data into the table and launch the Pivot Table. Place the dimensions as you wish in the Row, Column and Page settings and put the Measures in the data area. There we go - we have a tool that allows us to visualise in two dimensions any face of the cube in our example.
If you can′t wait to see the result, here is an example to download : example.xls.
- The sheet Data contains sales data provided by Paris, Lyon and Marseille.
- The sheet Analyze contains a Pivot Table, allowing you to cross all the datas.
Well done all of you who have stayed with us - I am counting on you for constructive criticism. You can choose between my
email and my beautiful form.
