Colosseum Dental
Healthcare | United Kingdom
Owner: Jacob Holdings
PROJECT OVERVIEW
SCOPE
Develop a bespoke data warehouse utilising Google BigQuery to capture data feeds from all key PMS systems and numerous external data sources
Develop a self-service PowerBI environment covering an array of metrics, visualisations and analytics and roll-out across 100+ practices
Enable almost-live data feeds through daily dashboard refreshes
Transform labour-intensive reporting processes via automation
SOLUTIONS
Supported the development of a Google BigQuery data warehouse, refreshed daily from PMS branch systems, financial, HR, operational and marketing platforms
Developed a robust, cloud-based, data analytics solution in PowerBI providing daily, granular visibility on over 150 bespoke analytics and KPIs
Implemented robust data governance procedures
Provided training workshops for end-users
MAJOR BENEFITS
Enabled in-depth analysis of performance by practice, region, area, manager, treatment types across multi-year time periods
Enabled the ability to track performance of newly acquired practices
Enabled 13-week practice lookahead analyses to drive increase in practitioner utilisation
Provided insights on specific performance of in-house profitability enhancement projects
Testimonial
“As a result of 1truth’s work, we now have a comprehensive BI reporting suite updating daily, that allows analysis at regional level right down to the activity of each dental practitioner. We are convinced that this tool will be a cornerstone to the transformation of the operations and financial performance of Colosseum Dental UK group moving forward.”
Philip Buergin, CEO, Colosseum Dental UK