At New Engen, our media department's business reporting ran on stale data and broken KPI logic that hadn't been standardized across systems. Leadership had no reliable numbers to make business decisions off of, and producing a monthly business review took a full day of manual work even before you could trust what it said.
I led the business side of a six-month rebuild, partnering with our data engineering and strategic operations teams who owned the infrastructure. We piped data from our disparate systems into Google BigQuery, and I worked with business stakeholders and leadership to redefine the KPIs and metrics views the business actually needed, while helping get data standardized against our new CRM. Once the views were built, I used AI to clean and shape the data, then fed it into a fully automated monthly dashboard for the business review.
The result cut prep time for the monthly business review from a full day to about 20 minutes. More importantly, leadership started acting on the numbers directly: we used the new reporting to re-staff a specific account to support new business and drive revenue, and it fed directly into hiring decisions and backfill planning across the department.