![\"\"](\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2020\/01\/christmas.gif\")
<\/a><\/p>\nLet\u2019s first look at the two charts on the left. The bar chart below shows the sales of each category of products, and the line chart above shows the annual sales of a certain category of products. Note that the two charts on the left are linked, that is, if you click on different product categories in the bar chart below, the annual sales volume of the corresponding product category will be displayed in the line chart above.<\/p>\n The cool 3D earth map in the middle shows the logistics route of goods ordered for Christmas, and the thickness of the flow line corresponds to the sales volume of the goods. We can also customize the style of the flow lines.<\/p>\n In the upper right corner of the dashboard is a word cloud diagram showing the categories of Christmas gifts people most want. The larger the font, the more popular such gifts are. Finally, let \u2019s take a look at the real-time sales chart in the bottom right corner. This chart can be connected to a database system to update the real-time sales data. And through the above water polo chart, we can observe the warehouse stock of the products in real time. When the storage volume is below the warning line, a red warning will be displayed, and a pop-up box will appear informing you: out of inventory.<\/p>\n Now, I believe you all know what are the most popular Christmas product categories. The data on this Christmas sales dashboard may be not accurate, but you can still learn from the implementation of data visualization<\/a> and the design of the sales dashboard<\/a>. If you are interested, I will be happy to share with you the methods and tips for making this Christmas dashboard. The following is the specific production process.<\/p>\n Well, first we need to choose an appropriate data visualization tool<\/a> or BI tool<\/a> that can design cool dashboards. If you have strong technical skills, you can also use a programming language like Python or R. The tool I use to make this Christmas dashboard is FineReport<\/strong><\/a>. You can download its personal version from the official website for free use.<\/p>\n The data in the Christmas dashboard was obtained from Statista<\/a>. And the data is stored in Excel file. Next we need to import data into FineReport.<\/p>\n After you download FineReport, place the Excel file in the folder \u201cReportlets\u201d on your computer. Or you can use your own data and connect FineReport directly to your database.<\/p>\n To achieve the linkage of the data, you can select a database to connect data.<\/p>\n And to achieve chart linkage, use simple SQL statements as conditions.<\/p>\n After preparing the data, start with the layout. I choose the type of Absolute Layout. Click \u201cbody\u201d, and you can set its properties.<\/p>\n We just need to drag and drop to insert the charts. For the selection of charts, you can refer to this article Top 16 Types of Chart in Data Visualization<\/em><\/a>.<\/p>\n The overall layout is as follows.<\/p>\n Then set the data for the chart. Select the data required for the chart in turn.<\/p>\n For the linkage effect, we have set simple SQL statements before. Now we set the parameters for the charts that need linkage.<\/p>\n The real-time sales chart on the bottom right can update the sales data in real time. This effect is directly achieved by the free plug-in of FineReport.<\/p>\n By the way, the effect of snowflake is realized by JS. You can do it yourself.<\/p>\n (FineReport has a professional UI team which owns rich experience in dashboard design. Contact us to get the JS code for free.)<\/p>\n Well, these are the main steps to make the Christmas dashboard. If you still have questions about the operation, there are two more detailed guides for your reference: A Step-by-Step Guide to Making Sales Dashboards<\/em><\/a> and How Can Beginners Create a Great Dashboard<\/em><\/a>.<\/p>\n A guide to take your data reporting to another level<\/a><\/em><\/p>\n
\n<\/a>This Christmas dashboard is an online sales dashboard that I made with data from the Internet.<\/p>\n<\/a><\/p>\nStep 1: choose tools and prepare data<\/h2>\n
Step 2: import data<\/h2>\n
<\/div>\n<\/div>\n<\/div>\n<\/figure>\n<\/div>\n<\/div>\n<\/div>\n<\/figure>\n<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/figure>\nStep 3: chart linkage<\/h2>\n
<\/a><\/div>\n<\/div>\n<\/div>\n<\/figure>\n<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/figure>\n<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/figure>\n<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/figure>\nStep 4: design layout<\/h2>\n
<\/a><\/div>\n<\/div>\n<\/div>\n<\/figure>\n<\/a><\/div>\n<\/div>\n<\/div>\n<\/figure>\nStep 5: insert charts<\/h2>\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/figure>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/figure>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/figure>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/figure>\nStep 6: display data in real time<\/h2>\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/figure>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/figure>\nAt Last<\/strong><\/h2>\n
You might also be interested in\u2026<\/h2>\n