Blast From the Past – Multidimensional Data Analysis

About eight years ago, I was analyzing television ratings at a leading network in Venezuela… when I came up with the following graph (see below). Rendering took forever in Excel, but the resulting image was not only beautiful, but highly informative. I basically took the network’s audience share for every 15-minute interval throughout the day, for every day of the year, and produced an area map, where interesting patterns became obvious.

The colors you see indicate the audience share for each point in time… deep reds indicate less than 10-percent share, blues around 40-percent and greens above 70-percent. This market is mostly a two horse race, which is why you see such high percentages. From these graphs it was easy to see patterns (like the orange swath down the right side of the image, or the blue-green lagoons at the top left and the blue river down the right edge) indicating areas where the network’s programming was strong or weak.

With more computing power, I’d have taken this one step further, adding a third dimension to the graph to indicate the difference in audience share with our main competitor. That would have made a cool landscape… Soon we could even have the Himalayas indicating dominance across a time slot, the cold ocean depths (and, why not, a little model of the Titanic) indicating hopeless programming. In between, maybe some palm trees and a Corona.

Data visualization is a powerful tool, and when done correctly it can bring new insights into otherwise stale data sets.

Yearratings Small

Here’s a detailed view of the graph, showing the chart for ABC (income-level demographics), from 4:30 p.m. to midnight, from April 9, 1998 until April 30th of that same year. On the right is the legend, explaining the different colors.

Yearratings-Detail

I found these on an old backup DVD along with the original Excel files and thought it’d be nice to share them. Let me know if you like them. My brain seems to be wired for pattern-recognition, so I tend to enjoy and appreciate these graphs a great deal.

If you like multi-dimensional graphics, I highly recommend the work of Edward Tufte. Check out his website and browse through any of his books next time you visit your local bookstore.

Technorati Tags: , , , , , , , , ,

  • You should sell those as art! Buenísimo.

  • researcher

    Hi,

    I would like to contact you about the TV marketshare visualizations and data,
    but I can’t find your email.

    Please respond to my email –
    researcher (Stanford University)

  • You should sell those as art! Buenísimo.

  • Researcher, I sent you an email to the address you left in the comment.

    Meanwhile, I’ll set up a way for readers to contact me directly if needed. Thanks for pointing that out.

  • researcher

    Hi,

    I would like to contact you about the TV marketshare visualizations and data,
    but I can’t find your email.

    Please respond to my email –
    researcher (Stanford University)

  • Researcher, I sent you an email to the address you left in the comment.

    Meanwhile, I’ll set up a way for readers to contact me directly if needed. Thanks for pointing that out.

  • This one makes sence “One’s first step in wisdom is to kuesstion everything – and one’s last is to come to terms with everything.”

  • This one makes sence “One’s first step in wisdom is to kuesstion everything – and one’s last is to come to terms with everything.”

  • Network Marketing Tip: A 30-Second Tool…

    When someone asks you what you do for a living, what do you say? Do you stumble as you try to find the right words? A 30-second commercial is the ideal response when used correctly and can be a wonderful tool for network marketers….

  • Pingback: Network Traffic Visualization Tool()