Power BI vs Tableau vs QlikView: Which BI Software is the Winner?

31 comments

Business intelligence makes sense of the modern data landscape, which grows increasingly more complex and digitized. It follows that picking the right BI tools for your company makes all the difference in deriving meaningful insights from your data and making better business decisions. So how do you choose? Comparing industry leaders can be a good place to start, so we compared three of the top BI tools on the market to help guide you in your software selection process. Without further ado, let’s look at a features-to-features comparison of Power BI vs Tableau vs QlikView and see which one has the advantage in each category.

Compare Power BI, Tableau and QlikView Against Your Needs

Power BI Vs Tableau Vs QlikView Header

About the BI Tools

Whether you’re just starting or in the middle of your search, you may have already heard of Microsoft Power BI, Tableau and QlikView, as they are all three quite popular BI solutions. However, you probably want to know how they stack up against each other and more importantly, against your BI requirements. We’ll briefly take a look at an overview of their features and what makes them unique.

Power BI

Microsoft Power BI is an analytics and data visualization tool that enables users to connect to a wide variety of data sources and create reports and dashboards. Though it originally emerged as an add-on to Microsoft Excel, Power BI has since grown to stand on its own as a formidable product that fulfills the needs of all companies, from small businesses to large enterprises. Its highlights include seamless integration with Microsoft Office technologies, powerful data preparation and data querying capabilities, a drag-and-drop data visualization builder and a perpetually free version.

Tableau

Tableau is a data visualization solution that excels in helping businesses turn their data into actionable insights through interactive dashboards and stories. With a high degree of customization and security options, it offers users considerable control over their data storytelling. Through a user-friendly interface and intuitive drag-and-drop functionalities, it encourages users of all technical skill levels to create and explore data visualizations. While Tableau Desktop is the main offering, it comes as a part of several different packages that pair it with a license for Tableau Server or Tableau Online.

Qlikview

QlikView is a data discovery and analytics platform from Qlik Technologies that helps companies make data-driven decisions by making insights accessible to business users. Built for speedy deployment and quick configuration, it connects directly to and pulls information from almost any data source and then allows users to analyze all their data and build visualizations that convey its story effectively. Its differentiators include the Qlik Associative Engine, which indexes every possible relationship among data to render faster insights and enable associative analysis, a data governance dashboard and wizards for alerts, reporting and more. Though the vendor encourages users to move to its cloud-based QlikSense platform, it continues to provide updates and support for QlikView, as it remains a strong competitor in the business intelligence field.

This is just a brief summary of these three BI leaders and their features. For even more details, make sure to check out their product pages and request our free pricing guide.

Compare BI Pricing & Costs with our Pricing Guide

Features-to-Features Comparison

Power BI Vs Tableau Vs QlikView Features Cheat Sheet

Data Connectivity

When it comes to business intelligence, you want to make sure to analyze all of your data to get the deepest, most accurate insights. In order to do that, your solution must be able to connect to all of the data sources your company uses.

To start off our comparison, Power BI supports connections to many types of data sets and data sources. With native integration to Microsoft technologies like Excel and strong support for a plethora of other platforms, Power BI ensures seamless connectivity to existing data analytics investments. Nearly every program that works with Microsoft can integrate with Power BI, offering an expansive library of possible collaboration options. It also can mine data from programs like Google Analytics, MySQL, Oracle, Salesforce, MailChimp, Facebook and Zendesk. Its strength lies in connections to both on-premise and cloud-based sources, with both desktop and browser-based authoring, all a hybrid integration strategy based on the Microsoft Azure cloud APIs.

Tableau users can access hundreds of data sources, with native connectors for many major enterprise platforms like Amazon Redshift, Cloudera, Google Analytics, Microsoft Excel, My SQL and more. Users can connect to data already published on their Tableau site, housed in a cloud database, private server or stored in Excel or text-based files. In addition, developers can build their own connections to sources that aren’t currently supported, or users can request Tableau to add support for those connections in future updates.

Qlik also broadly covers connections to both on-premise and cloud-based data sources, with native connectors to enterprise applications and cloud services that include Apache Hadoop, Azure, Microsoft Office, MongoDB, Snowflake, SAP and Twitter, among others. Users must install connectors separately for QlikView after downloading them from the Qlik website. Developers can build advanced connections through OBDC or REST API. Users can also import data from files through drag-and-drop or connect to both legacy and modern databases.

The Winner: Tableau and Power BI come out ahead for data connectivity, both offering a wide range of data integrations and support for data sources both newer and older.

Advantage
For data connectivity, @MSPowerBI and @Tableau rate better than QlikView in SelectHub’s research & analysis of the three tools. #BusinessIntelligence #Software

Dashboards and Data Visualization

Business intelligence is all about deriving insights from data, and one of the most effective ways to do so is through data visualization tools, which take numbers and turn them into visually appealing, easily digestible graphs, charts and maps. And if data visualization could come down to just one element, it would certainly be the dashboard. Dashboards provide a snapshot of crucial KPIs that viewers can consume in minutes, making them an efficient way to communicate insights and help decision-makers save time. Let’s compare and contrast these BI tools in terms of data visualization and dashboarding to see which one is the winner.

Microsoft Power BI hosts one of the most user-friendly data visualization tools in the business intelligence market. The drag-and-drop interface of the software, along with access to a library of data visualizations and 85 other data visualization applications, provides an intuitive experience that ultimately results in beautiful and informative reports. Power BI’s data visualization functionality hinges on its tiles, visualized metrics that serve as an entry point into the underlying reports and datasets, allowing for greater visibility into the significance behind the numbers. Creating dashboards is simple, as users can simply pin tiles from any report, and adjust the look and feel of their dashboards from the platform’s toolbar. Users can set alerts for certain dashboard tiles and assign featured or favorite dashboards to monitor important metrics. Convenient sharing capabilities make it easy for users to collaborate, share data across teams and access insights on any device through the web. Power BI utilizes many of the same functions available in Excel, so users familiar with the Office staple will be able to maximize the value of this platform.

Compare BI Pricing & Costs with our Pricing Guide

Tableau is well-known in the industry as a user-friendly data visualization tool. Its intuitive interface allows non-technical users to quickly and easily create and customize dashboards that provide insight into a broad spectrum of business information. These dashboards feature responsive layouts that adapt to a wide range of devices and screen sizes, allowing Tableau users all over to experience cohesive design. Users can swiftly generate graphics through manually dragging and dropping fields, or automatically asking the solution questions in natural language through Ask Data. Users can interact with their dashboards through filters, a Show Me tool, highlighting and more to dig deeper. Tableau has a library of pre-built templates called Dashboard Starters, that automatically create dashboards based on integrations to popular enterprise data sources, or users can opt to create their own custom visualizations or utilize ones created by other Tableau users in the online community.

Tableau Visualizations

Compare BI Pricing & Costs with our Pricing Guide

Along with standard report creation features – visualization templates, customizable views, configurable tables and graphics – QlikView’s data visualizations factor in real time, interactive analysis as reports are made. When the system is in use, all relevant visualizations and data sets are displayed for quick reference. QlikView users can create and insert objects based on data into a canvas to create dashboards. Users can utilize four components to design their dashboards: charts, selections, buttons and metrics. QlikView offers a palette of tables and chart types for users to create visualizations. Dashboards are integrated within sheets as objects. Users can interact with dashboards through built-in drill-down and filtering options. As an older software, QlikView’s dashboards are relatively limited in interactivity and customization compared to other tools; however, many of the more advanced dashboarding features in line with modern expectations of BI tools, such as drag-and-drop data, are available through Qlik’s SaaS-based updated platform, QlikSense.

The Winner: It comes down to Tableau vs. Power BI – both solutions feature drag-and-drop dashboard creation, but Tableau offers out-of-the-box features like animations and pre-built dashboard templates that are available on Power BI only through customization or extensibility. Tableau also allows users to leverage any number of data points for analysis in data visualizations, while Power BI users are limited to 3,500 data points when it comes to drilling down into datasets, making Tableau’s dashboards more valuable when it comes to interactivity. This is a close one, but Tableau ultimately comes out ahead of Power BI. With its intuitive interface, customization options and real-time analytics, Tableau provides an all-inclusive and user-friendly experience that makes it the definitive front-runner for data visualization and dashboarding.

Advantage
@Tableau rates better than Power BI and QlikView for #Dashboard and #DataVisualization capabilities in SelectHub’s research & analysis of the three tools. #BusinessIntelligence

Reporting

Reporting is an important feature of any BI tool; it organizes data to show what is happening in a business at any given point in time. While reporting once was the field of IT power analysts only, modern BI solutions have made self-service reporting into reality for business users so that they can generate their own reports in minutes, not days, while reducing the burden on their company’s IT department.

Power BI users at all subscription tiers can build and share reports. Through a drag-and-drop canvas, users can create, customize and explore their interactive reports, which are responsive and compatible with all screen sizes and aspect ratios. Users can publish reports to the cloud or on-premises, or embed them into existing apps or websites. Additionally, users can export paginated reports in various formats, including Excel, Word, XML, CSV, PowerPoint, MHTML and PDF files. Power BI reports are designed to fit well on a page for smooth, pixel-perfect printing. Power BI Report Server is an enterprise-level reporting solution that allows for on-premises governance and report distribution behind a firewall, while still being a cloud-ready solution. Users can share their reports with others within their organization with the Share button, and managing permissions and access to their reports is simple from within the application.

Power BI Report Server

Power BI users can create, customize and publish interactive reports to the cloud for quick, easy and secure distribution.

Tableau’s reporting tool provides both automated, scheduled reporting as well as ad hoc reporting. Users can create reports in tables and spreadsheet formats, with visualizations in the form of graphs, charts or histograms. These reports can be exported in various file formats, including images and PDF files, which users can opt in to receive as regular email updates. Reports can convert to customized dashboards, accessible through a web browser.

