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 leverage KNIME flexibility in order to query data from our database and manipulate them for any ad-hoc business case, before presenting results to stakeholders."
"We have been able to appreciate the considerable reduction in prototyping time."
"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 most valuable is the ability to seamlessly connect operators without the need for extensive programming."
"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."
"I've tried to utilize KNIME to the fullest extent possible to replace Excel."
"The solution is good for teaching, since there is no need to code."
"The most valuable feature of this solution is real-time report tracking."
"The sharing features are vital, especially the ability to share and test different shared dashboards."
"It's the analytic engine in terms of the interface on the Power BI environment, as opposed to pivot tables, and it's a mobile solution."
"The most valuable feature is integration with Python."
"It is a powerful tool that helps our data analysis processes."
"It provides easy integration with Office tools."
"Power BI has strong support from Microsoft. If you need help, they answer promptly. There are also several discussion groups where you can get information, like the product roadmap and any new things coming up."
"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."
"I would like to see better web scraping because every time I tried, it was not up to par, although you can use Python script."
"It's difficult to provide input on the improvement area because it's more of self-learning. However, there are times when I am not able to do certain things. I don't know if it's because the solution doesn't allow me or if it's because of the lack of knowledge."
"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."
"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."
"It needs more examples, use cases, and MOOC to learn, especially with respect to the algorithms and how to practically create a flow from end-to-end."
"KNIME is not good at visualization."
"KNIME's licensing and data management aren't as straightforward relative to Alteryx. Alteryx's tools are more sophisticated, so you need fewer to use it compared to KNIME. I think tab implementation could be easier, too."
"The license is quite expensive for us."
"The maps in Power BI could be improved. You deal with many maps over the years, like maps of America and Saudi Arabia. The maps aren't detailed enough, and there aren't enough visualization tools. Whenever I want to use a map, I struggle with choosing the right visualization."
"I would like to see the product offer more graphics to impact different audiences."
"Microsoft BI has its own challenges in terms of user interface and how quickly somebody can learn how to use it."
"There is no specific area that I have a problem with. It's just that, with whatever feature you come across, every visual has its own formatting and behavior. What you get in one visual for a feature, you don't seem to get in another."
"Drill-down in dashboards needs to improved. The capability only works in Power BI Desktop today. We need to have an alternative approach today."
"The DAX features need some improvement. It's not as easy as Excel. They need more DAX formulas."
"I am taking a course to be able to use the solution better. Some aspects of the solution are not straightforward."
"Its price could be better. Its licensing cost is very high."
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 Microsoft Azure Machine Learning Studio, 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.