- Moved their data to BigQuery, which is easier for their organization to maintain and have easy access to.
- Introduced Stitch to load data into the warehouse, reducing the need for specialized skills and speeding up data pipeline development.
- Turned their complex production data from CloudSQL into an analytics-friendly format.
- Redesigned their data model into a star schema, making data generation more efficient and cutting down on storage and compute resources.
- Rewrote their scripts into modular SQL scripts using Dataform, which reduced the codebase and made code management easy to handle.
- Rebuilt the dashboards in Looker Studio with advanced drill-down features, making it easy for users to find insights and track data origins from specific customer activities.
- Created specific datasets for different business divisions, like finance, so they could integrate the data into their own models, saving them time on data gathering.