{"id":8027,"date":"2019-09-24T14:50:58","date_gmt":"2019-09-24T06:50:58","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=8027"},"modified":"2025-04-16T11:11:56","modified_gmt":"2025-04-16T03:11:56","slug":"a-step-by-step-guide-to-making-sales-dashboards","status":"publish","type":"post","link":"https:\/\/www.finereport.com\/en\/data-visualization\/a-step-by-step-guide-to-making-sales-dashboards.html","title":{"rendered":"A Step-by-Step Guide to Making Sales Data Visualization"},"content":{"rendered":"\n<p>I have written some getting-started guides on data visualization or&nbsp;business dashboards, but those articles are still a little theoretical. Recently, I have been working on a sales dashboard project for data visualization. From the determination of indicators, layout&nbsp;design, and chart types to dynamic effects, I summarized some experiences and opinions. In this post, I will share with you the specific steps to make a&nbsp;<strong><a rel=\"noreferrer noopener\" href=\"https:\/\/www.finereport.com\/en\/dashboard-tools\/sales-dashboard.html\" data-type=\"URL\" data-id=\"https:\/\/www.finereport.com\/en\/dashboard-tools\/sales-dashboard.html\" target=\"_blank\">sales dashboard<\/a><\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"531\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2020\/08\/3-1024x531.gif\" alt=\"\" class=\"wp-image-10650\" srcset=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2020\/08\/3-1024x531.gif 1024w, https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2020\/08\/3-300x156.gif 300w, https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2020\/08\/3-768x399.gif 768w, https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2020\/08\/3-1536x797.gif 1536w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<div id=\"toc_container\" class=\"toc_transparent no_bullets\"><p class=\"toc_title\">Contents<\/p><ul class=\"toc_list\"><li><a href=\"#1_Tools_for_Making_Sales_Data_Visualization\">1. Tools for Making Sales Data Visualization<\/a><\/li><li><a href=\"#2_Determine_Analytical_Indicators_for_Sales_Data_Visualization\">2. Determine Analytical Indicators for Sales Data Visualization<\/a><\/li><li><a href=\"#3_Design_Layout_for_Sales_Data_Visualization\">3. Design Layout for Sales Data Visualization<\/a><\/li><li><a href=\"#4_Select_Chart_Types_for_Sales_Data_Visualization\">4. Select Chart Types for Sales Data Visualization<\/a><\/li><li><a href=\"#5_Add_Dynamic_Effects_for_Sales_Data_Visualization\">5. Add Dynamic Effects for Sales Data Visualization<\/a><\/li><li><a href=\"#Sales_Data_Visualization_Practice\">Sales Data Visualization Practice<\/a><ul><li><a href=\"#_Import_data\">\u2460 Import data<\/a><\/li><li><a href=\"#_Make_a_template\">\u2461 Make a template<\/a><\/li><li><a href=\"#_Select_visualization_elements\">\u2462 Select visualization elements<\/a><\/li><li><a href=\"#_Add_dynamic_effects\">\u2463 Add dynamic effects<\/a><\/li><\/ul><\/li><li><a href=\"#Younbspmight_also_be_interested_in\">You&nbsp;might also be interested in\u2026<\/a><\/li><\/ul><\/div>\n<h2 id=\"6228\"><span id=\"1_Tools_for_Making_Sales_Data_Visualization\"><strong>1. Tools for Making Sales Data Visualization<\/strong><\/span><\/h2>\n\n\n\n<p>The&nbsp;<a href=\"http:\/\/www.finereport.com\/en\/features\/tv-dashboard?utm_source=medium&amp;utm_medium=media&amp;utm_campaign=blog&amp;utm_term=A%20Step-by-Step%20Guide%20to%20Making%20Sales%20Dashboards\" target=\"_blank\" rel=\"noreferrer noopener\">production of dashboards<\/a>&nbsp;can be done with code development or existing visualization tools. Many people will use JS and Ecahrts, but it usually involves data support, background response, real-time update, platform operation and maintenance, etc., more technology is needed, so I won\u2019t go into details here.<\/p>\n\n\n\n<p>Another way is to use off-the-shelf visualization tools. It is relatively simple and efficient to build a business dashboard with tools like&nbsp;<a href=\"http:\/\/www.finereport.com\/en\/?utm_source=medium&amp;utm_medium=media&amp;utm_campaign=blog&amp;utm_term=A%20Step-by-Step%20Guide%20to%20Making%20Sales%20Dashboards\" target=\"_blank\" rel=\"noreferrer noopener\">FineReport<\/a>&nbsp;or&nbsp;Tableau. Due to my own work needs, I am more familiar with the operation of FineReport, so what I will show you in this article is how I use FineReport to make sales dashboards.<\/p>\n\n\n\n<h2 id=\"7f67\"><span id=\"2_Determine_Analytical_Indicators_for_Sales_Data_Visualization\"><strong>2. Determine Analytical Indicators<\/strong> for Sales Data Visualization<\/span><\/h2>\n\n\n\n<p>Watching the sales dashboards, you may be attracted by the&nbsp;<a href=\"http:\/\/www.finereport.com\/en\/features\/data-visualization?utm_source=medium&amp;utm_medium=media&amp;utm_campaign=blog&amp;utm_term=A%20Step-by-Step%20Guide%20to%20Making%20Sales%20Dashboards\" target=\"_blank\" rel=\"noreferrer noopener\">cool visualization<\/a>. However, keep in mind that the dashboard must be based on the presentation of data, and any cool effects cannot affect the effective display of data.<\/p>\n\n\n\n<p>So, we should first consider which data and which indicators should be put on the dashboard. You can use the key metric decomposition method to determine which data to display.<\/p>\n\n\n\n<p><strong>Step 1<\/strong>: Identify a key indicator. For sales dashboards, your total sales must be the most important, which is the theme.<\/p>\n\n\n\n<p><strong>Step 2<\/strong>: Decompose the key indicator from multiple dimensions, that is, break down your sales.<\/p>\n\n\n\n<ul><li>From the time dimension. What is the sales situation for each quarter or month? Why are the sales particularly high in some time periods? What measures have been taken?<\/li><li>From the geography dimension. What is the sales situation in each region? What is their ranking?<\/li><li>From the planning dimension. What is the difference between the current sales and the previous plan?<\/li><li>From the proportion dimension. What are the sales of each product? Which are the most profitable star products?<\/li><\/ul>\n\n\n\n<h2 id=\"a817\"><span id=\"3_Design_Layout_for_Sales_Data_Visualization\"><strong>3. Design Layout<\/strong> for Sales Data Visualization<\/span><\/h2>\n\n\n\n<p>Under normal circumstances, an indicator monopolizes an area on the dashboard, so through the definition of key indicators, you know what content will be displayed on the dashboard, and how many pieces the dashboard will be divided into. For example, a <strong><span class=\"has-inline-color has-vivid-cyan-blue-color\"><a href=\"https:\/\/www.fanruan.com\/en\/glossary\/data-visualization\/what-is-sales-graph\" target=\"_blank\" rel=\"noreferrer noopener\">sales graph<\/a><\/span><\/strong> could occupy a prominent section to provide a clear view of sales performance. And you can determine the importance of the indicators based on the business scenario and then design the layout of the dashboard.<\/p>\n\n\n\n<p>The purpose of the layout is to reasonably present business metrics and data. There are primary and secondary indicators. The primary indicators reflect the core business, and the secondary indicators are used for further elaboration, so they are given different weights when designing the layout.<\/p>\n\n\n\n<p>Here I recommend several common layouts.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/201992402A.png\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/201992403A.png\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/201992404A.png\" alt=\"\"\/><\/figure>\n\n\n\n<h2 id=\"61f4\"><span id=\"4_Select_Chart_Types_for_Sales_Data_Visualization\"><strong>4. Select Chart Types<\/strong> for Sales Data Visualization<\/span><\/h2>\n\n\n\n<p>After the key indicators are determined, we need to determine the analytical dimensions of the indicators. Whether the data can be analyzed thoroughly and whether it can provide support for decision-making depend on the analysis dimension of the indicator. Our common analytical methods are analogy, trend, distribution, composition, etc. The choice of analytical methods depends on the actual business scenarios.<\/p>\n\n\n\n<p>Taking the data from the shopping mall as an example, I\u2019ll show you how to select the right chart type.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/201992405A.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>If you want to know more about the types and applications of charts, you can refer to this article&nbsp;<em><a rel=\"noreferrer noopener\" aria-label=\"Top 16 Types of Chart in Data Visualization. (opens in a new tab)\" href=\"http:\/\/www.finereport.com\/en\/data-visualization\/top-16-types-of-chart-in-data-visualization.html\" target=\"_blank\">Top 16 Types of Chart in Data Visualization<\/a><\/em><a rel=\"noreferrer noopener\" aria-label=\"Top 16 Types of Chart in Data Visualization. (opens in a new tab)\" href=\"http:\/\/www.finereport.com\/en\/data-visualization\/top-16-types-of-chart-in-data-visualization.html\" target=\"_blank\">.<\/a><\/p>\n\n\n\n<h2 id=\"7202\"><span id=\"5_Add_Dynamic_Effects_for_Sales_Data_Visualization\"><strong>5. Add Dynamic Effects<\/strong> for Sales Data Visualization<\/span><\/h2>\n\n\n\n<p>Dynamic effects are an important part of visualization. They make the whole dashboard more attractive. But excessive dynamism dazzles viewers and it can\u2019t highlight the key information. Therefore, we need to pay attention to the proportion of dynamic design.<\/p>\n\n\n\n<p>The range of dynamic effects is wide. There are dynamic images, page rotation, list scrolling, real-time data changes, and so on. The following are some built-in dynamic effects of&nbsp;<a href=\"http:\/\/www.finereport.com\/en\/?utm_source=medium&amp;utm_medium=media&amp;utm_campaign=blog&amp;utm_term=A%20Step-by-Step%20Guide%20to%20Making%20Sales%20Dashboards\" target=\"_blank\" rel=\"noreferrer noopener\">FineReport<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/201992406A.gif\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"700\" height=\"346\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2020\/08\/201992407A.gif\" alt=\"\" class=\"wp-image-10677\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/201992408A.gif\" alt=\"\"\/><\/figure>\n\n\n\n<h2 id=\"8f20\"><span id=\"Sales_Data_Visualization_Practice\">Sales Data Visualization <strong>Practice<\/strong><\/span><\/h2>\n\n\n\n<p>The above are the basic steps to make a dashboard. Having said that, I will show you how I use FineReport to make a sales dashboard.<\/p>\n\n\n\n<h3 id=\"4525\"><span id=\"_Import_data\">\u2460 Import data<\/span><\/h3>\n\n\n\n<p>First, we prepare the data and import it into FineReport Designer. The data here is fictitious because I use the built-in dataset of FineReport.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/201992409A.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>As shown in the figure below, in the real scene, we need to connect various databases to import data.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/201992410A.gif\" alt=\"\"\/><\/figure>\n\n\n\n<p>The connected data can be a common relational database, or it can be file data like Excel. And FineReport supports connection to big data platforms.<\/p>\n\n\n\n<h3 id=\"6092\"><span id=\"_Make_a_template\">\u2461 Make a template<\/span><\/h3>\n\n\n\n<p>Once the data is ready, the next step is the creation of the template.<\/p>\n\n\n\n<p>At first, I create a blank template, as shown below. The principle is to drag and drop a visual component (such as a chart) on the blank template, and then bind the data.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/201992411A.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Before we start, we need to think about what sales data we want to show on this blank interface.<\/p>\n\n\n\n<p>After careful consideration, I design the following layout. The middle is the main theme, and the left and right sides are sub-themes.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/201992412A.png\" alt=\"\"\/><\/figure>\n\n\n\n<h3 id=\"4e9a\"><span id=\"_Select_visualization_elements\">\u2462 Select visualization elements<\/span><\/h3>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/201992413A.gif\" alt=\"\"\/><\/figure>\n\n\n\n<p>For sales, we first analyze the quantitative indicators. Drag and drop tables and charts to display as shown above.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/201992414A.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Choose the right chart style on FineReport Designer and connect the data imported in the beginning.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/201992415A.gif\" alt=\"\"\/><\/figure>\n\n\n\n<h3 id=\"7db2\"><span id=\"_Add_dynamic_effects\">\u2463 Add dynamic effects<\/span><\/h3>\n\n\n\n<p>In this sales dashboard, I add a flow map to show the distribution of sales operations nationwide or globally.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/201992416A.gif\" alt=\"\"\/><\/figure>\n\n\n\n<p>The dynamic effect is shown in the figure below, and the data is the latitude and longitude information of the sales location.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/201992417A.gif\" alt=\"\"\/><\/figure>\n\n\n\n<p>Finally, after a series of landscaping settings, the dashboard is completed.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/201992401A.gif\" alt=\"\"\/><\/figure>\n\n\n\n<p>This sales dashboard is relatively simple, here are some other dashboards I have made with FineReport.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"542\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/12-1-1024x542.gif\" alt=\"\" class=\"wp-image-10627\" srcset=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/12-1-1024x542.gif 1024w, https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/12-1-300x159.gif 300w, https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/12-1-768x406.gif 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"451\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2020\/08\/201992421A-1024x451.gif\" alt=\"\" class=\"wp-image-10631\" srcset=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2020\/08\/201992421A-1024x451.gif 1024w, https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2020\/08\/201992421A-300x132.gif 300w, https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2020\/08\/201992421A-768x338.gif 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Finally, I would like to say that it is not difficult to make a dashboard. Above all, we must find out the key indicators for the nature of business operations, and let the leaders see the value of the data. That is the most important step in data visualization. I hope that the article shared today will help you a bit. If you want to make a sales dashboard yourself, you can download&nbsp;<a href=\"http:\/\/www.finereport.com\/en\/?utm_source=medium&amp;utm_medium=media&amp;utm_campaign=blog&amp;utm_term=A%20Step-by-Step%20Guide%20to%20Making%20Sales%20Dashboards\" target=\"_blank\" rel=\"noreferrer noopener\">FineReport<\/a>&nbsp;to practice, which is a zero-coded visualization tool. Its personal version is completely free.<\/p>\n\n\n\n<p><em>Originally published at&nbsp;<\/em><a href=\"https:\/\/medium.com\/@lewischou62\"><em>https:\/\/medium.com\/@lewischou62&nbsp;<\/em><\/a><\/p>\n\n\n\n<p><em>Follow&nbsp;<a href=\"https:\/\/www.facebook.com\/finereport\/\">FineReport Reporting Software<\/a>&nbsp;on Facebook to learn more about the sales dashboard!<\/em><\/p>\n\n\n\n<h2 id=\"id-190801-\u5b98\u7f51-Top10MapTypesinDataVisualization-Youmightalsobeinterestedin\u2026\"><span id=\"Younbspmight_also_be_interested_in\"><strong>You&nbsp;might also be interested in\u2026<\/strong><\/span><\/h2>\n\n\n\n<p><a href=\"http:\/\/www.finereport.com\/en\/data-visualization\/top-16-types-of-chart-in-data-visualization.html\">Top 16 Types of Chart in Data Visualization<\/a><\/p>\n\n\n\n<p><a href=\"http:\/\/www.finereport.com\/en\/data-visualization\/a-beginners-guide-to-business-dashboards.html\">A Beginner\u2019s Guide to Business Dashboards<\/a><\/p>\n\n\n\n<p><a href=\"http:\/\/www.finereport.com\/en\/about-finereport\/how-can-beginners-design-cool-data-visualizations.html\">How Can Beginners Design Cool Data Visualizations?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>From the determination of indicators, layout design, chart types to dynamic effects, this post will share with you the specific steps to make a sales dashboard.<\/p>\n","protected":false},"author":1,"featured_media":10650,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"image","meta":[],"categories":[854],"tags":[156,117],"yst_prominent_words":[1990,1991,1237,795,185,177,490,1795,1285,209,1983,1982,319,1980,1981,1241,1236,195],"_links":{"self":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/8027"}],"collection":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/comments?post=8027"}],"version-history":[{"count":18,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/8027\/revisions"}],"predecessor-version":[{"id":19582,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/8027\/revisions\/19582"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/media\/10650"}],"wp:attachment":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/media?parent=8027"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/categories?post=8027"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/tags?post=8027"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/yst_prominent_words?post=8027"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}