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.
"From a user-friendliness perspective, it's a great tool."
"The product is very easy to understand even for non-analytical stakeholders. Sometimes we provide them with KNIME workflows and teach them how to run it on their own machine."
"I would rate the stability of KNIME a ten out of ten."
"The solution allows for sharing model designs and model operations with other data analysts."
"I was able to apply basic algorithms through just dragging and dropping."
"Clear view of the data at every step of ETL process enables changing the flow as needed."
"It's very convenient to write your own algorithms in KNIME. You can write it in Java script or Python transcript."
"All of the features related to the ETL are fantastic. That includes the connectors to other programs, databases, and the meta node function."
"There is a feature in Microsoft BI that allows JSON data to SQL on the dashboards effectively and quickly."
"We can see that it's really improved the way end users can do their own graphs and pick their own fields of information and present that in a nice way."
"The most valuable feature of Power BI is its ability to provide customized visualizations and insights tailored to specific business needs."
"PowerBi is used to import our production data and generate dashboards, then integrates other Excel sheets to provide managers dashboards. This helps them get insights to make better OEE improvement decisions, mainly where to focus resources. We became able to see indicators from any time frame (day, week, month, or year), then could make better decisions."
"The capability to add custom visuals and create Power BI apps. You can package datasets, synchronization details, and dashboards into a single app."
"The fact that you can visualize items is great."
"The dashboard features are really valuable, you can connect to multiple data points."
"Allows business users with a mission to solve their own problems, without an IT person."
"KNIME could improve when it comes to large data markets."
"It could input more data acquisitions from other sources and it is difficult to combine with Python."
"The data visualization part is the area most in need of improvement."
"The documentation is lacking and it could be better."
"It could be easier to use."
"I would like it to have data visualitation capabilities. Today I'm still creating my own data visualtions tools to present my reports."
"I'd like something that would make it easier to connect/parse websites, although I will fully admit that I'm not as proficient in KNIME as I would like to be, so it could be I'm just missing something."
"From the point of view of the interface, they can do a little bit better."
"It would be better if they had some video tutorials. Most people from an Excel background may struggle with measures in Microsoft BI."
"The way you navigate the product, compared to other products in this industry, that could be improved a bit."
"Sometimes while developing, the front end is not easily customizable and it has limitations. We cannot go and do any UI we want. We have to stick to the limitations of the product."
"Automation could be improved and performance enhanced."
"It is getting better but still, there are opportunity areas in some aspects, especially the Windows OS dependency."
"The only concern I have faced with Microsoft BI is the time it takes to find out an issue and rectify it."
"The challenge of this product is in truncating the table data."
"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."
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.