IT Central Station is now PeerSpot: Here's why

Microsoft BI vs Qlik Sense comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
43,914 views|35,006 comparisons
Qlik Logo
17,159 views|12,553 comparisons
Featured Review
Buyer's Guide
Microsoft BI vs. Qlik Sense
March 2020
Find out what your peers are saying about Microsoft BI vs. Qlik Sense and other solutions. Updated: March 2020.
608,713 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"Power BI allows you to create user defined charts which is really useful.""We encourage end users to use Power BI because it's quite easy for them to interact with the menus and the navigation bar. Even for ordinary users, they can create their own dashboard using Power BI.""I also find connecting to different data sources is quite simple. Other solutions we were using before were complicated.""The product is easy to use and simple to navigate.""It is good for us for onboarding the data. We can connect to multiple data sources, do transformations to make the data usable, and then model it within the transformation. Someone who has come from a Microsoft Excel environment will easily be able to use this solution. Power query and report modeling are easy to understand in this solution. Their technical support is very good. They are extremely responsive, helpful, and hands-on.""The virtualization of Microsoft BI is very good.""The scalability is good. We have 20 people in my organization using this solution and plan to increase usage.""In my experience the scalability is good. You are able to increase users and add more data."

More Microsoft BI Pros →

"There are a lot of features available in this solution, it has been very easy to use. We have found it to be less complex and user-friendly compared to other solutions we have used.""From siloed reports, we went to a centralized knowledge hub, combining cross-functional data, and helping decision-makers see the data as a whole, therefore making more informed decisions.""It is extremely clean to view, easy to use, and intuitive to develop with. There are a host of online resources to provide assistance to new users.""We can bring data from multiple sources and easily blend it in Qlik and create a data model (star schema).""It allows you to create a new column using split on a current column, which we find very useful.""Qlik Sense has a modern look and feel and a very intuitive UI, so non-technical users find it very user friendly.""The most valuable features are that Qlik has a very strong ATL available and the capacity to handle large volumes of data.""The extensibility of the Platform with either internally created extensions or the use of third-party provided items really opens the platform up."

More Qlik Sense Pros →

Cons
"The default parameters of the prompt could be improved by including a dynamic option.""The look and feel should be updated in terms of the types of dashboards and graphs that you can produce. They aren't as visual as some of its competitors.""The challenge of this product is in truncating the table data.""We would like improvements made to the paginated reports so that it produces quality similarly to SSRS.""Creating dashboards could be easier.""If you are having millions of rows of data or you have a large database, Microsoft BI's performance depends upon how powerful your hardware is. When I am handling large amounts of data I do not use Microsoft BI or Tableau because of this, I use D3.""You need to purchase upgraded support separately.""The solution could be more customizable and you do not have too much freedom on the code."

More Microsoft BI Cons →

"If a team wants to keep track of source code changes, there is not an out-of-the-box solution for it.""More focus needs to be on data streaming/real-time data reporting.""More pivot table options, like the ability to have the totals row at the bottom of the table, would be helpful.""They should generally focus more on the evolution of current capabilities rather than doing everything but only at 50% effectiveness.""We have faced some issues with NPrinting, so I feel there is some improvement needed such that it would allow the use of variables and calculative fields from Qlik.""Ad-hoc reporting capabilities would be ideal.""They need to make security rules to access applications and data security easier and customizable.""Areas for improvement include user-friendliness, self-service, and some of the visualization options for generating reports."

More Qlik Sense Cons →

