Ledrop
Connecting sales and field data to improve distribution visibility.
Photograph for context: market trade in Lagos. Not a client site.
Connecting sales and field data to improve distribution visibility
Sales and field data held in two platforms, with inconsistent product and customer names, became one reporting foundation in Power BI, giving Ledrop clearer visibility into sales, distribution gaps, menu listings and reported out-of-stock issues.
What the engagement set out to fix.
What the solution runs on.
The problem
Ledrop’s sales and field operations data were held across two platforms: Uwanjani and QuickBooks. Each captured important business information, but differences in how products and customers were recorded made it difficult to connect the data and produce consistent reports.
The same product or customer could appear under different names, which complicated matching records, consolidating sales and comparing field observations with business transactions. Beyond sales reporting, management needed to understand where products were missing, where menu listings could be improved, and which outlets had reported out-of-stock situations.
The system
Two source platforms, one pipeline, one reporting environment. Names are standardised on the way in, so every figure in Power BI traces back to the system it came from.
What was built
Pattern Grid developed a Business Intelligence solution that integrated data from Uwanjani and QuickBooks, standardised key business records, and translated the combined information into Power BI reporting.
Azure handled the extract, transform and load process, with Azure Data Factory pipelines bringing both platforms into a structured reporting environment: a repeatable way to prepare sales and field information for analysis.
Product nomenclature was aligned so variations referring to the same product analyse consistently, and customer and outlet names were harmonised so sales transactions connect to field records without splitting one customer or product into several reporting categories.
Reporting structures and measures were developed to analyse sales by customer, product and reporting period on the standardised data.
Field observations were turned into reporting on distribution gaps (outlets where relevant Ledrop products were not observed), menu-listing gaps (products missing from outlet menus) and competitor-based opportunities (observed competitor products compared with the expected Ledrop equivalents).
Out-of-stock observations captured through field activity were organised so the products and outlets associated with availability issues are easy to identify.
Sales and field analyses were brought into Power BI dashboards that let users explore performance and gaps by product, customer or outlet, and reporting period.
What changed
The capabilities Ledrop gained, as recorded in the project notes.
Written from the project records. No performance figure is quoted unless the records support it.
Have a similar question in your business?
Tell us how your sales, stock or field data is held today. We reply to arrange a short conversation.