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 have been able to appreciate the considerable reduction in prototyping time."
"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."
"It's a huge tool with machine learning features as well."
"Since KNIME is a no-code platform, it is easy to work with."
"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."
"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."
"KNIME is easy to learn."
"Overall KNIME serves its purpose and does a good job."
"Microsoft BI's dashboards are helpful."
"Helped identify bad data, enabling the corrections needed to the data for management."
"There are some great automation elements in the product."
"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."
"What I like about Power BI is how fast you are able to create dashboards and how fast you are able to fetch the data. You can connect to the database or data source, and then you can design your dashboards very easily."
"Microsoft BI's initial setup is very straightforward."
"It is useful for bringing visualization to data. It calculates counts, ratios, etc."
"In contrast to what we were using before I think that Power BI has given us more extensive results."
"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."
"One area that could be improved is increasing awareness and adoption of KNIME among organizations. Despite its capabilities, it is not as well-known as other tools. The advertising and marketing efforts to reach out to companies and universities have not been very successful."
"Data visualization needs improvement."
"The documentation needs a proper rework. "
"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."
"The visualization functionalities are not good (cannot be compared to, for instance, the possibilities in R)."
"KNIME could improve when it comes to large data markets."
"There are a lot of tools in the product and it would help if they were grouped into classes where you can select a function, rather than a specific tool."
"I think that the solution is harder to use for people who are not experts in data."
"When we have a big report with lots of data, the solution slows down quite a lot."
"We haven't used it that long and I haven't come across anything that's stood out as needing to be fixed."
"Things can slow down if you create too many pages."
"The reporting could be a bit better."
"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."
"Adding paginated reports to this tool could be of great help for users who want to move away from SSRS."
"The interface could be improved."
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.