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.
"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."
"We can deploy the solution in a cluster as well."
"It's a huge tool with machine learning features as well."
"What I like most about KNIME is that it's user-friendly. It's a low-code, no-code tool, so students don't need coding knowledge. You can make use of different kinds of nodes. KNIME even has a good description of each node."
"Stability is excellent. I would give it a nine out of ten."
"I would rate the stability of KNIME a ten out of ten."
"It allows for a user-friendly approach where you can simply drag and drop elements to create your model, which is a convenient and effective idea."
"The solution allows for sharing model designs and model operations with other data analysts."
"You don't need much support with Microsoft Power BI because it has such a large base of users who can answer your questions on their forums. There are also many video tutorials and webinars available online that offer solutions to whatever problems you may have."
"What I like most is that I can do everything in Power BI that I can do in Excel."
"There is a feature in Microsoft BI that allows JSON data to SQL on the dashboards effectively and quickly."
"We have found the product very stable and reliable."
"It is useful for bringing visualization to data. It calculates counts, ratios, etc."
"Microsoft BI's initial setup is very straightforward."
"The solution is not that difficult to install, although this will vary with the experience of the person responsible for its installation."
"The virtualization of Microsoft BI is very good."
"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."
"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."
"To enhance accessibility and user-friendliness, there is a need for improvements in the interface and usability of deep learning and large-scale learning languages."
"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'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."
"KNIME is not scalable."
"I've had some problems integrating KNIME with other solutions."
"KNIME could improve when it comes to large data markets."
"Areas for improvement would be the construction of reports and the dashboard budget."
"Microsoft Power BI can be confusing, because it has two languages that you need to learn if you want to use it, and this makes it more difficult for nontechnical users."
"I find the solution to be 70 percent stable."
"The Power Query feature needs to be improved to handle large amounts of data. This feature is also slow for large data transfers making it better to use some kind of script."
"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'm missing collaborations functionality to operate or to work connected with multiple people on a data source or on virtualization. There should be more collaborations functions, such as in Confluence. We haven't explored the solution sufficiently in this area, but at this time it doesn't look sufficient."
"Microsoft BI has its own challenges in terms of user interface and how quickly somebody can learn how to use it."
"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."
KNIME is ranked 1st in Data Mining with 21 reviews while Microsoft BI is ranked 1st in BI (Business Intelligence) Tools with 83 reviews. KNIME is rated 8.0, while Microsoft BI is rated 8.0. The top reviewer of KNIME writes "Allows you to easily tidy up your data, make lots of changes internally, and has good machine learning". On the other hand, the top reviewer of Microsoft BI writes "User friendly, easy to set up and great for analyzing data". KNIME is most compared with RapidMiner, Alteryx, Weka, Dataiku Data Science Studio and Microsoft Azure Machine Learning Studio, whereas Microsoft BI is most compared with Amazon QuickSight, Tableau, 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.