Welcome | View My Profile | Sign Out
MediaPost Home About MediaPost Privacy/Terms Media Kit Sitemap
Publications Home News
Online Media Daily Media Daily News Marketing Daily Mobile Marketing Daily Search Marketing Daily
Daily Feed> Email Daily Feed> Video Daily Feed> Social
Online Blogs
Online Spin Email Insider Search Insider Behavioral Insider Online Publishing Insider Mobile Insider Video Insider Gaming Insider Performance Insider Metrics Insider Social Media Insider Just An Online Minute Daily Online Examiner Raw Blog
Media Blogs
Research Brief Diane Mermigas:On Media TV Watch TV Board Magazine Rack Media Creativity Notes From the Digital Frontier Digital Outsider Mad Blog Red White and Blog
Marketing Blogs
Engage:Hispanics Engage:Kids 6-11 Engage:Moms Engage:Boomers Engage:Gen Y Engage:Teens Marketing:Green Marketing:Sports
Magazines
OMMA Magazine Media Magazine
Subscribe
Feedback Loop RSS Feeds Archives Subscribe
Feb 24 OMMA Metrics Measurement (NYC) Feb 25 OMMA Behavioral (NYC) Mar 17 OMMA Global (San Francisco) Apr 14 Search Insider Summit (FL) Apr 18 Email Insider Summit (FL) Apr 27 Outfront Conference (NYC) May 12 OMMA Mobile (NYC) May 13 Digital Out-of-Home Awards (NYC) Jun 15 OMMA Video Jun 16 OMMA Publish (NYC) Jun 17 OMMA Social (NYC)
Recently Concluded Events
Jan 26 OMMA Social (San Francisco) Jan 25 OMMA Performance (SF) Jan 12 MEDIA Agency of the Year 2009 (NYC) Jan 11 OMMA Agency of the Year 2009 (NYC) Dec 6 Email Insider Summit (Utah) Dec 2 Search Insider Summit (Utah) Nov 3 OMMA Adnets (NYC) Oct 30 OMMA Video (LA) Oct 29 OMMA Mobile (LA) Oct 29 OMMA Mobile & Video (LA)
All MediaPost/OMMA Events Event Blogging Past Event Videos
Industry Events Calendar
2010 Digital Out-of-Home Awards
2010 MEDIA Agency of the Year 2009 2010 OMMA Agency of the Year 2009 2009 Creative Media Awards 2009 OMMA Awards 2009 Digital Out-of-Home Awards 2009 Media Agency of the Year
All Awards
Employment Situations Wanted Services Offered Post a Job
Briefs Reports Online
MediaPost Directories
Mobile Insiders Group
People Finder Edit My Profile View My Profile My Contacts My Calendar
HOME • MANAGE SUBSCRIPTIONS • MEDIA KIT
Visualizing Data
by Jodi McDermott, Friday, September 4, 2009, 12:45 PM

SHARE

TOOLS

RELATED ARTICLES
TAGS:  Metrics

MOST READ

When an engineering colleague of mine (95% of my immediate surroundings) emailed me a link this past week, I thought for sure it was for a YouTube video.  This link was different though, in that it introduced me to Anscombe's quartet, a set of four datasets that share the exact same statistical properties.  Each one of these datasets has the same mean, variance and mean of each y variable, variance and mean of each x variable and the exact same correlation between the x and y variables.   A little geeky, eh?

What's my point, you might ask?  When each one of these datasets is plotted out visually, they have completely different appearances (just click on the link above and you'll see what I mean).  There are outliers where one would not expect to see them -- identifying both opportunities and risks in your data depending on what you are analyzing.  However, one would never see the variance in data patterns if it was not plotted in a chart or graph (or analyzed data point by data point).

Looking at your data is just as important as reading your data.  Not all of us can see the obvious by just looking at numbers, even if we don't consider ourselves "visual" people.  I've learned this quite extensively in my current job when presenting data findings to a combination of both finance and product teams.  Some people are "table" folks and others are "chart" folks.  Regardless, the combination of the two data presentation methods jogs the brain and forces you to see the data in new ways and patterns. Here are three reasons why you need to visualize your data:

1.     Visualizing data allows you to segment elements within your results set.  For example, when analyzing campaign data, the average click-through rate or cost per acquisition might meet your campaign goals.  However, deeper segmentation via visualization can help you determine where further optimization opportunities lie via eliminating waste and exploiting upside outliers.

2.     Ability to see relationships and correlations within the data.  Scatterplots and grids can help sift out opportunities where you might have huge upside if you can optimize your key trigger points (whether it is behavior metrics like CTR or margin management).

3.     Trend analysis over time is more obvious when it is visualized. Trends in data can shift dramatically or slowly over time. Visualizing trends can allow you to see the slope of a metric or group of metrics to identify seasonal and market trends that may not pop out at you when you are just staring at a table of numbers.

