Your Essential Guide to Dashboards
Introduction
At Hurree, we like to consider ourselves data dashboard experts. Not only do we have a platform that lets you build effective and beautiful dashboards (sorry, shameless plug), but our team here uses them everyday. From sales and marketing to operations and development, everyone at Hurree uses them in some way, shape, or form. So, we know a thing or two about how to create dashboards that will accelerate business growth, and a whole host of other great things that we will delve into later.
Our hope is that by the end of this guide, you’ll have everything you need to plan, design, build, and share great dashboards that actually help you solve problems and achieve your goals. Over the course of this guide, we’ll cover:
- What a dashboard is
- The benefits of a dashboard
- The different types of dashboards you can build
- The elements of a dashboard
- Dashboard design basics, and
- Common dashboard mistakes to avoid
Let's get started!
Dashboard Basics
What is a dashboard and do you actually need to use them?
What is a dashboard?
Simply put, a dashboard is a highly visual display of data that is a useful tool in keeping businesses on track to achieving their goals and objectives. It provides a centralised, at-a-glance view of the most important information, allowing teams to get a better understanding of their performance and identify changes, both positive and negative, in real-time.
Dashboards are used to track KPIs and metrics and are automatically populated using various data sources and channels. Even if you have not used a dashboard in business, it’s likely that you’ve used one before, whether it’s your car dashboard or your fitness tracker.
Benefits of dashboards
Dashboards are a great way to collate your data for a multitude of reasons. Here is a list, though not exhaustive, that will help you see why dashboards can be a key tool for your team.
Time saving
With incomprehensible amounts of data being created daily, it’s not an easy feat trying to sort it and gain value from it. The more data that is created, the more difficult it is to accurately get an understanding of what the data is telling you. Think about the last time you put together a monthly report or a management report. It probably wasn’t a quick task, and chances are you had to visit numerous channels and platforms to export the data, and then try to make sense of it. This is where dashboards present a solution. They condense large volumes of data from multiple sources and automatically populate within your dashboard, saving you valuable time.
Visualise data for better understanding
Dashboards are highly visual and present various kinds of data in one single place in the form of graphics, charts, tables and gauges. Data presented in this way makes it much easier to digest and obtain a high level overview of key data points, without needing to be highly skilled at data analysis. Displaying your data in a visual way will allow you to spot patterns and trends, which otherwise might have been missed when viewing on a spreadsheet in a purely numerical format.
Customisable
What data is important to one business may not be for another, which is why being able to customise your dashboard is so crucial. Any good dashboard will give you the option to include what you want, and exclude what you don’t, giving you a visualisation that will display only the most important metrics. This, in turn, helps you to see how your business is doing across multiple teams and areas.
Improves decision making
Dashboards display the most important data, giving you a more accurate and comprehensive picture of what’s actually happening. By gathering data from multiple sources and presenting it in one place together, you have more context which allows for more agile and quicker decision making. The user will not have to wade through data that isn’t relevant and potentially distracting from the key decisions that need to be made.
Real-time monitoring
If you have to wait on reports generating or data exporting, it might be too late to make any adjustments to your strategy. With a dashboard updating automatically, the lag time is significantly reduced, giving you access to accurate, real time and up to date data. Dashboards also significantly reduce the chances of inaccurate data caused by human error ending up in reports.
Data transparency
Using dashboards means teams and departments will no longer have to work in data silos, not knowing what is going on in other areas, which is particularly useful for teams or colleagues who work remotely. With a shared dashboard, each member can regularly check progress and stay on top of developments, rather than having to wait for information to be shared manually. By removing data silos, everyone has visibility of what’s working and what’s not, helping to foster a culture of high performance and productivity.
How dashboards are used in reporting
So by now, it should be evident that dashboards are great tools to help organisations take better advantage of the vast amounts of important data and information at their disposal. Using dashboards in the creation of your reports is a wise decision for many reasons, the main one being that you will mitigate the risk of including any incorrect data in your reports.
Automated dashboards present data exactly as it appears in the original source, meaning there is no chance of any mistyped numbers or typos in your reports. This in itself, helps to provide accurate, transparent and reliable data, not to mention saves you valuable time.
Source: Forbes
We won’t discuss all the benefits of using dashboards again (as we’ve just discussed them in-depth above), but whichever way you are using dashboards, it’s important to be aware of the main differences between dashboards and reports. While both serve the same purpose, that is to help make data-driven decisions and show progress, there are slight differences between them that we will look into further below.
What's the difference between a dashboard and a report?
It’s probably important to look at the difference between a dashboard and report when looking at how you can effectively use dashboards in your reporting cycle. Reports are static documents, featuring historical data from a specific point in time. They will sometimes use visuals to highlight relevant information, but they will more than likely include a plethora of raw numbers. That’s because the purpose of a report is to provide detailed analysis of data at any given point, and will likely be used for specific purposes like monthly leadership meetings, annual reviews, etc.
Dashboards, on the other hand, are living documents. A good dashboard feeds real-time data into a platform that provides visualisations. It is meant to be a high-level overview of a curated set of KPIs and metrics that answer a specific question.
Thus, reports tend to be more detailed than dashboards, and likely much longer. They will offer the opportunity for very in-depth analysis, so require a large effort to build and share. Dashboards are built to be efficient and easy to update, and are tools for specific circumstances.
Does my business need a dashboard?
The question, then, is when do you need a dashboard? Dashboards are most appropriate when you need to provide high-level insight into a complex system, for example, to a management team or c-suite.
If the question is ‘does my business need a dashboard?’ the short answer is yes. Imagine driving a car. Would you technically be able to get to your destination without elements like a speedometer, fuel gauge, or sat nav? Yes. Does having those elements make your drive not only more efficient but safer? Also yes.
Source: Media Education Centre
Data dashboards function much in the same way. You don’t strictly need one to do your day-to-day job, but most processes will be much smoother and more efficient if you incorporate one.
Types of Dashboards
A comprehensive overview of the four main types of business dashboard.
Knowing you need a dashboard is only half the battle - you also need to know what type of dashboard is right for you. This is more than knowing you want to track marketing KPIs as opposed to sales data. There are four main types of dashboard that teams and companies will use, either on their own or in combination with one another.
Operational dashboards
Operational dashboards are for when you want to monitor specific processes or, as the name states, operations. One of the defining features of an operational dashboard is the shorter timeframes, tracking real-time or transactional data against your key metrics or KPIs. That’s because the objective of people using operational dashboards is to monitor what is happening right now.
Operational dashboards are designed to be integrated into your daily workflow. Think of a call centre or direct sales team - they want to see what is going on as it happens, as it will actually affect their day-to-day activity. With that in mind, operational dashboards should also contain contextual data that informs decision making.
Because of all this, operational dashboards have to have a fairly detailed view, looking at granular data that will show you progress towards a target and facilitate real-time action.
Operational dashboards help teams be proactive and get in front of any potential issues. For example, if a call centre team is using an operational dashboard, they can track things like call time, dropped calls, and complaints in real-time to ensure their SLAs stay in the green.
Example
An operational dashboard, as mentioned, will show real-time performance. That looks different for different teams, but a marketing team may use it for something like paid search campaign management. This would allow you to see how a campaign is performing and address potential issues. It might include metrics such as:
- Cost per acquisition
- Number of clicks
- Click through rate
- Cost per click
- Spend across a set period of time
- Total spend
- ROI
Check out more about marketing dashboards here.
Strategic dashboards
Strategic dashboards are used when you need a high-level overview of what’s going on in the business, to identify opportunities and issues. They can sometimes be known as executive dashboards as they allow senior management and executives to monitor the status of KPIs. Whereas operational dashboards look at the day-to-day, strategic dashboards look at long-term strategies and high-level metrics. Essentially, these types of dashboards help you understand the overall health of your team or business by summarising performance over a set period of time, like weekly or monthly. The important thing to remember is that these dashboards are designed to be checked at regular intervals so you can keep on top of your performance against your chosen KPIs.
Using benchmark data, strategic dashboards are used to align the performance of departments and teams with the overall business strategy. The best strategic dashboards will aggregate data from multiple sources to ensure that all areas of performance are being tracked accurately. The type of data you’ll see on a strategic dashboard are things like KPIs, balance scorecards, sales performance figures, etc.
Example
Not surprisingly, strategic dashboards are great tools for management teams. Think of data and KPIs that you would present at a board meeting - easy to see what’s going on but detailed enough that it provides context for decision making. A lot of what goes into a management dashboard will show current performance against targets or vs a previous period. Some good examples of what to include:
- Revenue: target vs actual
- Financial performance compared to previous year
- New customers compared to previous year
- New customers: target vs actual
- Revenue per customer: target vs actual
- Revenue per customer year on year
- CAC vs CLV
Analytical dashboards
As the name suggests, analytical dashboards are used to analyse large amounts of data. These work best when looking at historical information as a means of investigating trends, and consequently predicting outcomes. Analytical dashboards are a great tool to discover insights and actually establish the targets you’ll be tracking with other dashboards.
However, analytical dashboards can be very detailed and not as intuitive to use. They were developed by and for the use of data analysts, and include a large volume of data across multiple variables. In other words, the data displayed tends to be quite complex, but they are also quite customisable when used by the right teams. If you have the right skill level, analytical dashboards allow you to interact with data exploration and uncover fresh insights with filters, brushing, series selection, data drilling, and other features. They do this by incorporating advanced business intelligence features like drill-down and ad-hoc querying – allowing the user to explore more of the data and get different insights.
Not every business or team will need to use analytical dashboards, but they can be very useful in certain situations.
Example
Financial performance can be tracked and displayed well using the detailed nature of an analytical dashboard. The example below focuses on performance that can help senior management track spend and create specific operational processes to make decisions going forward. It includes metrics such as:
- Return on assets
- Working capital ratio
- Return on equity
- Debt-equity ratio
- Balance sheet
Tactical dashboards
Tactical dashboards fall somewhere between strategic and operational. They are used by line managers or team leaders to analyse and monitor processes, and like other dashboards, facilitate decision-making. What makes tactical dashboards different from others is that they capitalise on the interactive nature of dashboards, designed to be interactive in the way users interact with the data.
While strategic and operational dashboards operate to monitor processes and troubleshoot, tactical dashboards are meant for in-depth analysis, particularly in teams or companies where an analytical dashboard either isn’t possible or appropriate.
What this means is that tactical dashboards provide the users with the ability to filter data, segment information, and more, in a way that allows you to detect patterns and opportunities easily. Think of it as analysis over monitoring. You’d likely use tactical dashboards when setting out company-wide objectives and OKRs, or perhaps even looking at long-term planning.
Example
For marketers, a tactical dashboard is great for measuring the performance of things like social media campaigns. Set up properly, it allows you to drill down into the different channels, ensuring you have enough data to amend your strategy going forward. KPIs and metrics that you may track here would be:
- Followers
- Impressions
- Link clicks
- CTR
How to choose the right dashboard for you
Dashboards shouldn’t be scary. In fact, they are literally meant to make your life easier. But we know it can be a little daunting to choose the right type of dashboard for your team or business. Like with most things, you first need to consider what you’re trying to achieve. In other words, what is the purpose of your dashboard? Are you tracking day-to-day processes? Are you using it to provide high-level analysis? The answers to these questions will provide you with a basis for choosing your dashboard.
However, it can get a bit tricky when you’re looking at the different options, and in some cases, you may need to use more than one. But here are a few questions that will help you decide what type of dashboard is best for you.
What's your question? | Operational | Strategic | Tactical or Analytical |
What problem are we trying to solve? | Using real-time data to fix day-to-day issues | Measuring overall business health against target KPIs | Better view of trends and deeper data insights |
Who will use the dashboards? | Teams and their managers | Senior management including c-suite | Middle management (analysts and execs) |
What are we measuring? | Daily performance | Quarterly and annual performance | Performance issues, weekly/monthly performance |
What are our goals? | Better data awareness on the team and fixing process issues quickly | Achieving KPI targets | Better visibility into performance against key objectives |
Dashboard Design
KPI measurements
Dashboards are not just about throwing together data, they should have a clear purpose behind them and provide a way to track progress, and KPI measurements are one of the best ways to do that. Effective dashboards will display KPI measurements in a way that provides meaningful insight and leads to real action.
You can even take this a step further. A great dashboard, as opposed to a good one, will not only show your KPI measurements, it will also show if you’re on track to hit your goals. Let’s use our marketing dashboard as an example, an effective dashboard would have a way of measuring KPIs like conversion rate, customer acquisition cost, etc. However, an even more effective dashboard would show your current performance against your target performance, so you can always see what you’re doing at-a-glance.
Data visualisation
Part of being able to track your KPIs on a dashboard is effective visualisation of your progress and data. Being able to see your key metrics and KPIs in a graphic way is one of the reasons dashboards exist. Without the visual representation, you’re really just putting numbers on a page.
Some of the elements you’ll want to make sure you have access to are:
Real-time data options
Not every dashboard you create will require real-time data, but having the option - or close to it (think of a few hours’ delay) - is an absolute must. This means your dashboards maintain relevance allowing you to make timely and accurate decisions. This is especially important for operational dashboards as they rely completely on making up-to-the minute decisions.
If you’re tracking call-centre performance using an operational dashboard and your data is lagging, you could end up in quite a difficult situation.
Let’s say, for example, your call volume is showing as low, but that data is actually from an hour earlier and you have since had a large increase in calls. If you’re using the older data, you may let some staff go home early or go on break, causing major issues for the team.
Sharing options
A dashboard isn’t effective if you have to physically present it to stakeholders anytime they want access to the data. That’s why having a number of sharing options is super important. You also don’t want to have to provide account login details to every person who may want to see your dashboard. This makes it hard to manage the quality of the data and, let’s be honest, there are a large number of stakeholders out there who aren’t exactly tech savvy. So what options should you be looking for?
- Email: being able to send a snapshot or link to the dashboard via email means you can share your dashboard with anyone, regardless of their technological know-how.
- Link sharing: similar to the email options, being able to share a link that provides a viewer with a scaled down version or snapshot of the dashboard means you can send it via any of your messaging tools (i.e. Slack, Teams, Google Hangouts).
- Reduced user permissions: for people who maybe want to be able to look at different filters or dig into the data, having the options of reduced permissions or ‘Guest’ logins means you can protect the integrity of the dashboard, while still allowing them to get what they need from it.
The basics of dashboard design
Now that you know what goes into a good dashboard, the next step is building a dashboard that looks the part. How do you go about doing that? Well, it will depend on your specific dashboard, but it’s important to keep in mind these basic tips.
Glorious purpose
By the time you’re designing your dashboard, you should already know what and who it’s for. This information isn’t just useful in deciding what information to include, it’s also really important for how you include that information.
Use hierarchies to show priority
One really great way to make your dashboard easily readable is to structure data in a way that makes it clear what’s important. In other words, use hierarchies to place the most important information where people are most likely to see it.
One model of doing this is using an inverted pyramid structure. With this type of layout you would have important details at the top of the dashboard, trends in the middle, and then the more granular details at the bottom (if at all).
Follow the 5-second rule
Nothing to do with food, this rule posits that you should be able to understand all of the important data in 5 seconds or less. While it’s not a hard and fast rule, you should aim to make sure your data is laid out in a way that all of your FAQs can be answered at a glance. The whole point of a dashboard is to distil large swathes of data into a digestible form, and no one wants to be digesting for more than a few minutes.
This is especially true when you’re sharing your dashboards at an executive or c-suite level. Your CEO doesn’t want to spend an hour of their time deciphering the data, so ensuring your dashboard is built to be read quickly will make everyone happy.
Less is more
It’s a cliche for a reason. Too much information or too many visuals not only make a dashboard feel cluttered, but it can actually drown the important information you’re trying to share.
Source: National Library of Medicine
There are no hard and fast numbers, but keeping visualisations on any one dashboard below 10 means there is room for it to be seen, and it won’t be overshadowed.
Some tips to keep in mind:
- Round your numbers. No one needs to see that your conversion rate is 23.55672%
- Keep your visualisations to 10 or below. Anything more should be split into 2 dashboards.
- Use size and position to your advantage. They can show hierarchies and groupings without having to add more text to the dashboard.
Choose the right visualisations
It’s not just about the number of visualisations but making sure you choose the right type. Dashboard design is all about efficiency, but that doesn’t mean variety is not also appreciated.
When choosing your visualisations, you want to consider the type of information you’re trying to show. With each different type of relationship or correlation, a different visualisation will likely be appropriate.
For example, if you’re trying to show a comparison between multiple elements, a pie chart probably isn’t the best choice.
Don’t forget the context
A number on a dashboard only means as much as the context around it. Yes, you got 27 MQLs this week, but what does that mean? Is that lower than last week? Did those leads go on to convert at all?
So how do you provide context on a dashboard? It’s very important to tell a story, and there are a few ways to do that. Showing the complete cycle or ‘end’ point of a variable helps. Using our example above, you could contextualise that by showing the performance of the entire funnel.
# MQLs → # SQLs → # Opportunities → Customers
Past data is also very useful as it displays progress. So if you’re looking at the number of MQLs, why not use a visualisation to show that number compared to the last period of measurement. A line graph is a good option, or even just a percentage increase.
Review and evolve your dashboards
There’s always room for improvement, no matter how well thought out and designed your dashboard is. One of the best things you can do to make your design effective is to ask task the users and stakeholders for feedback on a regular basis. Have them think about the following:
- What are the elements they use often and why?
- Are there any elements they don’t use at all?
- Is anything missing that they’d like to see?
- Has the dashboard changed their processes? How?
This specific feedback will drive any improvements or changes to the dashboard. It’s important to ensure the dashboard is fit for purpose, and that may change over time, especially as your business goals evolve. What was important to you and your team in 2019 won’t necessarily be what’s important now, and it’s important that the tools at your disposal reflect that.
Common Dashboard Mistakes
The dos and don'ts of dashboards.
So now you know what to do to build a great dashboard, it would probably also be helpful to know what not to do.
Here are some of the most common mistakes when it comes to dashboards, and most importantly, how to avoid them.
Not defining your purpose
We’ve said it a few times in this guide, but a dashboard can only be effective if it is fit for purpose. For this to happen, you need to know your purpose. Too many businesses and teams create dashboards for the sake of it or because they think they need to have a place to track their numbers. Not only does a purpose drive your team to action, it will dictate what type of dashboard you should actually build.
Want to monitor overall business performance? A strategic dashboard would be most appropriate. Are you monitoring day-to-day processes and performance in order to ensure a defined service level? Then you’ll need an operational dashboard.
Only when you define why you’re building your dashboard, will you be able to then determine how to build it effectively.
Not automating your data
Dashboards, obviously, are only as good as the data that feeds them. You need clean, and more importantly, current data for a dashboard to be effective. If your information is old and out of date, you may as well not have a dashboard to begin with.
Manual data collection can be a huge barrier to keeping a dashboard up-to-date. While automating data collection can seem like a massive process in the short-term, long-term it will save time and ensure you are working with the most accurate information.
Manual data collection is inefficient as well as being ineffective. The best thing to do would be to invest in software - whether third-party or something part of your current tech stack - that integrates with your tech stack and pulls data from your tools in as close to real-time as possible.
Metrics and KPIs are unclear
Good dashboards drive decisions. They are not just charts and metrics arranged nicely on a screen. For a dashboard to drive action, its metrics need to be scannable and easy to read. Each KPI and metric included within your dashboard should be clearly labelled with the data that is being presented. If there is a chart showing the sales revenue, then make sure it is labelled to say this, otherwise no one will know what data is being shown. Aim to use short and concise language, providing a clear description, without overloading the dashboard with unnecessary, long winded titles and explanations. This is particularly relevant when sharing the dashboard with other team members who might not like to admit they do not understand the data or are too proud to ask for an explanation.
Not building with your audience in mind
A cluttered dashboard is an ineffective dashboard. One reason for the clutter is not knowing your audience or the end-user of the dashboard. When you don’t know or take into account who is actually going to be using this information, the impulse is to include data that will be applicable to as many users as possible.
However, a dashboard can’t (and shouldn’t) be everything to everyone. Different stakeholders require different information. When you try and combine data and information meant for multiple user groups in one dashboard, you end up with a dashboard that isn’t clear or useful.
Don’t be afraid to create more than one dashboard if needed. The key is to define your end users before you map out your dashboard, so you know who will be using it and what data they will need.
No context
Without context your data means nothing, it’s just a collection of numbers and charts. For example, your dashboard may show your website conversion rate is 22%. But what does that actually mean? Is that good? Is it higher or lower than normal? How many of those contacts went on to purchase? Context, in this sense, provides meaning to your metrics and KPIs by placing them in the framework of a greater breadth of data.
So, how do you provide context?
- You can compare your data to industry benchmarks. This isn’t always ideal, but can be useful if you don’t have your own historic data.
- Set an overall business goal or target and compare (and include that as a performance indicator on your dashboard). Comparing your performance to an arbitrary target or goal allows you to properly track your progress and correct course if necessary.
- Look at trends in your own numbers (i.e. YoY results). This is probably the best way to contextualise your data, as it compares your current performance to your past performan
Ignoring design basics
Dashboard design is almost as important as the data itself. When people are seeing their dashboards fail to make an impact, a lot of times it’s because they are heeding the design basics. Too many charts, too much colour, not enough whitespace, no labels or legends - these are all design issues that can make your dashboard unreadable.
So how do you avoid this? Follow the design basics we outlined earlier. Feedback directly from the source is the only way to gauge how effective your dashboard is for your users. And don’t be afraid to make wholesale changes to your look and feel if it means it’s easier for your stakeholders to use.
Just as important as choosing the right information, your dashboard will only be effective if you have the right software. There are a host of different options out there, each with their own strengths and weaknesses, but there will be key functionality to look out for.
Data sources and integrations
This is the most basic but most important element of any good dashboard software - the ability to pull information from multiple data sources. Even more important is that it can integrate and pull data from the tools already in your tech stack.
A good dashboard tool will have connectors to data sources like Facebook, Google Analytics, or HubSpot, for example. While a lot of tools will offer plug and play integrations , there are a lot of dashboards out there that will work with you to set-up bespoke integrations based on your specific needs; however, this level of customisation often comes at a much higher cost.
How often data updates
Although basic, this functionality is super important, having a direct impact on the type of dashboards you want to create. Operational dashboards specifically require near real-time data to function properly. When you’re looking for dashboard software, you need to take this into account. Having up-to-date, relevant data is a key requirement in today’s fast-paced world, where information from yesterday will not be enough for today.
Collaboration and sharing options
By their very definition, dashboards are about collaboration, so any good dashboard software will have multiple options for sharing and collaborating. In terms of sharing, think about the following:
- Does the tool offer the ability for users to log in themselves?
- Does it provide different levels of access?
- Can you share a snapshot of the data easily with less tech-savvy stakeholders?
Ideally, your dashboard software will have multiple options so that you have the flexibility to share your data however your stakeholders prefer.
User experience
All the bells and whistles of your dashboard software won’t mean much if it’s difficult to use. Not only should your dashboards be easy for stakeholders to navigate, they should also be easy to build and navigate. No one wants to have to employ a developer or coding expert to set up and update your dashboard. Look for a dashboard software that seamlessly integrates with your existing tools and platforms and has quick, easy-to-add widgets.
An important feature to consider is the ability to show only the data that you choose, as one size doesn’t always fit all. What metrics are relevant for one business may not be relevant to another so you need a dashboard that will allow you to customise the widgets that you add.
Visualisation options
We’ve talked about how important having the right type of visualisation is, and that’s why you should ensure any dashboard tool you use has the right chart, graph, table, etc. for the data you want to display.
Source: Shift
Dashboards, as we’ve tried to outline here, are essential tools in any reporting arsenal. If you want to get started building great dashboards, now, here are some resources to get your started.
- Sign up for a free Hurree trial and start building your dashboards today
- Check out the Hurree blog for best practice, tips and tricks
- Read through our Essential Guide to KPIs so you can make sure you’re tracking the right KPIs on your dashboard
Contributors:
Ashleigh McCabe
Content Marketing Specialist
Melissa Hugel
Content Marketing Manager
Jonny Robinson
Graphic Designer
From Our Blog
Stay up to date with what is new in our industry, learn more about the upcoming products and events.