The Keys to Effective Dashboard Design

Craft clear and user-friendly dashboards for your stakeholders using the right metrics, visuals, and spacing.

Good dashboard design boils down to 3 factors:

1. Numbers

We need to include the right metrics for the right audience. A lot of statisticians and data scientists go wrong here by trying to get too fancy with the metrics used. Try to use universally understandable metrics (such as averages, proportions and counts) rather than less commonly used measures (such as standard deviations and interquartile ranges).

2. Visuals

We need to know when to use a chart versus a table versus ‘impact metrics’. If we have decided to use charts, we need to choose the right charts for the job. Chart selection should be based on the science of vision and perception see Cleveland and McGill, 1984, shown below:

It should not based on what looks aesthetically pleasing at the time. Once we have selected our charts based on what we know about human vision, we need to design these charts well, free of chart junk and with high data-ink ratios (see Edward Tufte’s work for more).

3. UX and Spatial Layout

Once we have decided on our metrics and charts, it is time to arrange these items appropriately in an appropriate spatial manner. Eye tracking studies by Tableau suggest that humans read dashboards in a “Z” pattern, reading across the top of the dashboard from left to right first.

Our most important metrics or graphs should be positioned across the top of the dashboard, with the most important numbers in the upper leftmost corner. We should then implement appropriate interactivity into our dashboard via tooltips, filters and highlighting effects (you will be out of luck here if you are working in Excel. Think about upgrading to Power BI or Tableau). Where possible, the dashboard should be dynamically linked between the various graphical/tabular components, so that when we filter to a subset in one graph/table, the other graphs/tables will dynamically adjust also.

Level up your dashboard skills in our Designing Effective Dashboards workshop

Similar posts

A Data Storyteller’s Guide to Better Slide Design

Apply these simple techniques to quickly transform busy slides into a clear, polished presentation for your stakeholders.

Impact Metrics: The Ultimate in Simplicity

Chart isn’t always needed to present data. Use impact metrics to put a spotlight on the metric that matters.

When Not to Use a Stacked Bar Chart

Are you using stacked bar charts to visualize your data? Find out if your chart is revealing or hiding the insight from your audience.

Sign up to hear about our upcoming courses and events: