top of page
Writer's pictureFahad H

It's Not The Ink, It's The Think: 6 Effective Data Visualization Strategies


Ten years, and the 944,357 words, are proof that I love purposeful data, collecting it, pouring smart strategies into analyzing it, and using the insights identified to transform organizations.

In the quest for that last important bit, I am insanely obsessive about 1. simplification and 2. pressing the right emotional buttons.

The reasons are that we all like complexity, it gives us energy :), we tend to be logical, and we often treat data output as the end when in reality the data output is just the start of the process that results in actions that deliver business impact.

Very often the output of our work with Big Data or Small Data, Google Analytics or R, will end up in a few cells of a spreadsheet or a table in Word/Keynote/PowerPoint. The stakes for this output are higher when we are in front of the Senior Leadership of any company, we have but a few minutes to communicate what we have to. Hence my two obsessions above.

In this post, with lots of pictures and real-world data examples, I want to share 6 different strategies you can leverage in service of simplification and pressing the right emotional buttons. Along our journey, I've also sprinkled in 15 universal truths that will bring you joy.

Here are the sections in this post:

I've written a couple other posts in this same spirit, with 17 additional tips. I'll link to those posts and an article in Forbes in the last section.

You'll also find two examples below where I want you to play along. I'll share the before version, and I want you to challenge yourself, create a better after version, and share it with me. I'll add a couple of the best in each case below with your name (and your permission).

[update] Clearly the readers of Occam's Razor are engaged, I got an avalanche of submissions! Thank you. I've added a selection of eleven below to inspire you. There are so many different, and simpler, way to solve the problem. In each case below, you'll see a section called update, as is the case here, and that's where you'll find the wonderful submissions from our readers along with a after version I'd originally created. [/update]

Before we head any further I should stress that all the examples below are real. Some are from slides I saw at conferences, some from our company, and some from yours. In all cases, I've spent time changing company names or the names of the things on the slide (so if you see Display Ads, that might be TV data). I did not want to call anyone out, we all suck at this and we all need to get better together.

An important assumption.

I'm assuming for the rest of this post that either you are the person responsible for presenting the output of the analytical efforts OR you are working with a person who will present and that they are curious and will commit the time and intellectual horsepower required.

99% of the final data outputs are heartbreakingly bad because the person telling the story did not create the story (thus the intellectual vacuum) and they furthermore did not commit the time required to understand the story enough to make it their own, to be able to tell it with passion/commitment.

The end result in all these cases is that data efforts come to naught. It is a simple yet hard to solve problem. Commit to addressing it, or at least exposing it and crap will not exist.

For the purpose of this post, I'm going to assume it does not exist.

Let's go, and have some sexy data presentation fun!

Death at the last-mile.

This is what I mean by an Analyst's death at the last mile… I'm confident a ton of work went into getting the data, analyzing it, creating this graph and choosing just the right fonts…

an excuse of a data story 2

It is also true that it is completely ineffective and no one will understand anything.

Too many bars, inside them too many slices, odd color choices, all end up with this question: what the heck's going on here?

This whole thing should probably be just three bars (or if you really push me, four). In its current form it will take too long to explain and as a result you are going to lose the audience pretty quickly. And, this is likely 1 of 45 slides you have.

That is what I mean bydeath at the last-mile . A lot of great effort went into this, with no impact.

Or, checkout this beauty…

display volume

It breaks my heart. The Analyst who was presenting this at the conference was really smart. The output above is trying to do too many things, there are too many things on it, and the outcome will be that your audience of 5 or 5000 is on their phone reconsidering their dating pool.

The above should be a table with two rows and three columns. That's it. Obsessively simple, pressing the right emotional buttons.

One more.

Just because this one is from one of the largest business consulting companies in the world, and the title of the study was: Cutting Complexity and Adding Value. #ironic

cutting complexity adding value

There is only one simple message above, and just two metrics that matter. It should have just focused on those two. Everything else is a distraction or a ill-conceived strategy to prove the hourly consulting rate is worth it by pummeling the audience by taking up all available space on the slide.

