Effective dashboard design: a step-by-step guide | Geckoboard (2024)

The first step to designing any dashboard is to clearly define what you’re trying to achieve. What‘s the purpose of your dashboard? Who’s it for? What do you want them to do differently because of it?

Perhaps you’re trying to focus your team on a specific goal, or show them how they contribute to the bigger picture. Or maybe you want to make sure a particular type of problem gets noticed quicker. These are all good purposes to keep in mind.

For inspiration, explore these examples: Executive | Finance | Marketing | Sales | Support | Product

Content is key when it comes to dashboarding. If you’re not showing useful metrics then it doesn’t matter how you arrange them.

Often you’ll already have some goals and KPIs defined, and adding those is a great starting point. Just remember, everything should tie back to the purpose of your board.

Every inch on your TV dashboard is valuable real-estate. Adding too much information can detract from what’s important and make everything harder to find. If you’re really struggling to fit everything in then you may need more than one dashboard.

When putting any metric on your dashboard you should make sure they:

  • Match the purpose of your board
  • Can be influenced by your team
  • Can be easily understood
  • Change reasonably often (you don’t want to be staring at numbers that never change)
  • Don’t vary so much that you can’t easily detect trends

Another way to improve your dashboard design is by reducing the amount of visual noise. The American statistician, Edward Tufte coined a term for this: data ink ratio.

The term comes from a pre-digital age when data visualizations were nearly always printed with ink. Data ink is quite literally the ink on the page that communicates data, whereas non-data ink does not. Well designed dashboards (and other data visualizations) aim to use as little non-data ink as possible – in other words, they have a good data ink ratio.

That means removing unnecessary grid lines, icons, color, labels, or anything else that doesn’t actually communicate data. Dashboards with a poor data ink ratio are hard work for the user, because the non-data ink is distracting and gets in the way.

Decorative elements like colorful backgrounds or quirky illustrations may grab your attention the first time you look at a dashboard, but the novelty very quickly wears off, and eventually it just gets in the way.

When displaying numbers, try not to be overly precise. Showing your conversion rate to 3 decimal places or your revenue to the nearest cent when you only care about much bigger changes just distracts from what’s important. Plus, including too much detail can make a mountain out of a molehill.

When selecting a visualization, you should choose the one which most clearly and efficiently communicates your data.

That means, it should take as little time as possible to understand.

In general, people aren’t very good at comparing and contrasting spatial area. This means pie charts and area charts are rarely the best choice of visualization.

Also, it can be tempting to change a visualization just for the sake of variety. Do do this. If choosing the right visualization means choosing the same visualization, then that’s fine. Most of the time, you’re going to be using a combination of numbers, bars, lines and tables and not much else.

It’s important to position the information on your dashboard logically. Grouping related metrics next to each other makes them easy to find — and makes your dashboard's design more attractive.

There are many different ways to group e.g. by metric, product, brand, campaign, region, team or even time period. You may need to experiment with which is most appropriate for your board.

Giving groups a title makes them easier to spot.

With dashboards, it’s often necessary to be repetitive, especially when you’re showing the same set of metrics for multiple things. Your dashboard will be far easier to read if you use the same visualizations and layouts between groups. It will also look far more pleasing, so avoid the temptation to use a line chart instead of a column just to spice things up.

Introducing a sense of hierarchy makes your dashboards easier to scan. Use size and position to emphasize the most important information and downplay metrics that need to be looked at less frequently. Consistent sizes and clear relationships between elements will help create patterns and visual flow.

In terms of positioning, the top left corner of your dashboard is the best location as that’s where your eyes are naturally drawn to first.

Don’t be afraid of empty space. It’s better to leave a gap than to make something bigger just to fill it.

To know if a number’s good or bad your viewers need context. Would they know, for instance, that 42 new leads today is out of the ordinary?

One of the easiest ways to do this is to include past data. You could include the same metric for the previous day, or even a line or column chart showing how the metric tracks over a longer period of time. Another technique is to include the average or previous highs and lows.

If you’re working towards a goal, include the target as well as your current progress.

You can also add warnings for when a metric is above or below a certain threshold to make it easier to spot problems.

A key part of your dashboard are the labels that describe each metric or chart. They should be self explanatory, and unambiguous for your viewers At the same time, you should try and keep them as short as possible to avoid cluttering up your board and getting in the way of the data.

Abbreviations can be helpful too (as long as your audience understand them) e.g. “7d” instead of “7 days”. Symbols like ‘%’ can replace the word. You may also get away with a shorter definition for a metric if people are already familiar with it.

Headings can also be used to reduce repetition. Imagine you have the same metric for different time frames e.g. signups today, signups this month etc. If they’re all grouped under a heading called “Signups” you don’t need to repeat it each time.

So far, we’ve covered several rules for designing the perfect dashboard. But the thing about rules is they’re made to be broken.

Dashboard design is about more than just how efficiently you can lay out data. Ultimately, it’s about getting people to engage with the information. And sometimes, the most engaging dashboards break the rules.

So whether it’s a twitter feed, new deals, or a daily cat gif, remember it’s ok to break the rules sometimes if it means people engage with your dashboard. Just don’t go too wild.

