Self-service BI review: Tableau vs. Qlik Sense vs. Power BI

All three next-gen BI solutions make data discovery and analysis remarkably easy, but Tableau does it best

Watching the new, easy-to-use, exploratory business intelligence products edge out the older, feature-bloated reporting platforms for systems of record is like watching evolution in action. Let’s face it: The first-generation BI products required their own IT priesthood to set up, and they incurred the same implementation delays as every other IT project. Things got worse, not better, as the various BI product marketers got into feature wars instead of actually trying to deliver business value.

The three data discovery products I’ve been reviewing over the last few months -- Tableau, Qlik Sense, and Power BI -- demonstrate a range of capabilities at a range of prices, with Tableau the most capable and expensive, Qlik Sense in the middle, and Power BI the least capable, but a very good value. Each product might be useful to you, depending on your specific requirements and budgetary limitations.

Note that there are about two dozen significant products in the BI category; the three I discuss here are not your only choices. As you’ll see, however, Tableau, Qlik Sense, and Power BI all offer a good selection of chart types and data sources, and they are all much easier to learn and use than the traditional BI products. On the other hand, other products are better for routine line-of-business reporting, even if they are not as good as these products for data discovery.

Tableau 9.0

Tableau Professional can connect to a wide assortment of file (Figure 2) and server data sources, including Excel workbooks, character- and tab-delimited files, statistical files, and upward of 40 server types, although 19 of those are available only from Windows. Tableau Personal is restricted to six kinds of data source; the free Tableau Public can use a mere four kinds of data source.

You can connect multiple data sources to a Tableau worksheet and create joins between tables or files. If you know the joined data has referential integrity, you can improve performance by telling Tableau to assume referential integrity.

Tableau does a good job of importing data whether or not it’s in an ideal format. It does a similarly good job of inferring geographical information from street addresses. Tableau also gives the analyst a lot of flexibility to pivot, split, reformat, and massage the imported data without having to return to the original data source.

Tableau 9 Welcome screen

Figure 1: Tableau 9’s Welcome screen offers easy access to data connections, workbooks, training, and resources.

Tableau analysis is a drag-and-drop process with property sheets, kind of like a Visual Basic for data scientists. As we can see in Figure 3, the data dimensions (fields used for classification) and measures (data values both primary and calculated) appear in the tab at the left. You can drag them into rows and columns, attributes and filters.

Every feature of Tableau has additional options, even though the default settings are often pretty good. For example, the size of bubbles can be controlled in the Edit Sizes dialog that comes up when you double-click the bubble card, below the marks and colors cards to the left of the chart in Figure 3. Color, size, and shape give you the ability to represent extra dimensions and measures on a given chart in addition to the row and column measures. You can also do a lot with actions and tool tips.

Tableau lets you organize your analyses into worksheets, dashboards, and stories. Dashboards can contain an arrangement of multiple worksheets, and you can create actions for one worksheet that affect other worksheets in the dashboard, making it easy to, for example, see the data for a particular city over time, as in the “See what’s happening in your home town” dashboard of the CNBC Recovery Watch story.

Tableau file import

Figure 2: Tableau 9 can read a wide range of files (shown above) and servers. New in this version is support for SAS, SPSS, and R data files; Apache Spark SQL servers; and regular expressions in calculated fields for PostgreSQL, TDE, Apache Hive, and Oracle.

CNBC Recovery Watch is an example of a Tableau story on Tableau Public, which as you’ve seen displays the analyses in a browser. Anyone can sign up for Tableau Public for free, then download the Tableau Public app for Windows or Mac to create other analyses. That version of the app can only save analyses to the Tableau Public server.

Tableau Server is a private version of the system you recently used. It runs on Windows, has an administration system to control sharing, and can work with all the same data sources as Tableau Desktop. Tableau Online is a hosted version of Tableau Server.

If you want to share analyses privately but don’t have access to Tableau Server or Tableau Online, you can export a “packaged” workbook from Tableau Desktop, send it to your colleagues, and have them open it with the free Tableau Reader.

Tableau worksheet

Figure 3: Setting up a Tableau worksheet is even easier than creating a graphic or pivot table in Excel, and offers many more options both in terms of graphics and analytics.

Tableau’s selection of chart types is very good, and Tableau provides excellent control over chart appearance. It also gives the analyst easy ways to display multiple dimensions and measures. Tableau’s maps, dashboards, and stories help the analyst to explain the logic leading to a conclusion, and its parameterized displays controlled by widgets allow the viewer to play along.

Tableau supplies sample data, videos, quick starts, live classes, and webinars to help people get up to speed on the product. All versions of Tableau are available as free trials.

It’s very easy to learn the superficial stuff in Tableau, and many people can become productive with it in half an hour. However, it’s harder to learn features that are beneath the surface unless you happen to have seen them in a training video or know their names, so you can search the help.

Qlik Sense 2.0

When you first open or create a Qlik Sense “app” (essentially a project), you see an overview screen (Figure 4) that displays its sheets, bookmarks, and stories, as well as a project summary. From here you can view any part of the project or create a new sheet. The compass drop-down at the top left allows you to get to the data manager, data load editor, data model viewer, and the hub. The list drop-down lets you add data, perform sheet operations, and get help.

A Qlik Sense sheet shows one or more visualizations. The visualizations are automatically associated for selection purposes.

Qlik Sense sheets fig1

Figure 4. A Qlik Sense App overview displays its sheets, bookmarks, and stories, as well as a project summary. From here you can view any part of the project or create a new sheet. The compass drop-down at the top left allows you to get to the data manager, data load editor, data model viewer, and the hub. The list drop-down lets you add data, perform sheet operations, and get help.