In each case of death by last mile, how did we end up quickly identifying that only two numbers are important above or that the Cancer one has three columns or first one is best as three bars?

Rules learned from a lifetime of practice. And, an unhealthy obsession with simplicity.

Here are some of them, more at the end of this post.

1. Rebel against crapification via cluttering.

This is such a simple rule, and one that will fix any problem. Just don't clutter. Don't. Just don't.

Negative space is a good thing. Don't feel obligated to use every pixel available.

Know the difference between a handout – to be printed, to be shared after, to be sent off to lots of people who will not read it – and a presentation.

Universal Truth #1: You are the presentation, not the slides.

100% of the most memorable things that will be retained by your audience are going to come out of your mouth and won't be on the thing in the screen. I know. Even with the greatest data in the universe on the screen. You are the presentation. Please keep that in mind as we go and look at how to do the slide part, the table part, the analysis part smarter.

Let's look at this example, the research done is expensive and good. A copious amount of effort was put in by the Research Analysts. The whole thing dies at the last mile…

ashley original

Universal Truth #2: Clipart is for adult earthlings with questionable taste (or young earthlings who don't know any better).

Universal Truth #3: Let things upset you. It is how you make things better.

Setting aside universal truth #2, it irritated me that you can't actually hold your phone like the lady in the clipart. Take out your phone. Try it. Position your fingers exactly like her. Are you feeling weird? Where's your thumb? See? Now, are you irritated like I am? Be irritated. Take that irritation, fix things. It is the path to glory.

Your goal is to present the data, as simply as possible. Let's KonMari!

Universal Truth #4: Don't puke all the data out at one.

Animations are your best friends. Control the pace of the story, let things be reveled as you speak/present, keep the focus on you.

Universal Truth #5: The only acceptable Animation on a slide is Fade.

The first thing we do is declutter the title (if you insist on having a title, I dislike them quite a bit as demonstrated by all the after examples in this post). Here it is…

ashley simpler 1

The simplest way to communicate effectively is to have a structure that people can internalize and follow easily. In this case, with just a couple of minutes of thought we can come up with a simple structure to communicate the findings.

Share the first one, Shops…

ashley simpler 2

Now dwell on it. There is nothing else to read on the slide. Just one insight. Talk about why it is interesting. Talk about what the audience can do with it. Talk about what shifts it represents. So on and so forth.

The process is how you'll establish your personal value. Nothing in the presentation, on the slide, no matter how compelling, will do that. The context you surround the data with, your words, will do that.

I won't stretch the entire process, but you'll present one element of the structure at a time, and this is where your Ashley slide will end up…

ashley simpler 3

Shops, Loves, Watching.

Three relatable elements of a structure, they are sticky, and an insight under each.

Scroll back up. Look at the original.

Would you have gotten this simple and direct message from the clipart and the copious text?

Universal Truth #6: It's not the ink, it's the think.

The slide is not effective because there is less ink, it is effective because of the think that went into simplifying it and into extracting the story you want to tell. An obsession with having less ink is simply a forcing mechanism to cause more think .

Ok, time for you to practice a bit. Don't scroll further, just enough to take a look at this example… You've seen it at a major conference…

shopping stats original

Consider our simple guideline: Declutter.

Get a post-it, sketch your version of it. As you consider the ink, let it force the think as well.

Ready to look at some alternatives?

You might have noticed the redundancy, the circles are trying to say the same thing as the numbers. Don't be redundant, unless it is your signature style thing. :)

If you just remove the numbers, you have something simpler…

shopping simple 1

It is not unusual for me to see tons of redundancy in our data analysis outputs. Focus on eliminating them. Picture a smiling Marie Kondo.

Universal Truth #7: Never force your audience to do the math. That's your job.

This is where the cute circles fail. Your audience has to figure out how much the second and third circles represent exactly.

Get rid of anything that fails universal truth 7. This would be my first step in decluttering…

shopping simple 2

Simpler. More direct.

Reduced clutter also encourages the application of universal truth 5, it forces you to see what's there. I mean really see.

