1 Comment

  1. A. Oleksiak says:

    Mia has set the bar high! Fabulous work, that I will be attempting to mirror!

Leave a Reply

Your email address will not be published. Required fields are marked *

Revamping a Tired Data Table: A ‘Before’ and ‘After’ Reveal

May 15th, 2018 / Dashboards, Data Visualization / , , , , , , , , , ,

I met Mia Schmid in 2017 when she enrolled in one of my Dashboard Design workshops. Later, she reached out and shared her own before/after makeover based on what she learned in the training. Her makeover was so dramatic that I wanted to share it with you, too. Great work, Mia! –Ann

In my current position, I am responsible for compiling quarterly data across our six programs as part of organization-wide internal reporting. In the past, I populated the tables (below) to report out on progress towards annual goals.

Before: A Black-and-White Table Without Any Visualizations

This table did a terrible job of communicating what we needed to know. The multiple columns of numbers didn’t make clear what, if anything, staff should take away from this. And it didn’t effectively communicate progress over time to inform our decision-making.

Mia Schmid's "before" table: This table did a terrible job of communicating what we needed to know. The multiple columns of numbers didn’t make clear what, if anything, staff should take away from this. And it didn’t effectively communicate progress over time to inform our decision-making.

After: A Dashboard that Displays the Key Data Points with Visuals

Last summer I took an online course with Ann on dashboard design in Excel. Using what I learned in the course, I transformed the ugly tables into a dashboard (below). I created data bars to communicate percentage progress towards annual goals and sparklines to show trends over time. I also integrated my organization’s branding using colors for each of the four issue areas we work on.

Mia Schmid's "after" dashboard: with this revised dashboard, we can show change over time much more effectively with sparklines and are able to include data from when the organization started in 2013. 

In the original table, we had included separate columns to compare how each program did in 2016 to 2017. Now, with this revised dashboard, we can show change over time much more effectively with sparklines and are able to include data from when the organization started in 2013.

The Result: An Easier-to-Read and Engaging Document to Communicate Our Progress

This is a huge improvement to how we have tracked organization-wide goals! The dashboard is so much easier to read compared to the table format and is a much more engaging way to communicate our progress than merely throwing a bunch of numbers into a table and expecting staff to make sense of it.

This dashboard also communicates more than just progress towards goals. When I first put this dashboard together I was struck by how many of our programs either exceeded or under-achieved on their goals for 2017. Goal setting is one area we have been working on with each program and this dashboard has also enabled us to communicate to leadership why appropriate goal setting is so important—achieving a goal by 349% signals to me that the target set by the program is questionable. Historically, program staff set goals based on anecdotes and chose numbers that “sounded good” rather than targets that were grounded in past performance and conscious of any expected growth in the coming year.

What was an annoying task is now a fun opportunity to create something meaningful for my organization and wow my colleagues—and it’s possible with just Excel.

1 Comment

  1. A. Oleksiak says:

    Mia has set the bar high! Fabulous work, that I will be attempting to mirror!

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Courses

Most “professional” reports are too long, dense, and jargony. Transform your reports with these practical tips. You’ll never look at reports the same way again.

Learn More

Leaders have more important things to do than read Dusty Shelf Reports. Design dashboards that inform, inspire, and look great in just 12 weeks. Spring 2019.

Learn More

SPONSORED

Data visualization best practices, practical how-tos, tutorials in multiple software platforms, and guest experts. Designed with busy number-crunchers in mind.

Learn More