Analyzing Business Unit Sales in Retail Stores

This dashboard was created for one of the leading American menswear company, which provides a personal, convenient, one-of-a-kind shopping experience with elite products and world-class service to its customers. The dashboard provides a comprehensive report of sales by all brands, as well as sales trends across any given period of time. 

Challenges 

Some of the major challenges faced by client were :

• No Insights on sales of different Business Units in the Brands.  
• Unable to track the performance of various Brands  across stores  
• Sales comparison – Planned  vs. last year  and 2 Year or across different time frames   
• Comprehensive view of the overall performance of store based  on Brands for the particular Business Units 

Solution 

 Our solution enabled the following capabilities to address customer challenges : 

• Provided a holistic analysis of the Plan Vs Last Year Sales, Margin trends and Operating Income effortlessly, across Year, Month and Week, leading to increased management efficiency  
• Ability to view the distribution of Sales and projections across Brands, Store Segments  
• Ability to view the Top and Bottom performing Stores and Divisions and relevant analysis for it  
• Analysis to compare sales across different time series