When I look at the above, I realize the Analyst has ordered the story randomly. In the real-world Halloween comes first, then Cyber Monday and then Post-Holiday.

Small thing, but it matters so much to the flow of the story. This will ensure that in a very subtle way you don't jumble the brain of your audience…

shopping simple 3

Better. But, you are not done yet.

There is still too much text.

Universal Truth #8: Anything that is going to come out of your mouth should not be on a slide. (Also see truth #1.)

Applying the combination of what we did in the Ashley example, try and find a structure to communicate the story, and universal truth #8, you end up with this…

shopping simple 4

Started, Finished, Picked. Simple elemental structure to plant in the audience's mind.

Text simplified down to just the important days.

A little orange line to evoke the end of the period when retailers typically stop paying attention, stop doing the cool things and stop paying attention. But, they should not. The orange line subtly forces a closer look at the 44%, and that will prompt them to discuss what they can do to take advantage of this opportunity.

Nice, right? Scroll up a little, look at the original.

I'm sure you have even more ideas of how to make our two examples less cluttered. I would love to see them, hear your ideas. What matters most is less that my after versions are the gospelic best ones, I simply want to illustrate how with just a tiny amount of effort, and your brilliant think, the outcome can be so much better. You just have to care enough.

2. Don't fragment data, don't forget higher order bits.

It is not uncommon that we might end up presenting ten or twelve slides (or 106 if that is what you are into!). One sad outcome of this is that we'll tend to fragment the data, which results in our inability to tell the story as powerfully as it deserves to be told. It also forces a lot less think than might be optimal.

Let's look at this real data for a fictitious company… This is slide one…

reliance original 1

Ok. Interesting trend. Up and down and up.

You ruminate on it, you let all the bars sink in. You are going to some kind of conclusion, and then comes the next slide with some more data…

reliance original 2

It all looks new. You try to analyze it mentally (ignoring the speaker of course, yes they are still talking).

Usually the first instinct is to try and see if there's connective tissue between the two slides. It might take a second because of scale is different on both slides, but you'll ultimately get that the green bars are the same ones as before. They just seem to be different.

Why have the fragmented view?

Every time the ink creates a pause for you, an opportunity will kick in for more brilliant think.

What is the problem we are trying to solve with this data?

The higher order bit is that we want Reliance to be encouraged into action because as the above slides shows they are not competitive with the Market Leader. Sucks.

That in turn provokes these thoughts: Do we really need the trend if that's the higher order bit? Can we frame the problem in a different way, than percents, to create a sense of urgency? What above is really going to seem painful to Reliance?

Good think questions, right?

We are not really framing things cleanly, we are obsessing about something the Analyst loves, trends, and in the end, across two slides, the pain you want to deliver to drive action is completely absent.

Let's try something different, I would animate this to show one element at a time so that I could tell this story: In the last year there were 336 million (!) opportunities to engage with expressed intent, the average for your peer was 24 million…

reliance simpler 1

Nice appetizer. Actual numbers. Making things really real.

Universal Truth #9: Actual numbers make reality real a million times better than percentages.

That set's the stage for one more click: Your performance doing this time period was…

reliance simpler 2

Jaws dropped. People squirm in their seats. Things are getting hot. It does not look good. Sweet, that's what you want.

Everything you see above is framed simply, it is pretty much the same data you saw in the green/gray bars above.

Good so far, but the pain is missing. Let's show the cost by quantifying the impact due to the difference between 7 million and 24 million.

Be a true change agent, add the pain…

reliance simpler 3

Now, you're cooking.

The other three numbers suddenly are a lot less important. the only one the audience can see is $80 mil lost revenue.

And, the conversation shifts from discussing the twelve month trends and the green/gray bars and excuses about advantages of the Market Leader. You have now singularly focused the conversation on the higher order bit: What should we do?

That's the difference between someone who reports data to someone who drives change in behavior. #winning

Yes, the trended data will be important in some executional kind of way. We have it handy, we'll use it. But, to make the most important decision, at a time when as a company Reliance is not doing well, that trend is simply a distraction.

Just to bring this home for you, here's my final version slide with the originals…

reliance summary

