The Client 🤵
A prominent FMCG distributor in the Middle East, overseeing a network of over 200 branches and managing a portfolio of more than 3,000 SKUs, serving  4,000+ customers . ​


The Problem ⛔

• The Client encountered challenges in managing end-to-end supply chain, tracking both primary and secondary sales. Data came in from different silos, such as various sales platforms, payment gateways, and refund systems. The Client had no visibility on the Inventory across Primary & Secondary Sales Channels.  

• The Client struggled to manage and process large volumes of Sales and Refund data. The team relied on outdated excel techniques due to which creating reports manually proved to be a laborious, time-consuming and error-prone. ​

• They lacked key metrics and a unified view of 360 Degree Sales Analysis.

​

​

Our Solution ✔️

1. We automated the data cleaning process, consolidating multiple scattered data sources into a single unified system. 

2. We modeled the most relevant KPIs concerning primary and secondary sales that would guide the team on high-priority metrics for better decision-making. 

3. We then aggregated all this data into a visually compelling dashboard. The dashboard carried six key screens with drill-down capabilities that provided deeper insights beyond surface-level metrics.   ​

​

We’ve kept the dashboard clean and minimal, take a look:

​​

Screen 1 - Home