{"id":10726,"date":"2017-01-17T10:55:45","date_gmt":"2017-01-17T16:55:45","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/blog\/?p=10726"},"modified":"2022-11-22T16:08:32","modified_gmt":"2022-11-22T22:08:32","slug":"how-to-build-a-dashboard-that-your-executives-will-love-2","status":"publish","type":"post","link":"https:\/\/www.mrc-productivity.com\/blog\/2017\/01\/how-to-build-a-dashboard-that-your-executives-will-love-2\/","title":{"rendered":"How to build a dashboard that your executives will love"},"content":{"rendered":"

\"Education\"Summary: Businesses have access to more data than ever before. But, is this data actually helping business leaders make more informed decisions? In many cases, the answer is “No.” Why? Far too few businesses actually capitalize on their data. In this article, you’ll learn how effective dashboards will help you capitalize on your data, as well as tips for building dashboards that executives will love.<\/em><\/span>
\n<\/a>
\n

\"photo
photo credit: Snapographic_com<\/a> via pixabay<\/a> cc<\/a><\/figcaption><\/figure><\/p>\n

The modern business has access to more data than ever before. The problem is, this data often hurts decision making. <\/p>\n

As mentioned in Reuters, \u201cDying for Business\u201d report, \u201cOne-third of managers are victims of \u2018Information Fatigue Syndrome.\u2019 49% said they are unable to handle the vast amounts of information received. 43% think that important decisions are delayed and their abilities to make decisions are affected as a result of having too much information.\u201d<\/p>\n

What\u2019s happening? Why are so many struggling with data?<\/p>\n

For some, they haven\u2019t set up standard reporting processes. Others have standard reporting processes, but their reports are ineffective. Still others use executive dashboards that are little more than charts and data on a page.<\/p>\n

Today, let\u2019s focus on that last point: Executive dashboards. When used correctly, executive dashboards cut through the clutter and give business leaders a clear view of the business. They drive action.<\/p>\n

The problem is, many executive dashboards fail at this primary objective. They are overwhelming. They\u2019re full of data, but don\u2019t really provide clear insights. They don\u2019t ultimately provide much value to your executives.<\/p>\n

So, how can you create effective dashboards that your executives will love? Today, let\u2019s answer that question. Here are a few tips:<\/p>\n

Understand your audience<\/h3>\n
\"photo
photo credit: geralt<\/a> via pixabay<\/a> cc<\/a><\/figcaption><\/figure>\n

The first step in creating a dashboard that your executives will love: Understand your audience. <\/p>\n

The fact is, not all executives care about the same data. For instance, the CEO will need different something different than the senior management team. The CMO will want far different data than the CIO.<\/p>\n

Talk to those who will use the dashboard (or dashboards). Answer a few important questions:<\/p>\n

What are their goals for the dashboard? If it is successful, how will you know?<\/p>\n

What metrics do they care about?<\/p>\n

Which metrics do they truly need? Now, this might sound like the last question, but it\u2019s much different. You\u2019ll find that some executives care about metrics that don\u2019t drive action. They\u2019ll want many different metrics on their dashboard–when they only really need a handful of them. <\/p>\n

The question is, how do you know which metrics to keep and which to leave out? How do you know which metrics your executives truly need? Ask yourself, \u201cWhat happens if this changes?\u201d about every metric. If the answer is ambiguous or if you don\u2019t know, it\u2019s probably not a metric that they need. It\u2019s not a metric that drives action. <\/p>\n

\n\u201cMake sure the information being presented is actionable,\u201d says Alison Trapp, Principal, Lyon Consulting, LLC<\/span><\/a>. \u201cIf your CEO isn’t going to do anything about a falling number of “likes” on the company’s Facebook page, don’t include it in the dashboard. Set triggers in advance. If you follow a six sigma methodology and have normal data, you’ll likely set these 1 or 2 standard deviations from the average. Otherwise, they are set at the point where you need to take action.\u201d\n<\/p><\/blockquote>\n

Keep it to a single page<\/h3>\n

One way to ensure that you\u2019re only including the most important data: Keep it to a single page. This forces the user to only keep those metrics that matter the most. It focuses the dashboard on only a few metrics.<\/p>\n

Avinash Kaushik summed it up nicely in his article, Five Rules of High Impact Web Analytics Dashboards<\/span><\/a>: \u201cIf your dashboard does not fit on one page, you have a report, not a dashboard. This rule is important because it encourages rigorous thought to be applied in selecting the golden dashboard metric. It acts as a natural barrier to cramming in too much information, makes data presentation easier, makes the dashboard more understandable.\u201d<\/p>\n

It\u2019s a great rule to follow, but one that is commonly ignored. In general, ineffective dashboards are usually the result of trying to do too much. They try to include too many features, or too much data. They try to fit as much information as possible on the screen. This negates the power of dashboards: Simplicity.<\/p>\n

\n\u201cYou want to have a few options that executives can toggle without giving them an overload of options or they can get bogged down in trying to slice the data,\u201d says Dustin Bolander, CIO of Technology Pointe<\/span><\/a>. \u201cFor example on our client utilization reports you can select by team or industry vertical. If you need more flexibility you have to look at a different report. Simple is better!\u201d\n<\/p><\/blockquote>\n

Give them insights (not just data)<\/h3>\n
\"photo
photo credit: Life-Of-Pix<\/a> via pixabay<\/a> cc<\/a><\/figcaption><\/figure>\n

The problem with most dashboards comes from a lack of insight, not a lack of data. They contain data, but rely on the executive to find insights. The problem is, the executive doesn\u2019t always understand the data in the way that a data analyst might. So, while the dashboard might do a great job at summarizing data, its meaning might not be clear to the end user.<\/p>\n

This article<\/span><\/a> sums up the issue perfectly:<\/p>\n

\u201cPeople who are closest to the data, the complexity, who’ve actually done lots of great analysis, are only providing data. They don’t provide insights and recommendations.<\/em>
\n
\nPeople who are receiving the summarized snapshot top-lined have zero capacity to understand the complexity, will never actually do analysis and hence are in no position to know what to do with the summarized snapshot they see.
\n<\/em>
\nThe end result? Nothing.
\n<\/em>
\nStandstill. Gut based decision making. No real appreciation of the delicious opportunity in front of every single company on the planet right now to have a huger impact with data.\u201d<\/em><\/p>\n

So, what\u2019s the answer? How can you provide insights that ensure your executives can take action on the data? As explained below, it helps to give them a \u201cplain english\u201d description of the data. This might include insights into what the data means, or recommendations based on the data.<\/p>\n

\n\u201cDocumentation and\/or brief descriptions of the metrics reported are necessary,\u201d says Dr. Jim Sullivan, Sr. Director, IT for Pharmaca Integrative Pharmacy<\/span>. \u201cThese should include a \u201cplain english\u201d description as well as a simple calculation, and explanation of the time frame for the data. This prevents debate about what a number actually means, and also provides insight into what steps the business may need to take to improve the metric performance.\u201d\n<\/p><\/blockquote>\n

Add context<\/h3>\n

\"dashboard\"<\/a>Suppose you\u2019re the CEO of a manufacturing company. Your dashboard shows that you\u2019ve shipped 75 widgets today, and that you\u2019ve had 5 damaged products returned. Are those numbers good? How do they compare with industry averages? Can they be improved? Is that better or worse than the previous day?<\/p>\n

I share this example to highlight one incredibly important dashboard aspect: Context. Sure, your dashboard might display data, but without context…it means very little. Without goals, historical data, or industry benchmarks, your data doesn\u2019t mean much.<\/p>\n

What\u2019s the best way to include context? With images and color. For instance, take a look at the image on the right. Not only do the gauges list the percentages, they’re color coded to add context. The orange color on the middle gauge illustrates that 55% is not an acceptable level, and should be investigated.<\/p>\n

This is just one example, but you get the idea. Effective dashboards use colors and images to tell a story.<\/p>\n

\n\u201cA picture can tell a thousand words,\u201d says Kenneth Ashe<\/span><\/a>, Project Manager at Prudential Financial. \u201cThis is especially true for dashboards. Utilizing visuals in dashboards are a great way to convey a message. In project dashboards, by reporting a project as green, yellow or red, an executive can quickly see how a project is trending. Visuals become even more important in financial dashboards. Instead of communicating with data tables, graphs and charts should be used to tell the story. Not only are they more visually appealing, they are often easy for audiences to understand.\u201d\n<\/p><\/blockquote>\n

Lets users dig into the data if necessary<\/h3>\n
\"photo
photo credit: blickpixel<\/a> via pixabay<\/a> cc<\/a><\/figcaption><\/figure>\n

A good dashboard will provide a high level view of your data and minimize noise. After all, executives want to look at their dashboard and get a big-picture view of the company. <\/p>\n

But, what if your executives need more information on a certain metric? That\u2019s where drill-downs come into play. For instance, if your dashboard displays product returns, it should also let the user drill down and see where products are being returned, reasons for the return, and any other pertinent information. An effective dashboard starts with a high-level view, and provides drill-down capabilities.<\/p>\n

\n\u201cDashboards that can be drilled down into to answer questions with either filters or click-through reports are essential,\u201d says Michael Shearer, Director, Marketing Operations, SelectHub<\/span><\/a>. \u201cThese drill-downs and filters can answer more detailed questions that always arise during dashboard reviews\/executive meetings.\u201d\n<\/p><\/blockquote>\n

Provide customization options<\/h3>\n

With dashboards, one size doesn\u2019t fit all. Different users want to see different data. Or, they may want to see the same data, but organized differently.<\/p>\n

Yet, I still see many dashboards that display a pre-determined set of metrics in a pre-set layout. While each department might get their own dashboard, users within that department are stuck with a static layout.<\/p>\n

For instance, a sales dashboard might display metrics like daily\/monthly product sales, geographical sales numbers, top customers, and salesperson performance, to name a few. If one sales manager needed additional metrics, or metrics that differ from the other sales manager\u2019s dashboards, they run into problems. They must either create a brand new dashboard themselves, or request a new dashboard from the IT department.<\/p>\n

If you really want to get the most out of your dashboards, deliver customizable dashboards. Give each executive the ability to adapt their dashboard to meet their own specific needs. <\/p>\n

Automate the data feeds<\/h3>\n

It\u2019s a mistake I see all too often. Businesses create dashboards that rely on manual data updates. While it may seem feasible at the time, this mistake can cripple your dashboard.<\/p>\n

Why is this bad? Besides the obvious time drain, it leads to out-of-date, inaccurate dashboards. While it may work for a little while, the employee in charge of updating the dashboard will eventually forget to make an update. Or, maybe they\u2019ll make a mistake as they\u2019re updating the dashboard.<\/p>\n

The results can be disastrous. Executives go on using the dashboard, without knowing the data is out of date or inaccurate\u2013resulting in misinformed decisions.<\/p>\n

If you plan on using your dashboard as a decision-making tool, you must automate your data feeds. Don\u2019t make your dashboard\u2019s accuracy rely on manual processes.<\/p>\n

Summary<\/h3>\n

These are just 7 tips for building dashboards that your executives will love, but the list could certainly be longer. If you would like to add anything to this list, I\u2019d love to hear it. Feel free to share in the comments.<\/p>\n","protected":false},"excerpt":{"rendered":"

Summary: Businesses have access to more data than ever before. But, is this data actually helping business leaders make more informed decisions? In many cases, the answer is “No.” Why? Far too few businesses actually capitalize on their data. In this article, you’ll learn how effective dashboards will help you capitalize on your data, as …<\/p>\n

How to build a dashboard that your executives will love<\/span> Read More »<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","slim_seo":{"title":"How to build a dashboard that your executives will love - mrc's Cup of Joe Blog","description":"Summary: Businesses have access to more data than ever before. But, is this data actually helping business leaders make more informed decisions? In many cases,"},"footnotes":""},"categories":[8],"tags":[12],"class_list":["post-10726","post","type-post","status-publish","format-standard","hentry","category-education","tag-business-dashboards"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/10726","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/comments?post=10726"}],"version-history":[{"count":10,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/10726\/revisions"}],"predecessor-version":[{"id":14196,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/10726\/revisions\/14196"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/media?parent=10726"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/categories?post=10726"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/tags?post=10726"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}