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 used 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 drill downs for the following:

• Overall summary showing this year and last year’s past week numbers for Sales Revenue by Divisions, Regular vs. Markdown contribution to Sales Revenue and Average Unit Retail Price. These can be filtered by In-Store or Online channel and Boys, Girls, Men’s, or Women’s divisions. Sales Revenue by Division chart also allows drill down view of Sales Revenue by Departments (e.g. Women’s Jeans, Women’s Shirts) within the 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.


•The division managers can view units available, mark-down and regular units available for all the departments in their division.

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

인증 파트너는 팀의 중요한 부분입니다. 새로운 비즈니스 기회를 찾고, 연결하고, 전 세계 Power BI 사용자와 귀사의 재능과 경험을 공유하세요.

등록

등록하는 데 도움이 필요하세요?
pbiptnr@microsoft.com에 문의하세요.

Request demo