Archive for the ‘Visualization’
Overcoming the treachery of analytics
Written by Jeff Larche on September 3, 2010 – 12:43 am -What do these three quotes have in common?
- “Worship no false idols” — The First Commandment in the Old Testament
- “If you meet the Buddha on the road, kill him” — Zen adage
- “Become a ruthless killing machine when it comes to metrics/data” — Avinash Kaushik in a recent blog post.
If you guessed that they all warn (with increasing violence!) against mistaking the symbol of something for the real thing, congratulations! You won a pipe. Surrealist painter René Magritte painted this particular pipe as a way to get us thinking about the paradox of symbols. Under it he painted a caption, “This is not a pipe.”
To drive his point home, Magritte named the painting, The Treachery of Images.
So how can we know when it’s time to wage war against our own treacherous web analytics? And once the body count has been tallied, what takes their place? What do we use to answer key questions and spur appropriate actions?
Results Simply Summarized
The answer: Show your audience only what they really want to know — not mere numbers and measurements, but the other RSS: results simply summarized. Here’s Avinash’s post for the full story.
And here it is in a nutshell:
He describes a favorite application he downloaded for his Nexus One phone. It’s a cardio trainer. The app starts out just like another popular body monitoring system. I’m thinking of the Nike Plus application for the iPhone. Both give the standard run-down of miles run and progress achieved, compared with past sessions.
The cardio trainer app then makes an elegant attempt at RSS. Avinash, for one, feels that it succeeds. I agree. It refocuses attention past the numbers to the actual workout goal.
At the end of each run, to reflect his level of exertion, Avinash is presented with an award of sorts. The screen shows two pieces of fruit — two pairs. They represent the number of calories burned. The pairs are his to enjoy guilt-free. (Or he can imagine a calorie-laden equivalent, in a mental swap of one food for another. Perhaps the next version of the app will allow users to actually do this; To replace the outline of two pears with a rendering of a candy bar, or a couple of bottles of beer!)
You might think these simple pictures are the same as Magritte’s pipe — mere symbols; not the real thing. You’d be overlooking a major distinction.
All Magritte was doing was showing something. Avinash’s workout app was presenting it — awarding it. It was the summarization of the data behind it, proving to Avinash that this was his hard-won snack. It says, “Here you go. You earned it.”
Connecting On Two Levels
The representation of the pears became something he connects with — both rationally and emotionally. Unlike Magritte’s pipe, the pears are supported by evidence. Consequently they become so real he can taste them!
Sadly, if most analytics pros were asked to cut out their own distracting and unpersuasive metrics, they’d discover that little remains. Most metrics talk and talk but never get to the point.
This is precisely what senior management does not want. They want quick and truthful take-aways. Will they be dining one delicious pear this month, or two? Or will there be none at all?
Of course business leaders would pears in their analytics absurd. So what do they care about? They want to see money of course. Or at least, clear proxies for money. Showing people is always good. Consider using generic-looking silhouettes of them, shown judiciously and with data supporting their numbers.
Be bold, and show senior management that their site this month generated more sales leads — as represented by silhouettes of cookie-cutter executives, presumably eager to know more about the product. Count them. Are there more shown this month or last? Line them up for comparison.
Or show how the website is lowering operational costs, by successfully answering more consumer questions without calls to your pricey phone center. In this case, the graphic could be a string of telephone headset icons. Compared to last month, are there fewer of them shown, or more?
Go on your own metrics killing spree, but first, know what you’re pursuing. Kill any metric that produces more smoke than light. Allow the remaining metrics to build upon each other, and add richness to your story. Then, as a satisfying grace note, find the single graphic that best sums up the current situation. Use symbolic language that is meaningful to your audience, to transcend facts and figures.
Do this, and far from being Magritte’s pipe, this graphic will be your own “Avinash’s pears.”
Tags: Avinash Kaushik, Occam's Razor, Rene Magritte, This is not a pipe
Posted in Visualization, Web Analytics, Web Marketing | No Comments »
MindJet adds Gantt charting to its mind mapping software
Written by Jeff Larche on August 11, 2010 – 8:20 pm -I’ve been an advocate of mind mapping for years, and have recently talked about my preference for using MindJet.com’s mind mapping product, MindManager. I even demonstrated its power, while leading a discussion about rich digital media, at an UnGeeked Conference in May. I find the system a huge time-saver. Now MindJet has upgraded their software to include a valuable way to share project roles, deadlines and milestones: Gantt charting.
Since the 1990s I’ve appreciated the ability of Gantt charts to bring teams to agreement on project roles and deadlines. It’s an equally valuable way to show clients how any delay in supplying crucial content or sign-offs can push web launch dates out. Below is an example:

