What users are saying about

Microsoft BI

594 Ratings

QlikView

543 Ratings

Microsoft BI

594 Ratings
Score 7.8 out of 101

QlikView

543 Ratings
Score 7.7 out of 101

Add comparison

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 well suited for QuickBooks uses -- particularly if you are running 2015 Enterprise or later. It's not perfect for those organizations that are trying to push data analytics down to the staff/user level ... I think it is still best suited for a knowledgable IT or SQL geek on the startup process. But if you can get a geek (like me) to design your reports, then any staff person can use the reports and even make simple updates (like sorting on a new date range, or selecting different filters).
David Worrell profile photo

Feature Rating Comparison

BI Standard Reporting

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

Ad-hoc Reporting

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

Report Output and Scheduling

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

Data Discovery and Visualization

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

Access Control and Security

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

Mobile Capabilities

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

Application Program Interfaces (APIs) / Embedding

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

Pros

  • EASY visualization of business data. Excel is the killer app so anybody remotely good at basic office tools knows how to make PivotTables and PivotCharts. If you don't, it's really easy to learn; give it a try... People think big data visualization is hard but it's not for most business use cases.
  • FAST visualization of business data. There are BI/Analytics tools out there, some of them beginning with the letter S, that are slooow. I do my taxes waiting for them to run basic queries/filters/charts. Microsoft BI (and Tableau, etc.) create compact data models to allow for pretty fast data loading and slicery.
  • FREE or at least REALLY CHEAP visualization of business data. Who has MS Office on their business computer? Oh, everybody. If you don't have Office Pro, pony up for that or get the monthly license. The bigness of data you can run on your own machine is fairly big; don't use cloud if you don't need it. By comparison, who enjoys throwing thousands of dollars away on bloated legacy BI software? Well, too many companies, apparently.
Alexander Lubyansky profile photo
  • QV's #1 strength is the drag and drop visualization tools -- with just a bit of training, you can make some really nice looking charts
  • QV's #2 strength is the simplicity of the filtering. Other SQL languages might call this "linking" or database structure ... which can be a pain.... but QV makes this easy. Further, once the data is inside QV, the ability to FILTER the data using check boxes is completely intuitive and simple.
  • QV's #3 strength is its ability to work across platforms and integrate multiple data sources and multiple types of data. QuickBooks data is just one example of something that it can chew up with ease.
David Worrell profile photo

Cons

  • More than two dimensions. Yes, I know that 2D is the core of Excel's DNA. However, we're starting to deal with higher-dimensional arrays here in analytics land so better visualization support would be cool.
  • UI weirdness. By default, you are flipping back between regular Excel tabs and super-top-secret BI tabs. You create charts in one place, but look at them in the other. That kind of stuff. I know there are a couple of other ways to interact with Microsoft BI, but please figure out the main way.
  • Better hookups to other analytics tools including Microsoft's. Microsoft BI has a good variety of data connections, and I don't expect it to bloom into a full-fledged analytics tool, but it may be a good idea to keep hammering at connectivity with "hardcore" analytics. In my case, Python stuff.
Alexander Lubyansky profile photo
  • In the beginning you need to involve the user, the first impact is friendly but the immediate results are somewhat trivial.
  • When you understand the potential of the system you need to QlikView experts for more complex processing.
  • If you connect a complex database such as a company ERP solution (you can easy do it), you need to know the database structure to find data.
Ermanno Basso profile photo

Likelihood to Renew

Microsoft BI8.0
Based on 25 answers
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.
Lee Cullom profile photo
QlikView8.8
Based on 29 answers
We paid for the licenses in full when we acquired the application. Unlike Salesforce.com, there is not recurring license fees. The license fee was a one-time thing which means all we're paying for now and in the future is for support and maintenance. Both of which are not required.
Luke Fitzwater 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
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 BI9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo
QlikView9.8
Based on 4 answers
QlikView server is very stable, with minimal errors and rare outages.
Oleg Troyansky 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
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
QlikView2.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 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
Thorough project planning and requirements gathering ensured project's success.
Boris Skylar profile photo
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

Breadth of Deployment

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
QlikView is used by around 150 users across the university with half of them coming from the medical center. All other departments are using QlikView for one dashboard or another.
Raymond Younan profile photo

Alternatives Considered

We chose Microsoft BI due to performance, functionality, TCO and openness (yes, I know, this sounds strange for Microsoft).
  • SAP Business Objects has a less attractive GUI for end users, inferior Excel integration, inferior SharePoint integration, requires more labor to enhance performance and has higher licensing costs than Microsoft BI.
  • Tableau Server has no real ETL capabilities... and thus requires an underlying BI stack. So, while Tableau rules the visualization world with Tableau Desktop, Tableau Server doesn't give us all of the capability we need for a full BI solution for our clients. Tableau Desktop makes an excellent complementary product to Microsoft BI. We typically recommend using both to customers in certain situations.
  • Microstrategy - Comprehensive Multidimensional/HOLAP platform, expensive, visualizations are better than SAP BO, but not as strong as Microsoft, especially Microsoft SSAS + Tableau (which can be acquired at a lower price point). Excel integration isn't as seamless as SSAS to Excel either.
  • Oracle - Expensive, patchwork of acquired BI tools rather than a platform, inferior visualizations. This platform is meant for customers who are already trapped in Oracle licensing.
Lee Cullom profile photo
The only other product I have used for reporting is putting data into Excel and creating pivot tables. The ability to connect directly to multiple databases and other data sources is vastly superior.
No photo available

Collaboration and Sharing

Microsoft BI8.2
Based on 27 answers
This is prefaced with the assumption that SharePoint is being used as the portal.
Lee Cullom profile photo
QlikView6.3
Based on 21 answers
Once a dashboard is created, it can be shared between all users. However, a single user's changes cannot be shared with other users and thus making the collaboration capability limited.
Raymond Younan profile photo

Data Integration

Microsoft BI8.7
Based on 26 answers
If you combine Microsoft SQL enterprise licensing with Azure & Power BI, it's actually difficult to find a data source that can't be leveraged. This has never been a negative in our customer implementations.
Lee Cullom profile photo
QlikView8.9
Based on 21 answers
Data connectivity is more time consuming compared to other BI tools, at least with the ones which I worked with.
No photo available

Return on Investment

  • Business users easily learned self service BI with training and what to do and what not to do with self service BI
  • Learning curve for Powerpivot and other office 365 tools for IT team who already knew about data warehousing concepts is steep
No photo available
  • Overall QlikView had a positive impact
Bhaskar Reddy 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.