{"id":9890,"date":"2016-01-26T10:50:58","date_gmt":"2016-01-26T16:50:58","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/blog\/?p=9890"},"modified":"2023-03-13T15:44:27","modified_gmt":"2023-03-13T20:44:27","slug":"7-deadly-business-dashboard-mistakes","status":"publish","type":"post","link":"https:\/\/www.mrc-productivity.com\/blog\/2016\/01\/7-deadly-business-dashboard-mistakes\/","title":{"rendered":"7 harmful business dashboard mistakes"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-725\" src=\"https:\/\/www.mrc-productivity.com\/blog\/wp-content\/uploads\/2010\/11\/Education.jpg\" alt=\"Education\" width=\"76\" height=\"100\" \/><span style=\"font-size: 14px;\"><em>Summary: When used correctly, business dashboards will help you make sense of your data and drive your business. However, not all dashboards are created equal. Many businesses make key mistakes with their dashboards, which can limit their effectiveness and kill the project altogether. In this article, we explore a few of the most common mistakes, and how to avoid them.<\/em><\/span><br \/>\n<a name=\"20160125\"><\/a><!--more--><\/p>\n<figure id=\"attachment_9246\" aria-describedby=\"caption-attachment-9246\" style=\"width: 300px\" class=\"wp-caption alignright\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-9246\" src=\"https:\/\/www.mrc-productivity.com\/blog\/wp-content\/uploads\/2015\/06\/speedometer-653246_640-300x185.jpg\" alt=\"photo credit: geralt via pixabay cc\" width=\"300\" height=\"185\" srcset=\"https:\/\/www.mrc-productivity.com\/blog\/wp-content\/uploads\/2015\/06\/speedometer-653246_640-300x185.jpg 300w, https:\/\/www.mrc-productivity.com\/blog\/wp-content\/uploads\/2015\/06\/speedometer-653246_640.jpg 640w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><figcaption id=\"caption-attachment-9246\" class=\"wp-caption-text\">photo credit: <a href=\"https:\/\/pixabay.com\/en\/speedometer-speedo-rush-vollgas-653246\/\">geralt<\/a> via <a href=\"http:\/\/pixabay.com\/\">pixabay<\/a> <a href=\"http:\/\/creativecommons.org\/publicdomain\/zero\/1.0\/deed.en\">cc<\/a><\/figcaption><\/figure>\n<p>As data volumes grow, more organizations are gravitating towards business dashboards. Dashboards help these businesses make sense of their data&#8211;turning mountains of information into actionable insights.<\/p>\n<p>When used correctly, dashboards are powerful tools. They drive decision-making. They save time. They improve business processes. They alert leaders to problems before they get out of hand. The list could go on.<\/p>\n<p>The problem is, dashboards are often misused. Businesses make key mistakes when planning and building their dashboards. These mistakes limit the dashboard\u2019s effectiveness, and can even kill it altogether.<\/p>\n<p>What are these mistakes? Today, let\u2019s explore this topic and explain how to avoid each one. Here are 7 common mistakes businesses make with their dashboards:<\/p>\n<h3>1. Failing to define the dashboard\u2019s purpose<\/h3>\n<blockquote style=\"line-height: 1.7em; background-image: none; margin-left: 0; padding-left: 18px; height: auto;\"><p>\u201cOne big mistake is not being clear on what purpose dashboard is serving,\u201d says Joe Wang, CSO at <a href=\"http:\/\/www.servicepower.com\/\" target=\"_blank\" rel=\"noopener\"><span style=\"color: red; font-weight: bold;\">ServicePower<\/span><\/a>. \u201cA dashboard that is good for leadership is typically useless for operations and vice versa. Operational dashboard needs to tell you where the issues are so you don\u2019t waste time looking at everything. You can go straight to the problem. Leadership dashboard rolls up and is typically an average of everything.\u201d<\/p><\/blockquote>\n<p>Business dashboards come in all shapes and sizes, but typically fall into one of three categories. Here\u2019s a brief explanation of each:<\/p>\n<p><strong>Strategic Dashboards:<\/strong> Strategic dashboards help business leaders monitor company progress towards predefined goals. They help executives keep tabs on the strategic direction of the business.<\/p>\n<p><strong>Operational dashboards:<\/strong> Often used at the departmental level, these dashboards monitor day-to-day operations of their department. They help managers catch problems as they occur, and ensure that everything flows smoothly.<\/p>\n<p><strong>Analytical dashboards:<\/strong> These dashboards provide insights into data collected over time. They help users understand what happened in the business, and what changes they should make in the future.<\/p>\n<p>The problems arise when a business doesn\u2019t define their dashboard\u2019s purpose. Or, worse yet, they try to create dashboards that serve multiple purposes.<\/p>\n<p>What happens when you don\u2019t define your dashboard\u2019s purpose? You\u2019re left with a dashboard that doesn\u2019t fit anyone\u2019s needs.<\/p>\n<h3>2. Offering too much information<\/h3>\n<figure id=\"attachment_8147\" aria-describedby=\"caption-attachment-8147\" style=\"width: 180px\" class=\"wp-caption alignright\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8147\" src=\"https:\/\/www.mrc-productivity.com\/blog\/wp-content\/uploads\/2014\/07\/small_6909744081.jpg\" alt=\"photo credit: Walter Benson via photopin cc\" width=\"180\" height=\"240\" \/><figcaption id=\"caption-attachment-8147\" class=\"wp-caption-text\">photo credit: <a href=\"https:\/\/www.flickr.com\/photos\/55084317@N08\/6909744081\/\">Walter Benson<\/a> via <a href=\"http:\/\/photopin.com\">photopin<\/a> <a href=\"http:\/\/creativecommons.org\/licenses\/by-sa\/2.0\/\">cc<\/a><\/figcaption><\/figure>\n<p>It\u2019s probably the most common problem found in business dashboards. Rather than choose important metrics, the business tries to cram an overwhelming amount of data into a single dashboard.<\/p>\n<p>As a result, they negate the biggest benefit of a dashboard: Simplicity.<\/p>\n<blockquote style=\"line-height: 1.7em; background-image: none; margin-left: 0; padding-left: 18px; height: auto;\"><p>\u201cData Dumping is a common dashboard mistake,\u201d says Jordan Goldmeier, author of <a href=\"http:\/\/www.amazon.com\/Dashboards-Excel-Jordan-Goldmeier\/dp\/1430249447\" target=\"_blank\" rel=\"noopener\"><span style=\"color: red; font-weight: bold;\">Dashboards for Excel<\/span><\/a>. \u201cThis is the process of placing everything on a dashboard because you are either unsure of what stakeholders truly want or because you want to make everyone happy. Either way, the result is usually a confusing mess. Dashboards that attempt to be everything to everyone become nothing to anyone.\u201d<\/p><\/blockquote>\n<p>What\u2019s the general rule of dashboards? \u201cIf your dashboard does not fit on one page, you have a report, not a dashboard,\u201d states Avinash Kaushik in his article \u201c<a href=\"http:\/\/www.kaushik.net\/avinash\/five-rules-for-high-impact-web-analytics-dashboards\/\" target=\"_blank\" rel=\"noopener\"><span style=\"color: red; font-weight: bold;\">Five Rules of High Impact Web Analytics Dashboards<\/span><\/a>.<\/p>\n<p>\u201cThis rule is important because it encourages rigorous thought to be applied in selecting the golden dashboard metric,\u201d he says. \u201cIt acts as a natural barrier to cramming in too much information, makes data presentation easier, makes the dashboard more understandable.\u201d<\/p>\n<h3>3. Failing to automate data feeds<\/h3>\n<p>A dashboard is only as good as the data behind it. Any successful dashboard needs clean, current data. If you feed your dashboard old data, you\u2019re better off not creating one in the first place. This type of dashboard will lead to poor decisions, and will eventually be abandoned.<\/p>\n<p>However, many business make this very mistake. They design dashboards with the assumption that the data will get updated manually. While this may work in the short term, it\u2019s a long-term nightmare.<\/p>\n<blockquote style=\"line-height: 1.7em; background-image: none; margin-left: 0; padding-left: 18px; height: auto;\"><p>\u201cOne common mistake is failing to automate the data feeds,\u201d says Tim Montgomery, President of <a href=\"http:\/\/timitsolutions.com\/\" target=\"_blank\" rel=\"noopener\"><span style=\"color: red; font-weight: bold;\">TIMIT Solutions, LLC<\/span><\/a>. \u201cDo not make the mistake of designing a dashboard dependent on people supplying updates. Out of date data can be worse than no data at all, and people will not keep data up-to-date. Realize that in design phase.\u201d<\/p><\/blockquote>\n<h3>4. Displaying unclear metrics<\/h3>\n<p>Let me ask you a question: What makes an effective dashboard? Does it need fancy charts and graphs? Does it need real-time data?<\/p>\n<p>While the answer varies depending on your business, there\u2019s one aspect everyone can agree on: An effective dashboard is one that drives a decision. Too many dashboards amount to nothing more than charts on a page. Why? Because they\u2019re not designed around action. They\u2019re not designed to drive business objectives.<\/p>\n<p>An effective dashboard must deliver the message without forcing the user to dig around the data. How do you know if your dashboard is clear enough? As explained below, give it a simple test.<\/p>\n<blockquote style=\"line-height: 1.7em; background-image: none; margin-left: 0; padding-left: 18px; height: auto;\"><p>\u201cGive it the 5-second test,\u201d says Montgomery. \u201cAn executive must be able to &#8220;feel&#8221; good or bad within 5 seconds of looking at the dashboard. Use Red\/Yellow\/Green and\/or other visual effects to achieve this. If it takes longer than 5 seconds it&#8217;s back to drawing board!\u201d<\/p><\/blockquote>\n<p>How do you know which metrics to add to your dashboards? Before adding any metric, ask yourself this question: \u201cWhat action will this metric drive?\u201d If the data spikes or falls, will that metric lead to a decision? If you don\u2019t know, that metric doesn\u2019t belong on your dashboard.<\/p>\n<h3>5. Building the same dashboard for different users<\/h3>\n<figure id=\"attachment_7683\" aria-describedby=\"caption-attachment-7683\" style=\"width: 300px\" class=\"wp-caption alignright\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-7683\" src=\"https:\/\/www.mrc-productivity.com\/blog\/wp-content\/uploads\/2014\/03\/man-65049_640-300x225.jpg\" alt=\"photo credit: geralt via pixabay cc\" width=\"300\" height=\"225\" \/><figcaption id=\"caption-attachment-7683\" class=\"wp-caption-text\">photo credit: <a href=\"http:\/\/pixabay.com\/en\/man-despair-problem-null-one-65049\/\">geralt<\/a> via <a href=\"http:\/\/pixabay.com\/\">pixabay<\/a> <a href=\"http:\/\/creativecommons.org\/publicdomain\/zero\/1.0\/deed.en\">cc<\/a><\/figcaption><\/figure>\n<p>A single dashboard cannot be all things to all people. Yet, many make the mistake of trying to cram their dashboards full of data that applies to different audiences.<\/p>\n<p>What happens? The dashboard is so overwhelming, no one uses it.<\/p>\n<p>Before creating a dashboard for any group of users, do your research. Understand their goals, needs, and technical skill level. Then, create a dashboard focused on that user group.<\/p>\n<p>But, it doesn\u2019t stop there. Different users within the same user group want their dashboards customized in different ways. Some want to see different data. Others want their dashboard formatted in a different way. As explained below, this creates a big problem if not addressed from the start.<\/p>\n<blockquote style=\"line-height: 1.7em; background-image: none; margin-left: 0; padding-left: 18px; height: auto;\"><p>\u201cI\u2019ve seen too many businesses fall into the customization trap after their dashboard is released,\u201d explains Rick Hurckes, Services Director at <a href=\"https:\/\/www.mrc-productivity.com\/\" target=\"_blank\" rel=\"noopener\"><span style=\"color: red; font-weight: bold;\">mrc<\/span><\/a>. \u201cEvery user wants something a little different, which traps the dashboard creator in an endless loop of customizations. One way around this problem is to provide users with customizable dashboards. Give users the option to control which graphs\/charts to display on their dashboard as well as the layout. This lets every user customize their own dashboards, and helps you avoid the customization trap.\u201d<\/p><\/blockquote>\n<h3>6. Misusing color<\/h3>\n<figure id=\"attachment_9164\" aria-describedby=\"caption-attachment-9164\" style=\"width: 300px\" class=\"wp-caption alignright\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-9164\" src=\"https:\/\/www.mrc-productivity.com\/blog\/wp-content\/uploads\/2015\/05\/beads-209341_640-300x200.jpg\" alt=\"photo credit: hodihu via pixabay cc\" width=\"300\" height=\"200\" srcset=\"https:\/\/www.mrc-productivity.com\/blog\/wp-content\/uploads\/2015\/05\/beads-209341_640-300x200.jpg 300w, https:\/\/www.mrc-productivity.com\/blog\/wp-content\/uploads\/2015\/05\/beads-209341_640.jpg 640w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><figcaption id=\"caption-attachment-9164\" class=\"wp-caption-text\">photo credit: <a href=\"http:\/\/pixabay.com\/en\/beads-colorful-macro-many-color-209341\/\">hodihu<\/a> via <a href=\"http:\/\/pixabay.com\/\">pixabay<\/a> <a href=\"http:\/\/creativecommons.org\/publicdomain\/zero\/1.0\/deed.en\">cc<\/a><\/figcaption><\/figure>\n<p>When used correctly, color is a powerful tool in dashboards. It helps users identify good and bad trends at a glance, without the need to examine every data point.<\/p>\n<p>The problem is, color is often misused. When used incorrectly, color will detract from your dashboard and make it even more confusing.<\/p>\n<p>How is color misused? As explained below, color is misused in two common ways:<\/p>\n<blockquote style=\"line-height: 1.7em; background-image: none; margin-left: 0; padding-left: 18px; height: auto;\"><p>\u201cOne common mistake found in many organizations&#8217; first iteration of executive dashboards is a misuse of color,\u201d says <a href=\"http:\/\/www.linkedin.com\/in\/douglasrbriggs\/en\" target=\"_blank\" rel=\"noopener\"><span style=\"color: red; font-weight: bold;\">Douglas Briggs<\/span><\/a>, Director, Business Intelligence at Washington University in St. Louis. \u201cWhile color is often one of the most heavily-requested features of a dashboard for its ability to draw visual attention to anomalous data conditions effectively and quickly, organizations often misuse color in dashboards in one or more of two distinct ways:<\/p>\n<p><strong>Overuse of color:<\/strong> Companies will often populate their initial draft of a dashboard with a variety of visual data displays, each using color. This can create a visual presentation that has too much of a &#8220;carnival&#8221; feel to users, whose eyes become distracted by each separate use of color. The end result is that users find it impossible to rely on visual cues that color is meant to create in order to focus their attention on the most important pieces of data shown on the dashboard. Organizations can fix this by defining clear expectations for what expected data ranges or values are for each represented graphic or metric and leveraging color only for meaningful exceptions.<\/p>\n<p><strong>Conflicting &#8220;meaning&#8221; of color:<\/strong> A more subtle misuse of color occurs when companies mix metrics on a dashboard that have different (or even inverted) value scales. Using green to show high values and red to show low values might be consistent for a sales target dashboard, unless the metrics are for out-of-stocks (for example), when low values are preferable. Companies using colors to designate value ranges need to adopt a strategy that designates a single palette of colors that is applied not based on the values of the metrics, but on the meaning of the components themselves (i.e. &#8220;green is good, red is bad&#8221; or &#8220;green is stable, red is unstable&#8221;).\u201d<\/p><\/blockquote>\n<h3>7. Providing no context<\/h3>\n<p>A common mistake with dashboards revolves around their lack of context. Without context, your data means nothing.<\/p>\n<p>What does that mean?<\/p>\n<p>For instance, suppose you have a chart that lists website conversion rates. It tells you what percentage of website visitors purchased your product.<\/p>\n<p>Now, suppose your conversion rate is 10%. Is that good? Is that an abnormally high conversion rate, or a low one? Can it be better? Without context in your dashboard, you can\u2019t answer those questions.<\/p>\n<p>So, how can you provide context in your charts? Here are three ways:<\/p>\n<p><strong>Compare your numbers with industry standard.<\/strong> If available, track down the industry standard for that metric, and list it on your chart. This gives you a good sense as to how well you\u2019re doing in that area. For instance, the industry standard conversion rate might be 1%&#8211;meaning your conversion rate is great by comparison.<\/p>\n<p><strong>Compare your numbers with your business goal.<\/strong> One of the most common ways to provide context involves listing the goal on the chart. This not only lets you know how you\u2019re doing, it gives you something to shoot for.<\/p>\n<p><strong>Compare your numbers to year-over-year results.<\/strong> Every business strives to at least improve on the last year\u2019s performance. Listing your statistics from the last year (or month) at the same time, helps you understand if your business is moving forward or falling behind.<\/p>\n<h3>Summary<\/h3>\n<p>While this list could certainly go on, the points listed above are some of the most common dashboard mistakes. What do you think? Would you add anything to the list? If so, please feel free to share in the comments.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Summary: When used correctly, business dashboards will help you make sense of your data and drive your business. However, not all dashboards are created equal. Many businesses make key mistakes with their dashboards, which can limit their effectiveness and kill the project altogether. In this article, we explore a few of the most common mistakes, &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.mrc-productivity.com\/blog\/2016\/01\/7-deadly-business-dashboard-mistakes\/\"> <span class=\"screen-reader-text\">7 harmful business dashboard mistakes<\/span> Read More &raquo;<\/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":"7 harmful business dashboard mistakes - mrc&#039;s Cup of Joe Blog","description":"Summary: When used correctly, business dashboards will help you make sense of your data and drive your business. However, not all dashboards are created equal."},"footnotes":""},"categories":[8],"tags":[12],"class_list":["post-9890","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\/9890","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=9890"}],"version-history":[{"count":9,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/9890\/revisions"}],"predecessor-version":[{"id":14644,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/9890\/revisions\/14644"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/media?parent=9890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/categories?post=9890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/tags?post=9890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}