Dashboards, Infographics, and Visualizations - Best Practices

  |  May 2, 2012   |  Comments

When using tools to visualize CRM, sales, website, and other data, are you more like Leonardo da Vinci or Leonardo the Turtle?

Dashboards, infographics, and visualizations have been on my mind a lot this year. I've always loved turning data into pretty colors and patterns, which is great as the number of dashboard projects for consultants like me has gone through the roof in the past couple of years.

The projects I've worked on, even just in 2012, have been at times affirming as an analyst, have driven some key business relationships, but sometimes have been very frustrating. I've been made to feel like Leonardo da Vinci when in one project I simply merged two data sets with a customer ID, drew a two axis line chart, and saw the client nearly fall off their chair in amazement. But I've also been involved in projects that made me feel like Leonardo the Turtle, wading through a sewer of data and misunderstood objectives.

It's made me think a lot this year about the responsibilities and checklists from both a client and agency perspective. To get the best out of your dashboard project, whether it has two data sources or 202, here are a few key learnings and things to think about for both sides.

For agencies or those internals teams tasked with building the tool:

  1. Be a Doubting Thomas and don't scope out your project until you physically see the data. Clients love to say to you, "Here's my data, I just want you to pop that in a beautifully visualized set of charts." But under the bonnet of any tool, web analytics, sales, or customer relationship management (CRM) could be a whole mess of data that will take weeks to get to a point where you can easily visualize. This is particularly true of multi-data source dashboards, say ad serving and web analytics data. If you don't have a long-term relationship with your client and they want you to scope without seeing the data then walk away now.
  2. Deliver a data audit. This should include profiling the data you receive so that you can understand underlying data distributions and also a quality assurance review of calculated metrics. Too often clients believe their data house is in order and when resulting visualizations don't look the way they want, the person building the dashboard gets blamed.
  3. Visualization is less important than data structure. Did I really just say that? Stop scratching your head deciding if you agree with Stephen Few about pie charts and start thinking about the database or data tables you are storing your data in. Does it need to be based on a data cube? Are you likely to have to build a gazillion summary tables? Will your dashboard have to read new data sources in the future and is your data layer flexible enough to do that quickly?

Learnings for clients or the teams, like marketing, who are going to be using the tool:

  1. Beware the funky white elephant. "Sex sells" and you want a bit of wow factor to impress your boss. But your company is already littered with reporting packages. Ensure that the visualization tool that you use can be shared across a number of users and that internal security settings won't mess up everyone being able to view the pretty Flash charts. To be frank, if you are impressed by a moving chart, then you shouldn't be the person deciding what software to use.
  2. The value of the data layer is probably 10 times the value of the dashboard. If you are merging multiple data sets and building a multi-channel dashboard, you are very likely to be pooling data that has previously been sat in disparate data silos. If this is the case, the data layer you get built for you, say a SQL database or even a set of Excel workbooks, is going to contain data over and above that which is summarized in your visual layer. You must get ready to mine this data like you would have mined each data source separately. Do you have the people in place to do that?
  3. Cost of ownership is likely to be way more than cost of development. If you haven't thought yet about who is going to own, run, and analyze your dashboard then stop now.

I haven't even begun to talk about which is the right visualization tool or what metrics are the right ones to include. From a structural perspective, data is a messy plate of spaghetti. But if you are prepared to audit properly, spend time developing the right metrics, and ensure there is an after-life for your dashboards then the visual impact will be dwarfed by the business impact from all your hard work.

ClickZ Live Toronto Twitter Canada MD Kirstine Stewart to Keynote Toronto
ClickZ Live Toronto (May 14-16) is a new event addressing the rapidly changing landscape that digital marketers face. The agenda focuses on customer engagement and attaining maximum ROI through online marketing efforts across paid, owned & earned media. Register now and save!

ABOUT THE AUTHOR

John D'Arcy

John D'Arcy is the Head of Numbers at Seren, a Foviance Group company. Seren is a U.K.-based consultancy that utilizes data analytics and user experience to help improve customer experience. John has helped clients measure and optimize their marketing communications for over 15 years across digital and traditional media. He's been able to utilize the modeling and statistical skills he learned in the offline world to bring a more rigorous approach to the digital analytics industry. John's team at Seren are certified professionals for a number of technologies including Google Analytics, Adobe-Omniture, and Webtrends.

COMMENTSCommenting policy

comments powered by Disqus

Get the ClickZ Analytics newsletter delivered to you. Subscribe today!

COMMENTS

UPCOMING EVENTS

Featured White Papers

ion Interactive Marketing Apps for Landing Pages White Paper

Marketing Apps for Landing Pages White Paper
Marketing apps can elevate a formulaic landing page into a highly interactive user experience. Learn how to turn your static content into exciting marketing apps.

eMarketer: Redefining Mobile-Only Users: Millions Selectively Avoid the Desktop

Redefining 'Mobile-Only' Users: Millions Selectively Avoid the Desktop
A new breed of selective mobile-only consumers has emerged. What are the demos of these users and how and where can marketers reach them?

Jobs

    • Contact Center Professional
      Contact Center Professional (TCC: The Contact Center) - Hunt ValleyLooking to join a workforce that prides themselves on being routine and keeping...
    • Recruitment and Team Building Ambassador
      Recruitment and Team Building Ambassador (Agora Inc.) - BaltimoreAgora, www.agora-inc.com, continues to expand! In order to meet the needs of our...
    • Design and Publishing Specialist
      Design and Publishing Specialist (Bonner and Partners) - BaltimoreIf you’re a hungry self-starter, creative, organized and have an extreme...