Segmentation, correlation and trending are just three of the reasons for data visualizations -- but there are so many more.  As analysts, we sometimes do not see the forest through the trees.  Visualizing data forces you to stop and look at the results and ponder the bigger picture.  In this case, perhaps, a picture is worth a thousand data points.

54 people recommend this article. 

7 comments on "Visualizing Data "

  1. Paul Van Winkle from ai
    commented on: September 05, 2009 at 3:18 PM
    The Tufte books and lectures are finally and massively relevant. I guess like many leaps, it takes crisis and crashes to heighten wider awareness of what's painfully obvious to a few focused individuals.

    www.edwardtufte.com

    Anyone who hasn't signed up for the travelling show should do so soon, before Tufte stops doing them. His three great books come with.

  2. John Grono from GAP Research
    commented on: September 04, 2009 at 7:34 PM
    It reminds of the tale of the statistician who couldn't swim who was found drowned in a lake.

    He'd calculated that as he was 6 feet tall and the average depth of the lake was only 5 feet he'd be fine ... even in the middle where his body was found at the bottom of twenty feet of water.

  3. John Dietz from Adometry
    commented on: September 04, 2009 at 3:07 PM
    As you say, charts and graphs are a great way to visualize trends or anomalies that would be hard to pick out of reading through a table, but in my experience it works best limited variables. I've seen too many graphs where too many variables are represented, then you end up trying to decipher lines and colors and shapes all at the same time.

    We spend a lot of time trying to figure out which data sets to show graphically and how to identify trends beyond basic variance analysis, and your example is a perfect example where you should graph it out.

  4. Maurice Boissiere from Clearspring Technologies
    commented on: September 04, 2009 at 1:48 PM
    Great reminder that data serves decision making and not to rely on any one metric or method of processing information when collaborating.

  5. Erin Scruggs from TM Advertising
    commented on: September 04, 2009 at 1:24 PM
    This is a great article. It reminded me of something that I had found about a week ago online regarding visualizing data in order to gain more insights from your data. Check out my post here: http://j.mp/KrgiZ if you're interested in reading more!

  6. John Jainschigg from World2Worlds, Inc.
    commented on: September 04, 2009 at 1:21 PM
    Awesome post! And what a wonderful tool to use for beating up people in meetings. "Clarifying mathematical verities by simple, readily-understood example? Valuable. Doing so while humiliating some MBA who wasn't listening in stat class and now thinks basic knowledge of Excel makes him/her an analyst of consequence to the organization? Priceless."

  7. Eric Melchor from Smart Digital Spending
    commented on: September 04, 2009 at 1:01 PM
    Hi Jodi,

    Interesting post! As an analyst, I always found more meaning in visual charts and graphs.

    Eric www.OnlineMediaAnalyst.com

Leave a Comment

You must be signed in to comment. Sign In

Do you have strong opinions and inside knowledge about the topic of this article -- and do you want to share your insights, observations and points of view regularly with the readers of MediaPost? To be considered as a MediaPost contributing writer, please send pertinent info about your credentials, plus several column ideas and one example of your writing on the topic, to pfine@mediapost.com. Please see our editorial guidelines here first.

JODI MCDERMOTT


AUTHORS

ARCHIVES

Recent Metrics Insider Articles
How To Avoid A 'Holey War' Of Spending   
My friend and business partner, Dave Reibstein of Wharton School, writes an advice column called Ask...
Audience Insights, Not Audience Measurement    
I find myself quoting Randall Rothenberg, Chairman of the IAB, more and more these days. Earlier...
The Cost Of NOT Branding   
It's a simple formula: Recession requires more tactical spending. This year's budget = + online spend...
Online Metrics: Trends For 2010   
When I look back at my 2009 predictions, I feel pretty good about my hit rate....
The Marketing Kwan   
"Love, respect, community and money" tied into one word. That is what Rod Tidwell was describing...
Forecast For 2010: Better Forecasting   
Yogi Berra said, "It's tough to make predictions, especially about the future." Yet the turn of...
Measuring What Matters Most   
There are so many things to measure, more and more marketers are getting wrapped around the...
Setting Realistic Expectations For Targeted Campaign Delivery   
We have a tendency on the Internet to believe that -- because we are, after all,...
The Future Of The Marketing Dashboard   
If conversations with clients are a good indication of the future, then 2010 will be the...
Making The 'Best' Business Case For Marketing Investments   
More than ever before, the approval of any significant marketing initiative is dependent upon a compelling...
>> Metrics Insider Archives 
ABOUT MEDIAPOST • MASTHEAD • MEDIA KIT • RSS FEEDS • PRIVACY/TERMS & CONDITIONS
©2010 MediaPost Communications. All rights reserved.
1140 Broadway, 4th Floor, New York, NY 10001
tel. 212-204-2000, fax 212-204-2038, feedback@mediapost.com