An optimal dashboard is Accurate, Clear, Empowering, and Succinct. These key tenets can be remembered with the acronym ACES.
A dashboard lives and dies by the trust the viewers have in what they are seeing. If the viewers doubt the accuracy it will not be used to make decisions. People will also be more hesitant to trust any dashboard or to do any querying themselves. A lack of accuracy in one dashboard causes a lack of faith in all the data.
Viewers belief in the Accuracy of the dashboard can be affected in multiple ways:
The answer to this question should always be yes. If for some reason the answer is no immediately flag the dashboard as needing to be fixed so people do not use incorrect information for their decisions. Viewers will assume any dashboard they come across to be accurate unless properly flagged otherwise. Use bracketed language [BROKEN] or perhaps emoji’s to make the status of the dashboard clear.
Most of the times it is not, this is because of how data is loaded into the data warehouse. Engineers use batch processing that runs on a schedule to load data from their production database to the data warehouse which is what the dashboard is querying. This can cause people confusion who are dealing with customers or scenarios in real time where they are not seeing the data in the dashboard. If the dashboard is not displaying all of the data due to batch processing, you should note on your dashboard when the data was last updated and it’s schedule.
Metrics need to be understood before the viewer can interpret the chart accurately. It is a best practice to include formulas, notes, or definitions for any non-traditional metric directly on the dashboard. Placing it next to the visualization using it allows for the quickest use. Here we can easily see clarification around who is not included in this metric.
People are visual creatures and have a lot of biases in interpreting any visualization of data. A common mistake is setting the Y-axis range incorrectly. We want to highlight variation but we do not want to bias interpretation. For line graphs we do not have to start at 0 and we want to capture how the data changes
For bar graphs we must start at 0 because if it starts at a different point it prevents us from being able to use the size to judge the difference. When we look at the two examples below in the first we can see that HR is about half of what support is which is correct Support is ~450,000 and HR is ~200,000. However when we look at the second example HR looks like it is ⅕ of what Support is which is not correct.
To be able to make a decision based off of a dashboard, the data must be displayed clearly. There are several factors that go into making the data clear.
Fonts for chart titles, axes labels, and details should not be decorative. The goal is legibility. We recommend using a sans serif font such as Arial, Helvetica, or Verdana.
Consider the font size of any metric that will be displayed on your dashboard. Think about what type of device the audience will be viewing this on as well. All text on a dashboard should not require you to squint to read it.
The color palette used for the dashboard should be easy on the eyes and not overweight one color over another. An easy way to accomplish this is to use more muted tones.
Colors should also be consistent when representing the same metric or type of metric from chart to chart.This makes it easy to relate the data across graphs, tables and charts
The colors used in the visualizations need to contrast the background enough to be seen clearly. However, too much contrast within a chart can be distracting.
We can examine some different color palette choices below and better alternatives.
This is difficult to see which part of the bar belongs to which category
This shows the difference between the categories but the last part of the chart is too saturated and grabs your attention so this is not ideal unless you are trying to highlight that section.
This differentiation is clear but some of the colors are very far apart on the color wheel and could become a bit distracting if used too much. We will discuss colors more in the Visually appealing section.
These colors show the difference between the categories without overweighting one of the categories.
Most dashboarding tools will default you to a color scheme that delineates categories clearly. If for some reason they do not, then customize your color selection so that evaluations of the data can be made at a glance.
Include information such as:
These additions make it easier for new viewers to understand what is going on.
If data is hard to decipher, it won’t be read. The more explanation or context needed to understand charts on a dashboard the less the dashboard is an effective intelligence tool. Remember, speed to insight is key. Squinting is challenging and time spent seeking out the author of a report for further explanation diminishes the impact of the dashboards goal.
Viewers in most countries read from left to right and top to bottom. Therefore the most important information should be top left and the least important information on the bottom right.
Visualizations should be aligned. Having a chart unaligned with the other visualizations will distract from the goal of presenting all of the information clearly to the viewer.
Since Yearly Subscriptions is out of alignment, it sticks out, and grabs the viewers attention and therefore may seem more important
Does a dashboard get used regularly and does it help people make decisions? These qualities are best evaluated after the dashboard is created by the end user/viewer of the dashboard.
Most BI tools will provide you with a query log where you can track the number of views for each dashboard:
If you start to see a drop off in views, you should follow up with the individuals who are no longer viewing the dashboard. Asking the following questions can help:
Some dashboards may be viewed less frequently if they are set up for longer-term decisions. These gaps indicate when the dashboard is not being used. The regular spikes show when it is used and how useful it is.
In this case, the views might be related to quarterly planning or reporting, if you look at a shorter time frame it appears not useful.
A simple way to check this is to ask the viewer, if the numbers on this dashboard went to 0 or if the numbers doubled would you do anything? If the answer is no, then the dashboard is probably not useful. If the answer is yes, then the dashboard is probably useful.
One of the main benefits of a dashboard is that it shows multiple data visualizations simultaneously which facilitates processing all of the information together. Due to people’s limited working memory, needing to scroll to see other data visualizations prevents viewers from being able to compare the various visualizations side by side to reach significant conclusions. Scrolling becomes counterproductive.
In the image below we can see the report on the left it would be impossible to compare the charts that are circled at once since we would need to scroll to see each one.
Having information on a dashboard hidden “below the fold” or below the bottom of the screen usually indicates that there is too much information on that dashboard. Ask yourself if the data is necessary or if it can be displayed in a smaller space without comprimising its clarity.
It is easy to keep putting more and more charts on a dashboard that are useful, however not all useful charts are relevant to the purpose of a dashboard.
While a weather forecast is useful and a Spend vs Customer Acquisition with a Forecast chart is useful. Neither is relevant to each other. Keep your forecasts separate :-)
Data that is relevant to other pieces of information on the dashboard should be placed in close proximity on your dashboard
Looking back at our original dashboard, we can note the placement of relevant data succinctly which makes it is easy to evaluate the data displays as a group.