8 Oct

Driving Adoption Through Design: Five Tips for Building User-Centric Dashboards

SJ
Sam Jansen

As a data analyst or BI developer, deploying a new data product or dashboard to production is always a satisfying moment. It’s also tempting to think that that’s the end of the story - time to progress the ticket to Done and move on to the next thing. A few weeks or months go by and you might wonder how your stakeholders are faring with that product you spent so much time on. You ask around or check the automated usage metrics, only to find that nobody has looked at it since the week of publication.

It’s a frustrating experience that’s familiar to many data practitioners, including those working for one of our clients, a global financial services organisation looking to innovate in new and different ways. Their BI developers had created a dashboard tracking the retail performance of a new product that is fundamental to the company’s long-term strategy, but they were struggling to get senior stakeholders to use it to drive decision-making. They turned to us for guidance on how to increase dashboard adoption, and in this post I will walk through the key advice that we offered.

The Key Questions Behind User Adoption

When developing a new data product, there’s one question that should be central to the whole design process: How does this product make my stakeholders’ job easier and/or faster? For dashboards, we can break this question down into three key considerations for the end user:

If the answer to any of these questions is "No", user adoption is likely to suffer. By using these questions as a guide to assess our client’s dashboard, we identified five key pieces of advice for increasing adoption.

Advances in BI tooling mean it has never been easier to create dashboards with an abundance of metrics and visuals, but creating them without our three key questions in mind will likely weaken end-user adoption

1. Build Your Dashboard with a Key User Group in Mind

A dashboard designed for everyone is a dashboard designed for no one. When you try to cater to multiple user groups, you risk creating a bloated product filled with metrics and visuals that each apply only to a subset of users. With so much clutter, it can be hard for users to determine whether the dashboard answers their key questions: This is a Q1 and a Q2 issue.

Our client initially attempted to build a single dashboard for three distinct groups: the Retail Performance Management Team, the Finance Team, and the on-the-ground Sales Teams. We recommended narrowing their focus to the Retail Performance Management Team first, ensuring the dashboard met their specific needs before considering other groups.

2. Understand Your Key User Group’s Critical Questions

To design a dashboard that truly serves its users, you must first understand the questions they need to answer. To do this, you will need to run requirements gathering sessions that explore not only the questions users have but also the value of those questions and their alignment with strategic goals. It’s equally important to identify any pain points in the current process of gathering these answers and to uncover questions that users can’t currently answer. All of this goes towards satisfying Q1.

Our client’s initial approach was to pack the dashboard with a variety of metrics, visuals and insights available from the underlying data, without first considering their utility. We stepped in to conduct sessions with key stakeholders from the Retail Performance Management Team. By walking through their critical questions, we aligned on what needed to be answered in the dashboard, then formalised this in a requirements document to ensure that everyone was on the same page.

Building a dashboard around a single user group and having a strong understanding of their critical questions allows you to streamline your dashboard and make it simple for end users to find the answers the need

3. Structure Your Dashboard Around the Natural Flow of User Questions

A well-structured dashboard should follow a summary > detail > granular flow, reflecting how users typically process information. Consider how much time users have to engage with the dashboard:

  • Summary Page: For those with limited time, this page should provide all the key insights they need.
  • Detail Page: Users with more time and a need for deeper insights should find everything they need here, building on the summary.
  • Granular Data: For those engaged in root cause analysis, granular data should be easily accessible.

By structuring a dashboard around a user’s thought process, we are satisfying Q2.

Our client’s Retail Performance Management Team was accustomed to manual reporting in Excel that typically took several hours a week to compile. By following the structure outlined above, we were able to introduce the summary visuals to highlight insights that tables alone couldn’t convey, whilst also preserving those tables to maintain a sense of familiarity for the end users. We also advised ingesting granular data into the dashboard to allow users to drill down as needed, improving flexibility and reducing frustration.

Structuring a dashboard using three views - summary, detail, and tabular - anticipates the end user’s natural train of inquiry and makes it easier for them to navigate the product

4. Explain Methodology Up Front and Test Your Dashboard Numbers Rigorously

Confidence in the dashboard’s accuracy is crucial for user adoption. Developers and end users must thoroughly understand the data lineage from source systems to the dashboard, including any transformations and filters applied along the way. This knowledge is essential for reconciling data and building trust in the end product - a Q3 consideration.

We suggested adding an intro page to our client’s dashboard that explained the data lineage: data sources, definitions of key metrics, the dashboard’s scope, and any key data inclusions/exclusions. This transparency builds trust in the dashboard’s contents. Additionally, some of our client’s dashboard developers lacked access to the data warehouse, which made it difficult to address data discrepancies raised by stakeholders. We recommended granting read access to upstream tables for all developers, enabling them to gain familiarity with the transformation pipeline. 

A good dashboard clearly highlights all the steps that went into its design - including data lineage, applied transformations, data refresh, and definitions of terms - so that end users are confident about what they see

5. Iterate with Stakeholders and Run User Acceptance Testing (UAT)

A dashboard should never be developed in isolation from its end users. To increase buy-in and ensure the dashboard meets user needs, stakeholders should be heavily involved throughout the development process. Regular touchpoints allow stakeholders to see progress, provide feedback, and gain early access to the dashboard, as well as ensuring that any risks impacting on Q1, Q2 or Q3 are raised and addressed early.

Our client previously had a working group dedicated to performance reporting on their new product, but it had recently gone dormant. We recommended revitalising this group with regular sessions to demo new functionality, using a Teams channel to log and address feedback promptly. We also recommended formal UAT with key users towards the end of the development lifecycle, as well as regular post-deployment check-ins to ensure that users felt supported even once the bulk of the work had been completed.

An iterative approach to dashboard design that involves stakeholders at all stages boosts end user confidence and buy-in

End User Collaboration Is the Key to Dashboard Adoption

By implementing these recommendations, our client is already well on their way to refocusing their dashboard to better serve the Retail Performance Management team. They are also adapting their dashboard development workflow to ensure the right questions are answered and stakeholders are engaged throughout the process. Ultimately, treating end users as a collaborator, rather than simply a customer in the dashboard development process will increase the chances that your hard work goes on to have a significant impact on your organisation’s decision-making.

At Mesh-AI, our data analytics team has deep expertise in creating impactful, actionable dashboards that align with your strategic goals and in helping you build up the people, skills and processes needed to be a data-driven organisation. Get in touch with us to learn how we can help you achieve better outcomes through focused actionable insights and a stronger analytics capability.

Latest Stories

See More
This website uses cookies to maximize your experience and help us to understand how we can improve it. By clicking 'Accept', you consent to the use of these cookies. If you would like to manage your cookie settings, you can control this in your internet browser. Find out more in our Privacy Policy