hi. I want to do the OLAP with RapidMiner. i have daha in a excel file. and i want to do an OLAP example in rapid miner. how can i find OLAP operators in rapidminer and and how can i do it. please tell me.. thanks.
There are no dedicated OLAP operators in RapidMiner, but you can basically do everything you like with your data. You may probably find the Filter Examples and Aggregate operators useful. If you supply more information on what you want to do, we can give you more detailed information.
hi, marius thanks for your answer. i want to tell you what i want to do. i have an excel file. there are three columns in this file. 1 column is about the city location names of an company, other coloumn is about the selling amounts of the product. and other column is about the dates of these sellings. and i want to analyse these details in OLAP. for example, selling amounts for locations or most less selling dates in dates, etc.. can you tell me please how can i do it? and also i need to show with graphics too. thank you much...
below I provided an example process which displays the product sellings by storeId, and the product sellings per date, sorted by sellings.
The most important operator here is Aggregate. Here you can define one or more grouping attributes, e.g. the storeId, or in your case the country, and aggregation functions, e.g. sum(amount), which means that for each store the product sellings are summed up.
dear marius, i did it but after that i cant find how to import them from excel. i think i need a book about this programme. is there any book? its very nice programme but i dont understand why it is so complicated....
Answers
Regards, Marius
below I provided an example process which displays the product sellings by storeId, and the product sellings per date, sorted by sellings.
The most important operator here is Aggregate. Here you can define one or more grouping attributes, e.g. the storeId, or in your case the country, and aggregation functions, e.g. sum(amount), which means that for each store the product sellings are summed up.
Hope this helps!
Best, Marius
thanks for help. but i have no idea about codes. can i do this example in rapidminer by clicking icons ? sory for my english