Analytics

Overview

A leading CPG client needed to reduce loses incur during store operations and preserving profit by minimizing preventable losses from shoplifting, shrinkage, and administrative errors.

Tools & technologies

Challenges

What we did?

Built a data lakehouse based solution to gather data into Azure Data Lake Storage (ADLS) based central repository.
Built data ingestion pipelines from The Azure Data Factory
Did transformations using Databricks.
Built a reporting layer on top of data lake using PowerBi.
Reporting solution provided toolset for tracking, monitoring, and analysis of lanes and cash registers. Below are some of the KPIs that were measured:
Cash Register Audit
Revenue Improvement
Cash Register Lane Performance
Associate Performance