What users are saying about

Microsoft BI

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

QlikView

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

Microsoft BI

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

QlikView

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
557 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

Add comparison

Likelihood to Recommend

Microsoft BI

I found that Tableau is more efficient in providing options to calculate measures, percentages as compared to MS BI Power Pivot. Also, Tableau is more web-friendly. However, analytic capability is well suited in Microsoft BI. Microsoft BI is well suited in larger organization setup which requires various integration with external line of business applications. Sometimes, the cost impact can be bigger for smaller organizations as they look for savings while shopping for minimum viable product.
Ved Mishra profile photo

QlikView

I can't recommend QlikView enough for a small shop on a shoestring budget--with one technical user administering things, all your users can have a really nice, super useful data exploration tool. The burden is certainly on that one user, but the payback is immense considering the price (free!). Solutions like Tableau and Qlik's new product, Qlik Sense, are certainly prettier and less demanding in terms of UI design, but they can't touch QlikView in terms of value.
Jake Tolbert profile photo

Feature Rating Comparison

BI Standard Reporting

Microsoft BI
8.0
QlikView
7.1
Pixel Perfect reports
Microsoft BI
7.9
QlikView
6.3
Customizable dashboards
Microsoft BI
7.9
QlikView
8.1
Report Formatting Templates
Microsoft BI
8.2
QlikView
7.0

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.6
Integration with R or other statistical packages
Microsoft BI
8.1
QlikView
7.4
Report sharing and collaboration
Microsoft BI
8.9
QlikView
7.1

Report Output and Scheduling

Microsoft BI
8.2
QlikView
6.9
Publish to Web
Microsoft BI
8.3
QlikView
7.2
Publish to PDF
Microsoft BI
8.8
QlikView
6.8
Report Versioning
Microsoft BI
8.1
QlikView
7.1
Report Delivery Scheduling
Microsoft BI
7.6
QlikView
6.7
Delivery to Remote Servers
Microsoft BI
8.1
QlikView

Data Discovery and Visualization

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

Access Control and Security

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

Mobile Capabilities

Microsoft BI
8.2
QlikView
6.7
Responsive Design for Web Access
Microsoft BI
8.2
QlikView
7.0
Dedicated iOS Application
Microsoft BI
8.4
QlikView
5.4
Dedicated Android Application
Microsoft BI
8.1
QlikView
7.5
Dashboard / Report / Visualization Interactivity on Mobile
Microsoft BI
8.3
QlikView
7.0

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.5
QlikView
Themeable User Interface (UI)
Microsoft BI
7.8
QlikView
Customizable Platform (Open Source)
Microsoft BI
7.4
QlikView

Pros

  • One Stop Shopping: Single solution provider provides tight integration between data storage, data manipulation, data processing and presentation. Instead of buying an RDBMS from one provider, data processing tools from another vendor, and presentation tools from yet another, the entire application stack is provided by Microsoft.
  • Value: Compared to other RDBMS vendors, Microsoft BI tools are more cost-effective because all the tools needed are included in the purchase of Microsoft SQL Server, SharePoint and Office. SQL Server even has a Business Intelligence Edition!
  • Performance: The SQL Server RDBMS is a top-tier data management solution. Ancillary tools like Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), PerformancePoint are mature, full featured and include lots of performance monitoring and high availability options. The newer Power BI tools have made tremendous strides in stability and usability since their introduction last year.
  • HDInsight and Azure BLOB storage offer a new paradigm for storing and querying data sets of all sizes. Flat files are stored in inexpensive storage, and HDInsight Hive allows "schema over file" table structures and near-ANSI SQL queries. This provides an inexpensive, very fast way to process data from web logs, large call center logs, and other large data volume data sets without importing into a database. Once the processing is complete, the HDInsight cluster (up to 64 nodes) is dropped, leaving the data intact.
  • Azure Hybrid Scenarios: Microsoft is rapidly migrating their business offerings to Azure. Business Intelligence is no exception.
  • Many new features in SQL Server 2012 R2 and SQL Server 2014 are designed to allow seamless management of both on-premise and cloud-based data,From Infrastructure As a Service (IaaS) options like virtual servers for development and test to Power BI for Office 365 sites that revolutionize how data is shared and accessed, Microsoft is making significant investments in the next generation of cloud-based solutions.
Chris Utter profile photo
  • 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

  • Power Pivot is a very good tool to do self service BI but there is no direct way to implement row based security to the model. There has to be a mechanism where the owner of the book can lock the model within the book to be read only or hide the model so that other users will only see the reports and not the underlying data model
  • Many to many functionality is simple in multi dimensional cubes but there is no direct and efficient way available in SSAS Tabular model and Power Pivot
  • Even though Power Pivot is a easy to use and fast to implement BI solution, without proper training, end users can't utilize all the functionality of Power Pivot and common mistakes and misunderstandings will be expensive in long run
No photo available
  • 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 BI8.0
Based on 25 answers
Low Cost and catching up to the market expectations
No photo available
QlikView8.8
Based on 29 answers
Qlikview is a solid tool for any organization looking for a in-memory dashboard tool.
Robert Goodman profile photo

Usability

Microsoft BI7.0
Based on 5 answers
Easy to use. Good User Interface and visualizations
No photo available
QlikView9.8
Based on 6 answers
Once the data is loaded (which can range from simple to complex depending on the data set), it is relatively easy to create new charts/dashboards
Bill Chamberlain profile photo

Reliability and Availability

Microsoft BI9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo
QlikView9.8
Based on 4 answers
We have not had any downtime issues with the product nor uncovered any significant bugs
Bill Chamberlain profile photo

Performance

Microsoft BI7.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
QlikView8.6
Based on 4 answers
It is not a SAAS product.
No photo available

Support

Microsoft BI7.1
Based on 6 answers
We are not currently utilizing Microsoft's technical support.
Robert Goodman profile photo
QlikView2.1
Based on 7 answers
They are still building it out. Just recently I received a contact for an escalation manager. I used to just call my sales guy.

Response times vary
No photo available

In-Person Training

Microsoft BI6.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
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 BI8.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
QlikView8.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 BI9.6
Based on 7 answers
Be prepared to help business users define their data. We found that different campuses had different definitions for the same thing. This took some change management and negotiating to get each team to come to a common understanding.
Robert Goodman profile photo
QlikView7.4
Based on 13 answers
It has taken some time to get used to Qlikview and the backend team behind it. From understanding the new regulations on using less images and also pushing for more tools (such as full compatibility on desktop, laptop, ipad, phone). We were given training on this and have helpful tips to find analytics behind Qlikview but it is very much also a learn as you implement system.
No photo available

Alternatives Considered

Microstrategy - I went with Microsoft BI because of features, usability, integration capabilities, performance, availability of talent, cost, and end-user (self-service) capabilities.
Sean Brady profile photo
It's easier to learn than Pentaho.
No photo available

Return on Investment

  • Cleaner, more accurate data returned to end users.
  • Better decision making.
  • Increased control over data.
Nathan Patrick Taylor profile photo
  • Speed to market is the really big thing. You can attach to multiple data sources quickly and build a consumable model for a dashboard. It doesn’t require IT talent to build. We have built more dashboards and added more users in the last year, then in our entire history. I was at a company of 30k+ employees before, and we didn't have near this level of BI adoption.
  • As a result, we are seeing benefits across business function. For example, within sales, our pipeline has much more visibility. It allows for much faster decisions on things like quotas. One of our biggest power users is in sales ops. She feels her dashboards load 10x faster than our previous tool and she can make changes on the fly.
No photo available

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.