What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
677 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
594 Ratings

Microsoft BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
677 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8 out of 101

QlikView

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
594 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.7 out of 101

Likelihood to Recommend

Microsoft BI

Visualization of business data: it's good, fast, and cheap. What more can you ask? With more specialized visualization needs, use Tableau or write code. For complex scientific visualizations, write code.It's also so much easier communicating about the tool and its visuals to other people who don't spend their lives analyzing complex data. "It's Excel for Big Data!" is really quite simple.
Alexander Lubyansky profile photo

QlikView

QlikView is a good tool for visualizing data as long as you are trying to visualize aggregated or anonymized data. It can generate most type of graphs and also show you the details of the data that are being graphed. However, you do need to be careful to not include sensitive data in you visualizations since the data is stored in the QlikView database and that could become an attack vector that you will need to watch.
No photo available

Feature Rating Comparison

BI Standard Reporting

Microsoft BI
8.0
QlikView
7.0
Pixel Perfect reports
Microsoft BI
7.8
QlikView
6.2
Customizable dashboards
Microsoft BI
7.9
QlikView
8.0
Report Formatting Templates
Microsoft BI
8.2
QlikView
6.8

Ad-hoc Reporting

Microsoft BI
8.4
QlikView
7.5
Drill-down analysis
Microsoft BI
8.2
QlikView
8.0
Formatting capabilities
Microsoft BI
8.4
QlikView
7.3
Integration with R or other statistical packages
Microsoft BI
8.2
QlikView
7.3
Report sharing and collaboration
Microsoft BI
8.9
QlikView
7.5

Report Output and Scheduling

Microsoft BI
8.2
QlikView
7.4
Publish to Web
Microsoft BI
8.3
QlikView
7.4
Publish to PDF
Microsoft BI
8.8
QlikView
7.5
Report Versioning
Microsoft BI
8.1
QlikView
7.5
Report Delivery Scheduling
Microsoft BI
7.5
QlikView
7.3
Delivery to Remote Servers
Microsoft BI
8.2
QlikView

Data Discovery and Visualization

Microsoft BI
8.1
QlikView
7.0
Pre-built visualization formats (heatmaps, scatter plots etc.)
Microsoft BI
8.4
QlikView
8.3
Location Analytics / Geographic Visualization
Microsoft BI
7.9
QlikView
5.9
Predictive Analytics
Microsoft BI
8.1
QlikView
6.8

Access Control and Security

Microsoft BI
8.3
QlikView
8.1
Multi-User Support (named login)
Microsoft BI
8.4
QlikView
8.3
Role-Based Security Model
Microsoft BI
8.1
QlikView
8.2
Multiple Access Permission Levels (Create, Read, Delete)
Microsoft BI
8.5
QlikView
7.7
Single Sign-On (SSO)
Microsoft BI
8.4
QlikView

Mobile Capabilities

Microsoft BI
8.2
QlikView
7.0
Responsive Design for Web Access
Microsoft BI
8.2
QlikView
7.0
Dedicated iOS Application
Microsoft BI
8.4
QlikView
5.9
Dedicated Android Application
Microsoft BI
8.1
QlikView
7.7
Dashboard / Report / Visualization Interactivity on Mobile
Microsoft BI
8.2
QlikView
7.4

Application Program Interfaces (APIs) / Embedding

Microsoft BI
7.8
QlikView
REST API
Microsoft BI
7.9
QlikView
Javascript API
Microsoft BI
8.3
QlikView
iFrames
Microsoft BI
7.7
QlikView
Java API
Microsoft BI
7.6
QlikView
Themeable User Interface (UI)
Microsoft BI
7.8
QlikView
Customizable Platform (Open Source)
Microsoft BI
7.5
QlikView

Pros

Microsoft BI

  • Connecting andJoining Multiple Data Sources Together - Multi-Dimensional SSAS
  • Usability in Report Creation for Business Analysts (Excel via Analysis Services specifically), Executives (Performance Point and Power BI) and Power Users (Report Builder)
  • Collaboration (via SharePoint only, before the release of Power BI Designer)
  • Speed of Analysis - Specifically when leveraging SSAS on databases up to 5 TB
  • Speed of ETL processing - Multiple Parallel Sequential Jobs with SSIS/DTS
Lee Cullom profile photo

