What users are saying about

QlikView

543 Ratings

Microsoft BI

594 Ratings

QlikView

543 Ratings
Score 7.7 out of 101

Microsoft BI

594 Ratings
Score 7.8 out of 101

Add comparison

Likelihood to Recommend

QlikView

QlikView is well suited for scenarios where a heavy data is involved or heterogeneous data is there which also requires some manipulation/ cleansing or application of business rules. Also, if the UI dashboard involves complicated formulas to be worked upon, QlikView is well suited.However, if there is a need to quickly create some dashboards where the developer has little knowledge on database/ scripting and also there is no data manipulation required for input data, other technologies other than QlikView can be considered.
No photo available

Microsoft BI

Most suitable scenarios:
-Large scale report automation and distribution.
-Self service BI for internal and external users.
-Relational databases and multidimensional models.
-Comprehensive security & access control.

Less appropriate scenarios:
-Non-relational databases
-Low budget
-Tight timeframe

I'd invite anyone reading this far to think hard on his/her goals with BI. Are you trying to build a solid and endurable BI service for your clients or your own organisation? Or do you just need to have some quick visualisation of the data you have to make strategic or operational decisions in a few weeks time?

Implementing a MicrosoftS BI stack takes time, knowledge, and skills, none of these comes cheaply these days. If your answer to my first question is "yes", go ahead and study Microsoft BI a bit more then make your decision on your own. If you see my second question is most relevant to you, go and grab a web-based BI tool such as SiSense, Tableau, Splunk, and so on. Take the free trial option and see if you can test your ideas fast and at a lower cost. Good luck!
Haibo Yang profile photo

Feature Rating Comparison

BI Standard Reporting

QlikView
7.3
Microsoft BI
8.2
Pixel Perfect reports
QlikView
7.1
Microsoft BI
8.1
Customizable dashboards
QlikView
8.3
Microsoft BI
8.1
Report Formatting Templates
QlikView
6.3
Microsoft BI
8.4

Ad-hoc Reporting

QlikView
7.2
Microsoft BI
8.5
Drill-down analysis
QlikView
6.6
Microsoft BI
8.6
Formatting capabilities
QlikView
6.9
Microsoft BI
8.3
Integration with R or other statistical packages
QlikView
8.8
Microsoft BI
8.3
Report sharing and collaboration
QlikView
6.6
Microsoft BI
8.8

Report Output and Scheduling

QlikView
6.9
Microsoft BI
8.7
Publish to Web
QlikView
6.5
Microsoft BI
8.7
Publish to PDF
QlikView
7.5
Microsoft BI
8.5
Report Versioning
QlikView
6.5
Microsoft BI
8.8
Report Delivery Scheduling
QlikView
7.2
Microsoft BI
8.8
Delivery to Remote Servers
QlikView
Microsoft BI
8.5

Data Discovery and Visualization

QlikView
5.5
Microsoft BI
8.8
Pre-built visualization formats (heatmaps, scatter plots etc.)
QlikView
6.1
Microsoft BI
9.0
Location Analytics / Geographic Visualization
QlikView
3.6
Microsoft BI
8.8
Predictive Analytics
QlikView
6.8
Microsoft BI
8.5

Access Control and Security

QlikView
7.7
Microsoft BI
8.7
Multi-User Support (named login)
QlikView
7.6
Microsoft BI
8.8
Role-Based Security Model
QlikView
7.5
Microsoft BI
8.6
Multiple Access Permission Levels (Create, Read, Delete)
QlikView
7.9
Microsoft BI
9.0
Single Sign-On (SSO)
QlikView
Microsoft BI
8.5

Mobile Capabilities

QlikView
6.8
Microsoft BI
8.5
Responsive Design for Web Access
QlikView
8.0
Microsoft BI
8.4
Dedicated iOS Application
QlikView
5.2
Microsoft BI
8.7
Dedicated Android Application
QlikView
6.4
Microsoft BI
8.5
Dashboard / Report / Visualization Interactivity on Mobile
QlikView
7.8
Microsoft BI
8.5

Application Program Interfaces (APIs) / Embedding

