Reporting that didn’t need a ticket
Reports used to mean filing a request and waiting. Moving the data to the cloud turned them into something people could build themselves.
- For
- Before CCC, as an employee at a national retailer
- When
- 2021–2024
The situation
The company ran on on-premise servers and a monolithic app stack. Reports came from old SSRS and Cognos setups that needed a ticket and a wait, and the marketing email system wasn’t connected to customer data at all.
What I did
Over several years, I coordinated the move to the cloud with an outside data team: pipelines from the on-premise databases into a Delta Lake, self-service Power BI reports on top, and HubSpot for marketing email, fed by the same data. Along the way we wrote the company’s first data dictionary with the business.
What changed
People could build their own reports instead of waiting in a queue, and marketing worked from the same customer data as everyone else.
Built with
- Azure Data Factory
- Databricks
- Delta Lake
- Google Cloud
- Power BI
- HubSpot