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 are able to automate several functions which were done manually. I can integrate several data sets quickly and easily, to support analytics."
"It can handle an unlimited amount of data, which is the advantage of using Knime."
"I've never had any problems with stability."
"This solution is easy to use and especially good at data preparation and wrapping."
"KNIME is quite scalable, which is one of the most important features that we found."
"The product is open-source and therefore free to use."
"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."
"It's a coding-less opportunity to use AI. This is the major value for me."
"I like how the Query Editor lets me manipulate the data, and the available visuals are good. You can do everything using the UI."
"Technical support has been great."
"What I like most is that I can do everything in Power BI that I can do in Excel."
"The most valuable feature of Power BI is its ability to provide customized visualizations and insights tailored to specific business needs."
"With the out-of-the-box Data Platform and Business Intelligence ecosystem, you get the entire platform with a single license."
"The product is easy to use and simple to navigate."
"The user experience is easy. Users get familiar with it quickly."
"Two valuable most features are the ability to create columns and create measures."
"KNIME needs to provide more documentation and training materials, including webinars or online seminars."
"It could input more data acquisitions from other sources and it is difficult to combine with Python."
"The main issue with KNIME is that it sometimes uses too much CPU and RAM when working with large amounts of data."
"The documentation needs a proper rework. "
"It's pretty straightforward to understand. So, if you understand what the pipeline is, you can use the drag-and-drop functionality without much training. Doing the same thing in Python requires so much more training. That's why I use KNIME."
"It's very general in terms of architecture, and as a result, it doesn't support efficient running. That is, the speed needs to be improved."
"The data visualization part is the area most in need of improvement."
"The pricing needs improvement."
"You need to purchase upgraded support separately."
"The DAX in Microsoft BI is quite difficult."
"It is not the right tool to do deeper analysis or predictions. When you have some data and you want to do some deep analysis, there is no feature to help you with this."
"Their technical support can be better. They normally take too long to escalate and resolve a case."
"The solution could improve by simplifying the user interface and adding integration or compatibility with APA."
"One opportunity for improvement would be on the Power Query side. As a consultant, I know Power Query is not the main strength of Power BI. It is not where Power BI shines, but many customers use Power Query to do full ETL workloads for deliverable cookies."
"The licensing needs improvement. There needs to be a middle option between Pro and Premium versions."
"Microsoft BI lacks integration capabilities, so it needs to consider increasing its integration capabilities."
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.