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.
"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."
"KNIME is fast and the visualization provides a lot of clarity. It clarifies your thinking because you can see what's going on with your data."
"The solution allows for sharing model designs and model operations with other data analysts."
"It is very fast to develop solutions."
"The solution is good for teaching, since there is no need to code."
"It is a stable solution...It is a scalable solution."
"It's a coding-less opportunity to use AI. This is the major value for me."
"Valuable features include visual workflow creation, workflow variables (parameterisation), automatic caching of all intermediate data sets in the workflow, scheduling with the server."
"Because this solution is very easy, and very visual, you can have results in minutes."
"Microsoft BI is easy to use and to design. I found Microsoft BI a lot easier than Tableau."
"Its visualization capabilities are pretty good. It is very easy to use. You can easily make your dashboard."
"As it was my first time using Power BI, I can say that it was fairly easy to learn, especially if you already know BI-type tools."
"In contrast to what we were using before I think that Power BI has given us more extensive results."
"This is a self-service BI tool, so it doesn't require a huge amount of technical training, knowledge, or a background in BI in order to induct new people into it."
"Microsoft BI's most valuable feature is flexibility."
"It is a little easier at buildings charts and graphs than Tableau."
"The main issue with KNIME is that it sometimes uses too much CPU and RAM when working with large amounts of data."
"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 solution is inconvenient when it comes to wrangling data that includes multiple steps or features because each step or feature requires its own icon."
"The ability to handle large amounts of data and performance in processing need to be improved."
"KNIME is not good at visualization."
"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."
"There are a lot of tools in the product and it would help if they were grouped into classes where you can select a function, rather than a specific tool."
"KNIME could improve when it comes to large data markets."
"Power BI shows reports on actual data, not metadata."
"I'm not overly technical, and so I can't really speak to any shortcomings from a technical standpoint."
"The product could have better analytics capabilities."
"There are some other visuals that are available in the Microsoft marketplace, however, you need to use them via trial and error. There needs to be a write-up about how to use them with a quick guide describing the visual."
"I would like them to provide a license that just allows us to see dashboards. What I don't like about this solution is that in order to just watch a dashboard, you need a license. Currently, you need to purchase a full license of Power BI Pro just to see something, which is not attractive. If you have a license, you can see a shared dashboard, but you can also build a dashboard or you can collaborate with other people. However, if you only want to see a dashboard, there is no license for that. I only want to see the dashboard, and I don't want to do anything more than watching the information on the dashboard. There is no license that allows you to see a shared dashboard. This is one of the areas of opportunity because I would like a lot of people to be able to see a shared dashboard, not to interact with it or to collaborate online with it. I would like to see more compatibility with non-Microsoft data sources. Given the fact that everything is related to Microsoft Azure and all services available on Microsoft Azure, I see that they're building more connections to Microsoft Azure services instead of other non-Microsoft services. I understand the strategy, but it would be good to have more compatibility with non-Microsoft data sources."
"Capacity could be improved."
"Better mapping capabilities and easier administration access would be beneficial, especially for understanding who has viewed reports."
"There could be an integrated AI that can automatically analyze some of your data and highlight or provide suggestions. For example, when you are looking at a data set, it can suggest putting it into a certain type of chart so that you gain different insights or a trend line. You would almost have templates that it would recommend for you."
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.