We performed a comparison between KNIME and Microsoft BI based on our users’ reviews in four categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: KNIME is a great alternative for organizations that are looking for a cost-saving, flexible, stable solution to handle their Data Mining and Data Science needs. Microsoft BI is a comprehensive, robust solution that performs well with Data Mining and Data Science in addition to exceptional performance as a Business Intelligence (BI) tool. As many PeerSpot users are heavily invested in the Microsoft ecosystem, Microsoft BI is the consistent trusted choice.
"One of the greatest advantages of KNIME is that it can be used by those without any coding experience. those with no coding background can use it."
"Since KNIME is a no-code platform, it is easy to work with."
"It's a coding-less opportunity to use AI. This is the major value for me."
"What I like most about KNIME is that it's user-friendly. It's a low-code, no-code tool, so students don't need coding knowledge. You can make use of different kinds of nodes. KNIME even has a good description of each node."
"Overall KNIME serves its purpose and does a good job."
"It has allowed us to easily implement advanced analytics into various processes."
"Valuable features include visual workflow creation, workflow variables (parameterisation), automatic caching of all intermediate data sets in the workflow, scheduling with the server."
"We are able to automate several functions which were done manually. I can integrate several data sets quickly and easily, to support analytics."
"I like data modeling. You can connect with your database, which is quite useful for me. It is a good tool if you have a large amount of data and you want to gather different data and interconnect it. The Power Query functionality is quite an interesting feature. If you have a query in Excel, you can also copy your query and run it in Power BI. Its dashboard is also very nice and not complicated. You don't need to be a developer to be able to use it. I am not an IT guy, and it is quite easy to use for somebody who is not an IT person."
"The data can be accessed from anywhere."
"The user interface is easy to work with."
"It is quite easy to use and it helps me to achieve the projects that I've been assigned."
"It integrates better with other Microsoft products. It is very easy to use and has very powerful visualizations. It has also got a lot of development going on."
"We have found the product to be scalable."
"I have found the most valuable feature of this solution is the Natural Language tool."
"The stability is good."
"In my environment, I need to access a lot of servers with different characteristics and access methods. Some of my servers have to be accessed using proxy which is not supported by KNIME, so I still need to create the middleware to supply the source of my KNIME configurations."
"The ability to handle large amounts of data and performance in processing need to be improved."
"The visualization functionalities are not good (cannot be compared to, for instance, the possibilities in R)."
"They should look at other vendors like Alteryx that are more user friendly and modern."
"It's very general in terms of architecture, and as a result, it doesn't support efficient running. That is, the speed needs to be improved."
"The pricing needs improvement."
"They could add more detailed examples of the functionality of every node, how it works and how we can use it, to make things easier at the beginning."
"The overall user experience feels unpolished. In particular: Data field type conversion is a real hassle, and date fields are a hassle; documentation is pretty poor; user community is average at best."
"The admin view could be improved by making it more simplified to manage a users' activity and other things."
"In an upcoming release, the solution could be simplified and have a more complete product package rather than a suite of products that we have to put together."
"This solution's performance when handling big data could be improved. Right now, if you're handling big data, the application becomes slow and the performance is very low."
"The biggest thing with Microsoft right now is better support. There should be more timely support. We can do 90% of it ourselves by the same token. When we're into the 10%, we do not get timely support via Microsoft's support team."
"It is definitely a wonderful analytics tool. However, database ETL, data integration functionality would be absolutely perfect in many cases. Currently, it doesn't get the job done and we need to extract, transform, and load the data from faulty data sets into something more suitable for the deployment of the analytics tool."
"Microsoft BI could improve by allowing large-size data sources. We have large data sources, and we have problems loading them in Microsoft BI."
"One opportunity for improvement would be on the Power Query side. As a consultant, I know Power Query is not the main strength of Power BI. It is not where Power BI shines, but many customers use Power Query to do full ETL workloads for deliverable cookies."
"It is getting better but still, there are opportunity areas in some aspects, especially the Windows OS dependency."
KNIME is ranked 1st in Data Mining with 50 reviews while Microsoft Power BI is ranked 1st in BI (Business Intelligence) Tools with 297 reviews. KNIME is rated 8.2, while Microsoft Power BI is rated 8.0. The top reviewer of KNIME writes "A low-code platform that reduces data mining time by linking script". On the other hand, the top reviewer of Microsoft Power BI writes "A complete ecosystem with an builtin ETL tool, good integrations with python and R, and support of DAX and Power Query (M languages)". KNIME is most compared with RapidMiner, Alteryx, Dataiku Data Science Studio, Weka and IBM SPSS Modeler, whereas Microsoft Power BI is most compared with Tableau, Amazon QuickSight, Domo, Oracle OBIEE and MicroStrategy.
We monitor all Data Mining reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.