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 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 is good for teaching, since there is no need to code."
"The most valuable features of KNIME are its ability to convert your sub-workflow into a node. For example, the workflow has many individual native nodes that can be converted into a single node. This representation has simplified my workflow to a great extent. I can present my workflow in a very compact way."
"We can deploy the solution in a cluster as well."
"Stability is excellent. I would give it a nine out of ten."
"This solution is easy to use and it can be used to create any kind of model."
"It is very fast to develop solutions."
"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."
"Very intuitive and easy to use."
"We have found the solution to be stable."
"The advantages of Microsoft Power BI stem from the fact that it is really easy to use. The drag and drop facilities provided by the product are good."
"I think the visualization part is valuable."
"PowerBI – Self-service BI."
"Connectivity, installation, and configuration are pretty fast and seamless compared to Cognos."
"Like all Microsoft products, it is very easy to set up initially."
"We've used Microsoft BI for the general use cases around reporting and dashboarding."
"They should look at other vendors like Alteryx that are more user friendly and modern."
"Both RapidMiner and KNIME should be made easier to use in the field of deep learning."
"The predefined workflows could use a bit of improvement."
"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 documentation needs a proper rework. "
"I've had some problems integrating KNIME with other solutions."
"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 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 mobile app is very poor."
"If you have to pull multiple data sources performance is somewhat lacking."
"Its setup and support should be improved. We would like to see more material for developers that provides clear explanations about how we can do data mining by using Microsoft BI. It would also be good if we can connect a feature to other customized machine learning solutions."
"I am a SAP user and I would like this tool to have more connectors - and to more easily connect to - the ERP or SAP environment."
"Its desktop tool is a little bit memory CPU intensive, and it can be improved, but the machines nowadays come with a lot of memory. For the desktop users who are using it on the desktop, we recommend that they do an upgrade. It is a minor issue. We can fix it on the desktop."
"Most of the dashboarding tools have prebuilt graphs. So, you have to stick with them, unless you are going to use a third-party tool to create them, and then you are going to upload them to the BI tool. In Power BI, they started supporting this functionality and created a tool for that, but it isn't yet complete and mature. It is still exceeding the expectations and is better than most of the BI tools when it comes to creating custom graphs, but it needs more enhancement and simplification. It would be good to have a design tool provided by Power BI to design the graphs that we want and set the figures that we want on them."
"I think that there should be visuals for financial reporting videos. It should just be a plug and play because there is a lot of coding that goes into it with different clients."
"I think because I'm moving more into RPA, I'd definitely like to see integration across the RPA, Power BI, or Tableau platforms, because that integration could then make automation and mundane reporting much faster."
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.