This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Case Study
Office of Finance Transformation: Scaling with a Modern Data Platform
Industry:
Healthcare
Focus:
Data architecture and reporting
Senturus modernized the monthly reporting system for Chord Specialty Dental Partners (Chord) using an Azure modern data warehouse architecture and Power BI reporting. The scalable solution supports the seamless integration of existing and new data sources as well as AI capabilities and is saving Chord $72,000 annually. Near real-time analytics and reporting automation give the company the insight speed to further enhance their competitive edge.
Challenge
Chord is a private-equity-backed dental rollup that supports 60+ dental organizations spanning pediatric, orthodontia and ambulatory surgical facilities. Their financial analytics team struggled to produce monthly productivity reports for leadership and regional management. Report turnaround was bogged down by a monthly manual process that took 15 work days to complete. Data would be extracted from five sources (three practice management platforms, a financial system and an HR application, all of which were third-party supported), compiled in Excel, and then generated into required reports.
The long turnaround prevented leadership from reviewing current, actionable data. Chord wanted to harness the full value of their data. They needed insight immediacy for their management and a better way to employ the time of their financial analysts, redirecting them from data curation to proactive analysis.
Solution
Senturus partnered with Chord to automate their reporting process and deliver a panoramic view of operations with responsive reporting that uses near-real time data. To do so, data from the five disparate systems was integrated into an Azure modern data warehouse (MDW), complemented by dynamic reporting capabilities via Power BI. A semantic model was created to conform all the data into a common reporting layer standardized on Chord’s business lexicon.
Reports were built to provide different levels of insights into the organization’s performance. Capabilities included filtering, drill down into office productivity metrics, and views by time periods and practices. The MDW approach supports the seamless integration of new dental practices and provides the foundation for integration of AI.
Benefits
Significantly boosting reporting efficiency and supporting growth, the modern data platform has transformed analytics for Chord and has escalated the strategic value of its office of finance.
- Saved Chord $72,000 annually by reducing dependencies on third-party platforms.
- Eliminated 8 days/month of manual data processing effort.
- Gives the finance team time to focus on more strategic endeavors and increase the business value.
- Significantly reduces time, work and cost associated with future integration of new dental practices.
- Allows Chord to evaluate the performance of practices and assess whether targets are met daily.
- Lets analysts uncover trends and patterns that were previously obscured, e.g., collections, AR balance, billed vs. collected, and productivity.
About our client
Chord Specialty Dental Partners is a dental support organization dedicated to expanding access to quality dental care for children and adults, supporting over 60 practices across six states. From accounting and financial management to human resources and procurement, they support their partner practices and their patients.