QlikView

  • Dashboards can be created easily with basic programming skills. A typical business analyst will not require a developer once the underlying data model is in place.
  • Qlikview can be used as a web based application allowing users to access dashboards anywhere permissions allow.
  • Qlikview provides a variety of pre-built objects that gives designers flexibility to represent data in multiple ways.
No photo available

Cons

Microsoft BI

  • Parallel Sequential job Processing within the SSIS GUI, not using DTS
  • More Options for non-SharePoint portal Integration
  • Reporting Services performance browser rendering time for reports
Lee Cullom profile photo

QlikView

  • The formula for harder BI analytics is neither intuitive or easy to learn. It really helps if you have some kind of SQL background. I really wish there were more out-of-the-box options that we can customize.
  • It may be more of a server issue but it can take hours to run a single query.
  • You have to define a lot of parameters for almost anything you create so the tool forces you to spend a lot of time selecting different options. I wish they had good pre-defined templates for layouts for us to choose from.
Suzan Liu profile photo

Likelihood to Renew

Microsoft BI

Microsoft BI 8.0
Based on 25 answers
The primary reason I give this a 10 is because of my previous experience with Microsoft. While I can be effective with other tools and solutions, my experience is primarily focused on the Microsoft solution stack and surrounding tools. Some people are Java-centric, some are C#-centric; I am Microsoft SQL Server-centric. Even with the explosion of "big data" tools, I always seem to gravitate toward the Microsoft solution because I know and understand it better than any other solutions.
Chris Utter profile photo

QlikView

QlikView 8.8
Based on 29 answers
I believe every client should have this software in their tool kit
Mike Schroff profile photo

Usability

Microsoft BI

Microsoft BI 7.0
Based on 5 answers
Usability is great. This product will make most feel right at home. I feel like this question should be asked from two points of view:1. Creator of reports, Data Models, Views etc: Most Advanced users will still rate the usability as very high. Its capabilities are still robust. However when compared to other Enterprise Class products it will not do many of the advanced application queries. 2. End user, Consumer: All end users will feel right at home. Many will be able to create connections to already created data models and other external publicly available sources like twitter, Facebook, World Health order etc... These connections are then in turn very very easily available to publish to SharePoint and Power BI. It took me a while to understand what I think is Microsoft's strategy. This will handle all but the most of robust needs. Much like many American made cars and my favorite Corvette, Microsoft is fast, has it own break downs from time to time but all of these are really to tolerate when the price is considered and the next one up that can out perform it is three to four times as much money makes this an easy one to still recommend
Sean Warren profile photo

QlikView

QlikView 9.8
Based on 6 answers
Dashboards are easy to use. They are very Excel-like with HTML5 capabilities. Data visualization is good.

The system requires minimum training to get user up and running. It just takes one hour to get up and running with building basic dashboards and one all day session for sophisticated dashboard building. It is intuitive.

We see this in our user adoption. We went from 6 users/day consuming dashboards to over 200 in 1.5 years.

We have 40-50 power users authoring dashboards. They have development licenses. My team in IT used to have to build all dashboards. Our capacity has grown from 3 to 50. Most of these users are analyst types good in Excel. A few power users can write SQL to build QVD models
No photo available

Reliability and Availability

Microsoft BI

Microsoft BI 9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo

QlikView

QlikView 9.8
Based on 4 answers
It is not a SAAS product.
No photo available

Performance

Microsoft BI

Microsoft BI 7.0
Based on 2 answers
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.
Robert Goodman profile photo

QlikView

QlikView 8.6
Based on 4 answers
It is not a SAAS product.
No photo available

Support

Microsoft BI

Microsoft BI 7.1
Based on 6 answers
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.
Jacob Saunders profile photo

QlikView

QlikView 2.1
Based on 7 answers
Qlik does have a tendency to push back sometimes stating that the issue is not related to QlikView but the system it is hosted on
Debbie Pyykkonen, MBA profile photo

In-Person Training

Microsoft BI

Microsoft BI 6.9
Based on 3 answers
This training was more directed toward what the product was capable of rather than actual programming.
Stephanie Grice profile photo

QlikView

No score
No answers yet
My team attended, but I cannot myself rate, but I think it was good as they've successfully launched a training program at our company themselves for users. It was 3-4 day training.
No photo available

Online Training

Microsoft BI

