Retail Store Data Analysis Using Excel Conversion Visitors Average Check
The video analyzes sales data in a chain of office supply stores. They are obtained from different sources and combined into a summary table.
Telegram channel: https://click.tgtrack.ru/c00d9f6ebbb28
For now, we are just getting acquainted with the data in podcast format.
If the format goes well, I will continue to analyze the numbers from this source.
The analysis considers the following indicators:
Revenue. Allows you to identify negative changes in gross income and assess the need to adjust pricing policy or assortment.
Attendance. Allows you to evaluate the work of sellers and overall customer satisfaction with the outlet.
Conversion. Equal to the share of customers who spent money at the outlet.
Average check. When dividing the number of purchases made by the total revenue of the store, you get the average check. The higher it is, the more efficiently the outlet operates.
Based on the analysis results, conclusions are made about seasonality and changes in indicators. Recommendations are also given for improving indicators and working with data.