You can select a dimension, measure, or a group of items from any visualization in a sheet (Figure 5). The other visualizations on the sheet will be updated with the same selection. You can also make multiple selections.

For presentation purposes you can organize sheet snapshots into stories and annotate the pages to bring out your points (Figure 3). If you need to drill down in response to a question about a story page, you can easily right-click on the relevant sheet and go to source. Once you are done looking at the source sheet, you can return to the story.

Qlik Sense dashboard

Figure 5. Here we have selected the Produce product group for preview by clicking it in the top donut chart. Notice that this selection shows up in the top left and has changed every chart and number on the sheet. Clicking the green check box will change the preview to a full selection and allow us to continue our analysis.

Qlik Sense 2.0 introduces the Qlik DataMarket, a source of public and commercially available data in six categories: business, currency, demographics, society, weather, and the economy. In each category, you will get some data for free, and all of the data if you have a Data Token. For example, in the economic data, you get the World Bank selected development indicators for free, but you need to pay to get the Federal Reserve Bank data on the U.S. consumer price index and the U.S. employment numbers.

Qlik Sense can import data from delimited files, Excel files, ODBC, OLE DB, and Web files (JSON with an add-on, plus XML and HTML tables). You can combine and relate all of these freely, and you can view the resulting schema in a data model view. Qlik Sense can connect to essentially any database, via ODBC and OLE DB, including “big data” sources such as Cloudera, Hortonworks, Vertica, and Teradata.

Qlik Sense retention

Figure 6. For presentation purposes, you can organize sheet snapshots into stories and annotate the pages to bring out your points. If you need to drill down in response to a question about a story page, you can easily right-click on the relevant sheet and go to source. Once you are done looking at the source sheet, you can return to the story.

Qlik Sense normally keeps all of its data in memory, in compressed form. There are times, however, that you have too much data to fit in memory. In that case, Qlik Sense offers “direct discovery” mode, which combines in-memory data with in-database data on demand. In direct discovery mode, some fields are loaded into memory only as metadata/symbol tables that can be used in expressions. The actual data residing in the database will be queried as needed.

Visualization types in Qlik Sense include bar charts, combo charts (bar plus line), gauges, KPIs, line charts, maps, pie (and donut) charts, pivot tables, scatter plots, tables, and hierarchical tree maps. Scatter plots include bubble size and color, but not bubble shape. You can add filter pane widgets and text and image areas to any sheet.

When working with Qlik Sense, you can save a bookmark to the current selection state of the current sheet. You can combine bookmarks into stories and add text and other annotations to make the story self-explanatory (Figure 6). If you’re using a story for a live presentation, you can drill down to the source for any visualization to answer a question, then return to the story when you’ve answered the question.

You can share your Qlik Sense analyses in multiple ways. Even if you’re running the desktop version, you can print a sheet or save it as an image file and send that to colleagues. You can share your desktop apps to the Qlik Sense Cloud, and up to four colleagues can explore your app. The Qlik Sense Cloud doesn’t currently support creating or editing apps, but that capability is planned for the future. Paid expansion of the Qlik Sense Cloud to more than five users per group is also planned, but the pricing has not been determined.

The most complete option for sharing is Qlik Sense Server, which allows any number of users to create, edit, and share apps. At $1,500 per token per year, however, Qlik Sense Server is not cheap, although it’s less expensive than Tableau.

I found the online articles and videos for learning Qlik Sense to be very good. As it turned out, I needed to spend quite a bit of time learning Qlik Sense -- there was a lot in the product that wasn’t obvious to me at first glance.

Microsoft Power BI

With the introduction of the new stand-alone Power BI, currently in preview, Microsoft hopes to compete with and perhaps leapfrog next-generation BI incumbents Tableau and Qlik. The new Power BI includes a Web interface to a service hosted on Azure and a Power BI Designer application for the Windows desktop, and it’s much more modestly priced: A standard account is free, a Pro account is $9.99 per user per month, and the Power BI Designer is free.

Both the website and the Designer application are updated on a regular basis. The Power BI Designer is updated monthly; it’s hard to tell when the site is updated.

You can import data into Excel, into the Power BI Designer, and into the Azure site. The data can come from Access, Active Directory, Azure SQL, DB2, Excel, Exchange, Facebook, GitHub, Google Analytics, HDFS, HDInsight, Marketo, Microsoft Dynamics CRM, Microsoft Dynamics Marketing, MySQL, OData, Oracle, Postgres, Power BI Designer files, Salesforce, SAP BusinessObjects BI Universe, SendGrid, SharePoint, SQL Server, SQL Server Analysis Services, Sybase, Teradata, Web tables, Visual Studio Online, and Zendesk.

Power BI visualizations

Figure 7. Power BI reports can contain multiple visualizations. Visualizations can be interactive, and interactions can affect the appearance of other visualizations.

For some data sources, Power BI has predefined charts, dashboards, and reports. For example, the default Visual Studio Online dashboard and report provide at-a-glance views of Git, pull request, and version control activity across the projects you configure for your account. For other sources, Power BI expects to see certain markers for its data. For instance, it supports Excel Worksheet named tables, Excel Data Model tables, and Power View sheets. If you only have raw data in your Excel worksheet, you need to go back to it and create one or more named tables; it also helps if you make sure your data types are correct.

If you upload a worksheet from your computer, Power BI will use it as a static snapshot. If the worksheet resides on your OneDrive, Power BI can refresh its data on demand. If you want to import text or CSV data files, you need to start by importing them into Excel or Power BI Designer.

1 2 Page 1
Page 1 of 2
It’s time to break the ChatGPT habit
Shop Tech Products at Amazon