![]() ![]() This block in this template displays the ratio of financial indicators for coffee and tea sales in a cafe. It is easy to perceive, looks beautiful, convenient to use - as a result, it is pleasant to work with. The result is an original, creative, and readable infographic-style data visualization. Therefore, it was decided to present data on tea sales on a silver platter, and on a cup - on coffee. And coffee from saucers is not sung anywhere. In most Eastern and Slavic countries, tea is drunk from saucers. The infographic diagram of the block diagram is made in the form of a coffee cup on a saucer. Here, a comparative analysis of two products is performed: coffee and tea. Uses a combination of donut and pie charts to visualize its data segment: Each diagram is responsible for its own segment of accounting data for visual analysis of the current state of the business as of the selected accounting period (in this case, the month). The dashboard structure is simple and consists of four blocks of diagrams. Dashboard in the style of infographics for the analysis of sales of goods in a cafe Let's analyze its contents in more detail. All this is implemented on the Processing intermediate sheet using formulas and tables:įurther, the processed data is transmitted and used in a graphical report in the form of a dashboard. ID - an auxiliary column for convenient data selection using the formula of the INDEX and MATCH functions according to several conditions on the "Processing" sheet.īefore outputting data to the main sheet "DASHBOARD" in a graphical form with interactive elements, you should first select and process incoming data from the sheet "Data".Quantity sold - how many products were sold in pieces.Amount of leftovers - how many items are in the warehouse.Product - the name of the products sold in the assortment of the cafe. ![]() Month - to select the analyzed accounting period.The table consists of the following columns: All of them are structured and collected in one table on the "Data" sheet for entering incoming data into the template. According to the accounting data for a period of 12 months, the following data was collected on the sales of products in the cafe. To get acquainted with the principles of operation and the structure of the template, we will simulate the situation. You can download an Excel file with interactive charts from the link at the end of the article.ĭashboard template for analyzing the accounting of sales of products in a cafe Download Cafe Products Sales Analysis in Excel templateĭiscoveries and free report template with data visualization in the style of infographics for presenting data on doing business in a cafe. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |