🎉 🎉 RAPIDMINER 9.10 IS OUT!!! 🎉🎉
Download the latest version helping analytics teams accelerate time-to-value for streaming and IIOT use cases.
"Advice to get started. Linking an SQL and Excel database"
I like to get some advice on how to get started.
This is my situation:
I work in a small company where we make foam. We have a production hall where the data of all the machines is stored in an SQL database. We have a laboratory where all the data of physical testings are stored in an Excel sheet.
Now my boss would like to see those two combined to check if there are correlations between the productionprocess and the physical behavior of the foam.
I think this is possible with Rapidminer but I don't know how..jet. The things I want advice in are:
-The online tutorial is simple in a way that I understand what's going on (great), still I lack the insight of when to use what if I get started with an example set of my own. Can somebody advise me for a document with the very basics.
-How can I deal with Excel if:
column 1&2, line 1(merged cell)= test title
column 1 and 2, line 2= two different demensions of test rusult
rest of the lines are test results
-How to combine the SQL and Excel database in the most efficient way
My background is lab-analyst and I did study for chemist half way. At my work I do quality control and R&D projects. The statistical results Rapidminer gives (the examples I've seen) I can interpret.