QlikView
Microsoft BI
8.4
REST API
QlikView
Microsoft BI
8.6
Javascript API
QlikView
Microsoft BI
8.4
iFrames
QlikView
Microsoft BI
8.4
Java API
QlikView
Microsoft BI
8.3
Themeable User Interface (UI)
QlikView
Microsoft BI
8.7
Customizable Platform (Open Source)
QlikView
Microsoft BI
8.0

Pros

  • in memory application
  • AQL i.e auto association
  • QVD
  • conditional hide n show feature
No photo available
  • Point 1. User defined automation of report execution and distribution. Microsoft SSRS so far is one of the most user friendly report scheduling and distribution platforms available. Our client users, often non-technical business people, can subscribe to any reports they have access to on the report server and make a customised execution by setting up parameter values, export formats, receipients, etc. etc. Many users use this feature to monitor their action lists and risk profiles on a regular basis. They absolutely love it!
  • Point 2. Extensive programmability. Programmability has always been a great strength of many Microsoft products. Adding to my point 1, take Microsoft SSRS for example, it comes with a great deal of programmability. This means what client users need do in point 1 to set up the report execution and distribution by themselves, can now be programmed and completed automatically. One trick we often do is to program on SSRS for automatically executing and distributing a report using different parameter values to generate different results and then send to the email boxes of tens, if not hundreds of line managers within client organisations. Every line manager will only receive the results relevant to his/her own business unit(s). Once set up, a client organisation can save hundreds hours of work on Excel spreadsheets each month. Clients are willing to pay you a fortune for such a level of automation in reporting process!
  • Point 3. Flexible integration with SSAS. Instead of praising the more techinical features such as partitions and actions shipped with SSAS, I'd make my point 3 to be more business user friendly by emphasising the integration options of SSAS. Excel, Power BI, SharePoint, and third party tools such as Tableau, can all be easily and nicely integrated with SSAS objects. Not to mention since MSSQL 2012 you also have got the choice between Tabular models and Multidimensional models. Your business analysts will love the flexibility SSAS can provide!
  • Point 4. Stability of the IDE. Of course this one is to me when I'm in a BI developer mode. Using Visual Studio to develop SSAS, SSIS, and SSRS objects is a relaxing experience and will be good to the longevity of your developers. Why? Because VS is stable enough to not crash your developers' computers. As a matter of fact, VS has never crashed my OS since 2008...I mean it.. though a few times before 2008...Unlike some other seemingly simpler IDEs which may freeze or overpower your OS while processing your design changes... VS is a powerful yet stable tool and your developers will love it.
Haibo Yang profile photo

Cons

  • Implementing maps other than that of US
  • Real time data handling is not possible
  • device compatibility isn't there
No photo available
  • Its not a web based application yet. So you have to install the client application on your local machine. In addition, you pretty much have to install a the full SSMS package. Its a heavy weighted suite of products
  • Compared to Tableau you are limited in your dashboard building ability. In SSRS you have to build a master report along with a subreport where these two items have to have a key that links them together. From there you can break up the screen into multiple quadratics with your visualization.
  • If someone wants to view the report on their iPad, you have to make sure that the subscription for their report is in PDF or CSV format. If its in Excel and they dont have Excel on their iPad, they cant view it. If its in CSV, I believe the report will open up in the iPads native spreadsheet app.
  • When you are stuck while building a report, the forums for Microsoft pretty much suck. Their technical articles suck also. Microsoft support is pretty much non-existent.
Mashhood Syed profile photo

Likelihood to Renew

QlikView8.8
Based on 29 answers
Ease of use, ability to load from pretty much any data source. today I created an application that loaded time sheets from excel that are not in a table format. With Qlik's "enable transformation steps" I was able to automate loads of multiple spreadsheets and multiple tabs easily. Could not do that with any other tool.
Debbie Pyykkonen, MBA profile photo
Microsoft BI8.0
Based on 25 answers
Flexibility and ease of use! I have not found something that I can't do with the Microsoft BI tools. Some things may be a struggle, but that comes with any tool. The online community support for developers and users of Microsoft is tops as well. If you have a problem you can post in the forums provided by Microsoft or just post on Twitter and you will get an answer from the experts in the field in no time. There is no better community out there for technology that is very supportive and will not bash you even for asking the most basic question. There are plenty of options for support that don't require you to contact Microsoft and that helps save a lot of dollars and time. The tools are keep up-to-date and are constantly evolving.
Steve Wake profile photo

