Pattern Grid engagement · Drinks retail, distribution and e-commerce

Drinks.NG

Integrating sales, inventory, fulfilment and marketing reporting.

A shopper with a trolley in a Lagos supermarket aisle

Photograph for context: a Lagos supermarket. Not a client site.

At a glance

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.

SourcesCin7 (sales, inventory, orders)SENRI (field sales)Google Analytics (web) PipelineAzure CLI ETL OutputsSales by channel, product, customerInventory days and valueFulfilment statusMarketing KPIs
Focus

What the engagement set out to fix.

  • Automated data integration
  • Multichannel sales reporting
  • Inventory reporting
  • Fulfilment visibility
  • Marketing KPIs
Tools and platforms

What the solution runs on.

  • Cin7
  • Google Analytics
  • SENRI
  • Azure CLI
  • Power BI
01

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 main challenges
Fragmented sales reportingDistribution, retail and e-commerce sales needed consolidating while keeping each channel visible.
Disconnected inventory and sales informationInventory records needed analysing alongside product sales to understand availability and movement.
Limited fulfilment visibilityOrder and fulfilment information needed organising to monitor progress and outstanding orders.
Separate marketing and commercial reportingWebsite activity and marketing KPIs needed to sit beside e-commerce sales performance.
Repeated data preparationData from three platforms needed an automated extraction and transformation process.
02

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.

03

What was built

Pattern Grid developed an automated data integration and Business Intelligence solution that brought together information from Cin7, Google Analytics and SENRI.

Automate data integrationDelivered

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.

Build multichannel sales reportingDelivered

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.

Structure inventory reportingDelivered

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.

Improve fulfilment visibilityDelivered

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.

Develop marketing KPI reportingDelivered

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.

Create Power BI dashboardsDelivered

Users can explore sales across channels, review inventory, monitor fulfilment and assess marketing KPIs with structured measures and filters.

04

What changed

The capabilities Drinks.NG gained, as recorded in the project notes.

Automated data preparation across three platformsA repeatable ETL workflow replaced separate, one-off extraction and preparation.
Consolidated visibility across sales channelsDistribution, retail and e-commerce analysed within one framework, each still visible on its own.
Better visibility into inventory and stock movementStock information connected to product sales: availability, inventory value and estimated coverage.
Clearer fulfilment reportingOutstanding fulfilment and orders needing operational follow-up are identifiable.
Structured marketing performance measurementAcquisition sources, engagement and commercial performance in one consistent framework, where supporting data was available.
A reusable Business Intelligence foundationAutomated workflows, structured datasets and Power BI measures that support ongoing reporting and future analysis.

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.

  1. We read your enquiry
  2. We reply to arrange a short conversation
  3. We suggest a sensible next step