Microsoft BI 8.5
Based on 2 answers
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.
Sean Brady profile photo

QlikView

QlikView 8.0
Based on 3 answers
Training was as expected. The demo environments tend to be more fully featured that our own environment, but the training was clear and well delivered.
Robert Goodman profile photo

Implementation

Microsoft BI

Microsoft BI 9.6
Based on 7 answers
Thorough project planning and requirements gathering ensured project's success.
Boris Skylar profile photo

QlikView

QlikView 7.4
Based on 13 answers
QlikView were here for a few days, and it was up and running. It was very fast.

Where it fell short, is they did the implementation in demo mode, and didn't initially work with us to help us scale. For example, should we consider a load balancer and multiple servers?. How much capacity can this environment handle from a data and user perspective. We had to learn on own by trial and error. We are bringing them in to do an architectural assessment, but we have to pay for this.

We are now bringing them back in for architectural assessment. It is a fee based engagement.
No photo available

Alternatives Considered

Microsoft BI

With over 20 years in IT, I have experienced a full range of relational and non-relational data solutions, from Oracle and Informix to MongoDB and Hadoop. In my opinion, the Microsoft BI stack is the most complete, well-rounded, high performing data management system on the planet right now. More and more, the ability to make data-driven decisions sets organizations apart from their competitors, and no one offers a better solution than Microsoft and its partners. As more and more of what we do in business life moves to the cloud, Microsoft is again leading the way with its Azure platforms.
Chris Utter profile photo

QlikView

Our shortlist included Tableau, a newer version of Microsoft's SSRS and Qlikview.

We also knew what Micro Strategies and Business Objects had to offer from our experiences with them at other companies, and knew what we could afford. We eliminated them on price and the complexity of set-up.

We liked QlikView's in memory, associative model, and self-service capability.

With "in-memory", everything that gets consumed from a dashboard is loaded in memory so it is incredibly fast. Although Qlik touts its mobile distribution capabilities, that was not a huge differentiator for us, but is something we are now exploring. Microsoft and and BO do have in-memory capabilities now.

The associative model is patented by QlikView. Basically it starts to understand the associations in your data, e.g. if A=B and B=C, then A=C. It means you can build a Qlikview model very quickly. In traditional data warehousing, you work with users and understand their requirements, refine the data model, start to physicalize it, tune it, build ETLs. It's a 3 month at best delivery cycle. That doesn’t work here at this company. Our business users will not wait for you. Our business is dynamic, we are launching new products all the time. Instead of going through an arduous process, you just load data into QlikView and build an associative model. It link things up. If it doesn’t work, you can change things very quickly. You don’t have to write data definitional language. Where you get into trouble, is if you load very large data sets into QlikView, memory not as abundant. They are releasing a tool called data explorer which allows you to do a hybrid approach – load some in memory and some in database. If data is going into frequently used dashboards it goes into memory. If infrequent access is required and the data set is very large, it makes sense to leave it in the database.

We also have a company called DataRoket that builds connectors for us, e.g. load this relational data into QlikView. They have built adapters for QlikView-Hadoop integration
No photo available

Return on Investment

Microsoft BI

  • Greatly reduced reporting project development time (and associated costs).
  • Significantly larger pool of experts to assist on large / ad-hoc projects.
  • Faster availability of critical business data to our users (due to decreased development time as well as performance of overall system - we are able to keep the data very fresh).
  • Significantly increased ETL / data integration capabilities means that more legacy and external system data is making it into the data warehouse.
Sean Brady profile photo

QlikView

  • When I implemented QlikView as a customer, we generated huge ROI with Excess and Obsolete Inventory analysis. QlikView enabled the kind of analysis and the kind of visibility that was never possible before.
Oleg Troyansky profile photo

Pricing Details

Microsoft BI

General

Free Trial
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Entry-level set up fee?
No

Microsoft BI Editions & Modules

Microsoft BI
Edition
Power BI
$0
Power BI Pro
$102
2. per user per month
Additional Pricing Details

QlikView

General

Free Trial
Yes
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
Optional

QlikView Editions & Modules

QlikView
Edition
QlikView Desktop
Free1
QlikView
Custom2
1. Personal Edition
2. Per License
Additional Pricing Details
On an perpetual license basis, based on server plus number of users. Contact vendor for pricing.

Add comparison