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 is a stable solution...It is a scalable solution."
"This solution is easy to use and it can be used to create any kind of model."
"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."
"I've never had any problems with stability."
"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."
"All of the features related to the ETL are fantastic. That includes the connectors to other programs, databases, and the meta node function."
"The most valuable is the ability to seamlessly connect operators without the need for extensive programming."
"It allows for a user-friendly approach where you can simply drag and drop elements to create your model, which is a convenient and effective idea."
"Its data visualization provides the user the ability to quickly look at data and focus on relevant information, allowing them to make an immediate decision."
"The interface is very easy to use."
"We are able to collaborate on things and get insightful data visualizations."
"The good part of it is that you can do whatever you want with it when it comes to building BI. In terms of languages, it supports Python, and it also natively supports R."
"It is easy to work with and very chic."
"The product can go easily go and extract data and it can put it into any format."
"Management reporting solution that's very stable and scalable."
"It offers a lot of information and is very flexible and interactive."
"It's pretty straightforward to understand. So, if you understand what the pipeline is, you can use the drag-and-drop functionality without much training. Doing the same thing in Python requires so much more training. That's why I use KNIME."
"The predefined workflows could use a bit of improvement."
"I would prefer to have more connectivity."
"KNIME could improve when it comes to large data markets."
"If they had a more structured training model it would be very helpful."
"The most difficult part of the solution revolves around its areas concerning machine learning and deep learning."
"It could input more data acquisitions from other sources and it is difficult to combine with Python."
"The program is not fit for handling very large files or databases (greater than 1GB); it gets too slow and has a tendency to crash easily."
"There are some limitations in Power BI; you have to work in the Power BI base. However, if you want something not out-of-the-box and you want something custom, you have to do a lot of work."
"In Microsoft Excel, you are able to have tabs. However, in Microsoft BI you do not have this flexibility."
"Its price could be better. Its licensing cost is very high."
"Integration with products that are not Microsoft could be more improved."
"I cannot comment on the stability as we haven't yet used it for a big project."
"The reporting part of Microsoft BI is rather limited compared to other reporting tools."
"It is not yet ready for enterprises. For a big enterprise data model, it is not so stable, and it also doesn't scale so well."
"The formatting template could be improved."
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.