VizWiz

Launch, grow, and unlock your career in data
Showing posts with label Fix it Friday. Show all posts

July 15, 2017

A New Way to Visualize an Income Statement

, , , , , , 22 comments
Thursday, as Eva and I were preparing for our next BrightTALK webinar (How data visualization can deliver clearer insights for the Finance industry) we were looking for examples of good finance dashboards. We found a page on Tableau's website with finance dashboards...great! So we thought.

Scroll down on the page and you see a series of examples. I clicked on the first one titled "Track profit and loss with an intuitive CFO dashboard". Yes! Had we found the Holy Grail? Turns out these are for the most part Excel dashboards rebuilt in Tableau, which is sadly how many finance departments choose to use Tableau. Take pity on them I say. Let's have a look at what Tableau created:


Keep in mind, this is billed as an "intuitive dashboard", but is it really? Normally when I write about makeovers, I list out the things that work well. With this dashboard, I can't think of a single thing that works well. Ok, maybe the title is clear and the filters are obvious. I don't see anything else that is even remotely intuitive otherwise.

Let's look at the viz in two separate pieces.

STACKED BAR/DUAL AXIS CHART

Generally I'm not a fan of dual axis charts that have different measures. I think these confuse the audience more than necessary, which defeats the purpose of using visuals to convey the information in the first place. In my experience, when people see a dual axis chart, they naturally look for correlations where they may not exist.

What else fails?

  • The way this chart is designed, it's too much work to know which axis goes with which metric.
  • Why use a dot plot when this is a time series? Wouldn't a line look better?
  • Why are there separate summaries for the years? When you first look at the top section, your eyes go all the way across before you realize you're now looking at a yearly summary. Poor design.
  • Why the heck is the Profit Margin legend so weirdly aligned?
  • Net profit is stacked in front of net sales. I get that, but then I have to do that math in my head for the difference. Why not just express it as a profit ratio, making it much more intuitive?
  • The dashboard is set to automatic size, which is never, ever a good choice. 

FINANCE TABLES

Tables in Tableau annoy me probably more than anything else. Yes, I understand people like tables, especially finance people. However, we all know that all they want to do is copy/paste it into Excel. Just give it to them in Excel if that's what they want.

What's wrong with this table?

  • The table doesn't align with the bar charts.
  • Again, they provided a separate yearly summary way off to the right. Why aren't the year totals after each year? 
  • I have to scroll to see all of the data in the table.
  • There are way too many metrics. Breaking down COGS and OPEX into all of its parts is completely unnecessary.
  • There are absolutely zero actions you can take from the table. It doesn't tell you anything about what's going well nor what needs attention.

I decided to spend some time making this over and creating an intuitive, actionable income statement. I drew inspiration from Lindsey Poulter's DC Metro scorecard to create my design. In my version I take each of the nine metrics that make up the income statement and create a "card" for each of them. Thank you to Tim Ngwena for the idea to add subtle borders around them. 

Overall, the desktop and tablet versions are designed to be read in a Z-pattern, while the mobile version is designed for scrolling (see the video below).

How to read each card:

  1. YTD vs. PY Bullet Graph - The bar chart represents YTD for the given metric and the reference line represented the same period of the prior year (PY). The bar is then colored based on the variance to PY. Blue is good, orange is bad. For some of the metrics, being beyond PY is good, like Gross Sales. However, for other metrics like COGS, being above PY is bad. Hence why you see some bars orange that extend beyond PY.
  2. Variance to Budget Sparklines - Below each bar chart is a sparkline that goes back to January of PY. In this case, the sparklines represent 17 months. As new data comes in, the line grows. The sparklines show the variance to the budget for each metric. A reference line at zero represents being "on budget". The dot on the end of each line is color by the variance to the budget for the most recent month.

With that, I'd like to introduce you to a much more actionable, much more intuitive income statement. Below this image is a video of the mobile version. Click on the image for the interactive version. If you are reading this on a mobile device, you should see the mobile version automatically. Device Designer made this super simple!


I also would like to thank Adam Crahen, Pooja Gandhi, Curtis Harris, Michael Mixon, Eva Murray and the entire Information Lab team for their quick feedback on this yesterday. It's very much appreciated!!


VIDEO OF MOBILE VERSION



October 21, 2016

Fix It Friday: Ten Alternatives Methods for Presenting Alcohol Consumption in OECD Countries

, , , , , , , , , , , 12 comments
If this post turns into a bit of rant, bear with me. Let's start with the Tweet that got me worked up:


You might think "It's just a chart Andy, relax!" True. It's a chart. It's not changing the world or anything. There are several things that have me a bit upset:

  1. Paul Kirby calls the chart "interesting" and maybe the CONTENT is interesting, but the chart is terrible.
  2. He says "Austrians drink twice as much as Italians", a fact that is simply not true. They drink 61% more than Italians. You can't just spout facts like that.
  3. Paul is visiting professor at the London School of Economics. I can only assume that his students follow him on Twitter. When he tweets things like this, his student will assume that this is how charts should be made, which only proliferates the number of poor charts we'll continue to see.

The chart itself has its own set of problems:

  1. It's too dark overall. The dark red bars and dark bottles are hard to see against the blue background.
  2. The flags are unnecessary. What value do they add?
  3. The bottles are cute, but unnecessary decoration.
  4. The legend is in reverse order.
  5. Do the bottle extend beyond the bars or do they start from the same baseline?
  6. It has a weak title. What's the story?

This is chart junk at its best. Don't create charts like this. I went to the OECD website and downloaded the data. Below I present ten alternative charts that all work better than the original. You can download the Tableau workbook with all of these charts here.











May 27, 2016

Fix it Friday: Early Leavers from Education and Training in Europe

, , , ,

On the train to work this morning I was reading through the blogs I follow and ran across this amazing visualisation from Stephanie Evergreen:


I love small multiples and I love slope charts, and this in an amazing combination of the two. Shortly thereafter, I ran across this chart from the Financial Times:


To me, this chart is screaming out for a slope chart. Also, I don’t understand why they didn’t include all countries in Europe. I downloaded the data from Eurostat and created this small multiples slope chart in Tableau.

I also was able to include an option that allows you to pick a gender or the overall. Notice how the title changes color to match the lines in the slope graph. Do you know how I did that?

Which one do you think tells the story better? Does the bar chart of the slope chart make comparing the years easier?

Subscribe to: Posts ( Atom )