I write weekly articles breaking down the previous week's Green Bay Packers' game. My main use for KNIME at this time is a workflow that takes play-by-play data from a CSV and puts it into a multi-tabbed Excel document, with all the stats I need for the week.
Business Analyst at a tech services company with 501-1,000 employees
Rule Engine allows me to create lookup tables on the fly
Pros and Cons
- "I know I don't use it to its full capacity, but I love the Rule Engine feature. It has allowed me to create lookup tables on the fly and break down text fields into quantifiable data."
- "I'd like something that would make it easier to connect/parse websites, although I will fully admit that I'm not as proficient in KNIME as I would like to be, so it could be I'm just missing something."
What is our primary use case?
How has it helped my organization?
I had been doing this via a mix of Excel macros and some things by hand. Even with the macros, it would take me 30-plus minutes every week, and even that was just for the raw data to get to pivot tables. If I wanted additional calculations based on pivot table data, that would take even more time. With KNIME, I am able to get that process down to under one minute, with data broken down into individual tabs. It has changed my week.
What is most valuable?
I know I don't use it to its full capacity, but I love the Rule Engine feature. It has allowed me to create lookup tables on the fly and break down text fields into quantifiable data.
What needs improvement?
I'd like something that would make it easier to connect/parse websites, although I will fully admit that I'm not as proficient in KNIME as I would like to be, so it could be I'm just missing something.
Buyer's Guide
KNIME
November 2024
Learn what your peers think about KNIME. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
817,354 professionals have used our research since 2012.
For how long have I used the solution?
One to three years.
What do I think about the stability of the solution?
No issues with stability.
What do I think about the scalability of the solution?
No issues with scalability.
How are customer service and support?
I haven't had to use technical support, but I have been able to find answers in the forum to any questions I have had.
Which solution did I use previously and why did I switch?
I had been using a combination of Excel macros and manual entry. I switched because I was looking for something a bit quicker and automated, something to remove as much human error as possible.
How was the initial setup?
I started simple, as I was learning the software as I went. It ended up being fairly complex. I still had some manual entry, but as I learned what KNIME was capable of, I kept building more and more to get everything as automated as possible.
Which other solutions did I evaluate?
I ran through a couple different options. None of them matched up to what KNIME could do.
What other advice do I have?
Do training up front to make building workflows clean and easy from the start.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Principal Lecturer at HAMK
Is easy to set up, has lots of features, and is stable overall
Pros and Cons
- "It's a huge tool with machine learning features as well."
- "There are some parameters that I would like to have at a bigger scale. The upper limit of one node that tries to find spots or areas in photos was too small for us. It would need to be bigger."
What is most valuable?
I've been using some of the analytics and photo manipulation features. I'm a teacher, and I've been using KNIME in my university.
It's a huge tool with machine learning features as well.
What needs improvement?
There are some parameters that I would like to have at a bigger scale. The upper limit of one node that tries to find spots or areas in photos was too small for us. It would need to be bigger.
For how long have I used the solution?
I've been using this solution for two and a half years.
What do I think about the stability of the solution?
Overall. it's stable. However, every time there is a major version release, we end up having to upload many of the nodes again. It takes some time to do the version change.
What do I think about the scalability of the solution?
It is scalable, especially with a server.
How are customer service and support?
The technical support is excellent, fast, accurate, and friendly.
Which solution did I use previously and why did I switch?
I used Power BI, but when I found KNIME, there was no going back.
How was the initial setup?
The initial setup is easy.
What other advice do I have?
You should do the KNIME courses, particularly the first two courses.
They would give you a very good base to make KNIME work nicely, and you would also know how it really works.
It is a really good system, and on a scale from one to ten, I would rate it at ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
KNIME
November 2024
Learn what your peers think about KNIME. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
817,354 professionals have used our research since 2012.
Solutions Architect at a retailer with 10,001+ employees
Should have better connectivity, although the solution is stable and allows for easy dragging and dropping of basic algorithms
Pros and Cons
- "I was able to apply basic algorithms through just dragging and dropping."
- "I would prefer to have more connectivity."
What is most valuable?
The solution allows one to do many things, including data preparation. I was able to apply basic algorithms through just dragging and dropping. This in contrast to Python and other solutions, which involve much coding.
What needs improvement?
I would prefer to have more connectivity. The user documentation is insufficient. I would like to see more enterprise level application. There are high end features which should appear, the MLOps platform being one. This feature is key.
There should be better connectivity to such platforms as AWS and SageMaker, as we rely heavily on AWS in RL. For certain South Asian markets, we plan to go with Azure, so it is important to have connectivity to both of the major clouds. There should be AI machine learning based algorithms. Such features should be available out of the box with good precision.
For how long have I used the solution?
I have worked with KNIME for a couple of months.
What do I think about the stability of the solution?
The solution is stable.
What's my experience with pricing, setup cost, and licensing?
KNIME assets are stand alone, as the solution is open source. I have not looked into their enterprise level application costs. While cost is a parameter, I would definitely consider other options which provide value for one's money.
What other advice do I have?
The solution is good for small scale implementation. Other solutions should be considered for enterprise level implementation.
I rate KNIME as a five or six out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Vice President Business Transformation at AJA
Good sample features, scales well, and the community support is helpful
Pros and Cons
- "KNIME is quite scalable, which is one of the most important features that we found."
- "Compared to the other data tools on the market, the user interface can be improved."
What is our primary use case?
We are users of KNIME and we also resell this product.
The primary use case is for data analysis.
What is most valuable?
KNIME has a good set of features for data analytics.
The sampling features are some of the most important ones for us.
What needs improvement?
Compared to the other data tools on the market, the user interface can be improved.
There are quite a few features that are not available in the Community Edition. Having more of these features brought into the platform would be helpful.
Support from KNIME could be enhanced, although the community support is great.
For how long have I used the solution?
I have been working with KNIME for between three and four years.
What do I think about the stability of the solution?
It has been stable for a while, since the release of version 4. However, between version 2 and version 3, it was quite unstable. The stability has improved.
What do I think about the scalability of the solution?
KNIME is quite scalable, which is one of the most important features that we found.
How are customer service and technical support?
The support for KNIME is good, although it comes from the community rather than from KNIME itself.
How was the initial setup?
The initial setup is quite simple, especially if you have already worked on other tools.
The deployment can be completed within a couple of hours, including the setup of permissions and other configurations.
What's my experience with pricing, setup cost, and licensing?
There is a Community Edition and paid versions available.
What other advice do I have?
For anybody who is looking for a new data science platform, KNIME is a product that I can recommend.
I would rate this solution an eight out of ten.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Head Of Business Solutions | Unmanned Shop | Automated Retail | AI | IoT | Robotic | Data Science at Smart Retail
Good data preparation and wrapping, but needs online training and more examples
Pros and Cons
- "This solution is easy to use and especially good at data preparation and wrapping."
- "It needs more examples, use cases, and MOOC to learn, especially with respect to the algorithms and how to practically create a flow from end-to-end."
What is our primary use case?
Our primary use case for this solution is shopping-basket analysis.
How has it helped my organization?
It gives much insight about business in different aspects, from understanding product portfolio to clients, much of them arouse interests from important stakeholders
What is most valuable?
It is a complete data science platform and especially good at scaling up data preparation and wrapping. It provides a large numbers of algorithms to look at data from different angles
What needs improvement?
It needs more examples, use cases, and MOOC to learn, especially with respect to the algorithms and how to practically create a flow from end-to-end. The learning curve is steep.
For how long have I used the solution?
We have been using this solution for six months.
What do I think about the stability of the solution?
Very good
What do I think about the scalability of the solution?
Perfect
How are customer service and technical support?
Very good and very prompt, usually in a few hours, can't complain more
Which solution did I use previously and why did I switch?
I wrote Python in different IDE, however KNIME is easier to tackle with changes in data sources, processes, and expectations, etc. It is simple to work around with different situations for testing and comparison.
How was the initial setup?
Setup is very easy, no more than a normal app
What about the implementation team?
I do it myself, and I am super-user level
What was our ROI?
More than worthy to invest
What's my experience with pricing, setup cost, and licensing?
One of the benefit for KNIME is free for desktop version, which is enough for small team work. It is worthy to try but prepare for times to search and learn. It is not really as easy as drag and drop.
Which other solutions did I evaluate?
I check with Alteryx and RapidMiner
What other advice do I have?
Official and structural online training is a must, which is now not enough. Or you can start something simple very easily but stuck to go deeper. However KNIME response is very prompt.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Has good machine learning and big data connectivity but the scheduler needs improvement
Pros and Cons
- "This open-source product can compete with category leaders in ELT software."
- "The ability to handle large amounts of data and performance in processing need to be improved."
What is our primary use case?
We are using KNIME for basic analytics to reduce the amount of processing time. We found that it takes a lot of time for scripting on the cloud, so we have been using it locally on our PCs.
How has it helped my organization?
While the product has not yet improved our organization, we expect to use it in full deployments with our clients to greatly reduce their costs and make our services more attractive.
What is most valuable?
The most valuable part of the solution is the machine learning part. The second feature that we use most is big data connectivity. When we deployed the architecture, we directed our IDS (Intrusion Detection System) server to where the big data will be on our servers. Then we needed some kind of basic machine learning and obviously. After that, we connected it with Tableau visualization. Now we are writing the big data part of our solution along with the overall machine learning. These two parts will be the most important for our business going forward.
I think also connectivity with hybrid databases and also integration with languages like Python are great advantages to what we are seeking to do in our environment. We have been using these features extensively and we find them to be very valuable in achieving what we hoped to achieve with the tool.
What needs improvement?
One thing that I found was that in the open-source version of the KNIME analytics platform, we see difficulties in scheduling jobs. If the scheduler could be updated in the open-source version, the software will be easier to schedule properly and to use efficiently.
The second time that I faced difficulty using KNIME was with data processing time. When we use large chunks of data for local processing, the processing is very slow. We do not want to move these big data often. For me, it seemed that moving one gigabyte of data went very slowly. So, the second thing that I would really like to see is a better ability to handle large amounts of data locally with KNIME in an efficient manner.
The third area that might be improved is that when we have a large amount of data — let's say like five gigabytes — then there is one panel completely ignored. The impact of that on the results of our data processing is not good. So I would really like to see the load balancing and the overall processing time substantially reduced.
So the things I would most like to see are the ability to handle large amounts of data and improved performance in processing.
For how long have I used the solution?
We have been working with KNIME for about six months.
What do I think about the scalability of the solution?
We do not have many people using the solution in our company at this point because the tool is comparatively new to us. There are around three or four users right now. We do have plans to increase the usage and the number of users. We have been planning it because we have growth opportunities with some clients. The only potential problem is that right now, we are under-confident, in our capability to implement pure KNIME solutions without more discovery and testing. So, we are planning it to replace Alteryx eventually with KNIME. But as of now, we are just planning. We do plan to increase the usage in the future but we have not done anything yet regarding that.
How was the initial setup?
The initial setup was very straightforward. It was not complex at all.
What about the implementation team?
We deployed it, we installed it ourselves on our local system server.
What other advice do I have?
We have done a few projects with some of our clients in KNIME. In these cases, we mainly used KNIME because of its ability to work in a data center environment in an enterprise system. This was one of the most important things that we were looking for. The second point was that KNIME is an open-source analytics platform. The point is that if some client has less data or a relatively small database, then we can use the open-source platform instead of using Alteryx, which is fairly expensive. These are the options we advise our clients about.
On a scale from one to ten where one is the worst and ten is the best, I would rate this product as an eight out of ten. I honestly do not feel familiar enough with this product that my rating is accurate as I need to be more familiar with it over time. On the other hand, I have used KNIME and other tools in a similar category — like Informatica and Alteryx. Informatica is purely a data warehouse software. Alteryx is something we use frequently. So I have used three ETL tools. If I compared KNIME with Alteryx which are the most similar of the three, then I think KNIME is much better for our purposes. Strictly as a comparison with Alteryx, I would rate KNIME as an eight.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Partner, Turkey and The Netherlands at a tech vendor with 201-500 employees
Our average record size was around 10 million records. If we have bigger data, we can opt for a Big Data extension for Hadoop, Spark, etc.
What is our primary use case?
In demand forecasting projects to extract, to clean and to transform data from various resources. Also some clustering and classification techniques are used for behavioural clustering and classification according to attributes.
How has it helped my organization?
My organization's field of activity is to develop business applications for niche areas. Almost three years ago, we decided to extend our solutions with advanced analytics. KNIME let us start easy and fast into the Advanced Analytics area. We are able to try project ideas with KNIME by doing proof of concept easy and prototyping fast.
What is most valuable?
What needs improvement?
I mentioned about the distributed architecture in my previous answer, but they did with version 3.5. This time maybe I could add the integration with graph databases like Neo4j.
For how long have I used the solution?
One to three years.
What do I think about the stability of the solution?
In the previous versions, I had some issues when reading large Excel files due to memory usage. But with the previous version (3.3), they renewed all Excel nodes and now I have no problem.
What do I think about the scalability of the solution?
With the data sizes that I dealt with, I did not. Our average record size was around 10 million records. If we have bigger data, we can opt for a Big Data extension for Hadoop, Spark, etc.
How are customer service and technical support?
I used it very little. All of them replied to me in one day. (It was not professional support, just over a forum). Also, I can find enough information in the documentation and forum.
Which solution did I use previously and why did I switch?
Before KNIME, I used SQL language and Excel for data analysis but machine learning algorithms. In parallel to KNIME, I worked on a few projects with R and Python separately. So I cannot say that I switched from different solutions.
But just for ETL with Excel, KNIME brings me better visualization, rich function set, preserving operations to repeat again and better performance on the same hardware.
How was the initial setup?
I am using Mac and it is so easy. Download a .dmg, extract it as an app, and copy it to the applications folder. On windows it is also simple installation.
For extensions like R or Python, you need experience with general OS and installation processes.
What about the implementation team?
We did in-house.
What was our ROI?
The biggest ROI comes from productivity when creating new things and also supporting old jobs.
And there is no hidden cost. Licensing is simple and open than other platforms.
What's my experience with pricing, setup cost, and licensing?
KNIME is open sourced platform and has a free desktop version with unlimited data size and functionality.
Also, the server version is good for teams and enterprise productivity. Especially the new "Model Factory", which lets data science teams easily build and manage models. When compared with similar products, it is less expensive but as powerful as (or maybe more powerful than) others.
Which other solutions did I evaluate?
The Open Source licensing and community support is one of our important criteria. The second one is the interoperability with other technologies and openness to different data sources. There are two options: RapidMiner and KNIME. We chose KNIME.
What other advice do I have?
Data Science requires freedom for creativity. Sometimes you need to crawl data from the web or social media. Sometimes you need to blend different sources like NoSQL MongoDB and Excel files, etc. It is not only algorithms and data extraction, visualization and preparation steps are important as at least algorithms.
Don't go with software that has complex and hidden licensing costs, which will kill your flexibilty and creativity. Also, interoperability brings the advantage of limitlessness.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partnership with KNIME
STI Data Leader at grupo gtd
Very user-friendly, stable, powerful, with many features
Pros and Cons
- "Easy to use, stable, and powerful."
- "The license is quite expensive for us."
What is our primary use case?
We use this solution primarily for automation processing, source data, and for data lake or databases.
What is most valuable?
I like the visual features and that we can connect using a pixel or an icon for the sources and controls. KNIME is easy to use, it's stable, powerful, and has a lot of features.
What needs improvement?
For now, the license is quite expensive for us and it would be helpful if that was reduced.
For how long have I used the solution?
I've been using this solution for a few years.
What do I think about the stability of the solution?
The solution is stable.
What do I think about the scalability of the solution?
We have five people using this solution so we haven't yet tested the scalability.
How are customer service and support?
We use the community for any questions we have.
How was the initial setup?
I think the deployment requires a specialist but once it's implemented it doesn't need any maintenance.
What other advice do I have?
We use the community version; the enterprise version is expensive for us. If we need better support or have other requirements we might need to move to the enterprise version.
I rate this product nine out of 10.
Which deployment model are you using for this solution?
Private Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free KNIME Report and get advice and tips from experienced pros
sharing their opinions.
Updated: November 2024
Popular Comparisons
IBM SPSS Statistics
IBM SPSS Modeler
Weka
SAS Enterprise Miner
IBM Watson Explorer
SAS Analytics
Oracle Advanced Analytics
Buyer's Guide
Download our free KNIME Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- What Is The Biggest Difference Between Alteryx and KNIME?
- What is the biggest difference between IBM SPSS Modeler and KNIME?
- Which solution do you prefer: KNIME, Azure Synapse Analytics, or Azure Data Factory?
- Which solution provides the best ROI: KNIME, Alteryx or RapidMiner?
- When evaluating Data Mining, what aspect do you think is the most important to look for?
- What is the difference between Online Analytical Processing (OLAP) and Data Mining?
- Why is Data Mining important for companies?