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.
"Easy to connect with every database: We use queries from SQL, Redshift, Oracle."
"The most valuable features of KNIME are its ability to convert your sub-workflow into a node. For example, the workflow has many individual native nodes that can be converted into a single node. This representation has simplified my workflow to a great extent. I can present my workflow in a very compact way."
"It has allowed us to easily implement advanced analytics into various processes."
"The product is open-source and therefore free to use."
"It can handle an unlimited amount of data, which is the advantage of using Knime."
"From a user-friendliness perspective, it's a great tool."
"This solution is easy to use and it can be used to create any kind of model."
"It provides very fast problem solving and I don't need to do much coding in it. I just drag and drop."
"It is very good, and it supports the Microsoft ecosystem, including Excel, etc."
"What Power BI is, is a whole collection of templates of small amounts of data that can be used to do something for a real world project, that can be easily set up and become the business intelligence environment or a data warehouse for a large amount of data, for a real world customer. That's what is remarkable."
"The uploading of information is very easy, as you just use an Excel sheet to start work right away and obtain the benefits of Power BI."
"In contrast to what we were using before I think that Power BI has given us more extensive results."
"The solution is stable."
"Microsoft BI's dashboards are helpful."
"Good reporting and data analysis tool that's user-friendly, easy to deploy, stable, and scalable."
"Microsoft BI was very helpful for me because I had a huge variety of connections. It is very convenient to build reports, even if somebody has no experience using BI tools or data visualizations. Additionally, the performance is very good when generating reports."
"The pricing needs improvement."
"It's difficult to provide input on the improvement area because it's more of self-learning. However, there are times when I am not able to do certain things. I don't know if it's because the solution doesn't allow me or if it's because of the lack of knowledge."
"Both RapidMiner and KNIME should be made easier to use in the field of deep learning."
"The documentation is lacking and it could be better."
"The ability to handle large amounts of data and performance in processing need to be improved."
"KNIME's documentation is not strong."
"KNIME could improve when it comes to large data markets."
"It could be easier to use."
"Integrating it with the physics build model or the engineering model should be included."
"The solution doesn't integrate well with third-party tools."
"I have been doing trial and error to figuring out how to do the data analyzing and modeling. There could be some improvement to simplify it."
"The Microsoft BI interface should be simpler and more user-friendly. I find it very difficult to move between their data sources and their analytics section."
"It needs more graphics and overlays."
"They are improving it all the time. What would be nice is if they could respond to feature requests more quickly. They can provide faster support for new features."
"It would be better if they had some video tutorials. Most people from an Excel background may struggle with measures in Microsoft BI."
"We haven't used it that long and I haven't come across anything that's stood out as needing to be fixed."
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, Weka and IBM SPSS Modeler, whereas Microsoft Power BI is most compared with Tableau, Amazon QuickSight, Domo, Oracle OBIEE and Databricks.
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.