QlikView features an advanced report generation and distribution tool called NPrinting. Organizations can create reports quickly in various popular formats, including Microsoft Office, PDF and HTML web pages. NPrinting offers both managed distribution and self-service reporting to ensure the right reports get to the right people effectively, either by ad-hoc requests, scheduled reports, email delivery or otherwise.

The Winner: Power BI simplifies report generation and customization while putting a focus on print-ready and publication-ready sharing – for these reasons, Power BI emerges as the winner for reporting.

Advantage
@MSPowerBI rates better than Tableau and QlikView for #Reporting capabilities in SelectHub’s research & analysis of the three tools. #BusinessIntelligence

Data Querying

While data lives in databases, users can only maximize the potential of their data through data querying. A data query, written in a particular programming language, often Structured Query Language (SQL), makes a specific request for data that extracts information and formats it for consumption and analysis. Data querying unlocks many of the more specialized and complex features of data preparation and data analysis, which can uncover hidden trends and relationships between data points. In order to fully make use of your data, your data analysts should have access to a BI solution that supports data querying.

Power BI’s Power Query Editor allows it to connect to different sources through queries. Its ribbon consists of five tabs for organization: Home, Transform, Add Column, View and Help. Users can shape and transform data with queries or view the number of active queries through a pane in the Power Query Editor.

Tableau uses a query language called VizQL and also supports custom SQL data querying. VizQL or Visual Query Language translates drag-and-drop actions into data queries. Through custom SQL queries, users can create a variety of requests. They can connect to a particular dataset rather than an entire dataset. Its custom querying allows users to append, combine and aggregate data. Users can create customized cross-database joins or table unions, restructure or reduce the size of data to use for analysis, and more. Tableau’s AI-powered Ask Data feature also allows users to make queries in natural language.

QlikView uses a load script, managed in its script editor, to connect to and retrieve data from various data sources. Users can specify fields and tables to load within the script, or use script statements and expressions to manipulate or transform data. QlikView’s associative engine identifies common fields from different tables, and users can see the resulting transformed data structure in a viewer. After QlikView loads the data, it stores it within the active document or in RAM. To refresh data, users need to reload the script.

The Winner: Tableau comes out the winner, with its built-in support for data queries in its own query language as well as SQL, as well as its augmented NLP data querying capabilities.

Advantage
@Tableau rates better than Power BI and QlikView for #DataQuerying capabilities in SelectHub’s research & analysis of the three tools. #BusinessIntelligence

Data Security

Protecting your data is just as, if not more important than analyzing it. Top BI solutions should stay up-to-date with protocols and certifications. Additionally, they should offer features that help administrators manage access, permissions, authentication, encryption, auditing and more so that companies can rest assured that their proprietary data is always safe.

Governed by Microsoft’s standards and policies of security, Power BI has strict compliance with data security standards. Power BI’s dedication to data security is evident in its very architecture: each deployment consists of a web front-end cluster and back-end cluster. Data remains secure as the solution authenticates clients and transmits data between the two clusters. Administrators can choose their preferred model of user authentication. Within the solution, Power BI offers row-level security and column-level security that can be implemented to restrict access to data for certain users. Whenever users share a dashboard, they can choose whether to give recipients Read or Reshare permissions; they can later view and manage individual user permissions for each dashboard. Platform security for Power BI also includes multi-tenant environment security, network security and the ability to add additional security measures.

Compare BI Pricing & Costs with our Pricing Guide

Tableau supports a wide variety of authentication methods, including local, SAML, Kerberos, mutual SSL, OpenID, trusted authentication and personal access tokens. It encourages best practices for server, extensive, encryption and network security. Users can protect live data sources, choosing whether to prompt users to provide database credentials when they click a published view. Tableau administrators have three options that they can use in tandem to manage data security: database login accounts, authentication modes and user filters. Site roles and permissions allow administrators to manage data access and authorization. Tableau also offers row-level security, restricting certain rows of data that users can see within a workbook.

QlikView offers authentication either through Windows, a user ID and password for the platform or through the license key. Access to data is managed through security tables, which users must build into the script through data queries in the same way as the solution normally loads data. These security tables can set access privileges for specific users or groups of users based on roles; users without authorization cannot access QlikView documents. Users can limit modification permissions within the security page in a QlikView document’s properties. QlikView and QlikView Server support a feature through which some of the data in a document can be hidden from the user based on the section access login.

The Winner: While Tableau and MS Power BI both share largely the same security components, Power BI leverages stronger security models through Azure and its built-in cluster architecture.

Advantage
@MSPowerBI rates better than Power BI and QlikView for #DataSecurity in SelectHub’s research & analysis of the three tools. #BusinessIntelligence

Augmented Analytics

Augmented analytics is the integration of artificial intelligence, machine learning and natural language processing to accelerate time to insights and help humans analyze data more effectively. It can make insights more accessible to users of all technical skill levels, automate time-consuming tasks, predict future events based on statistics and deliver more relevant information through personalization. All in all, augmented analytics is the data analytics you know and love, but faster and smarter. If you want a BI solution that’s future-proof, you definitely want it to be equipped with augmented analytics.