It is not just that we reduced the number of slides. It is that the fragmentation of data resulted in more ink less think and zero obsession with what really matters.

I do want to be cautious. I'm not fond of people who say that you should only have 10 slides, or some low number. It does not incentivize right behavior. I'm a firm believer in…

Universal Truth #10: Limit the number of stories you tell, don't limit the number of slides.

But as you go about that process, remember that fragmentation is not your best friend. And, remember to obsess about the higher order bits (what the heck is your end goal with all this data?).

Let's make all this real by looking at one more example.

This one pained me because the data is trying to make the case for solving a very important problem that women are faced with, yet the way data is being presented gets in the way of making a highly important point quickly.

Here's the first fragment

overactive a bladder original 1

It seems interesting on the surface.

Does not quite make the case for why it is an interesting something to ponder.

Here's the second fragment

overactive a bladder original 2

Also interesting in a superficial oh that is so intriguing kind of way.

Yet, even if here you can look at them both together, even with the y-axis being different for the two fragmented views, it is hard get the jolt you need to sit up and take notice. A part of it is also breaking universal truth #7.

Stop scrolling.

Go back up a little.

What would you do differently to make a version that is defragmented and keeps the higher-order bit squarely in the forefront?

Get a post-it. Sketch something.

Ready?

[update] Rishi Shrivastava shared this waffle chart as another lovely way to illustrate the data simply…

rishi shrivastava

It is a different way to bring focus to the conversation as is clearly visible from it's strengths. For my take on the original, continue reading… [/update]

After thinking about what the higher order bit is, to help me focus sharply, and applying the other lessons you've learned thus far, here's my simple version…

overactive a bladder v2 1

Sharp focus.

The biggest delta between the two trends is for women under 40. That's the only thing I care about.

The moment you see those two bars, so starkly illustrate the problem, you are on to what the heck should we do about this?

I felt this still did not "starkify" the opportunity clearly enough.

So I went and got me some real numbers…

overactive a bladder v2 2

Boom! Excitement delivered.

We often break our data story into too many pieces. Partly because we have this hidden worry that our jobs are not that justified. We throw off a lot of data as a subtle way of earning a great job performance review. Sadly the outcome is exactly the opposite.

What you want to do instead is to do all the slicing, dicing, segmentation, beautiful math, and then step above it. Reach for the higher order bit. It will lead to defragmentation of what you are trying to say, and the ensuing simplicity will drive the type of impact that will earn you a promotion faster.

Universal Truth #11: Data is just a means to an end. It can't be the end in of itself.

3. Obsess with deleting information provided.

This rule originates in the above universal truth. Because we are trying to get to the end that will drive the higher order bit outcome faster, one strategy you can embrace with impunity is to simple delete stuff.

Train yourself to find joy in killing things. Clipart of course, you are not a child after all. But all kinds of other stuff too. Enjoy the killing.

Whenever you see a data output, your first instinct should be what can I kill in service of enhancing simplicity and the effectiveness of the story?

Take this example… Don't drink it all in at one time, slow down, let it all sink in…

video research original

What do you see?

Grab that post-it.

How many universal truths does the above slide break? How many rules we've looked at so far are not followed? How many things you personally have in your arsenal of things you hate that are above?

Ready with your rough sketch of what you would do?

My approach was simple. Delete anything that's redundant, and simply visualize what's left for sharper focus. Here's my version…

video research fixed

Honestly. What else is there to say?

Show the distribution, add the ages, use colors to highlight segments you want to bring attention to, add a orange bar so they don't have to do the math, and happy birthday!

You get to this important place so much faster: What the heck am I actually trying to say?

Scroll back up and compare.

Let's make this even more real by looking at a more complex example of a multi-channel marketing recommendation…

bts holiday original

I am sure your instinct is: OMG!

There is a lot going on here. Everything seems sub-optimal. But, what I want you to recognize and appreciate is that there is no way that the person who put this together did not do a ton of work to get to this point. But, it dies at the last mile.

If you assess it carefully, the above recommendation set is trying to do five different jobs. That contributes to the problem. In the end, the audience is not impressed by the intelligence, they either start swiping left or right on their phone or become super confused.

