Data strategy · PetMediaGroup
One source of truth from 50+ scattered sources
Ingestion from 50+ sources with Stitch, modelled in dbt on Google Cloud, with Looker Studio dashboards for the CEO and Head of Product
The challenge
Data was spread across more than fifty tools and services. Without a shared model, every report started from scratch and leadership could not get a consistent view of performance.
How we approached it
- Data ingestionStitch connected to 50+ sources, landing data in Google Cloud Storage
- Single source of truthWarehousing and modelling in dbt so data is standardised across the organisation
- API integrationsPython integrations to third-party APIs that Stitch did not cover
- Business intelligenceLooker Studio dashboards presenting performance directly to the CEO and Head of Product
What was delivered
A data strategy and cloud architecture for growth: one modelled warehouse on Google Cloud and executive dashboards built on it.
Impact
50+Sources in one warehouse
1Shared model for the whole organisation
Unified data access, executive-level visibility for strategic decisions, and a foundation that scales as new sources are added.
More work
Related case studies
AI workflow automation · EMEA
From manual lead handling to automated marketing operations
80% less manual workload across 20+ EMEA countries
Read the case study →Analytics & BI · NestléFrom scattered HR data to workforce planning teams can act on
Workforce analytics for supply and demand planning
Read the case study →Forecasting · DaikinFrom missed forecasts to plans the business trusts
61% → 87% forecast accuracy across 3 countries
Read the case study →