The detail is intentionally too small to make out, because I’ve used live client details. From left to right, this chart shows the task name, and start date, end date, and duration in days. After that is the chart itself. Milestones are the green bars. Every task within that milestone must be completed before the milestone is reached and the next milestone and task set begins.
My web development team would “own” some of the tasks, and the client would own others. At a glance, everyone knew what they needed to do and when. They also knew the effects on the project as a whole if they missed their deadline. Great stuff.
Now, the just-released MindManager 9 includes this feature. Below shows a simple Gantt chart, from MindJet’s introductory video:
Needless to say I’m eager to give the Gantt charting a test spin. What’s especially exciting is it takes the collaborative strengths of building a mind map as a team and fairly quickly converts that shared map into a full-blown project plan.
Tags: Gantt charts, mindjet, mindjet.com, mindmanager, Visio
Posted in Productivity, Visualization, Web Marketing | 2 Comments »
Dashboard liberation: Excellent Analytics moves Google application to Excel
Written by Jeff Larche on July 8, 2010 – 7:13 am -Although it’s easy to bash Microsoft, over the years a handful to tricks have made me an avid fan of Excel. Pivot tables and relational look-ups (all hail VLOOKUP!) are two arrows in my web analytics quiver. I’ve just added another. If you work in Google Analytics a lot, you should too.
Excellent Analytics is a free Excel add-in that truly lives up to its name. It allows you to run queries to Google Analytics’ API right from Excel, and publish its results there.
Say goodbye to many of the “Save to Excel” hassles that used to come with wishing to share and chart GA results beyond it’s powerful-yet-limited dashboard.
Go to Excellent Analytics now and give it a try. You’ll need Windows Vista or greater, Microsoft Office 7, and Windows .NET Framework 4. Give yourself a couple of hours to install and learn the system. Then start publishing, charting and sharing. You’ll fall in love the way I did!
Tags: analytics, Excel, google analytics
Posted in Productivity, Visualization, Web Marketing | No Comments »
World Cup win was also a triumph for Edward Tufte
Written by Jeff Larche on June 23, 2010 – 11:31 am -The U.S. just won a pivotal game in the World Cup, and it was a squeaker. I “watched” it while working, using an amazing new data visualization app on the New York Times website. One tab in particular reminded me of the teachings of data visualization guru Edward Tufte. It showed an easy-to-read display of key game statistics, updated every 15 seconds:
The right column had a pull-down that allows users to see vital statistics about each player. The number of touches in the game, by player, is shown above. Others include fouls, cards, and of course goals (a list of exactly zero players at this point in the game!)
No, I’m not such a data wonk that I could feel like I’ve experienced the action by watching this view. But the other tabs at least gave me a hint at the action I was missing away from the television screen. Check these out, keeping in mind that you can see the latest action, and review the action that took place earlier, in a type of choppy animation, using the timeline player at the bottom of the app:
And here’s another:
Notice, at the very bottom of the graphic, the audio toggle. I chose to keep the app in the background, with the audio turned on. Throughout the game, the app was silent (thank goodness it didn’t pipe the vuvuzela noise through my computer speakers!) That is, the app was silent until that U.S. goal in added time. That’s when I heard a three-second burst of cheers. It was a cue for me to check the app and receive the thrilling news.
Edward Tufte believes the future vitality of business — and perhaps even of our species — hinges on how well we can communicate complex information quickly and intuitively. The Times has adopted many of his favorite techniques, particularly in the Finance and Sports sections. For example, those little sparklines you can find there were first made popular by Tufte.
This latest real time tracking of the complex game of world football (a.k.a. soccer) is a demonstration of how far we’ve come with data visualization, and an exciting taste of the future. Gooooaaaaallllll!
Tags: edward tufte, football, soccer
Posted in Visualization | No Comments »
Voice: The original rich media
Written by Jeff Larche on May 14, 2010 – 1:47 pm -I had a fun time talking to the group this morning at UnGeeked Elite. I spoke about the power of voice asset management. If you’d like to know more, here’s a post recently on our VoiceScreener blog, by our CEO, Kelly Fitzsimmons, describing Voice as an Asset (VaaA).
I promised to post a mind map of the post-presentation discussion. Here it is (click to expand):
Also, if you want to check out that TEC video, here’s my original post about it, Jeff Han’s demonstration of multi-touch screens. I was wrong in that it’s more slanted than vertical, as I had said in the presentation. I had seen another video of him demonstrating the screen somewhere else, and that one was more vertical, and shot more at a distance.
Finally, Jonathan Brewer, (@houseofbrew) of FirstEdge Solutions had dared me to show him that super-comfortable office chair I work on. Here’s the photo I just posted of it on TweetPhoto (click to expand):
Tags: HarQen, jeff han, ungeeked elite, VaaA, VAM, Voice as an Asset, Voice Asset Management
Posted in Milwaukee, Productivity, Social Networks, Visualization | 1 Comment »
Tuesday’s Milwaukee Pecha Kucha Night will blow you away
Written by Jeff Larche on February 19, 2010 – 9:51 am -Twenty slides, twenty seconds, 120 minutes of anarchy.
That’s the promise behind the upcoming Pecha Kucha event, to be held at the Sugar Maple, on the corner of Lincoln and Kinnickinnic in Milwaukee. Judging from the names I recognized among the list of presenters, this PK Night should be the best yet.
No Cover
Yep. It’s free to get in this time. And because it’s held at the Sugar Maple, there will be a huge assortment of microbrew and imported beers.
Pow? Free? Wow
That’s right. The first 20 people through the door receives a copy of Andy Nulman’s Pow!
As Always, Diverse Topics
Watch presentations that last no longer than seven minutes, on the following:
- Green Homes
- Coffee’s Global Impact
- “I Don’t Dance, Don’t Ask Me”
- Brewing Beer
- “Novembeards”
- The Three Brains of Humans
… And much, much more!
Presenters include James Carlson, Jim Chambers, Fred Gillich, Steve Hawthorne, Ryan Matteson, David Ravel, Winston Smith, Mike Brenner, Betty Blexrud-Strigens, and Jim Warchol.
It all starts at 8 PM this Tuesday, February 23, 2010. I’ll be there. Will you?
Pecha Kucha Milwaukee
at The Sugar Maple
441 E. Lincoln Ave.
Milwaukee, WI
As always, check in at the official Pecha Kucha Milwaukee site for updates!
Related posts:
Tags: Peach Kucha Milwaukee, PKM
Posted in Milwaukee, Visualization | No Comments »
“A good sketch is better than a long speech”
Written by Jeff Larche on December 14, 2009 – 8:26 am -According to this Harvard Business blog, posted by John Sviokla, the headline is a quote often attributed to Napoleon Bonaparte. Below is a sample of a “sketch” that illustrates his premise that there are three strong reasons to pay attention to data visualization when tackling business problems.