Grab your post-it.

Just based on the information you see above, what would a version you'll simplify look like?

Apply the lessons learned thus far, primary amongst which would be to just delete, delete, delete.

If it helps, ask yourself if I had to focus on this data doing just one job, what would that one job be?

Don't scroll. Do the work, I promise you'll learn more.

Ready?

There are many valid stories to tell above. My decision was that the most impactful one was the recommendation around the media plan for the six month period. Additionally, the higher order bit to solve for was to give that media plan a purpose.

Here's the quick five minute simple result…

bts holiday v2

Nothing gloriously sexy. Just effective.

Shows the key time-periods, start and end dates of each media recommendation, and leverages the See-Think-Do-Care business framework to give each media effort a purpose. The latter is especially important because it directly ties to what content the ads/marketing should contain, what the tone and texture should be of the landing page/app experience, and what we'll use to measure success (S, T, D, C metrics).

Universal Truth #12: Never ever never never end your story with a buffet of purpose-deficient "ideas."

Notice the subtle shift in posture as well.

I dislike ending on a buffet of choices after all the hard work. Here are five ideas, take whatever you want. It is is irresponsible behavior. You did all the work, why not benefit the audience? Hence, you see everything framed into two clusters of intent.

This does not mean everyone will agree with you and lift up your chair and parade you around the tiny cramped conference room. They'll argue with you, they'll debate amongst each other, there might even be a productive food-fight. At least everyone will know what your POV is, and over time your profile will be bigger and more influential.

Ok. Exercise time.

Here's a simple example similar to the before versions we've looked at in this section….

app engagement original

What would a version fixed by you look like?


I bet it would only take a few minutes for you to apply the lessons in this post. I would love to see what you do with it. You are welcome to comment below, or you can email me your version.

In a week, I'll update this post with my simple five minute version and I'll share a couple examples from you (with your name, and permission).


[update] So many exciting ideas from our readers, I was truly inspired.

Jordan Zivoder's version used a very different approach to visualizing the data…

jordan zivoder

Each strand is easy to follow, you can more easily see the outliers.

Roman Mozil's version converted the original into one that uses a very light touch to bring simplicity…

roman mozil 1

Even though the amount of data in Roman's slide is almost as much as the original, it does not look like it. Right? A testament to the power of spending just a couple minutes thinking.

Paul Berney's take on the slide was to pick a key point, and then illustrate it with an image…

paul berney

In my work you've seen I stay away from stock photos. In my experience they are massively abused, and if I have 10 mins to spend on presenting data, I want to spend all 10 mins on my data and answering so what. But, in this case you'll note how Paul fades the image into the background and leaves the focus on what matters.

Jakob Samuelsson and Hugo Galvenius put their thinking caps together and came up with this really simple version…

hugo galvenius jakob samuelsson 1

Hugo and Jakob wonderfully demonstrate the value of picking just one story to tell.

David Solito's version is very stark, focused, and expands the think

David Solito 1

He made some assumptions, and tied the difference in behavior to outcomes. His second slide…

David Solito 2

As you can imagine, this should drive the key points home very effectively and drive action.

Here's my version of the original that I'd shared in the storytelling ideation session I lead (where all these examples came from )…

app engagement fixed

My goal was to narrow down to just the segment that has something interesting to talk about, 18-34, and demonstrate their behavior starkly. Jina Chan also had a version close to the one above!

This slide was followed by a slide where I answered the so what question by sharing ideas of what USCO should do about this trend.

All the examples above prove there are many ways to tell the story simply and I hope you are inspired by the efforts of our wonderful readers. [/update]

Oh, and one more universal truth from the macro thought in this section…

Universal Truth #13: An Analyst is not a dispassionate participant. Invest in knowing the business, develop you personal point of view. Then, Express It. Let the audience benefit from your wisdom.

4. Don't run away, make the tough choices.

I'm sure you are noticing how these rules act like layers on a cake. One on top of another on top of the next one… each adding yummy deliciousness.

[In case you jumped here, just a reminder that was at the start of this post: All the examples are real, from different places, but names of companies and marketing channels have been changed or anonymized.]

Here's our next example… don't scroll too far ahead, grab your post-it again, note down what would you do differently…

aol health original

Some things are obvious. Yes, redundancy can be eliminated. Yes, colors are a bit garish. Yes, text can be optimized. So on and so forth.

I hope your review also exposed that there are two different ways to frame the story. The author above decides not to make a tough choice. I encourage you to make tough choices. It is hard enough to change minds in the first place, harder still when you are sharing lots of data, why make it nearly impossible by being shy.

Since this slide is framing the value of AOL, we could frame the value as an absolute or with the percentages. The problem with raw numbers is that you don't have any context to make them a bit more hard hitting. Hence, my choice was to anchor the story in Reach. You'll see in a moment that it is an imperfect choice, but it is important to make a choice.

Here's the first view you would see in my version…

aol health v2 1

What I want to communicate is my assessment of what is AOL's core value proposition here, something that will surprise people.

The second click would revel how the story is framed… For folks that unfortunately suffer from Diabetes, AOL has close to 50% Reach…

aol health v2 2

I could just keep it at the Reach number, but you've noticed an aversion to just percents in this post as they don't quite get the message all the way across. The number in the yellow font adds a little bit of sizing of the audience, invaluable context.

A couple more clicks, and the rest of the story fills itself out…

aol health v2 3

You can get the core message very simply now. And, you have a sense for the size that is easy to understand.

The challenge of course is that it is quite odd to see that the 2,120k number is on a graph that is visually lower than 106k. It is hard for folks to wrap their heads around that concept – understandably so.

There is a legitimate case to be made that you could cross-tab this simpler version to create a workable alternative. Have the orange line be a raw number benchmark, say 500k, the blue bars represent the raw numbers, and yellow text becomes the Reach numbers.

But, it was my judgment, there's that word :), that based on my understanding of the situation that a Reach centered story would have a higher impact in terms of the idea that we were selling.

I could have totally bombed, it is a price I'm willing to pay. I'm doing it to have the ability to simplify things, and take risks. I'm willing to make a tough choice. I highly recommend that you do too. Your couple failures will be dwarfed by the numerous successes.

Let's try to apply this rule one more time.

Here's the picture that was painted… It was a reflection of a company's possible growth…

usco original

What's missing above is the Nascar-esq parade of logos, to preserve anonymity. You can be assured that it was appropriately eye-striking.

Get a post-it.

If you had to make tough choices, what would they be?

Sketch it out.

Some of the rules you've learned thus far are easily to apply, and I hope you caught those things.

For me there are two tough things to consider. Should we have the logo parade, though it contributes in the above view to explaining each bar? Is this the best way to frame the story we want to tell?

The first one was an easy decision due to this…

Universal Truth #14: Don't tell the audience things they already know.

Please remember this. Every moment you have is precious. If you don't have enough to say, it is ok to fill the gaps with thoughtful pauses. Regurgitating a parade of data/ideas/facts that people already know is a terrible choice.

On the second question I decided to step away from the waterfall chart. First, because I'm not sure it is adding much value. Second, you may or may not have noticed this, the second bar, 1.9 M, is actually a loss. It is illustrated weirdly, I wanted it to be more clear.

Here's the first view I would show… The past and the part of next year that is not great clearly identified…

usco fixed 1

I love having the focus starkly on the core of what we want to say, and all the negative space to let the data/visual breathe.

Then, element by element we reveal rest of the story…

usco fixed 2

The green and the yellow bars have insights that the presenter is delivering, we put them clearly out there for something new to be told to the audience.

Compare the before and after, I hope you feel the shift from having the slide/data being the center of attention in the original to the person telling the story becoming the center of attention.

One more exercise to help you truly internalize the lessons.

Here's the original that you can take a crack at fixing…

purchase path original

What would your version with tough choices look like?


Make tough choices. I would love for you to email me your version. Or, share your thoughts in the comment section below.

In a week, I'll take a couple of the best versions from you and add them here with your name and permission. I'll also add the version I've already created


