{"id":27701,"date":"2024-05-17T05:00:00","date_gmt":"2024-05-17T03:00:00","guid":{"rendered":"https:\/\/sii.pl\/blog\/?p=27701"},"modified":"2024-05-20T11:57:18","modified_gmt":"2024-05-20T09:57:18","slug":"how-to-design-a-report-dashboard-effectively","status":"publish","type":"post","link":"https:\/\/sii.pl\/blog\/en\/how-to-design-a-report-dashboard-effectively\/","title":{"rendered":"How to design a report\/dashboard effectively?"},"content":{"rendered":"\n<p>Designing reports\/dashboards\/Business Intelligence (BI) applications is a vast topic. This stage of implementation is often treated hastily, with lower priority. We allocate little time to it due to deadlines or limited budgets. But <strong>should this be the approach to reporting?<\/strong> Should analytics be treated as a lower priority, often relegated to second or third place?<\/p>\n\n\n\n<p>Reporting is the primary tool for improving our business, enhancing quality, breaking new barriers, and evolving. Of course, it doesn&#8217;t replace operational work, which is the foundation of a thriving enterprise, but with an <strong>efficient reporting system<\/strong>, we can find answers to questions:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Where?<\/li>\n\n\n\n<li>When?<\/li>\n\n\n\n<li>How?<\/li>\n<\/ul>\n\n\n\n<p>And make decisions that can steer our business in the right direction.<\/p>\n\n\n\n<p>One of my favorite quotes,<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>Everything is designed. Few things are designed well.<\/p>\n<cite>Brian Reed<\/cite><\/blockquote>\n\n\n\n<p>perfectly illustrates the often overlooked approach, whether in projects or every aspect of our lives.<\/p>\n\n\n\n<p>We want our reports to be modern, colorful, &#8220;fancy &amp; sexy,&#8221; often forgetting what we need, how we will use them, and what stories they should tell us. By answering these questions, we begin the process of designing the report. It requires an <strong>understanding of business needs<\/strong>, but unfortunately, <strong>it also requires time, which is crucial here<\/strong>. Sometimes, &#8220;designing&#8221; takes longer than the actual &#8220;development.&#8221;<\/p>\n\n\n\n<p>In this post, I&#8217;ll present <strong>a simple approach<\/strong> I often use in my work. Of course, there are many approaches, but this one is so natural to us that it&#8217;s often overlooked.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>The capabilities of our brain<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Data arrangement<\/strong><\/h3>\n\n\n\n<p>Few people realize our brain&#8217;s potential in reporting and this organ&#8217;s crucial role in perceiving data. It&#8217;s worth leveraging its natural behavior when designing and <strong>creating reports\/dashboards.<\/strong><\/p>\n\n\n\n<p>It&#8217;s often said that the simplest solutions are the best, so our brain guides us on how we should <strong>place the most essential information<\/strong> and where the less important ones should go based on tendencies we possess:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>we read from left to right,<\/li>\n\n\n\n<li>we read from top to bottom.<\/li>\n<\/ul>\n\n\n\n<p>This is a natural process in which we participate without fully realizing it&#8217;s obvious.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><a href=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-1.png\"><img decoding=\"async\" width=\"901\" height=\"508\" src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-1.png\" alt=\"How we read charts (based on Zebrabi) \" class=\"wp-image-27682\" srcset=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-1.png 901w, https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-1-300x169.png 300w, https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-1-768x433.png 768w, https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-1-555x312.png 555w\" sizes=\"(max-width: 901px) 100vw, 901px\" \/><\/a><figcaption class=\"wp-element-caption\">Fig. 1 How we read charts (<a href=\"https:\/\/zebrabi.com\/create-the-best-kpi-dashboard\/\" target=\"_blank\" aria-label=\" (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"ek-link\" rel=\"nofollow\" >based on Zebrabi<\/a>)<\/figcaption><\/figure>\n\n\n\n<p>Analytics is meant to assist us in making important business decisions, so it&#8217;s crucial where data will be located and how quickly we can make strategic decisions with their help.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Granularity of data<\/strong><\/h3>\n\n\n\n<p>Considering the conditions of our organism, we should start building our report\/dashboard from <strong>the smallest granularity of data to the largest<\/strong>. It&#8217;s important to consistently move from one piece of information to another, so it&#8217;s worth, for example, starting by providing <strong>critical information<\/strong> in the form of <strong>KPIs at the very top of the report<\/strong>, which will immediately show us important, measurable, strategic data for our company.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><a href=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-2.png\"><img decoding=\"async\" width=\"601\" height=\"301\" src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-2.png\" alt=\"Well prepared KPI's \" class=\"wp-image-27684\" srcset=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-2.png 601w, https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-2-300x150.png 300w\" sizes=\"(max-width: 601px) 100vw, 601px\" \/><\/a><figcaption class=\"wp-element-caption\">Fig. 2 <a href=\"https:\/\/www.geeksforgeeks.org\/kpi-full-form-importance-and-types\/\" target=\"_blank\" aria-label=\"Well prepared KPI's (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"ek-link\" rel=\"nofollow\" >Well prepared KPI&#8217;s<\/a><\/figcaption><\/figure>\n\n\n\n<p>Then, the data should become increasingly precise, containing more information in the form of charts, for example, allowing us to quickly determine a reference point or cause or perhaps show that it was just an isolated case. But why was it that one case? Such data is already worth analyzing in several ways, factors in greater granularity of data for which a table is ideal.<\/p>\n\n\n\n<p>Below is a mock-up of a dashboard that progresses from the lowest granularity of data, critical, and key information to the highest to analyze the entire situation.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><a href=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-3.png\"><img decoding=\"async\" width=\"601\" height=\"340\" src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-3.png\" alt=\"Data granularity on the dashboard \" class=\"wp-image-27686\" srcset=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-3.png 601w, https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-3-300x170.png 300w\" sizes=\"(max-width: 601px) 100vw, 601px\" \/><\/a><figcaption class=\"wp-element-caption\">Fig. 3 <a href=\"https:\/\/www.reddit.com\/media?url=https:\/\/preview.redd.it\/kpi-box-data-and-table-data-dont-match-v0-7opyvea32q1b1.png?width=1188&amp;format=png&amp;auto=webp&amp;s=16d3b6ce10f0380479f9e0c0ea4bbff949b20fe7\" target=\"_blank\" aria-label=\" (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"ek-link\" rel=\"nofollow\" >Data granularity on the dashboard<\/a><\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Visual perception \u2013 contrast<\/strong><\/h3>\n\n\n\n<p>Our brain is capable of remembering a lot. However, how can we make sure that <strong>important information is noticed automatically<\/strong>? <strong>Contrast<\/strong> is often a crucial aspect of visualization. Thanks to it, we can quickly distinguish from &#8220;others&#8221; and remember.<\/p>\n\n\n\n<p>A simple example below.<\/p>\n\n\n\n<p>How many &#8220;5\u201ds can you remember in Fig. 4?<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><a href=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-4.png\"><img decoding=\"async\" width=\"601\" height=\"124\" src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-4.png\" alt=\"Memorization test (based on Information Dashboard Design, Stephen Few) \" class=\"wp-image-27688\" srcset=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-4.png 601w, https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-4-300x62.png 300w\" sizes=\"(max-width: 601px) 100vw, 601px\" \/><\/a><figcaption class=\"wp-element-caption\">Fig. 4 Memorization test <a class=\"ek-link\">(based on <\/a><a href=\"https:\/\/www.amazon.com\/Information-Dashboard-Design-At-Glance\/dp\/1938377001\" target=\"_blank\" aria-label=\" (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"ek-link\" rel=\"nofollow\" >Information Dashboard Design, Stephen Few<\/a>)<\/figcaption><\/figure>\n\n\n\n<p>And how many in Fig. 5?<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><a href=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-5.png\"><img decoding=\"async\" width=\"601\" height=\"120\" src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-5.png\" alt=\"Memorization test \u2013 version with contrast (based on Information Dashboard Design, Stephen Few) \" class=\"wp-image-27690\" srcset=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-5.png 601w, https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-5-300x60.png 300w\" sizes=\"(max-width: 601px) 100vw, 601px\" \/><\/a><figcaption class=\"wp-element-caption\">Fig. 5 Memorization test \u2013 version with contrast (based on <a href=\"https:\/\/www.amazon.com\/Information-Dashboard-Design-At-Glance\/dp\/1938377001\" target=\"_blank\" aria-label=\" (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"ek-link\" rel=\"nofollow\" >Information Dashboard Design, Stephen Few<\/a>)<\/figcaption><\/figure>\n\n\n\n<p>There is no need to add more; thanks to contrast, we can analyze the above data quickly and know the answer to the question asked.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Visual perception \u2013 color <\/strong><\/h3>\n\n\n\n<p>Another aspect of visual perception may be color. It is natural for humans to perceive the color red\/yellow\/orange as informing us, for example, about stopping, checking if everything is okay, and exercising caution. On the other hand, the color green is perceived as something good.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><a href=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-6.png\"><img decoding=\"async\" width=\"268\" height=\"506\" src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-6.png\" alt=\"Color perception based on traffic lights \" class=\"wp-image-27692\" srcset=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-6.png 268w, https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-6-159x300.png 159w\" sizes=\"(max-width: 268px) 100vw, 268px\" \/><\/a><figcaption class=\"wp-element-caption\">Fig. 6 Color perception based on traffic lights<\/figcaption><\/figure>\n\n\n\n<p>In reporting, this is referred to as conditional formatting &#8211; when we present data in a clear, natural manner, sometimes requiring emphasis that specific data deviates from our expectations negatively or positively. Standard colors are not a natural &#8220;alarm&#8221; for us that something needs our attention. However, for example, red\/orange should already catch our eye, and we can display important information such as &#8220;Target&#8221; and its performance, as shown in Fig. 8.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><a href=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-7.png\"><img decoding=\"async\" width=\"780\" height=\"508\" src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-7.png\" alt=\"Use of colors in charts (based on Information Dashboard Design, Stephen Few) \" class=\"wp-image-27694\" style=\"width:571px;height:auto\" srcset=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-7.png 780w, https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-7-300x195.png 300w, https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-7-768x500.png 768w\" sizes=\"(max-width: 780px) 100vw, 780px\" \/><\/a><figcaption class=\"wp-element-caption\">Fig. 7 Use of colors in charts (based on <a href=\"https:\/\/www.amazon.com\/Information-Dashboard-Design-At-Glance\/dp\/1938377001\" target=\"_blank\" aria-label=\" (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"ek-link\" rel=\"nofollow\" >Information Dashboard Design, Stephen Few<\/a>)<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><a href=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-8.png\"><img decoding=\"async\" width=\"601\" height=\"360\" src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-8.png\" alt=\"Use of color to indicate target\" class=\"wp-image-27696\" srcset=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-8.png 601w, https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Rys.-8-300x180.png 300w\" sizes=\"(max-width: 601px) 100vw, 601px\" \/><\/a><figcaption class=\"wp-element-caption\">Fig. 8 Use of color to indicate target<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><strong>The most straightforward solutions are the best<\/strong><\/strong><\/h2>\n\n\n\n<p>Often, simple solutions are the best. I hope the above examples demonstrate that small, manageable changes in report design immediately make reports more transparent and readable.<\/p>\n\n\n\n<p>The presented examples are <strong>just a glimpse into designing analytical solutions<\/strong>. There are many ways to present data depending on our brain&#8217;s or eye&#8217;s perception, such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>appropriate size,<\/li>\n\n\n\n<li>orientation,<\/li>\n\n\n\n<li>shape of components, visualization.<\/li>\n<\/ul>\n\n\n\n<p>Additionally, report segmentation should be done based on the needs of different user groups, such as management, key users, or analysts.<\/p>\n\n\n\n<p>Without knowing these techniques, we can rely on various standards in the BI world. One is IBCS \u2013 <a href=\"https:\/\/www.ibcs.com\/\" target=\"_blank\" aria-label=\" (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"ek-link\" rel=\"nofollow\" >International Business Communication Standards<\/a>, where we can find the best practices for good visualization design.<\/p>\n\n\n\n<p>***<\/p>\n\n\n\n<p>If you are interested in the topic of business analytics, be sure to take a look <a href=\"https:\/\/sii.pl\/blog\/en\/all\/business-analyst-en\/\" target=\"_blank\" aria-label=\"at other articles by our experts as well (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"ek-link\">at other articles by our experts as well<\/a>.<\/p>\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;27701&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;1&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;11&quot;,&quot;greet&quot;:&quot;&quot;,&quot;legend&quot;:&quot;5\\\/5 ( vote: 1)&quot;,&quot;size&quot;:&quot;18&quot;,&quot;title&quot;:&quot;How to design a report\\\/dashboard effectively?&quot;,&quot;width&quot;:&quot;139.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} ( {votes}: {count})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 11px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 18px; height: 18px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 11px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 18px; height: 18px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 11px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 18px; height: 18px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 11px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 18px; height: 18px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 11px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 18px; height: 18px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 139.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 11px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 18px; height: 18px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 11px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 18px; height: 18px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 11px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 18px; height: 18px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 11px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 18px; height: 18px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 11px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 18px; height: 18px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 14.4px;\">\n            5\/5 ( vote: 1)    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>Designing reports\/dashboards\/Business Intelligence (BI) applications is a vast topic. This stage of implementation is often treated hastily, with lower priority. &hellip; <a class=\"continued-btn\" href=\"https:\/\/sii.pl\/blog\/en\/how-to-design-a-report-dashboard-effectively\/\">Continued<\/a><\/p>\n","protected":false},"author":634,"featured_media":27700,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_editorskit_title_hidden":false,"_editorskit_reading_time":0,"_editorskit_is_block_options_detached":false,"_editorskit_block_options_position":"{}","inline_featured_image":false,"footnotes":""},"categories":[1319],"tags":[2204,1845,1526,1384],"class_list":["post-27701","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-soft-development","tag-dashboard-en","tag-business-analysis","tag-guidebook","tag-bi-en"],"acf":[],"aioseo_notices":[],"republish_history":[],"featured_media_url":"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2024\/05\/Jak-dobrze-zaprojektowac-raport-dashboard.jpg","category_names":["Soft development"],"_links":{"self":[{"href":"https:\/\/sii.pl\/blog\/en\/wp-json\/wp\/v2\/posts\/27701"}],"collection":[{"href":"https:\/\/sii.pl\/blog\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sii.pl\/blog\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sii.pl\/blog\/en\/wp-json\/wp\/v2\/users\/634"}],"replies":[{"embeddable":true,"href":"https:\/\/sii.pl\/blog\/en\/wp-json\/wp\/v2\/comments?post=27701"}],"version-history":[{"count":1,"href":"https:\/\/sii.pl\/blog\/en\/wp-json\/wp\/v2\/posts\/27701\/revisions"}],"predecessor-version":[{"id":27703,"href":"https:\/\/sii.pl\/blog\/en\/wp-json\/wp\/v2\/posts\/27701\/revisions\/27703"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sii.pl\/blog\/en\/wp-json\/wp\/v2\/media\/27700"}],"wp:attachment":[{"href":"https:\/\/sii.pl\/blog\/en\/wp-json\/wp\/v2\/media?parent=27701"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sii.pl\/blog\/en\/wp-json\/wp\/v2\/categories?post=27701"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sii.pl\/blog\/en\/wp-json\/wp\/v2\/tags?post=27701"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}