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.
"We have been able to appreciate the considerable reduction in prototyping time."
"The most valuable is the ability to seamlessly connect operators without the need for extensive programming."
"Automation is most valuable. It allows me to automatically download information from different sources, and once I create a workflow, I can apply it anytime I want. So, there is efficiency at the same time."
"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 is very fast to develop solutions."
"It can handle an unlimited amount of data, which is the advantage of using Knime."
"The most useful features are the readily available extensions that speed up the work."
"Stability is excellent. I would give it a nine out of ten."
"Our setup is very straight forward and can be done in a matter of hours."
"We have a lot of servers and applications from which we want reports, and it allows us to create reports from an SQL source or some other source."
"It is a powerful tool that helps our data analysis processes."
"Management reporting solution that's very stable and scalable."
"Like all Microsoft products, it is very easy to set up initially."
"The most valuable features are the flexibility, how many ways you can interrogate the data, and the the graphical visualization."
"Constant collaboration is the most valuable. I can build a dashboard, and several co-workers can access this dashboard. We can share information that is important for decision-making. It is a very easy-to-deploy solution. It is compatible with a lot of data sources. It is also very stable and scalable. There is also a very good forum and a lot of help and online training."
"It works well with SSAS, which we use to generate all different kinds of trending and analytics reports. Sometimes we use Power Query and DAX to build some aggregations on the Power BI side as well."
"The documentation needs a proper rework. "
"KNIME needs to provide more documentation and training materials, including webinars or online seminars."
"The predefined workflows could use a bit of improvement."
"I would prefer to have more connectivity."
"The ability to handle large amounts of data and performance in processing need to be improved."
"From the point of view of the interface, they can do a little bit better."
"Data visualization needs improvement."
"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 interface could be improved."
"BI is scalable, but there are some problems with limited online storage."
"The solution struggles with large amounts of data."
"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."
"There are certain features that are only available in the cloud version. It would be beneficial if they could be brought down to the on-premise version without the necessity of using the enterprise SQL database, as that can be very costly. We need more cost-effective features that are available in the cloud to be accessible on-premise."
"Integrating it with the physics build model or the engineering model should be included."
"The only concern I have faced with Microsoft BI is the time it takes to find out an issue and rectify it."
"Their technical support can be better. They normally take too long to escalate and resolve a case."
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.