Cambridge Education
Education | Cambridge, England
Owner: Bridgepoint
PROJECT OVERVIEW
SCOPE
Analyse, cleanse and transactionally connect 7 years of historical sales invoice and commissions calculations data
Standardise all excel commissions models (27 files)
Create data warehouse and self-service analysis suite
SOLUTIONS
Standardised all data in PowerBI datatables
Built data schema to connect revenue and commissions transactions
Designed and implemented data logic to ensure future-proofing
Advised client on how their key revenue reports should be modified and how to improve commissions and month-end processes
Designed and implemented PowerBI analysis suite
Trained staff in how to update dataset and in PowerBI report development
MAJOR BENEFITS
Company can now see revenues and commissions trends for past 7 years and model is easily updated for future years
Insights gained on performance by territory, student nationality, college, agent tier etc allowing business to re-focus growth strategy
Testimonial
“The 1Truth team initially undertook an extensive data cleansing exercise on our revenues and commissions data, covering a 7 year period. Their work will certainly help us drive EBITDA by re-focussing our sales and cost-of-capture efforts.”
Phil Symes, CFO, Cambridge Education Group