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.
"The visual workflow tools for custom and complex tasks always beat raw coding languages with the agility, speed to deliver, and ease of subsequent changes."
"What I like the most is that it works almost out of the box with Random Forest and other Forest nodes."
"It's a huge tool with machine learning features as well."
"It's a coding-less opportunity to use AI. This is the major value for me."
"From a user-friendliness perspective, it's a great tool."
"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."
"It provides very fast problem solving and I don't need to do much coding in it. I just drag and drop."
"The ETL which helps me to collect, reformat, and load the data from multiple sources into one destination, a storage database."
"The sharing features are vital, especially the ability to share and test different shared dashboards."
"It integrates with all of the Microsoft tools."
"Everything that's in M Query and DAX is the heart of Power BI because with these tools you can make up for a lot of other missing features."
"I like how the Query Editor lets me manipulate the data, and the available visuals are good. You can do everything using the UI."
"It's a powerful platform."
"The solution's initial setup isn't too complicated."
"Key features are its dashboard functionality and ease of integration with various data sources."
"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."
"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."
"It could input more data acquisitions from other sources and it is difficult to combine with Python."
"KNIME needs to provide more documentation and training materials, including webinars or online seminars."
"KNIME's documentation is not strong."
"Both RapidMiner and KNIME should be made easier to use in the field of deep learning."
"The main issue with KNIME is that it sometimes uses too much CPU and RAM when working with large amounts of data."
"The predefined workflows could use a bit of improvement."
"The documentation is lacking and it could be better."
"Integration with artificial intelligence would help. Humans take time to review the data and eliminate errors. Artificial intelligence based on machine learning and understanding can bring the same functionality."
"It should have more integrations."
"Power BI doesn't support some open-source data sources that are new, such as SnowSQL, Iceberg, or ClickHouse."
"It would be better if they had some video tutorials. Most people from an Excel background may struggle with measures in Microsoft BI."
"The handling of the workspaces can be made more granular for user access rights. It can be managed a little bit better in terms of the connection to Active Directory so that we have more granular access rights. I am not sure if this is really possible or if we can solve it differently, but we need a lot of workspaces, and we are not sure how we can deal with it from the access rights perspective."
"Power BI's drillthrough feature could be improved. I didn't like drillthrough and those options much, but I did like it in MicroStrategy."
"I cannot comment on the stability as we haven't yet used it for a big project."
"I have found using Microsoft BI is not easy. For example, trying to use the auto-refresh feature is not simple."
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.