Pricing and Cost Advice
  • "We have a premium Power BI license in-house that's quite an expensive license. It's $10 a month for four users and then I think 35,000 at the premium rate."
  • "It is somewhere in the middle in terms of price. Licensing is quite clear."
  • "Its cost seems to be unreasonable if you have many users, but for a lesser number of users, it is reasonable. It is $10 per month. Clients easily accept this option, so they must think it is reasonable. It is quite cheap as compared to other tools, such as Tableau. One of the best things about this solution is that it has a trial version."
  • "Once the trial period for the BI service is over, the cost is approximately $10 USD per user, per month, so it's quite reasonable."
  • "The pricing is very reasonable compared to any other tool."
  • "Microsoft BI is not very cheap. A premium license costs roughly 5,000 euros a month."
  • "This product offers good value for the money."
  • "Microsoft BI is free for the personal edition, but there is also a paid-for professional version."
  • More Microsoft BI Pricing and Cost Advice →

  • "The license mechanism of Qlik is quite complicated and not exchangeable. Such as 2016, they charge licenses by token, 1500$ for a token / 1 user. 2018: they change to 2 kinds of licenses: professional 1500$ / user, analyzer 800$ / user. 2019: they support subscription with 70$ Monthly for professional, 40$ monthly for analyzers, but for those you’re using perpetual licenses, they don't support acquiring more subscription licenses. The maintenance fee yearly are also high, 20% of the perpetual license."
  • "For on-premise enterprise users, a number of additional features come at a premium cost."
  • "I would rate Qlik's pricing four out of five."
  • More Qlik Sense Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Business Intelligence (BI) Tools solutions are best for your needs.
    608,713 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I would recommend as follows:  1) If you have legacies of SAP, Oracle  - look for SAP… more »
    Top Answer:Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are fully customizable and very user-friendly. This solution is very stable. Oracle… more »
    Top Answer:The most valuable features in Microsoft BI are the analysis using the feature drag and drop function. It's very easy to load and use different data sources.
    Top Answer:It depends on the Data architecture and the complexity of your requirement. Some great tools in the market are Qlik Sense, Power BI, OBIEE, Tableau, etc. I have recently started using Cognos… more »
    Top Answer:From siloed reports, we went to a centralized knowledge hub, combining cross-functional data, and helping decision-makers see the data as a whole, therefore making more informed decisions.
    Top Answer:I'd advise users to go to the cloud. If you can, go directly to the SaaS version. From a cost perspective, it was cheaper than other solutions - and better. Now it might seem more expensive, however… more »
    Ranking
    Views
    43,914
    Comparisons
    35,006
    Reviews
    183
    Average Words per Review
    534
    Rating
    8.1
    3rd
    out of 58 in Data Visualization
    Views
    17,159
    Comparisons
    12,553
    Reviews
    24
    Average Words per Review
    527
    Rating
    9.0
    Comparisons
    Also Known As
    SSRS, SSAS, MSBI, MS Reporting Services, Power BI, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
    QlikSense
    Learn More
    Overview

    Microsoft BI is a business intelligence solution that turns data into insightful and useful business information that is relevant to all levels of the business.

    Microsoft BI combines familiar Microsoft tools - Office, SharePoint, and SQL server, with extra features for end-users, such as Power View and Power Pivot. This powerful product gives businesses a competitive advantage by allowing end-users to better analyze their data, collaborate and better present their data.

    Qlik Sense is a visual analytics and business intelligence (BI) platform that gives users full control over their system’s data. From this platform they can control every aspect of their system data. It maximizes an organization’s ability to make decisions driven by their data.

    Benefits of Qlik Sense

    Some of the benefits of using Qlik Sense include:

    • Easily manipulate data: Qlik Sense allows users to easily combine and otherwise manipulate their system’s data. It allows them to create interactive visual representations of your datasets. The many different ways that the data can be represented offer many potential options for how to analyze the data. These choices enable users to easily gain critical insights.
    • Easily automate alerts and routine actions: Qlik Sense enables users to keep a close eye on their data. Automatic alerts that will notify them if their data changes in any way. Users don’t need expert knowledge of coding to create automated data-driven events. Users of all experience levels can take advantage of this benefit. Qlik Sense enables routine actions to be automated when necessary data insights will spur the system to take action. This combination of analytics and other tools empower users to take charge of their data.
    • Customize reporting: Users can set Qlik Sense to generate custom reports. These reports can also be customized to be shared by way of one of several methods, allowing users to control who sees their data and what they see.

    Reviews from Real Users

    Qlik Sense stands out among its competitors for a number of reasons. Two major ones are its associative analytics technology and its remote access capability. Qlik Sense employs an associative analytics engine that gives users the ability to take their data analytics to the next level. Users can create visual connections between different datasets spread across their network, creating deep insights that enable users to gain a full understanding of their data. This engine is easily scaled up to allow a large number of users to benefit from the deep insights that it provides. Users can access Qlik Sense from anywhere in the world. Qlik Sense has an online portal that can be used consistently from anywhere at all. Having the ability to remotely analyze data gives users flexibility when it comes to choosing how to deploy their manpower.

    Jarno L., the managing director of B2IT, writes, “The associative technology features are the solution's most valuable aspects. Qlik was the first company to implement an in-memory associative analytics engine. This basically means that all data is loaded into memory, but it also means that instead of joining data together, the data is associated together. From the front end, from the user interface point of view, data can be joined or included or excluded on the fly. It can be drilled down and drilled through and users can slice and dice it and that type of thing can be done from anywhere in the data to any other place in the data. It doesn't have to be predefined. It doesn't have to have hierarchies or anything like that.”

    Tami S., the senior business intelligence analyst at the La Jolla Group, writes, “With the changing business landscape, it is nice to access Qlik Sense through an external website. As an organization when we use QlikView Desktop, we need to connect to our internal network. We can access QlikView through the QlikView access point but the website has a little different look and feel than the desktop application. We appreciate that Qlik Sense is browser-based and the user experience is the same whether at home, in the office or on a boat. As long as the user has internet access, performance is the same.”

    Offer
    Learn more about Microsoft BI
    Learn more about Qlik Sense
    Sample Customers
    Konica Minolta, Klout, Mahindra Satyam, The Weather Channel, Argus, Credit Suisse, NCR, and Sysmex.
    Abbvie, Airbus, Barclays, BT Openreach, BMW, Daimler AG, HSBC, IKEA, Nationwide Building Society, Royal Mail Group, Sanofi, Siemens, Wendy'', Vodafone, Volvo
    Top Industries
    REVIEWERS
    Financial Services Firm14%
    Manufacturing Company12%
    Computer Software Company12%
    Government10%
    VISITORS READING REVIEWS
    Computer Software Company20%
    Comms Service Provider16%
    Financial Services Firm9%
    Government7%
    REVIEWERS
    Financial Services Firm18%
    Manufacturing Company11%
    Healthcare Company11%
    Retailer11%
    VISITORS READING REVIEWS
    Computer Software Company22%
    Comms Service Provider16%
    Financial Services Firm12%
    Government7%
    Company Size
    REVIEWERS
    Small Business38%
    Midsize Enterprise17%
    Large Enterprise45%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise14%
    Large Enterprise68%
    REVIEWERS
    Small Business18%
    Midsize Enterprise28%
    Large Enterprise54%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise15%
    Large Enterprise71%
    Buyer's Guide
    Microsoft BI vs. Qlik Sense
    March 2020
    Find out what your peers are saying about Microsoft BI vs. Qlik Sense and other solutions. Updated: March 2020.
    608,713 professionals have used our research since 2012.

    Microsoft BI is ranked 1st in Business Intelligence (BI) Tools with 188 reviews while Qlik Sense is ranked 3rd in Data Visualization with 22 reviews. Microsoft BI is rated 8.0, while Qlik Sense is rated 9.0. The top reviewer of Microsoft 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)". On the other hand, the top reviewer of Qlik Sense writes "Easy to use, provides a self-service environment, and offers high performance". Microsoft BI is most compared with Tableau, Amazon QuickSight, MicroStrategy and Oracle OBIEE, whereas Qlik Sense is most compared with Tableau, Alteryx, QlikView, Amazon QuickSight and IBM Cognos. See our Microsoft BI vs. Qlik Sense report.

    We monitor all Business Intelligence (BI) Tools 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.