Infographics: Telling Stories with Data

Visual.ly is a website that showcases thousands of infographics where data is displayed in unique and fun ways.  For consultants who are in the business of telling stories with data, it is worth a few minutes of your time.

Visual.ly - ScreenshotConsulting presentations are simpler.  90%+ of presentations will be on PowerPoint and only use simple graphs with very straight-forward messages.  It’s a good thing because executives look for compelling recommendations, not cutesy graphics.

Infographics - Simple graphs in Powerpoint

As I noted in another post, McKinsey & Company printed their client presentations in black and white prior to 2009.  For them, the strength was in the analysis and clarity of argument.  If “simple” is good enough for McKinsey, it is good enough for you and me.

So why bother? A cynic might ask, “So why should a consultant even bother looking at infographics, if they are not the type of graphics we use with clients?”

Answer: It’s good for you.  It’s easy for us to get set in your ways.  We need to feed our minds new ideas and new ways to improve our craft.  It’s instructive to see how professional graphic designers represent data – even if you apply it later in a more toned-down or straight-laced way.

1. Learn to build an argument.   In Osama vs. Air Travel: The Post 9-11 Effect on Travel, see how the designer combined data to show the impact of 9/11 on US travel patterns.

Infographics - Airline Bankruptcies

2. See how others analyze data.  You can take the most mundane data and do amazing things with it.  Look at this analysis of the Songs that Metallica Played on Stage during 1982-2012.  It’s amazing to see how many ways they sliced the 30 years of data.

Infographics - Metallica Songs Play on Stage

3. See good (yet crass) examples of consulting tools.  Many of the infographics use classic consulting tools like fishbone diagrams, venn diagrams, pie charts, waterfalls.  See this Taxonomy of Sh*t which is just an affinity diagram.    Albeit, a vulgar one.

Infographics - Taxonomy of Sht4. Learn from bad examples.  There are examples where the designers goes overboard and makes the data confusing.  In Texting While Driving, you can see a muti-layered pie chart that takes about 30 seconds to fully decipher.   Do not do this.

The main point is simple – that young people text while driving – but the graphic is unnecessarily ornate and confusing.   Also, it is bad graphics hygiene because the age groups are unequal: 16-19 (4 yrs), 20-24 (4 yrs), 25-34 (10 yrs), 35-44 (10 yrs)?

Infographics - Texting While Driving

5. Enjoy the creativity.  Live a little and enjoy the creativity.  Face it, data analysis, pivot tables, MiniTab, and Powerpoint can get boring.   Check out the How Much You Can Trust a Bearded Man? and see if you agree with their analysis.

Infographics - Trustworthiness of Beards

Another savant analyzed the color palette of 10 artists over the same 10 year period.   I swear, there are some creative people out there.  More right-brained than I am.

Visual.ly - 10 artists over 10 years

Let me know when you find great infographics, I will add it below.

5 super useful websites: free PC-to-Fax, free PDF editor, free icon finder, Kleki.com, and Wordle.net

Recently came across a list called 101 Most Useful Websites curated by Amit Argarwal, a columnist with the Wall Street Journal India.  Useful, free and refreshing websites.

1) FaxZero.com: This a free PC-to-Fax machine service.  No registration and it takes only 60 seconds to upload a document, type in the recipient’s fax number and send.  I used this yesterday to fax from the comfort of my desk chair.

Free Fax from PC

2) www.PDFEscape.com: This is a free online PDF editor that lets you do all those things your freebie-cheapie version of Acrobat reader does not.  Create pdf, edit, create form fields, add sticky notes, and highlight.  (Some of the features shown below)

Free PDF editor onlineFree PDF editor features3) www.IconFinder.com: This is an excellent search tool for icons, but I have two small caveats: 1) Double check to make sure the license is “creative commons”, so you can use it 2) Resist the temptation to load your presentation with lots icons.  Be sparing.  Putting lots of icons and meaningless photos in the PPT makes it look like a high-school science project.  Rely on your analysis and insights, not icons.

Icon Finder

4) Kleki.com: This is an online drawing tool that is both simple and fun.  No download needed.  As the website creator explained,”I like to paint and code, that’s basically why I’m creating this tool.”  Lots of talented and generous people out there.

Kleki Drawing Online

5) www.Wordle.net: This website lets you create a word cloud in about 20 seconds.  No download needed.  Simply copy/paste your text into the box, then change the colors, layout, font to your liking.  Doubt you will use this in a client presentation, but it is good fun.  See this blog’s word cloud below.  As consultants, need to always eat our own dog food.

Word Cloud

Data Analysis: the meaning behind the US state names

Happy Birthday!  The United States is celebrating its 236th birthday today.

