Visual Data Discovery: 4 Storytelling Approaches Compared
Qlik, SAP, SAS, and Tableau Software deliver the latest table stakes in visual discovery: storyboard capabilities. Here's how they stack up.
It would be nice if most data analyses ended with valuable decisions or actions. But in reality, many analyses end with a PowerPoint, finely tuned for board room presentations. Data is explored, analyzed, filtered, transformed, and then exported into a storytelling medium where it becomes static. The PowerPoint may be used to support or refute a hypothesis or to provide a status update.
But what if that same data and analysis could remain within the BI tool while delivering a boardroom-quality presentation? Could those death-by-PowerPoint meetings become more effective, interactive work sessions? Can the data be better presented, not only to support a hypothesis, but also to guide a decision maker to a logical conclusion that compels action?
This is the vision behind recent innovations in a number of visual data-discovery tools. Tableau Software and Qlik call them story points and storytelling, respectively, while SAP calls them storyboards and infographics. SAS, meanwhile, brings live integration within PowerPoint itself.
Table 1: Glossary Of Terms
Multiple visual indicators on a single page
Visual representation of information, used beyond quantitative data such as in subway or weather maps
Collection of thoughts with a beginning, middle, and end
While these features have similar names, the capabilities differ greatly. Here's a closer look.
Tableau story points Tableau released the concept of story points in version 8.2 in June. In this approach, a user can insert a data visualization onto a canvas and save the filters behind the data analysis. The idea of story points is to let users present the data as a story, with a beginning, middle, and end. The banner of the canvas can include a storyline title that is clickable. For example, in the story below, "Profits are increasing" is a clickable title. Multiple visualizations can be linked together to create a PowerPoint-like slideshow. Within each page, users can adjust the filters. As Tableau explains it, the data tells you what's happening, but the story guides you to an understanding of why it's happening.
QlikTech storytelling Qlik Sense Desktop was released in July as a free desktop visual-discovery tool based on the vendor's next-generation interface. The vendor has not announced a release date for Qlik Sense for the enterprise, which is currently in beta. In Qlik Sense Desktop, dashboards and individual visualization can be added to a story.
Compared to Tableau's approach, Qlik Sense has a few more bells and whistles for storytelling. First, each page of the story can contain multiple visualizations or snapshotted images with the drill point and filters saved. Also, there is an "effect" option that automatically recolors a chart so top (or bottom) performers stand out (in the image below, higher salaries are highlighted). Additional text can be added to the story, whether a simple annotation or a full paragraph. Images and shapes can also be added to the canvas to create an infographic. In play mode, each slide nicely transitions to the next. Dashboards remain interactive.
SAP Lumira storyboards SAP added the concept of storyboards to Lumira early this year. In contrast to the Tableau and Qlik approaches, SAP's storyboards are better described as dashboards with multiple visualizations on a single page. Lumira previously lacked the ability to create these simple dashboards, but it's a capability that most other visual data discovery tools already offered.
In addition to supporting visualizations and filters, Lumira storyboards let you add images and text boxes for titles or paragraphs. A version 16 update released in June brought support for infographics -- the ability to add pictograms and shapes to the storyboards.
As shown below, there is a preview feature that shows how the infographic will appear on various devices. With infographics, users can also set color options for images, backgrounds, and some charts. This, of course, should be an expected feature in any BI tool, but it was lacking in earlier Lumira releases.
SAP's infographic capability is an interesting concept, but I found the capabilities too immature to replace PowerPoint. For example, in trying to add a callout, text had to be added in a separate step, and the callout pointer could not be repositioned to connect to a particular image or outlier within the chart.
SAS Visual Analytics and PowerPoint The SAS Add-In for Microsoft Office is a little-known but powerful feature that lets users access and interact with SAS analyses directly from within Excel, Outlook, and PowerPoint. With this approach, users create visualizations within SAS Visual Analytics. The add-in embeds a Visual Analytics toolbar within PowerPoint from which users can insert visualizations onto the PowerPoint canvas. The visualization is a direct query, not a static export, so it can be refreshed. Users have all of PowerPoint's capabilities to add text and images.
More stories to come? All of these features reflect a growing trend in how to better present data and findings as part of a cohesive story. I suspect storytelling capabilities will continue to emerge in other visual data discovery tools. And as with any new technology, I expect second and subsequent releases will only improve.
In its ninth year, Interop New York (Sept. 29 to Oct. 3) is the premier event for the Northeast IT market. Strongly represented vertical industries include financial services, government, and education. Join more than 5,000 attendees to learn about IT leadership, cloud, collaboration, infrastructure, mobility, risk management and security, and SDN, as well as explore 125 exhibitors' offerings. Register with Discount Code MPIWK to save $200 off Total Access & Conference Passes.
Cindi Howson is the founder of BI Scorecard, a resource for in-depth BI product reviews based on exclusive hands-on testing. She has been advising clients on BI tool strategies and selections for more than 20 years. She is the author of Successful Business Intelligence: ... View Full Bio
6 Tools to Protect Big DataMost IT teams have their conventional databases covered in terms of security and business continuity. But as we enter the era of big data, Hadoop, and NoSQL, protection schemes need to evolve. In fact, big data could drive the next big security strategy shift.
Big Data Brings Big Security ProblemsWhy should big data be more difficult to secure? In a word, variety. But the business won’t wait to use it to predict customer behavior, find correlations across disparate data sources, predict fraud or financial risk, and more.
Join us for a roundup of the top stories on InformationWeek.com for the week of December 14, 2014. Be here for the show and for the incredible Friday Afternoon Conversation that runs beside the program.