[update] This was a challenging assignment. Bonnie captured it perfectly in the note to me: "Your funnel chart concerning purchases is way too confusing to even guess what the main objective is or what numbers go with what." :) Absolutely true.

It shows how the very best Analysts, at companies with great data environments, wonderful tools at their disposal, create things whose only outcome is a brutal death at the last mile.

Here are some brave souls who still gave it a go!

Andrew Clark took up the immense challenge and created this simpler version…

andrew clark

This version allows us to understand what was on the original a lot better. (What Andrew had zero way of knowing was that all the data on the slide was for Footage, none for Image purchases. The original is just so confusing!)

Hugo Galvenius and Jakob Samuelsson took a crack at making sense of the confusion in the original…

hugo galvenius jakob samuelsson 2

I love their taking everything down to one simple point. :) Really good.

Roman Mozil's version is so, so, much better than the original. He's picked one story to tell, and then told that story really well…

roman mozil 2

I appreciate his addition of a little text with a small explanation (you'll notice I dispense with it, but Roman did it better).

Here's the version I'd shared at the storytelling ideation day…

purchase path fixed

I picked one story, like Roman, and then used the visual treatments that made the story as simple and as attractive as I could make it in five minutes. I did not even do a graph, you'll notice it is just a table in Excel. The image was take with the table edges, they serve as a rough scale. Just to communicate that, I have only one number, 38%. [/update]

Remember, life is too tough for you not to be brave and make tough choices. :)

5. So what? So What?? So WHAT!

We have one more rule to go, but I think this is probably the most important one on the list.

One big way to focus the story you are telling is to ensure every beat in the story has a purpose. In our case, every table, every slide that comes from a piece of data, has to pass the so what test. It should be really clear why someone should deeply care.

An example of this that you saw above was quantifying the pain. The so what was $80 million in missed revenue. It can be other things as well, you saw the quantified opportunity size above. It can be any of the numerous brand metrics avilable to us. But, it always has to be something that would give your table/data/slide a clear purpose, something that causes people to lean-in.

Here's an example that illustrates that….

hispanic original

If you've been paying attention you'll notice this is a great example of how you can be seemingly uncluttered, and yet miss the mark by a wide margin.

And, if you've been paying attention you'll quickly get rid of the disappointing clipart, you'll notice the redundant numbers and text, you'll pick out the sadness of using percentages of percentages (see universal truth #7 above), additionally you'll be confused about what the +44% YOY numbers refers to because nothing seems to match that number, and other sub-optimal things.

You'll also consider the higher order bit and realize you can make tougher choices and frame what you want to say simply…

hispanic upgraded 1

Sweet, right?

Gets the very core of the message in front of the audience, as fast and as simply as we possibly can.

But, you are like… Avinash you said quantifying the opportunity size is more powerful than percentage deltas!

Yes, you are getting ahead of me.

Here… Yes, that is always better… quantify…

hispanic upgraded 2

So 22 million more Hispanics watch videos as a part of their shopping experience.

You see a compelling so what from the data there. Video is a valuable source, more people are using it, hurray.

I want you to push yourself harder. Shoot for the very best so what. In my experience, that comes from obsessing about the impact.

In this case…. Here's a more powerful so what that we found with a little bit of effort… People watch videos during their shopping experience, fine… What's the influence of that video watching?

OMG. Great question….

hispanic upgraded 3

This last piece of data, how much video advertising's influence has changed between 2013 and 2015 in the individual making their final choice, is killer. You're not just talking about raw reach, raw views, raw acquisition metrics. You're talking about tying the acquisition opportunity to the outcome/impact. That my dear readers drives action. The ultimate destiny of data.

Universal Truth #15: Purposeful data wins. Does your data have a powerful answer to the question so what ?

This is the hardest possible thing to do. It requires a fundamental understanding of the business, the various business strategies currently being executed, merging of various data sources, deep analytical skills, and an ability to predict impact. It is certainly the place where Analysis Ninjas are separated from Reporting Squirrels.

6. Shift your worldview to your client's.

Regardless of your role when you email a succinct summary of your insightful findings, or when you are standing in front of an audience, you are selling. Your audience – internal, external, at a conference – are your clients. Bring that perspective with you. It will cause you to lean-in a bit more.

Here's an example of some of the rules you've already learned, related to simplicity, tough choices, with an additional posture I want you to adopt: Taking the client's perspective.

We look at things too narrowly, or in a sales situation (see above) only care about ourselves. It is natural. Look at the data, think about the story, step outside your body, look at the situation from your client's perspective.

Let's make this real.

Ponder this incredibly complicated example…

video strategy original

What are the issues you see?

Take a post-it. Make a note of them.

There is a buffet here, we covered in story three why buffets are almost always sub-optimal as the client/audience does not benefit from your wisdom. You'll also see that there is just too much stuff, some of it unnecessary and other bits expressed in a more complex manner than might be optimal. It looks like there are two choices, but they are hard to see.

Applying the lessons we've learned today, here's what you can get to with only a tiny amount of effort.

video strategy fixed 1

If you are going to have a title (honestly, they add little to negative value), try and put some attitude in them. :)

