The dashboard design process is very similar to any design process however the output is a dashboard… obviously.
People get very attached to their solutions for a problem. The more they invest time and effort in their solution the stronger they believe in it regardless of the quality of the solution. This is why it is critical to avoid jumping right to solving the problem by building a dashboard. We don’t want low quality dashboards.
Spend time understanding why we are building a dashboard and give ourselves time to explore multiple ideas before selecting what we will actually build.
The process starts with defining our stakeholders and what the metrics they care about. Then we prototype dashboards, get feedback, and iterate. After getting feedback that the prototype meets the goals of the project we need to find the actual data and build the dashboard. Finally we need to share the dashboard and maintain it so it becomes a useful tool for the audience.
We can summarize this process into 4 steps:
This is the first and most important step. Having clarity about who this dashboard is for and what metrics matter to them is critical to creating a dashboard that will be used.
There are 4 main stakeholders
We will define in detail their responsibilities and where they factor into the process in the next chapter.
You will work with the point person to go from vague goals to query-able metrics. This process involves a lot of back and forth to weed out interesting but ultimately not relevant metrics to mission critical data for decisions to be based on. We will go into further details about how to do this in Determine the Metrics to Monitor
Once we have the metrics that we want to put in a dashboard we need to figure out how best to display them so that it is useful to the whole audience.
Use the visualization that best presents the metrics clearly and accurately. Even when sketching and prototyping graphs making the right visualization decisions here will improve the prototype and the feedback loop. We will cover when to use which chart in depth in Find the Best Visualizations for Your Metrics
There are best practices for taking the visualizations and composing them together in a dashboard. In fact some composition choices might actually make you change what visualization you had selected as optimal before. We cover best practices for arranging dashboards in Arranging Your Visualizations as a Dashboard
At this stage it is recommended that the visualizations and dashboards be sketched out on paper or using a lo fi tool that is not connected to any real data. The reason for this is that it allows you to quickly throw out bad ideas without worrying about the time investment. It also allows you to focus on design instead of checking if the numbers are right. We talk through visualization and dashboard prototyping strategies in Dashboard Prototyping and Feedback
Once we are satisfied with the prototype we have to create the dashboard using real data.
Many challenges can arise at this point. Where is the data stored? Is the data messy? Do we even have the data available? Working with the data team and the Data Gatekeeper is critical to navigating this step. We talk through common difficulties and how to overcome them in Finding the Data That Builds Metrics
We need to create queries to power the metrics, create formulas, and transform the data into charts. Using a framework to log the metrics, formulas, and data sources makes creating queries much easier, we outline how to do this best in Build the Metrics
Finally we have a fully functioning dashboard. Now we need to share it with the full audience. We should enhance the dashboard to make it more effective at scale and we need to make sure to maintain it as usage grows and changes.
The audience will have varying levels of data literacy and context for the data presented in the dashboard. You need to verify you have enough context within the dashboard and that you provide enough training so that people can get insights out of it easily. We go over these techniques in Sharing the Dashboard – Distribution Strategies
If the dashboard is useful the amount of views and total number of viewers is likely to grow. Adding links, interactivity, and documentation to a dashboard helps it accommodate more use cases and inspire other dashboard creators. Also as the number of views/viewers increases spending time optimizing queries becomes an important way of keeping the dashboard useful. We outline the steps in Scaling Dashboards
Datasources, tables, and fields change, dashboards need to change with it. Setting up scheduled times to review dashboards is critical to keeping them relevant and functional. Providing a way for the audience to alert you about issues will allow you to make informed improvements to the dashboard. We cover maintenance in Making Sure Your Dashboard Always Gets Better