Power BI users can run Quick Insights to automatically identify basic insights, correlations, and potential outliers via a set of visualizations generated through algorithms. AI-powered data visualizations automatically uncover key drivers that affect given metrics and segment data into groups using decision trees. With the Get Insights feature, users can simply click on a button within any dashboard to find out more about specific data; Power BI can run machine learning models to explain what’s happening. Though these ML models only run for a short period to return insights quickly, users can choose to continue running analysis, allowing the AI to update the insights as it learns more. Data analysts can also harness predictive analytics through automated machine learning (AutoML). Through AutoML, users can train, validate and invoke machine learning models, simplifying the creation and testing of machine learning algorithms. AutoML automatically extracts the most relevant features, selects an appropriate algorithm and then tunes and validates the ML model. After a model is trained, Power BI automatically generates a performance report that includes the results of the validation. Users can then invoke the ML model on any new or updated data within the dataflow. As far as personalization, Power BI supports personalized visualization panes and Siri Shortcuts like “Hey Siri, open my report.”

Machine Learning Power BI

In Power BI, users can create and train machine learning models that they can then apply to other data sets to generate insights.

As for Tableau, Smart Analytics uses machine learning to automate data preparation, allowing users to pivot and split data or index and group related words through fuzzy matching. Tableau also uses machine learning to recommend database tables and joins based on the organization’s data source usage metrics. Explain Data, powered by algorithms and statistical models, helps users explain specific points in their data with a focused set of explanations. Tableau also supports predictive analytics, with drag-and-drop forecasting and statistical model integration through R and Python.

Unfortunately, QlikView does not support any artificial intelligence, machine learning algorithms, chart suggestions or natural language processing at this time.

The Winner: Overall, when it comes to augmented analytics, Power BI is the victor, with AI-powered explanations available throughout the tool and built-in trainable machine learning algorithms.

Advantage
@MSPowerBI rates better than Power BI and QlikView for #AugmentedAnalytics and #AI capabilities in SelectHub’s research & analysis of the three tools. #BusinessIntelligence

Embedded Analytics

Embedded analytics delivers the benefits of data-informed decision making to users of an existing platform by allowing a BI tool to be embedded into another program. For any developer looking to add analytics to their software or service without building an in-house tool, BI tools with embedded capabilities provide a nifty solution.

Power BI users can embed Power BI dashboards, interactive reports and tiles within an application through REST APIs and JavaScript APIs; they can choose to view their data directly in Power BI or in the embedded application. Additionally, it supports multi-tenancy which accommodates many different user capacities with single sign-on authentication. Power BI users can create a dedicated capacity to create dedicated resources for their clients or workspaces. Users specifically looking for a more powerful solution can purchase Power BI Embedded, a scalable version of Power BI that allows for additional visuals and features, including white labeling, customization and Q&A support.

Compare BI Pricing & Costs with our Pricing Guide

Tableau offers embedded analytics with multitenant architecture, white labeling, customization and security measures such as single sign-on, row-level security and user permissions. Tableau provides multiple options to embed BI capabilities into custom-developed web applications through JavaScript API and Rest API. It also provides a Mobile App Bootstrap sample code to provide a starting point for custom mobile app development with embedded Tableau functionality.

QlikView does not support embedded analytics, but QlikSense and Qlik Analytics do, with flexible and powerful capabilities through RESTful APIs that allow developers to build and extend embedded analytics tools for almost any application or browser-based UI.

The Winner: Though Tableau and Power BI are neck-and-neck for embedded analytics, Power BI is the winner; comparatively, it is easier to embed into other applications and supports secure write-back through a custom visual, whereas Tableau only supports this through custom development.

Advantage
@MSPowerBI rates better than Tableau and QlikView for #EmbeddedAnalytics capabilities in SelectHub’s research & analysis of the three tools. #BusinessIntelligence

IoT Analytics

When technology experts talk about the Internet of Things, or IoT, they refer to interconnected devices that can transmit data over a network without needing human-to-human or human-to-device interaction. A few examples of IoT devices include smartphones, smart thermostats, sensors, vehicles, machinery and more. The Internet of Things brings all these devices together, and BI tools with IoT analytics capabilities can subsequently explore and analyze the huge volumes of data generated by this giant network of devices, creating insights with even more breadth and depth.

Power BI integrates with Azure Stream Analytics, a real-time analytics and complex event-processing engine that is designed to analyze and process high volumes of fast streaming data from multiple sources simultaneously. It also integrates with Azure Event Hub and Azure IoT Hub to ingest data from sources like connected devices, sensors, social media feeds, clickstreams, applications and log files. Power BI can identify patterns, which can trigger actions and initiate workflows such as creating alerts, feeding information to a reporting tool or storing transformed data for later use. Users can create real-time dashboards and alerts for these IoT devices based on temporal or spatial patterns and anomalies.