Skiovla writes that the graphic above "shows a big section of Iowa and a little of the surrounding states, depicting potential demand in the market by darker colors. We gathered this information from external sources and matched it down to localities by state. This 'layer' depicts the market potential. The next layer adds the performance of the agencies, shown with different-colored markers."
I came across this through Holy Kaw! from Alltop. Sviokla’s three reasons to provide data visualization are actually questions to ask yourself when you face a problem, or process improvement challenge:
- Is there a simple map or maps of information that could make my life easier?
- Do we have the ability to take the myriad data and synthesize it into these new forms?
- How much time does the organization waste arguing about the facts instead of deepening understanding or crafting solutions?
The take-away: It doesn’t always work, but there are times where you can best solve a problem — and win consensus for that solution — by giving the data over to your graphing software. (My personal favorite way to show data online is Google’s free charts API).
Tags: Harvard Businss blog, john sviokla
Posted in Visualization | No Comments »
Pecha Kucha Milwaukee wants YOU to make it brief!
Written by Jeff Larche on November 13, 2009 – 10:36 am -The Milwaukee chapter of the internationally-acclaimed Pecha Kucha Night has been on a bit of a haitus. That will all change, come February. Organizer Jon Mueller of 800 CEO Read posted on the central PKN site that he and his team are already looking for speakers:
If you’ve attended an event, you can’t deny that you haven’t thought about what you could present, right? Now’s the time.
We’re planning the next event for February 2010, and want to have you involved. We’re going to make this one the biggest and best yet. So, email me your idea, some sample images you’d use in your presentation, and a brief bio, and I’ll get back to you asap with more info: jon [at sign] 800ceoread [dot] com.
Looking forward to hearing from you, and of course to the next PKN!
Thanks,
Jon | PKN MKE
I’ll back Jon up on this. The 20-slide / 20-seconds-per-slide format is a blast to watch, and it’s even more fun to present. Check out links below, and contact Jon. You won’t regret it.
Related posts:
Tags: 800ceoread, Jon Mueller, pecha kucha night, PKN MKE
Posted in Milwaukee, Visualization | 2 Comments »
Time is the only solution to privacy objections to behavioral targeting
Written by Jeff Larche on October 21, 2009 – 8:50 am -Everyone involved in technology and marketing has had this conversation: They’re in a social setting, and the subject comes up about how technology is crafting messages to match consumer behavior. Someone pipes in, “Oh, like in Minority Report? That’s so wrong!” Although Gmail’s ads are customized based on the content of email messages, I’ve noticed that few object to that practice. Instead, they’ll complain about the ads appearing in Facebook — ads that clearly are using information users have given the network about themselves.
It’s a Catch 22 for online marketers. In order to boost response rates, we need to know more about the people viewing our ads. This work of behavioral targeting sounds like a win/win: “We’ll only provide you with the ads that you will likely care about.” But in practice, consumers get spooked.I’m reminded of direct response research done years ago. It was a survey to find out how people like to be hit up for contributions to non-profit causes.
Here’s how consumers responded:
- Least favorite: Personal asks
- 2nd Least: Telemarketing calls
- 3rd Least: Direct mail
What researchers at the time found telling was the direct correlation that existed between disliking a method of asking for donations and its effectiveness in getting them. In other words, personal asks — your sister-in-law selling Girl Scout cookies for her daughter — are most effective in terms of closing rates. The closing rates of telemarketing (back when this was a more viable medium for fund raising) were nearly as good. And a distant third in terms of effectiveness was direct mail.
So what’s really going on here? The accepted theory is this: We all have limited money to contribute to causes, and we would prefer to put off making decisions about where that money should go. Therefore, the most effective ways of forcing a decision are the least preferred.
Similarly, we love DVRs, because they allow us to zoom past commercials. They give us a way to avoid participating in commerce. They can’t touch us because we’re averting our eyes.
Behavioral targeting, if done properly, presents ads that also touch us. Thus, we look for reasons to hate the practice. Privacy is as good a reason as any and better than most!
So what’s the solution?
I do think that attitudes are slowly changing, and this change will eliminate privacy concerns as a reason to hate behavioral targeting.
Here’s an example. Consumers using social media are getting more comfortable with the various personas that they present on networks. They’ll show their “all-business” persona on LinkedIn, and their more casual facade on Facebook. Both are true depictions of the user, but they’re single facets of a full personality. Context determines how consumers behave on these sites. They are becoming accustomed to being watched by friends and business associates.
Reading Online Body Language
These same consumers are seeing how they can watch their friends right back. They are learning to “read” a friend’s feelings and preferences, based on online behavior. Consumers are getting accustomed to the online equivalent of body language. Or maybe that’s too strong a word. We’re all quite conscious of what we’re conveying, and body language implies unconscious action. Maybe what we’re doing on social media is more akin to a Kabuki dance.
Reading these dances is what marketers behind behavioral targeting are learning at a mass level, and turning into surprisingly accurate algorithms. But when it’s done by machines, in the service of a sale, many consumers still insist it’s “so wrong.”
Perhaps not forever.
To predict how people will react in the future — especially in areas such as privacy — I try to look at real world analogies. It’s not hard to imagine a web site as similar to a retail store. A while ago I wrote about how stores are analyzing shoppers using arrays of cameras. One system, called PRISM, is finding some unexpected insights into shopper preferences and behaviors. Shoppers aren’t getting freaked out. The prime reason: Most are oblivious to the surveillance.
But what if the people behind the cameras sprung up from their chairs and raced into the aisles, to say things like, “I saw you were looking at those lawn rakes. Can we interest you in some yard waste trash bags as well?” There would probably be lost sales, at the very least!
In the online world there are intercepts like this, but they are automated. This automated “intercept” is something people will become more accustomed to over time, as a generation weaned on social media, and used to their online movements being watched, comes into the majority. They will be able to understand that their behavior is being measured by machines as well as their online friends. They’ll realize there is no man behind the online ad “curtain” … just a predictive model.
Blurring The Lens To Reduce The Creep Factor
Another trend that will help the acceptance of behavioral targeting is a move toward more explicit boundaries. For instance, I expect an eventual backlash to camera surveillance such as PRISM. But before this reaction can take hold, the boundaries of store monitoring will likely improve. This improvement in technology will, for once, be toward discreetly blurring the “analytical lens” — instead of making it sharper.
Radio tomographic imaging is a new way to study store traffic. It uses arrays of extremely inexpensive radio transmitters and receivers, placed around buildings, to display people moving within. Below is a demonstration of the technology.
The benefits of this technology over cameras, at least to marketers, is cost — both in equipment and the labor of monitoring. Because people become moving “blobs” of color, it’s easier for computers to analyze traffic patterns and behaviors. Less can sometimes be more. Combine this information with RFID signals and you have a way to track a shopping basket all the way to check-out.
Imagine how this could be used:
Before he leaves that store, a consumer might someday pass an “intelligent end cap.” This smart store display knows — based on radio tomographic imagery, enhanced by RFID data sent to it — when to light up. The end cap would know the consumer has a yard rake, and offers him the trash bags he forgot to add to his list.
This hypothetical consumer will probably be grateful, since he really did need the bags for his yard project. And after all, he was just a blob of color moving through the store.
Ironically, this is the level of detail being used for most online behavioral targeting. This is the “privacy invasion” that is causing such a fuss on Facebook and elsewhere.
Over time, consumers will become more comfortable with behavioral targeting’s perceived betrayal of privacy.
That will leave only one valid objection the technique: They just don’t want to buy more stuff.
Tags: behavioral targeting, minority report, prism, radio tomographic imaging, ZigBee radios
Posted in Database Marketing, Visualization, Web Marketing | No Comments »
Multi-touch table magic, courtesy of MS Surface
Written by Jeff Larche on August 26, 2009 – 7:22 am -Robert Scoble just posted this YouTube video of a demonstration of Microsoft’s Surface multi-touch tabletop monitor. Shot at last week’s Gnomedex, this video serves as a sneak preview of what this technology can do in a social setting.
Last month I posted about the new Bokode barcode. One application I described to friends was its use on trade show floors. The barcodes would be worn on presenter name tags, and reveal much about the wearers to any conference attendee wielding a smart-phone camera (the link to the Bokode post is below).
The MS Surface offers a different solution to the same challenge. It’s one of making the most of a networking opportunity. The tabletop displays the conference’s social graph, which can be manipulated and organized by anyone who steps forward and plops down their name tag.
Making the most of conferences
National conferences demand efficiency from its attendees. The cost in time and money is considerable, so many of us look at them as a competition to beat our personal best: How many relevant contacts can we make? How many friendships and business ties can we deepen? It’s all an effort to be efficient, and not fly home feeling we’ve overspent on a rare chance to make valuable face-to-face contacts.
This strong networking benefit is what’s convinced me that Microsoft is on to something. I suspect the main challenge with their tables will be the over-crowding that takes place around them. Conferences providing this technology will be hard-pressed to have enough tables to go around.
Related links:
Tags: Gnomedex, Microsoft, MS Surface, multi-touch, Robert Scoble
Posted in Interface Design, Social Networks, Visualization | No Comments »
A novel way to make tabular data engaging
Written by Jeff Larche on May 14, 2009 – 10:33 am -Regular readers know I’m a fan of the work of Edward Tufte, who the New York Times once described as The da Vinci of Data. The unifying theme of his many books and papers is finding ways to make complicated data simple and immediately understandable.
This is rarely easy. That’s why there is so much data presented in less than ideal graphical formats. Difficult-to-process-tables are one of the contributors to the Death By Powerpoint syndrome.
Is boring your audience a crime? No. But especially in an era where so much is changing so fast, the need for nearly instant understanding is even more important. There must be understanding of the facts before the right decisions can be made. Obviously, companies whose people make decisions based on what’s really happening have a significant competitive advantage.
Reshaping How Information Is Shown
I was reminded of this when I looked over an old post, Survey of marketing tech types finds ROI strongest for search and internal email tactics. Its source was this table of survey information, from eMarketer:
Consider this the “Before” example, to be compared with the image below.
I found the insights in these survey results interesting and occasionally downright provocative. (You can click on the link above to read the observations that I thought were worth discussing.)
My problem: For me, at least, pulling insights from a table of percentages alone was nothing short of agonizing.
My solution was to convert it into this:
The Same Data Made More Understandable
Below is what I came up with (click for a slightly clearer version). After looking for other types of charting, I realized that the benefits of the table (many different comparisons can be made) could be combined with the benefits of a bubble graph (intuitive comparison of visual “volume”).
I don’t pretend to be a charting innovator, but instead present this as encouragement. If I can improve data using a simple graphics program (I used Visio), so can you.
Tags: charting, edward tufte, emarketer, Visio
Posted in Visualization | 10 Comments »










