"Advice to get started. Linking an SQL and Excel database"
Dear all,
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.
Thanks
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.
Thanks
Find more posts tagged with
Sort by:
1 - 4 of
41
Thank you for your quick and clear reply.
If it was up to me, I would come to the training. However since we are a very young and small company, my boss wants to see results first before investing. So I will go for the book than.
About my question of linking the databases, I get your point. Indeed it's like you said. Let me ask a (i think) more simple question.
Is it possible in Rapidminer to import a selected data-table directly out of an SQL data-base?
Till now I converted the data to an excel table via Crystal Reports.
Thanks
If it was up to me, I would come to the training. However since we are a very young and small company, my boss wants to see results first before investing. So I will go for the book than.
About my question of linking the databases, I get your point. Indeed it's like you said. Let me ask a (i think) more simple question.
Is it possible in Rapidminer to import a selected data-table directly out of an SQL data-base?
Till now I converted the data to an excel table via Crystal Reports.
Thanks
Hi,
Hope that helps,
Tobias
yes, this is possible. You can directly import data from an SQL database using the [tt]DatabaseExampleSource[/tt] operator. The easiest way to configure the operator is by executing the wizard which lets you specify all the necessary parameter values in a convenient way.
Pepijn wrote:
Is it possible in Rapidminer to import a selected data-table directly out of an SQL data-base?
Hope that helps,
Tobias
let my try to answer your questions: Well, generally the built-in RapidMiner tutorial is a good way to start learning how to actually use RapidMiner, nevertheless assuming that you have at least some basic knowledge of data, their properties as well as a general idea of data mining approaches and what they are good for. Unfortunately, there is actually no self-learning document, which explains both the basics of data mining and their corresponding application in RapidMiner. But there are of course solutions to that: first, you may read a book on data mining basics (e.g. the book "Data Mining" by Witten & Frank) and then try to use the approaches you have learnt from the book in RapidMiner. This however certainly involves a lot of discipline: there is no free lunch
Hope, this was helpful in some way. Otherwise we highly appreciate you would post again or contact us.
Regards,
Tobias