This page presents a Power BI report focused on retail sales analysis. Embedded within a sample, this report dives into sales data for items sold across various stores and districts. It offers you a detailed comparison between this year's and last year's performance in terms of sales, units sold, gross margin, variance, and also provides an analysis of new stores. The aim is to give you a clear and comprehensive overview of sales trends, enabling you to spot trends and pinpoint opportunities for improvement.
The objective of this introductory page is to furnish the dashboard user with an expedient overview of the sales performance on a Year-to-Date (YTD) basis.
In the upper-left section, we present three key performance indicators (KPIs): Total Sales YTD, the year-over-year variation, and the performance metrics for stores inaugurated this year. Subsequently, the pie chart delineates the distribution of YTD sales across two distinct channels. This is followed by a bar chart that provides a comparative analysis of monthly sales for the current and preceding years, alongside the annual variation.
On the lower-left quadrant, a geographical map illustrates the distribution of stores across the United States, with sales per store represented by the relative size of each bubble. The concluding graph offers an analysis of the trends in gross margin relative to the previous year, enabling users to pinpoint the month with the most significant discrepancy.
The second dashboard of this report aims to analyze sales by store.
To this end, we have integrated four slicers in the upper left section that allow users to filter by year, month, store type (New or Older), and store name.
The other four charts interact with these filters just as they interact among themselves. The first chart is designed to assess the top 15 performing stores in terms of sales.
The top right chart represents sales month by month and updates based on the slicers applied.
The subsequent chart, located in the middle of the page, evaluates the top five stores based on available sales floor area. This metric is derived from the "Total Sales/Available Sales Floor" ratio.
Lastly, the final chart illustrates the correlation between total sales and available sales floor area for all stores. Each bubble represents a store, and its size denotes the correlation index.
The objective of this third page is to analyze the performance of managers.
Similar to the previous dashboard, here we find four slicers, including a new one that allows filtering by "Channel Distribution."
The first chart enables ranking of "District Managers" (DM) by sales per available square meter. On the right side of the page, a stacked bar chart facilitates the identification of the Gross Margin's share in the total sales by manager.
Lastly, the table at the bottom of the page allows for more detailed data consultation. Managers are categorized by "Distribution Channels."
Ready to take your insights to the next level?
Book a 30-minute free call with me now to uncover personalized opportunities for growth. Don't miss out on the chance to elevate your sales performance. Schedule your call today!
You should know your business better!