16 Brands, One Data Standard
Non-conforming data structures across 16 brands in Malaysia and the UK, preventing unified reporting and hindering operational oversight.
The Challenge
A prominent F&B group operating 16 distinct brands across Malaysia and the UK faced a data nightmare. Each brand had evolved its own systems, processes, and data structures:
| Problem | Impact |
|---|---|
| Different POS systems | Incompatible data formats |
| Inconsistent product categorizations | No cross-brand comparison |
| Varied reporting structures | Impossible unified view |
| No centralized performance data | Leadership flying blind |
The leadership team couldn’t answer basic questions:
- Which brands are most profitable?
- Where are the operational inefficiencies?
- What’s working in one market that could scale to another?
Every month-end close meant weeks of manual data wrangling. By the time reports were ready, the insights were stale.
The Solution
Polar Packet brought order to the chaos.
Data Architecture Design
We engineered a unified data model accommodating each brand’s unique needs while providing standardized reporting:
- Custom schemas for POS data ingestion
- Standardized product hierarchies and categorizations
- Consistent KPI definitions across all brands
GCP Implementation
We built a centralized data environment on Google Cloud Platform:
| Component | Purpose |
|---|---|
| Automated pipelines | Data from all 16 brands |
| Data Cleanrooms | Secure, compliant analytics |
| Role-based access | Brand managers and executives |
Data Governance
We established data quality standards and hygiene protocols to ensure ongoing consistency as the portfolio grows.
The Results
| Metric | Impact |
|---|---|
| Data Structures | 16 brands streamlined into one unified model |
| Reporting Time | 70% reduction in hours spent |
| Analytics Capability | Data Cleanrooms established |
| Portfolio Visibility | Real-time view for first time in company history |
Key outcomes:
- 16 data structures streamlined into one unified model
- Data Cleanrooms established for secure cross-brand analytics
- 70% reduction in reporting hours
- Real-time portfolio visibility
- Scalable foundation ready for future brand acquisitions
The F&B group now makes decisions based on data, not guesswork.