Developed a Dashboard for a Retail Giant to Evaluate Sales Performance of Various Stores under the Group

Business Challenge:

One of the largest retail and distribution giants in GCC required to develop a dashboard for evaluating the sales performance of various stores under the group. The client also wanted a proper benchmark to evaluate the sales performance of their brand-new store.

Client was using an Excel-based heuristic process to measure the sales performance. This resulted in inefficient data mining and poor organizational visibility in each store which made it difficult for them to identify top/ underperforming areas and its underlying causes.

Collaborated with the client to develop an automated and comprehensive BI dashboard depicting all key metrics to evaluate the sales performance from organizational to category-brand level, in both existing and new stores.

This would make it easier for the client to highlight the top/underperforming areas and deep dive in those areas to decode the underlying causes.

TurnB Approach:

  • Identified data sources for analysis
  • Checked missing values, data discrepancies and outliers. Extracted, treated, and maintained data to ensure accuracy and performance of the dashboard
  • For existing stores, the previous year sales were set as the criteria for evaluating current year sales
  • For the brand-new store, the month-over-month sales changes of their existing stores were taken into consideration. This logical benchmarking indicated the current market patterns as client is a major player in the retail sector
  • Identified and formulated the key metrics and KPI’s for sales comparison and incorporated metrics in the dashboard that could be sliced and diced with ease from organizational to category brand level
  • The dashboard design and arrangement of metrics were done in an intuitive manner to identify the top/underperforming areas and to comprehend the impact
  • Key features of Power Bi like ‘Live connection to existing reports, Direct Query, Cross report drill- through etc. were implemented. This minimized the data load and improved the overall efficiency and performance of dashboard

Implications:

Replaced old standalone manual reporting with a readily available, automated BI dashboard which resulted in following outcomes:

  • This approach of end-to-end automation allowed client to set up a daily sales monitoring process
  • Enabled smoother reporting, improved data integrity and reduction in manual labour/cost
  • Helped client to compare and evaluate sales performance of their brand-new store based on the set benchmark
  • Easily identified the focus areas to target based on growth/degrowth
  • Performed a root cause analysis on focus areas by correlating and analyzing the key sales-driving factors
  • Enabled client to take proactive measures by pulling the right levers for maximizing sales and margin