RapidMiner is one of the best tools for predictive modelling and the automation of data processing, making it a very versatile platform for data science projects. Unfortunately, most data science projects mutate into pure reporting and business intelligence projects. (Read here how to avoid just that.) While the resources hired for conducting data science projects and spreading the knowledge on data science within a company, all too often these resources are maxed out for regular reporting tasks.
Luckily, we have RapidMiner's automation capabilities at hand to get rid of most tasks for data processing. What was lacking so far was an automated way of getting the results of data crunching into a decent shape to send them around. This extension was written to solve exactly this problem by blending in data from RapidMiner processes into a pre-formatted and designed Excel sheet!
The Advanced Reporting Extension for RapidMiner provides a small set of new operators to export data into a pre-formatted Excel sheet. The operators can be neatly integrated with any RapidMiner process, including Web Service definitions, so that you can generate the Excel files where and when ever you need them.
The full feature list is available on the right. In general, it covers two topics: Getting data into the Excel file and transforming the data within RapidMiner.
In general, the Open Report operator will begin a report by opening an template Excel file. In it's subprocess, the Write operators of the extension can insert content into specified areas. Any format, formula or chart will be preserved and recomputed with the new data. Once the subprocess finishes, the Excel file is either written on disk or delivered as file object for further use.
Another operator helps to transform RapidMiner objects into reportable ExampleSets by extracting the tables that a user sees in the result tab of RapidMiner.
- Open Report (Excel)
- Write Data Entry (Excel)
- Write Cell (Excel)
- Extract Tables
Areas of Application
Can be used to either completely automate any reporting task whose end result is supposed to be an Excel file or to generate it with the click on a button.
|Users||1 Year Subscription||2 Year Subscription||Perpetual License|
|1 Named User||€ 19||€ 29||€ 39|
|5 Named Users||€ 69||€ 119||€ 149|
|Company License||€ 150||€ 260||€ 340|