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.
"From a user-friendliness perspective, it's a great tool."
"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."
"I would rate the stability of KNIME a ten out of ten."
"The product is very easy to understand even for non-analytical stakeholders. Sometimes we provide them with KNIME workflows and teach them how to run it on their own machine."
"Easy to use, stable, and powerful."
"Overall KNIME serves its purpose and does a good job."
"KNIME is easy to learn."
"Power BI, once made available, can connect to various data sources, irrespective of the application, whether it be HR or business applications. The bank has many applications, but all eventually need to generate reports for tracking, distribution, or problem-finding based on analysis. Power BI was made available as part of the productivity suite to all businesses, which can connect to their applications and provide the reports and analysis they require."
"Tech support is very helpful."
"It ingegrates nicely with Office 365."
"It's a great tool for visualization data, and it's free for engineers."
"The solution has a good toggling feature."
"Its connectivity with other Office applications, mostly with Excel, and the ability to deploy it very easily are the most valuable features. It comes sort of bundled with the cloud, so you don't need to set up a server and a standalone infrastructure. So, getting into the system or building something that you can deploy is very easy and very cheap. With other systems, you need to have a server, and you need to have a license for the server. The initial setup is very costly."
"Power BI allows you to create user defined charts which is really useful."
"Management reporting solution that's very stable and scalable."
"Both RapidMiner and KNIME should be made easier to use in the field of deep learning."
"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."
"KNIME can improve by adding more automation tools in the query, similar to UiPath or Blue Prism. It would make the data collection and cleanup duties more versatile."
"The dynamic column name feature could be improved. When attempting to automate processes involving columns, such as with companies, it becomes difficult to achieve the same result when we make changes."
"The predefined workflows could use a bit of improvement."
"When deploying models on a regular system, it works fine. However, when accuracy is a priority, hyperparameter tuning is necessary. Currently, KNIME doesn't have the best tools for this which they could improve in this area."
"The visualization functionalities are not good (cannot be compared to, for instance, the possibilities in R)."
"The overall user experience feels unpolished. In particular: Data field type conversion is a real hassle, and date fields are a hassle; documentation is pretty poor; user community is average at best."
"The integration in Microsoft BI could improve for other solutions, such as Oracle DB and PostgresSQL. Additionally, the reporting from the databases to Microsoft BI should be in real-time and the overall performance could be better."
"I would like to see better, undisturbed stability without any interruptions."
"Microsoft needs to do some more research and development to make it more stable."
"Microsoft BI typically connects to a database, often SQL Server, but it's also capable of connecting to multiple databases, pulling data from them, and allowing for data consolidation. You can then aggregate and generate dashboards and reports from this combined data. Personally, I wouldn't claim to have the expertise to suggest significant changes or additional features, as it functions quite well as is."
"Microsoft has made a lot of progress with Power BI in the past couple of years, but there is still some room for improvement. For example, Integration is one area they could work on. They are adding more integration with other Microsoft tools, but I would like it if they sped up the process."
"We haven't used it that long and I haven't come across anything that's stood out as needing to be fixed."
"Power BI shows reports on actual data, not metadata."
"There needs to be improved guidance and documentation for the initial setup of Power BI as it currently remains complex."
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, Weka, Dataiku Data Science Studio 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.