Complete GCP DWH for SME Distributor
From copy-paste grind to always-on BigQuery reporting in weeks.
The Shift at a Glance
We eliminated a monthly bottleneck where the CSO spent a full day copy-pasting sensitive sales data from a legacy PHP system into spreadsheets. In weeks, we replaced that grind with a live GCP warehouse feeding Connected Sheets and dashboards. Now sales, PMs, and procurement teams track bonuses, quotas, and trends daily instead of waiting a month for answers.
- Executive Time Saved
- 12+ days/year
- Reporting Lag
- 30 days → 0
- Org Adoption
- Sales, PMs, Procurement
Who We Helped
SME distributor scaling across multiple regions. Already on Google Workspace, but still tethered to a home-grown PHP information system. Accessing critical sales performance data meant clunky manual work or waiting on the slow IS — a drag on efficiency as the business kept expanding.
The Pain
The CSO personally spent a full day every month copy-pasting sensitive numbers. Staff across sales and PM teams hacked around with CSV exports or waited on the sluggish IS. Reports lagged weeks behind reality, errors crept in, and no one trusted the numbers.
- Critical data locked across ERP, CRM, and vendor portals
- Month-end reports landed weeks late — useless for real decisions
- Teams wasting hours on copy-paste fixes and formatting gymnastics
- Conflicting numbers everywhere, no single version of truth
How We Fixed It
We built a fully GCP-native warehouse starting with a replication of their MySQL legacy system. Clean, structured tables were transformed via SQLX models for consistency. From there:
- Datastream CDC from ERP into BigQuery (near real-time ingest)
- Cloud Run Python ETL for CRM and supplier data
- Dataform silver/gold layers enforcing consistent KPIs
- Google Sheets connected directly to BigQuery for live pivot tables and reports
The Outcome
Reporting shifted from once-a-month snapshots to always-on insights. Sensitive workflows no longer bottleneck at the CSO’s desk. Instead of wasting days reconciling numbers, leadership and teams make confident calls on bonuses, procurement, and performance — backed by live, trusted data.
- Executive Time Saved
- 12+ days/year
- Reporting Lag
- 30 days → 0
- Org Adoption
- 100% Sales, PMs, Procurement
“We went from waiting weeks for answers to having numbers on tap. Everyone — from sales reps to procurement — trusts the data and uses it daily.”
Why It Matters
- Built entirely on Google Cloud — secure, scalable, and future-ready
- Directly integrated with Google Workspace tools staff already use
- Eliminates reporting lag so decisions are made on live data, not stale exports