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."
"The ETL which helps me to collect, reformat, and load the data from multiple sources into one destination, a storage database."
"The solution is good for teaching, since there is no need to code."
"The solution allows for sharing model designs and model operations with other data analysts."
"It is a stable solution...It is a scalable solution."
"This solution is easy to use and especially good at data preparation and wrapping."
"It has allowed us to easily implement advanced analytics into various processes."
"Since KNIME is a no-code platform, it is easy to work with."
"It is stable enough. It has a lot of powerful functions. It can also be customized with the DAX language. It is also intuitive enough and incremental. You can start with something simple, and then step-by-step, you can increase the reports and dashboards according to your needs."
"Microsoft B's beneficial features are that it is a Microsoft product and it is well known by the staff here in the company. It suited the available skills."
"The drill-down capabilities and automatic charts are the best ones. The visualization is also very good. In terms of visualization, no competing product, such as IBM Cognos or any other product, has the same capabilities."
"We are able to collaborate on things and get insightful data visualizations."
"The most valuable feature is definitely the visual aspect and the DAX capabilities to virtually do anything."
"The solution overall is very useful. The reports that are generated and the reporting functionality management are beneficial."
"Being able to transfer data with the Power Query feature is great for teaching with about one to two hundred rows of data. I am also able to see the relationship between multiple tables and create various sheets and dashboards."
"There is also a chart store where we can download charts, which is extremely useful."
"The visualization functionalities are not good (cannot be compared to, for instance, the possibilities in R)."
"I've had some problems integrating KNIME with other solutions."
"KNIME is not good at visualization."
"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."
"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."
"The program is not fit for handling very large files or databases (greater than 1GB); it gets too slow and has a tendency to crash easily."
"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."
"It could be easier to use."
"The data source definition is all over the place."
"There's always room for improvement for Microsoft Power BI, especially for the UX and the menus to make it more accessible to business users."
"In the future, Microsoft BI can be better by increasing user-friendliness"
"Power BI could be improved by implementing more options for data integration. Nowadays, the cloud takes care of scalability and security. As we all know, data sources are increasing, so we get data from a variety of streams. But if we could get the downstream data into the database and update the reports more easily, Power BI would be better."
"I would like Microsoft to include some inbuilt machine learning so that it becomes point-and-click, rather than us developing models out of API and BI connecting to that and getting the results. That process gets in the way of continuity."
"Real-time updating needs improvement."
"You need to purchase upgraded support separately."
"Microsoft Power BI was born native on the cloud, however, it's quite difficult when it has to connect to on-premise data sources."
KNIME is ranked 1st in Data Mining with 50 reviews while Microsoft Power BI is ranked 1st in BI (Business Intelligence) Tools with 293 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.