Advaiya Solutions Inc. - Retail Weekly Planning
A dashboard to be used during weekly planning meetings comparing key planning metrics for this year and last year by division and department. Metrics include sales revenue, regular vs. markdown contribution to revenue, average unit retail price, units available and in-store vs. online revenue.
파트너에 문의 동영상 시청하기
- Silver Application Development
- Gold Cloud Platform
- Gold Cloud Productivity
- Silver Collaboration and Content
- Gold Data Analytics
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.
•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.
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.