Microsoft BI (MSBI) vs. Qlik Sense

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.

Qlik Sense is a program whose purpose is to greatly improve all your operations and use of all data in an organic way. The mission will always be to increase the economic and commercial processes of the company in a short time. I recommended it for its high technology, which was Created for this area, the results are successful. We have noticed how it has increased relationships with our clients thanks to the credibility and security that we provide.

Incentivized

• 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

• Flexibility in data recording, from the app, as well as in handling them. Allowing you to view reports quickly and effectively.
• Easy to generate dynamic graphics according to our needs.
• It is very easy to use, intuitive, so it does not generate costs in the learning process compared to the tool with collaborators

Incentivized

• 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

• Scalability is RAM limited, all data is associative and in-memory so server's RAM is directly proportional to performance
• Limitation on advanced analytics capabilities in the form of R integration to perform complex statistical and analytical calculations
• Can have more intuitive interface

Incentivized

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.

Qlik Sense is a constantly improving it's software and working with its' users to make it better. They are great at keeping their users informed of progress and care about delivering a quality product

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

Standard user interface and powerful analytic functions is GREAT. As technical person working in the background there are more things to do to make this a completely great tool. Some functions that should be standard requires consult scripting and hours. Now we are using it quite advanced and with many servers and in combination with QlikView. So overall I love the tool. But it could be better and user friendly and powerful in the background

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.

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.

Not only can you ask the support team for help, but you can also ask the community. Also with the community there is a vast amount of problems that have already been solved. The problem you are encountering has a likely chance of already being discussed and even solved in the community section saving you time from reaching out.

Incentivized

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

The instructor was very knowledgeable.

Incentivized

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.

The online instructor was very knowledgeable.

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.

Hire Qlik consultants. It's better done by them or with their aid.

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

The customization of the platform opens up plenty of other options depending on the use cases. The API layer is incredibly rich and makes integration of Qlik based visualization into web pages a simple and effective pattern. It's been very easy to use with a great community made up of professionals. Qlik Sense has introduces artificial Intelligence into my data visualization and reporting activity.

• 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

• Once an app is published and running good, we can quickly see the time we save to analyze data.
• It's hard sometimes to realize the money we save by using this system.
• People start understanding the power of data and asking more questions.

Incentivized