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.
"This solution is easy to use and it can be used to create any kind of model."
"Stability is excellent. I would give it a nine out of ten."
"From a user-friendliness perspective, it's a great tool."
"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."
"KNIME is easy to learn."
"Valuable features include visual workflow creation, workflow variables (parameterisation), automatic caching of all intermediate data sets in the workflow, scheduling with the server."
"Key features include: very easy-to-use visual interface; Help functions and clear explanations of the functionalities and the used algorithms; Data Wrangling and data manipulation functionalities are certainly sufficient, as well as the looping possibilities which help you to automate parts of the analysis."
"We have been able to appreciate the considerable reduction in prototyping time."
"It is a good platform for data analysis, organization, and all of the other interim performances that are necessary."
"The stability is great and continues to get better and better."
"It's quite flexible, and it's easy to create reports using this system. It is very graphic and very user friendly."
"The initial setup is simple to do."
"Microsoft BI's dashboards are helpful."
"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."
"I like that I can use Power BI to upload data. That is very important for me. The visualization is also convenient and easy to use."
"There is a lot of variety in Power BI. In particular, the visuals are quite rich and the feature set has been growing rapidly in the last two years. Possibly the best part for me is that there are a lot of ways to connect with data sources."
"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 documentation needs a proper rework. "
"From the point of view of the interface, they can do a little bit better."
"Compared to the other data tools on the market, the user interface can be improved."
"KNIME's documentation is not strong."
"KNIME could improve when it comes to large data markets."
"In the last update, KNIME started hiding a lot of the nodes. It doesn't mean hiding, but you need to know what you're looking for. Before that, you had just a tree that you could click, and you could get an overview of what kind of nodes do I have. Right now, it's like you need to know which node you need, and then you can start typing, but it's actually more difficult to find them."
"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."
"One thing I would like to have is the scripting language, as they already have within Excel. It's already within a Microsoft business product, because Excel is the number one business product out there. So it would be nice to have the scripting capability in order to automate certain processes."
"It's not user-friendly; more tutorials, training, and better documentation would be helpful."
"Defining a relationship was very confusing. There were circular directions for which I had to do a lot of adjustments in the data. They can do something to make it easier."
"The dashboard could be simplified."
"We did have some issues building the Microsoft blog."
"The solution could improve the mobile application design. It is difficult to use compared to the desktop version."
"We haven't used it that long and I haven't come across anything that's stood out as needing to be fixed."
"Microsoft BI could improve by having better collaboration between developers working on the same dashboard. The developer platform is all done on a single laptop and it's difficult to have the same project files work. Two developers have to go back and forth. You have to have the project file on one developer's laptop making it difficult to co-develop."
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.