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.

파트너에 문의 동영상 시청하기
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.

Power BI 파트너가 되고 싶으세요?

팀에서 인증 파트너의 역할이 중요합니다. 회사의 인재들이 전 세계의 Power BI 사용자와 연결하여 경험을 공유하며 새로운 비즈니스 기회를 확대할 수 있습니다.

가입

파트너가 되어야 하는 이유에 대해 알아보세요.