Once you’ve built your dashboard don’t just leave it. Ask your team for feedback.

  • What do they look at most often or find most useful, and why?
  • What do they never look at or find least useful, and why?
  • Is there anything missing that they’d find useful?
  • Has it changed anything about the way they work?

Use this feedback to iterate your dashboard. Check your dashboard is driving the behaviour you intended. Step back from your board every now and then and look at how all the elements work together. Remind yourself what information you’re primarily trying to get across and how effectively those important elements stand out.

As your goals and priorities change, make sure you update your board so it acts as the heartbeat for whatever you’re doing.

Fill in the form below to download our dashboard design guide. Or why not see these dashboard design tips in action in this article: Dashboard design principles in practice, with real dashboard examples

Effective dashboard design: a step-by-step guide | Geckoboard (1)

Leave your email address to get our dashboard design guide sent to you.

Geckoboard will only use your information to contact you about relevant content, updates and product news. You can unsubscribe at any time, details in our privacy policy.

Effective dashboard design: a step-by-step guide  | Geckoboard (2024)

FAQs

What is the first step in the 7 step dashboard design guidelines? ›

1. Know Your Audience. The first critical step in designing your dashboard is to develop a user persona that defines who your audience is, what information they need, and how they will use this information.

How many steps are recommended to follow in creating an effective dashboard 5? ›

Planning an effective dashboard may seem like an overwhelming task, but it's easier than you think if you take it step by step. Follow these 4 steps to create a dashboard that helps you leverage one of your organization's most underutilized assets- your data.

What is the best first step when planning your dashboard? ›

Step 1: Define the Purpose of Your Dashboard

A good analytics platform can help you organize your data into insights and present it, but if you, the creator, do not have a clear vision for your dashboard, then users will be unable to glean anything from it.

How do you measure the effectiveness of a dashboard? ›

You should test your dashboard with real users and stakeholders, and ask them for their opinions and suggestions. You should also monitor your dashboard performance and usage, and track metrics such as views, clicks, time spent, satisfaction, and conversion.

How to create dashboard in Excel step by step pdf? ›

How to Create a Dashboard in Excel: Step by Step Guide
  1. Starting with Pivot Charts. Begin by inserting a pivot chart for a straightforward approach to dashboard creation. ...
  2. Enhancing with Slicers. ...
  3. Customizing Visual Elements. ...
  4. Expanding with Power Tools. ...
  5. Considering BI Software Alternatives. ...
  6. Additional Resources.

What is dashboard format in Excel? ›

The Excel Dashboard is used to display overviews of large data tracks. Excel Dashboards use dashboard elements like tables, charts, and gauges to show the overviews. The dashboards ease the decision-making process by showing the vital parts of the data in the same window.

What does a good dashboard look like? ›

Great dashboards are clear, interactive, and user-friendly. They communicate information at a glance through efficient data visualizations that will enable users to extract actionable insights, identify trends and patterns, and find improvement opportunities through a friendly online data analysis process.

What is the most crucial element of a dashboard build? ›

The 7 Must-Haves for Successful BI Dashboards
  • Data Visualization. The first key element of an effective BI dashboard is data visualization. ...
  • Dashboard Layout. ...
  • Global Filters and Reporting. ...
  • Customizable Views. ...
  • Sharing Data Sets. ...
  • Dashboard Tabs. ...
  • Navigation Options.

What is a successful dashboard? ›

Great dashboards are clear, intuitive, and customizable.

They communicate information quickly. They display information clearly and efficiently. They show trends and changes in data over time. They are easily customizable. The most important widgets and data components are effectively presented in a limited space.

What is the first step of building a dashboard in Jira? ›

Create your dashboard
  • From your project in Jira click Dashboards and View all Dashboards.
  • In the top right you can click on Create dashboard.
  • Fill in the name.
  • Start from a blank dashboard.
  • For Shared with select Public and click Add.
  • Click Create.
May 22, 2024

What is the first step to build a dashboard in Cognos Analytics? ›

Procedure: 1 – On the Cognos Analytics home page, tap the New icon at the bottom of the window and click on Dashboard. 2 – You see predefined templates that contain grid lines for easy arrangement and alignment of visualizations and other elements in a dashboard.

What is the first thing you should think about before creating a dashboard? ›

1. Choose the right data sets. The first step in building an external-facing BI dashboard is to choose the right data sets. You'll want to select data sets that are relevant to your business, and that will give you the insights you need to make better-informed decisions.

References

Top Articles
Latest Posts
Article information

Author: Allyn Kozey

Last Updated:

Views: 6353

Rating: 4.2 / 5 (43 voted)

Reviews: 82% of readers found this page helpful

Author information

Name: Allyn Kozey

Birthday: 1993-12-21

Address: Suite 454 40343 Larson Union, Port Melia, TX 16164

Phone: +2456904400762

Job: Investor Administrator

Hobby: Sketching, Puzzles, Pet, Mountaineering, Skydiving, Dowsing, Sports

Introduction: My name is Allyn Kozey, I am a outstanding, colorful, adventurous, encouraging, zealous, tender, helpful person who loves writing and wants to share my knowledge and understanding with you.