A major retailer was using detailed Excel spreadsheets in the weekly planning meetings to review and compare key planning metrics for this year and last year. While some conditional formatting was applied to identify patterns and analyze how the divisions and departments performed, the challenge was to get a quick overview of the different metrics for executives and enable simultaneous drill downs into each of the metrics side-by-side for a specific division and channel.
Visualizations are built-in Power BI to enable quick insights and drilldowns for the following:
• The overall summary shows a table displaying this year and last year’s past week numbers for Sales Revenue by Divisions followed by the department, which is further segregated into In-Store & Online channels. Similarly, Regular vs. Markdown contribution for Sales Revenue displays the contribution of Regular & Markdown for sales revenue for this year as well as the past year leading to create a comparison between both the years in their respective pie charts for each year. The Average Unit Retail Price gauge graph compares the average unit retail price of the previous year to the current year. These can be filtered by In-Store or Online channel and Boys, Girls, Men’s, or Women’s divisions.
•The division managers can view the contribution of in-store and online channels to past week’s sales revenue this year and last year for all the departments in their division. They can toggle in between the sales revenue values and the percentage contribution of in-store & online channels for all the departments in their division. Additionally, they can select their division from the slicer, which is provided at the top left corner. There is also a decomposition visual from where the retail managers can check the total sales revenue for each country and department. The division managers can also see the overall in-store & online sales revenue for each division for the current year and compare the same with the previous year.
•The division managers can view units available, mark-down, and regular units for the current year and previous year and can check the increase in available units. Additionally, they can also check the units available, mark-down, and regular units available for all the departments. The retailers can check the available units for each country and for each division in that specific country, followed by channel segregation.