Tableau can gather data from sensors or devices and then analyze and visualize it to develop insights based on data collected. Tableau can build dashboards from IoT data and detect trends or anomalies.

QlikView supports IoT Analytics with direct access to IoT data in close to real-time. It can analyze large amounts of IoT data and present it in an intelligible way, and it also supports monitoring and forecasting in real-time with automated alerts and more.

The Winner: With Azure Stream Analytics, real-time streaming data analytics is a cinch with Power BI, whose alert, dashboarding and anomaly detection capabilities propel it to the front of the pack.

Advantage
@MSPowerBI rates better than Tableau and QlikView for # capabilities in SelectHub’s research & analysis of the three tools. #BusinessIntelligence

Geospatial Analytics

Geospatial analytics helps turn spatial, location-based data into maps, visualizations and actionable insights. It gives geographic context to data points, adding another layer of information.

Power BI integrates with ArcGIS maps to provide map visualizations, which users can pin to dashboards. Users can also create map visuals based on TopoJSON maps. If their geospatial data is in any other formats, Power BI users can convert shapefiles or GeoJSON files to TopoJSON files which they can then convert into visualizations for their dashboards.

Tableau users can import geospatial data from various file formats and then analyze and visualize it directly in the platform. Tableau supports various types of interactive map visualizations, such as proportional symbol maps, choropleth maps, point distribution maps, heatmaps, flow maps and more. In Tableau, users can perform a map search to find locations and explore and inspect data related to those places. When users begin to type in the search box, map search suggests possible locations that are in their map view, based on location names and text from their data sources. Users can search for location types such as continent, country, state or province, county, city and postal code. Tableau also offers forward geocoding and reverse geocoding, as well as various spatial functions which allow users to perform advanced spatial analysis and combine spatial files with data in other formats like text files or spreadsheets. Tableau’s spatial connector allows users to connect to and join ESRI Shapefiles, KML, GeoJSON files, MapInfo tables and other forms of geospatial data.

Tableau Maps

Tableau uses geospatial analytics to help users add the “where” to their “why.”

Qlik GeoAnalytics lets users make better location-related decisions by offering mapping and location-based analytics for QlikView. QlikView’s multi-layer mapping provides geographic visualization and calculations, including spatial analysis to collect, display and manipulate location-based data such as street addresses, zip codes, satellite images and GPS coordinates. It also allows users to perform geo data look-up through which they can automatically populate and update dashboards and maps with data about specific places.

The Winner: With its integrations for geospatial data in a large variety of formats, interactive map visualizations and its powerful map search function, Tableau takes the lead.

Advantage
@Tableau rates better than Power BI and QlikView for #GeospatialVisualization and #MapVisualization capabilities in SelectHub’s research & analysis of the three tools. #BusinessIntelligence

Natural Language Processing

Natural language processing (NLP) and natural language generation (NLG) go hand-in-hand as tools that enable easy processing, querying and generation of data reports and visualization through conversational language commands, as opposed to commands written in SQL or other code. NLP and NLG are a feature of augmented analytics that make data insights more accessible to users throughout an organization.

Power BI provides a Q&A option to explore data by asking questions in natural language and receiving answers in the form of charts and graphs. Users can type questions about things such as ratios, formulas and indicators conversationally, and Power BI will generate automatic responses and reports. These reports can include intelligent narratives generated by Narrative Science Quill, an advanced natural language generation tool that can uncover hidden trends. These narratives are dynamic and continuously update as users interact with their data. Users can adjust the narrative and share them with others. Power BI supports both text-based and voice-based natural language queries and uses autocomplete to show relevant and contextual suggestions. Power BI integrates with Cortana; users can ask their questions to Cortana, the Windows built-in AI assistant, and instantly obtain an answer. The mobile app for Power BI also supports natural language queries.

Tableau supports NLP queries through Ask Data, which use algorithms to allow users to type questions in natural language and receive answer suggestions in the form of visualizations. Users can then further adjust their questions and the data visualization. The result can be saved for later use and shared with others. Users can also add additional data sources, perform map searches and create dashboards through natural language queries.

Though QlikView does not support natural language processing, QlikSense does.

The Winner: With more comprehensive features overall, Power BI is the champion for natural language processing.

Advantage
@MSPowerBI rates better than Tableau and QlikView for #NLP #NaturalLanguageProcessing in SelectHub’s research & analysis of the three tools. #BusinessIntelligence

Native Mobile App

Gone are the days that business stayed in the office; nowadays, work goes where we go, so we need to have access to our data wherever that new workplace may be. Native mobile apps play a major role in bringing insights to your Android or iOS devices, making sure that the platform seamlessly fits your screens of various sizes and your dashboards maintain their interactivity.

Power BI offers native mobile applications for Windows, Android and iOS devices that enable users to securely view and share real-time reports and dashboards and see all their essential data in one place. They can tap to explore, filter and focus on what’s important. Mobile users can also create and share reports, submit natural language queries, and set up push notifications for tile changes to get personal data alerts sent to their device. With up to 250 MB of offline data caching, mobile users don’t need to be connected to a network to see their data. By default, the mobile app refreshes data frequently; users can access and interact with dashboards they’ve accessed before while they’re offline, though paginated reports and some tiles that require an active server connection will not be available. The mobile app Notifications tab shows users a chronological personalized feed of messages about alerts they’ve set, new dashboards that have been shared with them, updates to the workspace and more. Power BI Mobile additionally supports on-the-go collaboration through touch-enabled annotation and sharing, geospatial analysis and QR code scanning.

Power BI Mobile

Power BI’s responsive mobile application features push notifications, a personalized feed, collaboration and more.

Compare BI Pricing & Costs with our Pricing Guide

Tableau has native mobile applications for Android and iOS users. It provides access to dashboards and KPIs, allowing users to interact with them through filters, scroll and zoom actions, and drill-down functions. Tableau allows mobile users to mark, scroll, search and browse through dashboards. Tableau’s offline data capabilities include interactive previews that allow offline users to access data; when users are connected to the server, the mobile app downloads all their favorite workbooks and views, which they can access later even without a network connection. Mobile users can subscribe to workbooks and set mobile push alerts when data reaches a given threshold. Tableau mobile users also have a personalized home screen that provides a curated, consistent view of their most important metrics.

QlikView’s mobile app is available only for iOS devices. It offers responsive design by re-sizing charts, re-scaling the level of data detail and optimizing the visualizations for mobile screens.

The Winner: Power BI is the winner in this category, besting Tableau in its mobile collaboration, geospatial analysis and QR code support, as well as report generation and NLP queries.

Advantage
@MSPowerBI rates better than Tableau and QlikView for #mobile capabilities in SelectHub’s research & analysis of the three tools. #BusinessIntelligence

Free Trial

Try it before you buy it – definitely try out every tool on your shortlist to see how it integrates with your existing solutions. A free trial gives you a risk-free period to do just that.

Power BI offers a 60-day free Pro trial. It also has a perpetually free edition for individual users, Power BI Desktop.

Tableau offers a 14-day free trial of either Tableau Server or Tableau Online, with Tableau Desktop included. It also has a perpetually free edition, Tableau Public.

Qlik offers a 30-day free trial of QlikSense, the upgraded SaaS version of QlikView. Qlik also offers a perpetually free version of its software for personal use, called QlikView Personal Edition.

The Winner: Microsoft offers the longest and most robust free trial out of the three vendors, so we’re giving this one to Power BI.

Advantage
@MSPowerBI rates better than Tableau and QlikView for its #FreeTrial in SelectHub’s research & analysis of the three tools. #BusinessIntelligence

Power BI vs Tableau vs QlikView – Which Solution Wins?

Overall, Power BI comes out ahead of Tableau and QlikView when compared across these 13 key requirements. It claimed the advantage 10 times – and across many of the most critical features — making it the more attractive choice based on SelectHub’s analysis.

But when all’s said and done, the winning solution still may not be the winner for you. Even if Tableau and QlikView didn’t claim the title, they still have a place in the winner’s circle as two of the leading business intelligence tools on the market. One of them, both of them or neither of them may suit your company’s needs better than Power BI can, as you may prioritize certain requirements more than others.

Your budget is also a crucial factor in choosing software, but pricing for all three solutions vary, depending on a number of factors. For a complete comparison of costs and pricing plans, make sure to check out our free pricing guide, so you can be sure you’ll be paying for exactly everything you need — nothing more and nothing less.

What did you think of our Tableau vs Power BI vs QlikView comparison? Which features matter to you the most? Who is the winner for you? Be sure to share with us in the comments below!

Compare BI Pricing & Costs with our Pricing Guide

Top Competitors

Tableau Server Logo
Tableau Server
Starting at $35 per user per month
QlikView Logo
QlikView
Starting at $1,350 per named user
Dundas BI Logo
Dundas BI
Starting at $6 per user per month
Oracle Analytics Cloud Logo
Oracle Analytics Cloud
Starting at $350 per named user
SAP Business Objects Logo
SAP Business Objects
Starting at $21 per user per month
SAS Visual Analytics Logo
SAS Visual Analytics
Starting at $1,365 per month with limited user capacity
Domo Logo
Domo
Starting at $2,100 per user per year
Power BI Logo
Power BI
Starting at $9.99 per user per month
MicroStrategy Logo
MicroStrategy
Starting at $5000 per named user per year
Sisense Logo
Sisense
Starting at $21,000 per year for 5 users
Hsing TsengPower BI vs Tableau vs QlikView: Which BI Software is the Winner?

31 comments

