KNIME Analytics Platform vs. Microsoft BI (MSBI) vs. Rational BI

KNIME Analytics Platform is excellent for people who are finding Excel frustrating, this can be due to errors creeping in due to manual changes or simply that there are too many calculations which causes the system to slow down and crash. This is especially true for regular reporting where a KNIME Analytics Platform workflow can pull in the most recent data, process it and provide the necessary output in one click. I find KNIME Analytics Platform especially useful when talking with audiences who are intimidated by code. KNIME Analytics Platform allows us to discuss exactly how data is processed and an analysis takes place at an abstracted level where non-technical users are happy to think and communicate which is often essential when they are subject matter experts whom you need for guidance. For experienced programmers KNIME Analytics Platform is a double-edged sword. Often programmers wish to write their own code because they are more efficient working that way and are constrained by having to think and implement work in nodes. However, those constraints forcing development in a "KNIME way" are useful when working in teams and for maintenance compared to some programmers' idiosyncratic styles.

Incentivized

Microsoft BI has a lot of features and is a very powerful tool, especially if you have folks on your team that know how to utilize all of its capabilities. To truly unlock all that it can do, it does require people to have a deep understanding of its capabilities. That's where the software really shines. If you are looking for a simpler, more basic reporting tool, there are other programs available that do not require such a steep learning curve.

Incentivized

Definitely well suited for small companies, but again many of their competitors are also well suited in this segment. We were in general happy with the solution provided, but I'm not blown away by their solution or support. If you want to get more data-driven visual boards with data displayed in nice graphics is in my opinion a good start, and here Rational BI delivers what it should.

Incentivized

• Summarize instrument level financial data with relevant statistics
• Map transactions from core extracts to groups of like transactions using rule engines
• Machine learning using random forests and other techniques to analyze data and identify correlations for use in predictive models
• Fill out sampling data from averages.

• Comparatively easy to use compared to other data analytics solutions, collaborating with other colleagues on data work is simple.
• Using Visual Studio for database, ETL, reporting, and analytics development save time and money.
• Transfer of data from one application to another via Excel and comparison of data attributes between applications
• Dashboard functionality, as well as Python support, are available, allowing you to add additional charts and graphs.

Incentivized

• Arrange data.
• Dashboard.
• Automatic reports.

Incentivized

• It does not have proper visualization.
• Some other BI tools (QlikView) have much easier functions for data interaction.
• Some other BI tools (Tableau) can be set up much faster.
• It is not an easy tool to use for non-tech savvy staff.

Incentivized

• MSBI designs can work on increasing data processing capabilities enough to handle the huge datasets etc.
• It would be a lot better if it is a little low on cost.
• it needs to create opportunities little more than they do regarding customization of some very unique visualization effects

• Not seeing anything at this time, comprehensive product.

Incentivized

We are happy with Knime product and their support. Knime AP is versatile product and even can execute Python scripts if needed. It also supports R execution as well; however, it is not being used at our end

Microsoft BI is fundamental to our suite of BI applications. That being said, Northcraft Analytics is focused on delighting our customers, so if the underlying factors of our decision change, we would choose to re-write our BI applications on a different stack. Luckily, mathematics are the fundamental IP of our technology... and is portable across all BI platforms for the foreseeable future.

KNIME Analytics Platform offers a great tradeoff between intuitiveness and simplicity of the user interface and almost limitless flexibility. There are tools that are even easier to adopt by someone new to analytics, but none that would provide the scalability of KNIME when the user skills and application complexity grows

Incentivized

The Microsoft BI tools have great usability for both developers and end users alike. For developers familiar with Visual Studio, there is little learning curve. For those not, the single Visual Studio IDE means not having to learn separate tools for each component. For end-users, the web interface for SSRS is simple to navigate with intuitive controls. For ad-hoc analysis, Excel can connect directly to SSAS and provide a pivot table like experience which is familiar to many users. For database development, there is beginning to be some confusion, as there are now three tool choices (VS, SSMS, Azure Data Studio) for developers. I would like to see Azure Data Studio become the superset of SSMS and eventually supplant it.

Incentivized

Overall Rational BI is a valuable enterprise reporting tool for any data driven organization. It offers great depth and breadth of features for reporting and analytics that can lead to better business outcomes. Its easy to use and highly configurable to evolve to changing reporting needs of organizations of any scale.

Incentivized

The product has been reliable.

SQL Server Reporting Services (SSRS) can drag at times. We created two report servers and placed them under an F5 load balancer. This configuration has worked well. We have seen sluggish performance at times due to the Windows Firewall.

KNIME's HQ is in Europe, which makes it hard for US companies to get customer service in time and on time. Their customer service also takes on average 1 to 2 weeks to follow up with your request. KNIME's documentation is also helpful but it does not provide you all the answers you need some of the time.

Incentivized

MSBI natively has a site that allows you to vote on user enhancements and bug fixes. This allows the largest nagging issues to float to the top and the development team can prioritize accordingly. As mentioned earlier, the large community base of MSBI developers assist technical resources in handling technical questions.

Incentivized

I haven't used the support myself, but my colleagues have been satisfied with the support. As I have understood from my colleagues the support is as you could expect. Still, the documentation could be better and that could avoid the need to contact their support, but overall we're still happy with the support as well.

Incentivized

This training was more directed toward what the product was capable of rather than actual programming.

I have used on-line training from Microsoft and from Pragmatic Works. I would recommend Pragmatic Works as the best way to get up to speed quickly, and then use the Microsoft on-line training to deep dive into specific features that you need to get depth with.

KNIME Analytics Platform is easy to install on any Windows, Mac or Linux machine. The KNIME Server product that is currently being replaced by the KNIME Business Hub comes as multiple layers of software and it took us some time to set up the system right for stability. This was made harder by KNIME staff's deeper expertise in setting up the Server in Linux rather than Windows environment. The KNIME Business Hub promises to have a simpler architecture, although currently there is no visibility of a Windows version of the product.

Incentivized

We are a consulting firm and as such our best resources are always billing on client projects. Our internal implementation has weaknesses, but that's true for any company like ours. My rating is based on the product's ease of implementation.

Having used both the Alteryx and [KNIME Analytics] I can definitely feel the ease of using the software of Alteryx. The [KNIME Analytics] on the other hand isn't that great but is 90% of what Alteryx can do along with how much ease it can do. Having said that, the 90% functionality and UI at no cost would be enough for me to quit using Alteryx and move towards [KNIME Analytics].

Incentivized

We have used the built in ConnectWise Manager reports and custom reports. The reports provide static data. PowerBI shows us live data we can drill down into and easily adjust parameters. It's much more useful than a static PDF report.

Incentivized

Rational BI allows a deeper data analysis with respect to the other software I experimented with. The velocity to perform the analysis is similar to the other one. The predictive analysis could be very useful, but at the moment I do not use it in my activities. Dashboards are nice and easy to understand.

Incentivized

• It is suited for data mining or machine learning work but If we're looking for advanced stat methods such as mixed effects linear/logistics models, that needs to be run through an R node.
• Thinking of our peers with an advanced visualization techniques requirement, it is a lagging product.

Incentivized

• As a SaaS provider we see being able to provide self-service BI to our client users as a competitive advantage. In fact the MSSQL enabled BI is a contributing factor to many winning RFPs we have done for prospective client organisations.
• However MSSQL BI requires extensive knowledge and skills to design and develop data warehouses & data models as a foundation to support business analysts and users to interrogate data effectively and efficiently. Often times we find having strong in-house MSSQL expertise is a bless.

Incentivized

• Allows folks to work on other items as reporting is done in the background.
• Scheduling and delivery of reports with one click.
• Single pane of management.
• Ease of use.

Incentivized