Microsoft BI (MSBI) vs. OpenText Magellan vs. Syncfusion Essential Studio

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

If you do not have a large budget and are a large organization, I would steer clear of Actuate. If you are looking to do very complex washboarding, I would not use them. Your developers have to be very skilled to work with this. Plan to bring in consultants if necessary to help your process. Adhoc reporting is weak. If your pricing is user based and you expand, this could be very expensive.

The datagrid is probably their most popular control I would think. It is so flexible and configurable. Most of mine are plain views in ASP.NET Core, but I have a whole bunch that are dynamically created at runtime in my controller. That is so powerful.

• 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

• The report outputs can vary across different types such as HTML, PDF, and Excel
• Their open source offering is very sufficient
• There are great boards and blogs for developers and engineers to expand and use their features.
• The people from the company that I've worked with are professional and courteous.

Incentivized

• Integrates well into Microsoft tech stack. i.e. ASP.NET, Blazor etc. So it acts as a plug-n-play, which is great!
• Shrinks the development cycle without adding too much of its own ecosystem overhead.
• Provides different UI skins so the controls don't appear as "stitched".

• 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

• The documentation on all the available features, but most importantly on the scripting side, can be improved
• The standard look & feel of some basic options, like parameter selection or sorting and filtering, looks dated and can't be customized
• The server portal needs to provide better tools
• More integration is needed with other OpenText products

Incentivized

• Sometimes links point to dead addresses in the documentation.
• Some components have a difficult learning curve but that is usually due to the complexity of the control.
• Minor version changes introduce breaking changes, for example updating from 20.1.x to 20.2.x gives us licensing errors, which in my opinion is a kind of breaking change as it requires all users to update their licenses.
• Theming with CSS variables is not possible. Access to Theme Studio code is not possible. So a fully custom solution is needed to make Syncfusion Essential Studio Enterprise Edition components themeable with CSS variables.

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.

I am no longer working for the company that was using Actuate but I believe they would continue to use it because the stitching costs would be to high. It would require a complete rewrite of the reports and the never version of Actuate (BIRT) even required an almost complete report rewrite

Incentivized

It takes effort to include a new component library into existing software, especially in our case where we have 5 large applications that are written and maintained by about 100 developers. So changing such a core thing comes with a lot of effort. The other reason we will very likely renew our use of Syncfusion Essential Studio Enterprise Edition is that it works really well and has helped us to speed up the development process.

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

It is quite intuitive to use. It is fit specifically for doing sentiment, emotion, and intention analysis as well as text classification and text summarization. I would have given 10 if it is fit for the purpose of doing image processing and analysis as well. There is a huge market to analyze video and image data.

Incentivized

I would rate Syncfusion® Essential Studio® a 10 out of 10 for overall usability. The components are intuitive to implement, with clear APIs and consistent design patterns across the suite. This makes it easy for developers to get started quickly and reduces the learning curve even when working with new controls.
In addition, the documentation and sample projects provide practical guidance that helps accelerate development. The built-in customization options also allow us to adapt the components to fit our branding and business requirements without excessive effort. Overall, the usability is one of the key reasons why Syncfusion has become an essential part of our development toolset.

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.

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

Always there on the front and backend for us and the client.

Although I have decades of software development experience, I had never created a website from scratch before, and my html and css skills are not particularly strong. Between documentation and incredible dedication from the support team they helped me overcome all of my challenges. It's amazing that they typically create sample code for most of the issues that I submitted. On rare occasions where I uncovered a defect they kept me informed as to its status, and typically resolved it in a short-term release, and/or gave me a reasonable workaround. They hopped on zoom calls with me on multiple occasions when necessary.

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.

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.

Feedback from the team has been very positive.

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

It is vastly superior to these in many ways, for complex reporting it is a much more sophisticated solution. Visualizations are very good. Javascript extensibility is very powerful, others don't support this or as well. Pentaho and MS are both OLAP oriented. Pentaho is moving more toward big data, which was not our primary focus. Others are stuck in the Crystal Reports Band metaphor.

Firstly, there is a free version for small businesses and it allows you to jump start without risk. I found one of the other products a bit short in the number of out-of-the-box supported events handlers for each control and, although you can manually add them, I feel more comfortable to just have them ready. After using the free version I just felt in love with Syncfusion Essential Studio Enterprise Edition controls and decided to stay with them; they have all I need and more. The usage of Syncfusion Essential Studio Enterprise Edition controls is straightforward and intuitive. Support is world-class even for the free version; you get answers in 24 hours at most. Also, the support team is ready to remotely connect to your project in case it is needed; we have had one situation like this, and the issue was solved.

• 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

• Actuate can handle 50 to 60 sub reports inside a report very well.
• Dynamically creating the datasource, chart, graph, reports are the main advantages. We can do any level of drilling, and can create a performance matrix dashboard efficiently.

• First of all, I think the best positive impact is the reduce of time development. I do not know exactly how much time, but certainly, using the framework we save a lot of effort and time.
• About negative impact, sometimes using the controls of the framewrok have a signifcant impact in the execution time and page load.
• And of course, the use of Syncfusion Essential Studio Enterprise Edition has a significant impact of the learning of javascript and JQUERY.