The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

"Schemas design, OLAP , ETL, and dashboards"

shivinder85shivinder85 Member Posts: 1 Learner I
edited May 2019 in Help

Ive worked on OLAP cube design using star and snowflake schema in SQL Server 2012 earlier.. But now we wish to move on to an open source platform. So, please suggest is it possible to build a star schema using RapidMiner, then populate the tables with data using ETL, then apply OLAP operations such as slice and dice, drill down on the same and finally build a dashboard? If yes, please also suggest some possible links on how to do the same?

Tagged:

Best Answer

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn
    Solution Accepted

    Hi!

     

    RapidMiner is primarily a data mining tool with some ETL capabilities. It is not specialized for the data warehouse tasks you're describing. If your focus is data warehousing and you're not interested in easy and powerful data mining, then open source tools like Pentaho might be better for your use case.

     

    That said, I've been doing exactly these things with RapidMiner Studio and Server for the last years, so obviously it's possible. 

     

     

    Regards,

    Balázs 

Sign In or Register to comment.