Join the conversation
  • Dylan - July 29, 2016 reply

    Tableau equals expensive glitter.

  • pokemongo - August 16, 2016 reply

    Much thanks! This a astounding web site!.

  • sivabonu - November 15, 2016 reply

    Currently Iam working as Congnos BI developer. I wanna change my career . Can any one suggest me Which one is best in the market now Tableau/Qlikview/MSBI/IBM Cognos BI.

    Lukas - November 17, 2016 reply

    I would suggest you to go with QlikView, because it is becoming very popular nowadays, but Tableau is also good choice considering complexity and versatility of this tool. Hope it helps a little bit.

    dshi - December 20, 2016 reply

    Try MicroStrategy.

    Tim Jevon - March 12, 2017 reply

    Hi Sivabonu,

    Though I cannot confirm a definitive answer as to “which is best” I have a friend who was a very senior Cognos consultant that recently moved to Tableau and my impression is that he’s very happy to have made the move!

    I firmly believe that the future will be dominated by Tableau, Qlikview or PowerBI; Tableau has the market share and ease of use, PowerBI has the advantage of the native Microsoft integration….

    Best of luck with your career

    Chandru - September 27, 2017 reply

    Currently I am working as Business analyst . I want to change my career . Can any one suggest me Which one is best in the market now Tableau/Qlikview/Powe BI.

    Gungadin - December 3, 2017 reply

    Sivabonu,
    Given your background in Cognos BI, you can easily learn any of the 3-4 tools you have asked about especially Qlikview and MS Power BI. But do know that learning new BI tools does not maketh a “new career” for a BI developer, it’s called “keeping up”.

  • Nelly - May 10, 2017 reply

    There is a lot of business out there for Tableau and it’s relatively easy to learn

  • Chris - January 26, 2018 reply

    None. Sorry to be blunt. The idea of pure visualization and analytics tools without feedback loops into processes (So called Insight only tools) is just not enough. Most application based analytics are now embedded anyway (especially in the cloud). So process improvement (insight to action), corporate steering, value driver trees, rules engine, machine learning, big data learn,business partner integration, learn and burn scenarios all find very little value in a stand alone analytics tool. Time to move into ML, Advanced Statistics and most importantly Data streaming and data quality (all 5 dimensions). The above vendors all have little to add until they can integrate into the “action part” of insight to action. Most are being ripped out anyway due to lack of Governance and high cost. Expect more from your data asset than some pretty story boards and graphs. Think what you need to move from Insight to Action: Alignment, Context, Relevance, Specificity, Change, Monitoring/Clarity of impact. None is available in the tools mentioned here as far as i can tell. All they do is break the key paradigm for digital: Do not replicate data if at all possible, and never break the link to live data.

    Michael Shearer - January 26, 2018 reply

    Chris, thank you for the insightful reply. Are there tools you’d recommended that meet the criteria you’ve outline?

    Abhi - April 30, 2019 reply

    Sorry to be blunt, but you seem to know nothing about operational analytics. For insight to action, you can always design your dashboard to show what actions you need to take next using the data. You can’t always jump into ML, Advanced Statistics without knowing how to actually design your data model.

    John - August 17, 2020 reply

    Eh. As technical guy your ideas sound strange, complex and unnecessery.

    First of all, the feedback loop. You read data from ERP, like MS Dynamics, you don’t feed data to ERP with BI tool. You feed data to ERP with ERP, mostly. If example is MS Dynamics then there’s a set of tables underlying ERP. What you input is restricted by these tables. “Based on data we don’t need to do maintenance every 2 week for this machine, this other machine still needs it.” This is relatively hard to input to ERP, easiest way to execute this is to change maintenance schedule wich might not be in ERP. You can solve this by doing what current BI tools allow, write a note. “This customers margin is too low, there needs to be actions.” How on earth you input this to ERP?

    Second, ML (machine learnign), Advanced Statistics, etc. These are fun words, buzzwords, but their meaning is relatively small. Many companies don’t have any BI tools, they are still on Excel and ERP combo. Also you can’t just throw data to ML algorithm and expect it to tell all the answers. You still need way to know if you are on budget.

    Third. “Never replicate data if possible and never break the link to live data.” It’s little hard to know where to start. For mostly data isn’t replicated for fun, it’s replicated for a purpose. Link to live data? What? In most cases live data is totally irrelevant. What does that even mean? If you have over 200 retail stores you don’t do anything with their live data. Another way is to use really much money. With over 200 retail stores data is generated several gigabytes per day. If you want history, meaning in this case month old data then you have really hard time combining it with ‘live data’. Most business people want to analyze what their business is doing on year, month, week, not what they are doing 1 minute ago. Same in production. If you have many factories then you just have so much happening that it’s meaningles to look to ‘now’. It’s meaningfull for factorys production manager, etc, but they usually use ERP for that. They use BI tools to notice anomalies and trends over time. This same applies to all businesses doing B2C, there’s just too much data. And yes, I’ve built application that used 400GB memory to analyze data.

  • Miguel - September 3, 2018 reply

    Can you please elaborate on what you mean by “a weak point of Tableau is its lack of regulatory compliance support”? In what context / from what perspective? thanks

    Alainia Conrad

    Alainia Conrad - September 19, 2018 reply

    Hi Miguel. We double checked this information for you and updated the article. Thank you for your comment!

  • han - February 12, 2019 reply

    i honestly don’t know what the author means about Microsoft have more integration abilities than Tableau.. it doesn’t – that’s the reason why i don’t choose Microsoft – because it’s so microsoft heavy. first of all you need to run the desktop on windows, 2nd if you need to publish the report to the server to share with others, you’ll need the ability to refresh the data.. the only way you can do it is through gateway – https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem . That only runs on windows!

    Kim O'Shaughnessy - April 5, 2019 reply

    Hi Han,

    Firstly, apologies for the delayed response. We had our analyst team look into this to make sure you got the most up-to-date version of the information you needed. We found that Microsoft Power BI offers support for 100+ data connectors including SAP HANA, Hadoop, Google BigQuery, Google Analytics and more. It’s well integrated with Microsoft’s portfolio products, including its Azure cloud platform. It also offers more than 180 custom connectors to build workflows, apps, and integrations with Azure Logic Apps, Microsoft Flow, and PowerApps.
    Tableau supports 70+ connectors but connects with many more varieties of data sources as compared to MS Power BI.

    Hopefully that provides some insight for you!

  • Alex R - April 18, 2019 reply

    In my opinion, Qlik is the one to be considered for the next 2 years, since is gaining a lot of inertia, because lately it developed it’s Qlik Core on Linux and bought CrunchBot in February 2019, that is specialized in AI-powered natural language … that is one next step in the Analytics domain.

    Bergen Adair - April 22, 2019 reply

    Thanks for reading and contributing your input Alex! Qlik definitely has some great features, this analysis is a simple feature-by-feature breakdown performed by our analysts. I look forward to seeing how both advance in the next few years!

  • Jai - April 21, 2019 reply

    Hi

    Do the three tools readily connect with Mongo Databases?
    Regards

    Bergen Adair - April 22, 2019 reply

    Thanks for reading Jai! Both platforms do connect with MongoDB. Here are some instructions for doing so:
    Tableau
    QlikView

  • Mike - May 22, 2019 reply

    This is a rather impressive (though not without Errors and Inaccuracies )PR post on behalf of Tableau.

    One Question, if I may? SAP starts at $55,000 a year ? What does that relate to? it certainly is NOT representative of SAP BusinessObjects or SAP Crystal Server (2016)

    If I might suggest a revisit good old reliable and secure BoBj. On June 19 , SAP’s Maheshwar Singh will introduce the new features and enhancements included in BI 4.3, with a focus on technical changes, including updates to third-party components and the operating system. Sign up here: https://bit.ly/2W8OO9m and maybe you can do an article after ? You are a good writer. Good structure and engaging.

  • Manjusha quadras - January 17, 2020 reply

    can we use the PowerBi report server for the real-time dashboard and how?

    Hsing Tseng - January 20, 2020 reply

    Hello Manjusha!

    Yes, you can.
    You can see how on Microsoft’s site here.

    Thank you for reading!

  • Alex - April 7, 2020 reply

    Read this carefully. Just one question to author. Why you compare QlikView with competitors? Do you know about Qlik Sense? If not, I recommend to compare the new modern product instead of QlikView. The article looks like comparizon the Windows 3.11 vs Windows 10 or MacOS or Ubunutu 18.

    Hsing Tseng - April 27, 2020 reply

    Thank you for your thoughtful comment! We do have Qlik Sense in our product directory here: https://www.selecthub.com/business-intelligence-tools/qlik-sense-enterprise/. This article compares QlikView, which is still a supported product by Qlik Technologies, but you are right that Qlik Sense is the more current offering. We’ll assess the differences between Qlik Sense and Qlik View to determine how to improve our comparisons moving forward and see what we can write about it in the future.

  • David Spree - May 24, 2020 reply

    Ive used QlikView for 10 years and PowerBI for 3.
    Qlik is far far better than PBI at building the UI …
    Try hiding/showing a visual in PBI based on user selections
    Or having a line chart where a single line changes colors based on on its value.
    Or dynamically including a dimension in a chart.
    You can’t. Or if you can they involve huge kludges …

    PBI MQuery is fine, and DAX is great.
    But the PBI chart/visualization is like a toy compared to Qlik.

  • Addend Analytics - August 27, 2020 reply

    Great explanation, all answers to questions about PowerBI has been well explained. Thank you for sharing!

    Hsing Tseng - August 28, 2020 reply

    Thank you for reading and commenting!

  • Benjamin Kamau - October 20, 2020 reply

    I really think that comparing to Qlik View rather than Qlik Sense (which is Qlik Tech’s Enterprise version, that does do white-labelling, etc.) missed a trick… would be great of you updated to compare to Qlik Sense!

    Hsing Tseng - October 20, 2020 reply

    Hi Benjamin,

    Thank you for the suggestion! We will be taking that into consideration moving forward with our research and hope to write an in-depth comparison of these products to Qlik Sense as well.

    Thank you for reading and leaving a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *