Drinks.NG
Integrating sales, inventory, fulfilment and marketing reporting.
Photograph for context: a Lagos supermarket. Not a client site.
Integrating sales, inventory, fulfilment and marketing reporting
Data spread across Cin7, SENRI and Google Analytics became an automated reporting environment in Power BI, giving Drinks.NG a connected view of sales, inventory, fulfilment and marketing across its distribution, retail and e-commerce operations.
What the engagement set out to fix.
What the solution runs on.
The problem
Drinks.NG operated across distribution, retail and e-commerce channels, with business data spread across Cin7, SENRI and Google Analytics. Each platform captured a different part of the business: sales transactions, inventory records, field sales activity and website performance.
The business needed a connected reporting environment to understand performance across channels and monitor the relationship between sales, stock availability, fulfilment and marketing activity.
The system
Three 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 an automated data integration and Business Intelligence solution that brought together information from Cin7, Google Analytics and SENRI.
Azure CLI was used in the extract, transform and load workflow to automate the movement and preparation of data from the three platforms into structured datasets for reporting.
Sales data was organised to give both a consolidated view and the ability to examine distribution, retail and e-commerce individually, by product, customer and period.
Inventory records were prepared alongside sales, with product-level measures for available quantity, average daily units sold and estimated inventory days, to assess stock coverage and flag products needing replenishment or review.
Order and fulfilment records joined the reporting framework so fulfilment status and orders needing attention can be monitored, connecting sales reporting with the operational process.
Google Analytics data and marketing inputs were prepared to report on acquisition, engagement and campaign effectiveness, with acquisition cost and return on advertising spend calculated where cost and attribution data were available.
Users can explore sales across channels, review inventory, monitor fulfilment and assess marketing KPIs with structured measures and filters.
What changed
The capabilities Drinks.NG 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.