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.
"KNIME is quite scalable, which is one of the most important features that we found."
"This solution is easy to use and it can be used to create any kind of model."
"Key features include: very easy-to-use visual interface; Help functions and clear explanations of the functionalities and the used algorithms; Data Wrangling and data manipulation functionalities are certainly sufficient, as well as the looping possibilities which help you to automate parts of the analysis."
"The product is open-source and therefore free to use."
"Easy to connect with every database: We use queries from SQL, Redshift, Oracle."
"We are able to automate several functions which were done manually. I can integrate several data sets quickly and easily, to support analytics."
"The solution is good for teaching, since there is no need to code."
"It's a very powerful and simple tool to use."
"They find Power BI's data pull mechanism to be sufficient and cost-effective, especially considering the stability it provides. In comparison with other solutions, Power BI stands out as a fantastic choice. Therefore, I would definitely recommend sticking with the Pro license."
"Initial setup was very straightforward. Users can get up and running reporting on databases within minutes."
"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."
"Considering that it's Microsoft, it can be integrated with the Power Platform, which is also Microsoft-based, like SharePoint, Power apps, Power Automate, and Power BI, which is the most user-friendly."
"The solution is very easy to use."
"Power BI is a complete ecosystem. It has an integrated ETL tool and good connectivity with applications such as Office 365 and SQL. There are also solutions for RPA, such as Microsoft Power Automate and Microsoft Power Apps. Power BI now has integration with Power Query, which has an AI feature for text analytics. Text analytics is a very good feature. This feature is also there in Tableau, but I like it in Power BI because you can write something like, "What is the total sale in the Eastern region?", and it will give you the answer. For example, when you have different types of user opinions, you just run one algorithm and you will have the output that provides the number of positive and negative responses. You can even have a dashboard with positive remarks. This feature has been introduced recently. Power BI supports the DAX and Power Query M languages. These languages are making Power BI very strong in data analytics, and you can do many types of analysis."
"The most useful features are the ability to connect different databases to Microsoft BI and explore them. Once the database information has been extracted, you have the ability to construct indicators and dashboards from the information."
"What's most valuable in this tool is that it gives its users detailed error messages. It's a very stable data analytics tool, and it offers good scalability."
"KNIME needs to provide more documentation and training materials, including webinars or online seminars."
"One area that could be improved is increasing awareness and adoption of KNIME among organizations. Despite its capabilities, it is not as well-known as other tools. The advertising and marketing efforts to reach out to companies and universities have not been very successful."
"The main issue with KNIME is that it sometimes uses too much CPU and RAM when working with large amounts of data."
"The documentation needs a proper rework. "
"Not just for KNIME, but generally for software and analyzing data, I would welcome facilities for analyzing different sorts of scale data like Likert scales, Thurstone scales, magnitude ratio scales, and Guttman scales, which I don't use myself."
"One thing to consider is that the prebuilt nodes may not always be a perfect fit for your specific needs, although most of the time, they work quite well."
"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."
"KNIME is not scalable."
"People without private emails cannot publish and, frankly, this doesn't allow for easy training."
"I would like to see more AI capabilities in future releases. There's a strong interest in AI, including technologies like GPT, which facilitate real-time interactions."
"I feel the modeling page should be simplified."
"If I have to update data automatically, where I have to pin the gateway, it doesn't update. There is a scheduled refresh functionality so that it refreshes automatically, but I find it very hard to make it work."
"My data is restricted to my DB and I'm not sure how this would handle an extremely large dataset."
"Microsoft BI has its own challenges in terms of user interface and how quickly somebody can learn how to use it."
"Their technical support can be better. They normally take too long to escalate and resolve a case."
"The solution could improve the mobile application design. It is difficult to use compared to the desktop version."
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.