{"id":8197,"date":"2019-10-11T16:40:55","date_gmt":"2019-10-11T08:40:55","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=8197"},"modified":"2019-10-25T11:18:48","modified_gmt":"2019-10-25T03:18:48","slug":"why-executive-need-kpi-dashboard-to-manage-data","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2019\/10\/11\/why-executive-need-kpi-dashboard-to-manage-data\/","title":{"rendered":"Why Executive Need KPI dashboard to Manage Data"},"content":{"rendered":"<h1><strong>Why We Need a KPI Dashboard?<\/strong><\/h1>\n<p>Have you ever driven a car without looking at its dashboard?<\/p>\n<p>Without checking its fuel level, temperature, speedometer or any of its indicators. For some, they even check their tyres, side mirrors, and hazard lights.<\/p>\n<p>Simply drive a car without checking the dashboard means you are exposing yourself to a higher risk level.<\/p>\n<p>Just like driving a car, managing a business also require business owners to know his\/her critical numbers to make better business decisions. Without knowing the numbers, decisions are just made based on emotions or his\/her intuitions alone.<\/p>\n<p>Start today with simple indicators to know your business better. I&#8217;m sure you able to see the benefits of knowing the critical numbers in your business key result areas.<\/p>\n<p><a href=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/10\/2019101101L.jpg\"><img loading=\"lazy\" class=\"aligncenter wp-image-8226\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/10\/2019101101L-300x200.jpg\" alt=\"\" width=\"471\" height=\"314\" srcset=\"https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101101L-300x200.jpg 300w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101101L-768x512.jpg 768w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101101L.jpg 1024w\" sizes=\"(max-width: 471px) 100vw, 471px\" \/><\/a><\/p>\n<h1><strong>Types of KPI Dashboard<\/strong><\/h1>\n<p>There are many types of KPI dashboards. Almost all positions in a company have KPI requirements. However, the KPI rules of different positions are different and cannot be managed uniformly. This often causes management difficulties for management. At this time, the KPI \u00a0dashboard can easily solve the management dilemma and check the KPI completion status of different positions.<\/p>\n<p>Here are some simple examples:<\/p>\n<p>&nbsp;<\/p>\n<p><strong>#Marketing:<\/strong><\/p>\n<p>Number of leads from the specific lead source<\/p>\n<p>Number of channel partners<\/p>\n<p>Number of marketing activities<\/p>\n<p>&nbsp;<\/p>\n<p><strong>#Sales:<\/strong><\/p>\n<p>Rate of conversion<\/p>\n<p>Value of business transactions<\/p>\n<p>Value of sales booked<\/p>\n<p><a href=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/10\/2019101102L.png\"><img loading=\"lazy\" class=\"alignnone wp-image-8199 aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/10\/2019101102L-300x184.png\" alt=\"\" width=\"545\" height=\"334\" srcset=\"https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101102L-300x184.png 300w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101102L-768x471.png 768w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101102L-1024x628.png 1024w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101102L.png 2024w\" sizes=\"(max-width: 545px) 100vw, 545px\" \/><\/a><\/p>\n<p style=\"text-align: center;\">KPI dashboard made by <a href=\"https:\/\/www.tableau.com\/\">Tableau<\/a><\/p>\n<p><strong>#Finance:<\/strong><\/p>\n<p>Number of invoices issued per month<\/p>\n<p>Average value of invoices issued per month<\/p>\n<p>Value of payments received per month<\/p>\n<p>Value of payments made per month<\/p>\n<p>&nbsp;<\/p>\n<p><strong>#HR:<\/strong><\/p>\n<p>Number of training days<\/p>\n<p>Number of annual leave taken<\/p>\n<p>Number of MC taken<\/p>\n<p><a href=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/10\/2019101103L-1.png\"><img loading=\"lazy\" class=\"wp-image-8211 aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/10\/2019101103L-1-300x139.png\" alt=\"\" width=\"686\" height=\"318\" srcset=\"https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101103L-1-300x139.png 300w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101103L-1-768x356.png 768w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101103L-1-1024x474.png 1024w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101103L-1.png 1692w\" sizes=\"(max-width: 686px) 100vw, 686px\" \/><\/a><\/p>\n<p style=\"text-align: center;\">HR dashboard made by <a href=\"http:\/\/www.finereport.com\/en\/\">FineReport<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>#Operation:<\/strong><\/p>\n<p>Number of products delivered<\/p>\n<p>Value of products delivered<\/p>\n<p>Number of product returned\/rejected<\/p>\n<p>Number of complaints received<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Start with a simple KPI Dashboard before you expand into a more detailed and bigger scope of business. It&#8217;s a good idea, right?<\/p>\n<h1><strong>Tips for Making KPI Dashboard<\/strong><\/h1>\n<p>Making a dashboard becomes easier once you have clarity of vision and listed down what you want (and what you don\u2018t want).<\/p>\n<p>Here you can use FineReport to make a KPI dashboard. It is easy-to-use and you can make various charts by some simple drag &amp; drop action.<\/p>\n<ul>\n<li>Arrange the data. Enter your data in excel or <a href=\"http:\/\/www.finereport.com\/en\/features\/data-integration\">other databases<\/a>.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/10\/2019101104L.png\"><img loading=\"lazy\" class=\"alignnone wp-image-8201\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/10\/2019101104L-300x152.png\" alt=\"\" width=\"667\" height=\"338\" srcset=\"https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101104L-300x152.png 300w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101104L-768x389.png 768w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101104L-1024x518.png 1024w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101104L.png 1377w\" sizes=\"(max-width: 667px) 100vw, 667px\" \/><\/a><\/p>\n<ul>\n<li>Design layout and load data.<\/li>\n<\/ul>\n<p>FineReport supports custom layouts, and you can create your favorite layouts by dragging and dropping. For example, like this<\/p>\n<p><a href=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/10\/2019101105L.png\"><img loading=\"lazy\" class=\"alignnone wp-image-8202\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/10\/2019101105L-300x165.png\" alt=\"\" width=\"631\" height=\"347\" srcset=\"https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101105L-300x165.png 300w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101105L-768x422.png 768w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101105L-1024x562.png 1024w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101105L.png 1450w\" sizes=\"(max-width: 631px) 100vw, 631px\" \/><\/a><\/p>\n<ul>\n<li>Use Conditional Formatting &amp; Formulas to Display Icons.<\/li>\n<\/ul>\n<p>FineReport supports <a href=\"http:\/\/www.finereport.com\/en\/features\/data-entry\">custom formulas<\/a> to determine if the data meets the criteria. For example, we can calculate the KPI value of each employee by the KPI formula. If it is greater than the specified value, it is excellent, otherwise, it is unqualified.<\/p>\n<p><a href=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/10\/2019101106L.png\"><img loading=\"lazy\" class=\"alignnone wp-image-8203\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/10\/2019101106L-300x163.png\" alt=\"\" width=\"644\" height=\"350\" srcset=\"https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101106L-300x163.png 300w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101106L-768x417.png 768w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101106L-1024x556.png 1024w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101106L.png 1146w\" sizes=\"(max-width: 644px) 100vw, 644px\" \/><\/a><\/p>\n<h1><strong>Data Analysis in KPI Dashboard<\/strong><\/h1>\n<p>What core indicators will be analyzed by KPI <a href=\"http:\/\/www.finereport.com\/en\/features\/tv-dashboard\">dashboard<\/a>? It\u00a0 generally can be divided into the following six categories:<\/p>\n<p>&nbsp;<\/p>\n<ol>\n<li><strong>Data Total Analysis<\/strong><\/li>\n<li><strong>Development Trend Analysis<\/strong><\/li>\n<li><strong>Data Comparison Analysis<\/strong><\/li>\n<li><strong>Compositional Structure Analysis<\/strong><\/li>\n<li><strong>Achieve Progress Analysis<\/strong><\/li>\n<li><strong>Influencing Factors Analysis<\/strong><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>Here are a few examples of financial analysis:<\/p>\n<ul>\n<li><strong>Data Total Analysis<\/strong><\/li>\n<\/ul>\n<p>Data total analysis is often used to measure the key core indicators that leaders are most concerned with under the business segment. For example, finance is annual operating income, annual consumption cost, and annual net profit.<\/p>\n<p>As shown in the figure below, we use the dashboard component to calculate the three core indicators of the company&#8217;s total annual revenue, annual cost, and net profit. The annual revenue status is clear at a glance.<\/p>\n<p><a href=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/10\/2019101107L.png\"><img loading=\"lazy\" class=\"alignnone wp-image-8212\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/10\/2019101107L-300x81.png\" alt=\"\" width=\"533\" height=\"144\" srcset=\"https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101107L-300x81.png 300w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101107L-768x207.png 768w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101107L-1024x276.png 1024w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101107L.png 1164w\" sizes=\"(max-width: 533px) 100vw, 533px\" \/><\/a><\/p>\n<ul>\n<li>Analysis of Development Trend<\/li>\n<\/ul>\n<p>Development trend analysis is often used to visually compare data trends over a continuous range for pre-judgment of next year&#8217;s plans. Such as sales forecast, financial ratio trend. For example, on the one hand, it can analyze whether there is an abnormality in the increase or decrease of data, and discover problems that may exist in the enterprise; on the other hand, it can help enterprises predict the future financial situation and judge the development prospects of the enterprise.<\/p>\n<p>Such a chart that directly presents the trend of the enterprise, generally can use the line chart for analysis and statistics, with the horizontal axis for time (year, month, day), and the vertical axis for indicators such as operating income, cost, profit rate, etc. \u00a0As shown in the figure below, the left-value axis counts the trend of annual operating income and cost expenditure, and the right-value axis calculates the annual profit rate trend.<\/p>\n<p><a href=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/10\/2019101108L.png\"><img loading=\"lazy\" class=\"alignnone wp-image-8213\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/10\/2019101108L-300x111.png\" alt=\"\" width=\"703\" height=\"260\" srcset=\"https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101108L-300x111.png 300w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101108L-768x284.png 768w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101108L-1024x379.png 1024w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101108L.png 1324w\" sizes=\"(max-width: 703px) 100vw, 703px\" \/><\/a><\/p>\n<ul>\n<li>Data Comparison Analysis<\/li>\n<\/ul>\n<p>Data has no value without comparison, and single data cannot be judged. In general, the reference standard for comparative analysis has the following four aspects:<\/p>\n<ol>\n<li>Time comparison: comparison with actual data of the previous period and the same period of last year<\/li>\n<li>Entity comparison: comparison with data of advanced enterprises in the same industry or other enterprises in the same industry<\/li>\n<li>Caliber comparison: compared to the plan or budget data line<\/li>\n<li>Structural comparison: Compare the composition of the two data on the basis of the composition analysis, and analyze the changes in financial indicators.<\/li>\n<\/ol>\n<p>When we do a comparative analysis, it is recommended to use a histogram or a bar chart to compare the size of the data. When comparing data structures, it is generally recommended to use the cumulative column chart and the cumulative bar chart for data comparison analysis. In addition, other charts can be used according to the specific situation of the analysis, such as the high and low connection of the line chart to represent the comparison between the highest and lowest inventory of several companies and the inventory.<\/p>\n<p><a href=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/10\/2019101109L.png\"><img loading=\"lazy\" class=\"alignnone wp-image-8206 aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/10\/2019101109L-300x162.png\" alt=\"\" width=\"744\" height=\"402\" srcset=\"https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101109L-300x162.png 300w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101109L-768x415.png 768w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101109L-1024x553.png 1024w\" sizes=\"(max-width: 744px) 100vw, 744px\" \/><\/a><\/p>\n<p style=\"text-align: center;\">Sales dashboard made by FineReport<\/p>\n<ul>\n<li>Achieve Progress Analysis<\/li>\n<\/ul>\n<p>If you need to show the progress of a certain indicator or a task, such as the completion of the department&#8217;s performance, the progress of the declaration of fees, and so on. In order to more intuitively display the progress of various indicators and tasks, we can generally show the progress of the data by stacking column charts, stacked bar charts, and Gantt charts.<\/p>\n<p><a href=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/10\/2019101110L.png\"><img loading=\"lazy\" class=\"alignnone wp-image-8214 aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/10\/2019101110L-300x125.png\" alt=\"\" width=\"576\" height=\"240\" srcset=\"https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101110L-300x125.png 300w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101110L-768x320.png 768w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101110L-1024x426.png 1024w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/10\/2019101110L.png 1802w\" sizes=\"(max-width: 576px) 100vw, 576px\" \/><\/a><\/p>\n<p style=\"text-align: center;\">Gantt chart made by FineReport<\/p>\n<h1><strong>Conclusion<\/strong><\/h1>\n<p>KPI dashboard can help executives make better decisions through the visual display of various indicators. Whether it is process management or indicator query, KPI big screen will greatly improve efficiency and reduce unnecessary communication time.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Using KPI dashboard to boost your business efficiency.<\/p>\n","protected":false},"author":1,"featured_media":8226,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[854],"tags":[173,118],"_links":{"self":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/8197"}],"collection":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/comments?post=8197"}],"version-history":[{"count":11,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/8197\/revisions"}],"predecessor-version":[{"id":8578,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/8197\/revisions\/8578"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media\/8226"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=8197"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=8197"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=8197"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}