We center the story on two choices, and make it super-duper easy to compare every equivalent element across the choices.

It takes you maybe five seconds to see the deltas, and perhaps make up your mind as to what you want to do.

You could be happy at this point. You should not be.

If you go back and look at the original you'll notice that that you don't really have two packages to choose from. Scroll back up, it is not very hard to spot.

Two of the elements are the same. There is a new element in package two, it is of immense value to consider what value you'll get from adding it. And, is it really worth giving up 600k views for $56k when it comes to TrueView In-Stream Skippable?

That should lead you to wonder, as did I, is it really of value to get "3.0 M impressions" for $100k with Pre-Roll, when compared to "2.8 M Views" for almost half the cost with Bumpers?

If you truly think about what you are saying from the unselfish perspective of your client/audience, because you loooooove them, truly and deeply, you might end up framing the opportunity completely differently.

My choice was to eliminate the poorly created package business complexity, frame the story as three advertising choices with the investment required for max impact, and then, with truly the client-centric view, say that they should choose just two…

video strategy fixed 2

Because I don't like buffets and want the audience to benefit from my point of view, I put two smiley faces for the choices that I would make if I were them.

Yes, I can get more money by choosing the first two. But, I would value Views more than Impressions. Hence my final version above.

I leave some money on the table in the short run, but I leave the lasting impression that I care for them first, I care for myself fifth. The true and glorious path to both driving big change and creating trusting relationships.

Always, always, always, look frame things from the client's perspective. [If you are in Team SDM remember we have even higher standards: Obsess about the client's client!]

But Wait, There's More!

This is a topic with deep fascination for me, if that's true for you as well then here's a small collection of paths you can walk down in order to truly master this delicious topic.

There are fifteen additional rules, with tons of real-world before – after examples like above, across these two posts: Great Storytelling With Data: Visualize Simply And Focus Obsessively | 7 Data Presentation Tips: Think, Focus, Simplify, Calibrate, Visualize

If you are interested in inspiration related to different types of visualization techniques you can use in your analytical practice, you are going to die of delight: Data Visualization Inspiration: Analysis To Insights To Action, Faster!

The very best lesson when it comes to data, the one thing you should never forget and you can never apply enough of, is this one: A Great Analyst's Best Friends: Skepticism & Wisdom

At Google we've developed an amazing framework we use to tell stories with data, more on that in this Forbes article: The Digital Evangelist Leading Google's Storytelling Movement.

I hope you find the knowledge in these links to be of value as you tell your stories with data.

As always, it is your turn now.

Have you shared your versions of the two exercises with me? Which of our six rules is your favourite? Are there other rules you would apply to any of these examples to make the output even more impactful? Which after version did you love the most? Did any of your sketches take you in a different direction than where I ended up? Do you have golden rules for telling stories with data that are not covered here?

Please share your insights, critique, lessons, examples, post-it pictures, and guidance via email (blog at kaushik dot net) or via comments below.

Thank you.

1 view0 comments

Comments


bottom of page