How To Differentiate Advanced Data Visualisation Solutions

Boris Evelson By Boris Evelson

I get many inquiries from clients on how to select a data visualization vendor / solution. The criteria that my clients often site are

  • Thick and thin client
  • Dynamic visualizations, not just static charts 
  • Ability to pull data from multiple sources
  • OLAP-like functionality

All these criteria are pretty much a commodity these days. The real differentiation will come once you start looking at advanced (key word "advanced") visualization features such as

  • If it’s a thin client does it have Web2.0 RIA (Rich Internet Application) functionality (Flash, Flex, Silverlight, etc)?
  • In additon to standard bar, column, line, pie charts,etc how many other chart types does the vendor offer? Some advanced examples include heat maps, bubble charts, funnel graphs, histograms, pareto chats, spider / radar diagrams, financial market specific charts (candlesticks, etc), project management specific charts (gantt, etc), scatter plots, relationship diagrams, overlapping sets, cluster analysis, and others?
  • Can the data be visualized via gadgets/widgets like temperature gauges, clocks, meters, street lights, etc?
  • Can you mash up your data with geospatial data and perform analysis based on visualisation of maps, routes, architectural layouts, etc?
  • Can you have multiple dynamically linked visualization panels? It’s close to impossible to analyze more than 3 dimensions (xyz) on a single panel. So when you need to analyze >3 dimensions you need multiple panels, each with 1-3 dimensions, all dynamically linked so that you can see how changing one affects another
  • Animations. Clicking through 100s of time periods to perform time series analysis may be impractical. So can you animate/automate that time period journey / analysis?
  • Multi dimensional charts. Can you have a 3rd, 4th, 5th, etc dimensions, such as a size of a bubble, color of a buble on an XY axis?
  • Subsets ands supersets. Can you select a point, rectangle, or a "lasso" (irregular region) and drill down into the subset or roll up into a superset (if selecting across several charts)?
  • Can you have microcharts (aka trellis or sparklines) – a two dimensional chart embedded in each row or cell on a grid?
  • Can you do contextual or gestural (not instrumented, not pushing buttons, or clicking on tabs) manipulation of visualization objects, as in video games or iPhone like interface?
  • Is the data that is being analyzed
    a) Pulled on demand from source applications?
    b) Stored in an intermediary DBMS
    c) Stored in memory? This last one has a distinct advantage of being much more flexible. For example, you can instantaneously reuse element as a fact or a dimension, or you can build aggregates or hierarchies on the fly.
  • Is there a BAM-like operational monitoring functionality where data can be fed in into the visualization in real time?
  • In addition to historical analysis, does visualization incorporate predictive analytics components?
  • Portal integration. If you have to deliver these visualizations via a portal (SharePoint, etc) do these tools have out of the box portal integration or do you need to customize.
  • Can you reuse metadata, such as KPIs, KPMs, that was already setup in your BI or ETL or DW models?

What did I miss?
 

Comments

re: How To Differentiate Advanced Data Visualisation Solutions

pretty good article, well i use business intelligence software to run my small business and to see what i got and what to expect from my business.

re: How To Differentiate Advanced Data Visualisation Solutions

Hi Boris,Good summary. I would only add that the quality of the design and visualizations themselves is pretty important too. In other words, if Stephen Anderson and Edward Tufty looked at the charts, what would they say?Good article; thank you,-Stas Antonshttp://SmartSymbols.comhttp://twitter.com/SmartSymbols

re: How To Differentiate Advanced Data Visualisation Solutions

Some of the more advanced functionality could be dynamic changing of 3D to 2D. This allows managers to see the good-looking charts, and at the same time allows conversion to 2D for better data visualization. See examples at (right click and select an option):- http://www.fusioncharts.com/gallery/Chart.asp?mscombi3d_1- http://www.fusioncharts.com/gallery/Chart.asp?pie3d_1More in interactive features could be:- Ability to copy data from chart (context menu)- Interact with chart's data using client-side scriptStill many commoditized data visualization tools do not provide personalization options like adding your company logo, and your company name in context menu.There are hundreds of other such advanced features that make a data visualization component complete.

re: How To Differentiate Advanced Data Visualisation Solutions

Steven Few offers constructive (although a bit misguided) criticism http://www.perceptualedge.com/blog/?p=637. Have fun reaing our heated exchange, but mostly, he offers solid, deep insights into data visualization functionality.