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.
"It provides very fast problem solving and I don't need to do much coding in it. I just drag and drop."
"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 solution allows for sharing model designs and model operations with other data analysts."
"It is a stable solution...It is a scalable solution."
"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."
"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."
"The visual workflow tools for custom and complex tasks always beat raw coding languages with the agility, speed to deliver, and ease of subsequent changes."
"There are a lot of connectors available in KNIME."
"With Power BI, you're able to store your data within spreadsheets and SharePoints, and then have Power BI pull the data out and report on it. So we actually saved a ton of money not needing to load the data into databases, which is a big prerequisite for many other reporting tools."
"Microsoft BI allows us to connect to any database or any dataset."
"The initial setup is relatively simple."
"It's user-friendly and provides data abstracting capabilities. We are also able to share reports with our colleagues very easily."
"It's a pretty scalable product."
"It's a very easy-to-use solution."
"The visuals are great and make everything look very professional. We can change the look and feel or manipulate the data according to our requirements. It's extremely flexible."
"This product has a lot of features and most of them are user-friendly."
"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."
"The documentation is lacking and it could be better."
"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."
"It could be easier to use."
"In my environment, I need to access a lot of servers with different characteristics and access methods. Some of my servers have to be accessed using proxy which is not supported by KNIME, so I still need to create the middleware to supply the source of my KNIME configurations."
"Both RapidMiner and KNIME should be made easier to use in the field of deep learning."
"There are some parameters that I would like to have at a bigger scale. The upper limit of one node that tries to find spots or areas in photos was too small for us. It would need to be bigger."
"I would prefer to have more connectivity."
"They are improving it all the time. What would be nice is if they could respond to feature requests more quickly. They can provide faster support for new features."
"In an upcoming release, the solution could be simplified and have a more complete product package rather than a suite of products that we have to put together."
"The solution could use a faster speed on certain interactions and a refresh of the dashboards."
"My main complaint is that the error messages need to be made more clear. Currently, they are either too generic or outright misleading, and finding the real problem is like searching for a needle in a haystack."
"I would like to see a more user-friendly interface with Microsoft BI."
"You need to purchase upgraded support separately."
"We have used other solutions and the reporting functionality should be user-friendly and have a drag and drop feature should be available, but Microsoft BI doesn't have these features. When you are creating reports and you can't change as a user. Every time you need one developer or one technical person to make the changes."
"I would like for the next release to have better desktop performance, especially for big databases. Additionally, I would like to have more integrations with programs like Salesforce in order to get more live data coming in."
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.