Microsoft BI (MSBI) vs. Syncfusion Essential Studio

Microsoft BI is well suited for Stream analytics, easy data integration, report creation and UI/UX designs (limited but what all available are great ones) Microsoft BI may be less appropriate for handling huge number of datasets and difficult queries. It may also be difficult for a company with heavy data.

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

• 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".

• The race to perfect gathering of Non-Traditional datasets is on-going; with Microsoft arguably not the leader of the pack in this category.
• Licensing options for PowerBI visualizations may be a factor. I.e. if you need to implement B2C PowerBI visualizations, the cost is considerably high especially for startups.
• Some clients are still resistant putting their data on the cloud, which restricts lots of functionality to Power BI.

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.

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

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.

While support from Microsoft isn't necessarily always best of breed, you're also not paying the price for premium support that you would on other platforms. The strength of the stack is in the ecosystem that surrounds it. In contrast to other products, there are hundreds, even thousands of bloggers that post daily as well as vibrant user communities that surround the tool. I've had much better luck finding help with SQL Server related issues than I have with any other product, but that help doesn't always come directly from Microsoft.

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

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

• 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.