I saw an article from Mental Floss Magazine by Matt Soniak called How All 50 States Got Their Names.  It was well-timed for July 4th, but a bit long at 5,000 words.  After reading through the alphabetical list A, B, C , I started getting frustrated by all the words.

Call me lazy, but I wanted to see the big picture.  Understand the narrative.  Dig out the insights.  So, I did what all consultants do when confronted with data. . .

1) Think about the logical groupings

  • I noticed that the state names really boiled down to either a) Native American Indian words or b) European (read: Spanish, French, English) words

2) Put the data into excel for analysis

  • I started the un-fun task of reading the words, and boiling it down into its parts
  • Here are the first 10 states (A-G) with the name origin and meaning

State Names and Meaning A-G

3) Look for anything interesting: trends, outliers, common threads

  • Consultants love maps.  I am no exception.  Tableau is my favorite for visually mapping data, but I found a free alternative at www.diymaps.net
  • 60% of states have names with Native American Indian word origins.  All 28 states shown below in blue trace their names back this way

States with Native American Indian Names4) Make it graphical if it helps to convey the point

  • I ran the map again for the states which names that have multiple name origins
  • Surprisingly, eleven states (shown in green below) have unknown name origins or multiple conflicting stories.  For example, New Mexico obviously comes from “Mexico”, but even that name has an unclear origin as described here.

States with Unclear Names

For those in the US . . . Do you know the meaning of your state’s name?  I didn’t

  • Here are the other 40 states, letter H – W.  This is good Jeopardy stuff
  • If there are “quote”, it is a Proper noun.  For example, Louisiana was named after King Louis.  Also, Virginia was named after Queen Elizabeth I (the “Virgin Queen”)
  • Some names have both Native American Indian & European origins; for example, Illinois and Michigan were Native American Indian words that were anglicized

State Names and Meaning H-W

Bar Charts: Plastic surgery, meat consumption, reasons young people die

Consultants always appreciate visuals.  Here are some great bar charts from the Economist showing the differences between countries.  Note: not all countries are shown.

Meat Consumption by Country by Product

  • Luxembourg, United States, and Australia eat the most meat per capita
  • Argentina eats the most beef per person (think pampas)
  • Kuwait eats the most poultry per capita, by a wide margin
  • Austria eats the most pork per capita (curious how China would stack up)

Economist chart on meat consumption by country - Consulting blog

Cause of Mortality in Young People (10-24 year old)

  • American young people have the highest mortality rate for this age group
  • More Americans die from violence (dark blue bar) than other OECD countries
  • New Zealand and Finland have the highest % of suicides from this age group
  • The US, New Zealand, Portugal, and Greece have the highest traffic accident rates

Economist chart showing teenager deaths by cause - Consulting blog

Plastic Surgery by Country

  • South Korea has the largest number of plastic surgeries per capita
  • Brazil has has the largest number of invasive plastic surgery per capita
  • US and Brazil have the largest total number of surgeries (3.31M and 2.52M)

Economist chart plastic surgery by country - Consulting blog

Related Posts:

Finviz.com: Powerful free online financial markets dashboard

Management consultants love tools, especially free ones that few people know about.   After all, a wrench, a hammer, and a screwdriver all do the same thing – it gives its user leverage.   A consulting tool is no different.  A little bit of effort + tools = results.

One of my favorite online financial market tools: www.finviz.com

Finviz S&P500 Heat Map: This displays all 500 stocks in the S&P index at once.  The amount of information packed into this heat map is amazing:

  • Companies are grouped by industry
  • Larger companies (market cap, revenues) get bigger boxes
  • Red, black, green color all have meaning
  • One click zooms in, two clicks goes to the specific stock
  • (On the top) can look at S&P, World equities, or Exchange Traded Funds
  • (On the right) can look at stock performance, P/E multiples, dividend yield, earnings date proximity etc. . .

Finviz - Consulting Blog

Finviz Stock Screener: This tools helps you narrow down the list of 6,800+ publicly traded stocks using 60+ filter criteria.  While it is not an investment bank-grade Bloomberg terminal or Capital IQ service, you will be surprised how good it is.   Here are a few questions I was able to answer in 3 minutes:

  • How companies from BRIC countries have a 5%+ dividend yield? 11
  • How many Ag chemical companies have a 10B+ market cap? 5
  • What are the largest Brazilian companies? Petrobras, AMBEV, Vale . . .

Finviz - Consulting Blog

It is a crazy useful tool, but be aware there are limits:

  • Only shows publicly traded companies
  • Only shows foreign stocks listed on the US exchanges
  • Categorizes company by their main business (e.g.,  Berkshire Hathaway is under insurance, not furniture, candy etc. . .)