More Than Pie Charts - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Software // Information Management

More Than Pie Charts

Business intelligence is too important to be limited by outdated presentation and visualization.

With practically 30 years in IT, I can remember when we (the conceptual IT) viewed technology as an enabler for some tasks but a constraint for many others. Those were the days when you could tell users, "Well, I'd like to help but there simply isn't any way to address that problem given the technology available." Technology choices were simpler then — mostly because they were few. Today, of course, it's a different story.

A dizzying array of great technology exists today that addresses most business intelligence (BI)-centric issues. But then why is it that much of what is being implemented is uninspiring BI technology that leads to mediocre solutions? Case in point, the ever-present pie chart.

Can you effectively interrogate a large OLAP cube using a simple pie chart? Can you really report and communicate all the necessary insight through your dashboard, given the volume and complexity of data, with just a pie chart? The obvious answer is no. But any of the advanced tools necessary to address complex BI issues seem slow in adoption, including visualization (Gartner, Dec. 5, 2003). Even though more robust visualization tools and technologies are available, the pie chart continues to be thrown in front of users.

The currently available technology is far outpacing our ability to comprehend its application and effectively absorb it into our BI environments. Architects, designers, and project planners simply have no idea what solutions exist or how to implement them. Some BI architects espouse the idea of standards in what almost seems a defensive maneuver. Too often the excuse is, "Well, the standard OLAP tool we use is x" — regardless of whether x can address the task at hand. The value of standardization is well understood; however, should it be invoked to the detriment of delivering actionable insight? Certainly not.

A Taste Of Advanced BI

Within virtually every segment under the BI umbrella, examples of leading technology can have a dramatic impact on the ability for user communities to make better decisions. From OLAP to dashboards, from event-based data capture to data quality, the number of tools far exceed those traditional few vendors whose advertising budgets are the biggest.

Spatial Enabled Dashboard. Map Intelligence affords interactive analysis between components of traditional BI technology, such as charts (pie charts) and pivot tables, with spatial technology for creating maps. Each component is synchronized such that any data manipulation, limits, filtering, or chart slicing is automatically reflected in the maps as shown in Figure 1. It's this blend of traditional and nontraditional BI technology that provides a unique dashboard environment.

FIGURE 1 Spatial enabled dashboard.

Map Intelligence lets user dynamically generate and query maps from any tabular source, not only making the user experience more meaningful, but also enhancing the visualization impact of the data being examined. Spatial layers are dynamically generated from the facts and dimensions reflected in the pivot tables and charts. The experience is a seamless integration between spatial analysis and a familiar BI dashboard.

The core technology of Map Intelligence, aside from the dashboard, is the middleware component between the dashboard itself and a geographic information system (GIS). All spatial capabilities are derived and served up from the spatial technology that's being accessed — for example, ArcIMS from ESRI, which is an Internet map server. Future releases of Map Intelligence are planned to interface with ArcGIS, also from ESRI, to take advantage of advanced spatial analytic and presentation capabilities.

With Map Intelligence, dashboard users aren't constrained to only the traditional time analysis anchor. Instead, analysts now use space as a second anchor point. Both time and space analysis combine to provide unparalleled opportunity to transform typical data into informational insight.

Exploratory OLAP. Another example of high-end analytics, supported by advanced visualization tools is a Poly Surface chart generated by a product called PolyVista (see Figure 2). The image depicts the graphical relationship (surface plot) of the measure Profit in terms of two dimensions, customer Education Level and Yearly Income.

FIGURE 2 Advanced visualization.

The blue surface maps the actual profit value for each cell in the table with larger values seen as darker blue peaks and the smaller values shaded a lighter blue. The figure helps visualize the profit potential across customers from low education to high education as well as from low salary to high salary.

Superimposed on the profit profile are bar markers indicating cell intersections where the profit is either greater than or less than expected. This statistical deviation is greater than expected where the bars rise above the midplane and lower than expected profits where the bars project downward from the midplane. These high and low deviation scores highlight points of interest to the sales analyst.

PolyVista is all about providing advanced OLAP tools and techniques, enabling analysts to aggressively interrogate dimensional data. Fundamental to all aspects of this technology is the notion of exploratory data mining and advanced visualization to support the traditional drill-down, roll-up, and slicing and dicing indigenous to OLAP solutions. The combined solution provides analysts some of the best opportunities to information insight.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
1 of 2
Comment  | 
Print  | 
More Insights
InformationWeek Is Getting an Upgrade!

Find out more about our plans to improve the look, functionality, and performance of the InformationWeek site in the coming months.

Becoming a Self-Taught Cybersecurity Pro
Jessica Davis, Senior Editor, Enterprise Apps,  6/9/2021
Ancestry's DevOps Strategy to Control Its CI/CD Pipeline
Joao-Pierre S. Ruth, Senior Writer,  6/4/2021
IT Leadership: 10 Ways to Unleash Enterprise Innovation
Lisa Morgan, Freelance Writer,  6/8/2021
White Papers
Register for InformationWeek Newsletters
Current Issue
Planning Your Digital Transformation Roadmap
Download this report to learn about the latest technologies and best practices or ensuring a successful transition from outdated business transformation tactics.
Flash Poll