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.
"It's very convenient to write your own algorithms in KNIME. You can write it in Java script or Python transcript."
"Overall KNIME serves its purpose and does a good job."
"It is very fast to develop solutions."
"We have been able to appreciate the considerable reduction in prototyping time."
"It also has very good fundamental machine learning. It has decision trees, linear regression, and neural nets. It has a lot of text mining facilities as well. It's fairly fully-featured."
"All of the features related to the ETL are fantastic. That includes the connectors to other programs, databases, and the meta node function."
"Valuable features include visual workflow creation, workflow variables (parameterisation), automatic caching of all intermediate data sets in the workflow, scheduling with the server."
"The most valuable feature is the data wrangling, which is what I mainly use it for."
"I like having the ability to connect Excel files as data inputs."
"I like the downloadable visualizations a lot. I think that they give the user a very nice starting point in creating awesome dashboards, with the right way to tell their data story."
"MS SQL & SQL Server Analysis Services."
"Users already using Excel can generate new reports and dashboards within minutes."
"With the out-of-the-box Data Platform and Business Intelligence ecosystem, you get the entire platform with a single license."
"There is a lot of help and documentation on the Internet, so no special training is needed to use the source code."
"The solution's initial setup isn't too complicated."
"It provides easy integration with Office tools."
"In the last update, KNIME started hiding a lot of the nodes. It doesn't mean hiding, but you need to know what you're looking for. Before that, you had just a tree that you could click, and you could get an overview of what kind of nodes do I have. Right now, it's like you need to know which node you need, and then you can start typing, but it's actually more difficult to find them."
"From the point of view of the interface, they can do a little bit better."
"The documentation is lacking and it could be better."
"I would like it to have data visualitation capabilities. Today I'm still creating my own data visualtions tools to present my reports."
"I would like to see better web scraping because every time I tried, it was not up to par, although you can use Python script."
"KNIME's documentation is not strong."
"The main issue with KNIME is that it sometimes uses too much CPU and RAM when working with large amounts of data."
"The most difficult part of the solution revolves around its areas concerning machine learning and deep learning."
"If I compare it to Tableau, I'd say the visualizations can be better. We should have multiple options. By that I mean, while there are multiple options for the visualization, the look and feel of the dashboard when you compare to Tableau is on the lower side. Tableau has a much better visualization."
"If you have to pull multiple data sources performance is somewhat lacking."
"From any improvement perspective, I want the product to be made available to users free of cost...The stability and scalability of the product can be better."
"It should have more integrations."
"I would like Microsoft to include some inbuilt machine learning so that it becomes point-and-click, rather than us developing models out of API and BI connecting to that and getting the results. That process gets in the way of continuity."
"The report server feature is quite limited."
"Power BI could be improved by implementing more options for data integration. Nowadays, the cloud takes care of scalability and security. As we all know, data sources are increasing, so we get data from a variety of streams. But if we could get the downstream data into the database and update the reports more easily, Power BI would be better."
"The admin view could be improved by making it more simplified to manage a users' activity and other things."
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.