Usability

QlikView9.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
Microsoft BI7.0
Based on 5 answers
The product is very usable compared to competitive solutions. I didn't give it a full 10 because Microsoft needs to improve their Report Builder module.
Robert Goodman profile photo

Reliability and Availability

QlikView9.8
Based on 4 answers
QlikView server is very stable, with minimal errors and rare outages.
Oleg Troyansky profile photo
Microsoft BI9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo

Performance

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

Support

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
Microsoft BI7.1
Based on 6 answers
We are not currently utilizing Microsoft's technical support.
Robert Goodman profile photo

In-Person Training

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

Online Training

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

Implementation

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

Breadth of Deployment

Not applicable to our firm as we are small consulting firm.
Debbie Pyykkonen, MBA profile photo
It's deployed in departmental and company-wide implementations through our customer base. In the global 2000, we typically find either Microsoft or SAP as the corporate standard. There is probably a bit more SAP than Microsoft out there, particularly for ROLAP implementations. When MOLAP is leveraged, there are more Microsoft customers.
Lee Cullom profile photo

Alternatives Considered

QlikView has a great capability of handling complicated, heterogeneous and raw data and convert them into consumable form by performing basic ETL operations in comparison to Tableau and Power BI.
No photo available
Microsoft is a distant me too in a world that is crowded and drowning in BI Me too products. Visualizations 5/10. Micro Strategy, ClickView, Domo, BOBJ etc will kill this product. The issue is cost and speed to implementation. The cost is far less than any of the previously mentioned items. The implementation time could be a fraction of those products. The implementation of this product can be as simple as connecting Excel to the database (Create the relationships that you can do in the dbase or the query in Excel) and pushing to the Cloud. From the cloud based app you simply launch the gateway. The gateway is a breeze for anyone to connect with. The gateway only needs path back and its a breeze. No IT guys needed, no professional services, no firewalls or routing tables to configure. Just plug and play. This feature alone is the key product differentiation in my review. We already had the tables developed and ETL be damned, they all push from the MS-SQL dbase directly to cloud. Is this going to be big and fast in an environment with Data Universe's, API's to other products, and true Enterprise class features. I dont think so. Is it good enough for most small to medium companies or departments? Yes
Sean Warren profile photo

Collaboration and Sharing

QlikView6.3
Based on 21 answers
Via accesspoint users can share sessions
Add annotations and share bookmarks via email
Debbie Pyykkonen, MBA profile photo
Microsoft BI8.2
Based on 27 answers
It is easy to export anything you build in Microsoft BI to Excel or other tools and then share it from there. With SSRS being a web based reporting tool, that makes it very easy to share reports with anyone that has access to the internet or the network. At this point the weak point in report accessibility is on tablets and smartphones, Microsoft is working to make all of their tools HTML5 compliant, but it is not there yet. Security for all of the tools is baked in and is easy to setup if you already have a Microsoft Active Directory infrastructure. If you are not using Microsoft Active Directory you can still enhance the tools to use your own security tools without a lot effort. I believe that in the very near future this rating will be a 10 as well, once all of the tools are supported on all platforms using established standards.
Steve Wake profile photo

Data Integration

QlikView8.9
Based on 21 answers
Real time, associative model.
No photo available
Microsoft BI8.7
Based on 26 answers
There is no data that I have not been able to get with the Microsoft BI tools. The tools will accept flat files and access any database that has a way to query it, even if that is through a web API. If you need to get some data into a Microsoft BI solution, there is a way to do it. You can go down the custom development route if you have to, but in most cases there is someone else that has tried to do the same thing and shared their solution online for you to use. The Microsoft BI tools are used in so many different companies and scenarios that it is very rare these days that you are first one doing something. There is also the speed factor, depending on the source of the data I have run into more issues with the source systems not being able to keep up with the processing on the Microsoft BI side.
Steve Wake profile photo

Return on Investment

  • 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
  • Cleaner, more accurate data returned to end users.
  • Better decision making.
  • Increased control over data.
Nathan Patrick Taylor profile photo

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.

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