Improved data accuracy and helped identify and recover $1.3M in missed billable claims by establishing a Business Intelligence (BI) practice at SmileMD, providing real-time insights and enhancing decision-making.
01
Challenge Our organization faced a significant challenge in anticipating the impact of change due to the lack of timely reporting and inconsistent data analysis methods. Reporting and dashboards were manually created and maintained in Excel, leading to a high margin of error and poor data hygiene, which hindered our decision-making capabilities.
02
Action To overcome these obstacles, we established a comprehensive Business Intelligence (BI) practice. This initiative provided OFFOR Health with its first real-time view of flow, capacity, and efficiency across departments and capabilities.
BI Practice Establishment: Developed and implemented a robust BI practice that enabled real-time data visibility and standardized reporting processes.Data Hygiene Dashboards: Created a series of dashboards focused on maintaining data health, reducing errors, and ensuring consistent data quality.03
Results The introduction of the BI practice led to significant improvements:
Low Margin of Error: The new data hygiene dashboards dramatically reduced reporting errors, ensuring reliable and accurate data for decision-making.Financial Recovery: Through rigorous data cleanliness exercises, we identified and recovered $1.3 million in missed billable claims, directly contributing to the organization's financial health.These results not only enhanced our ability to anticipate and respond to changes but also reinforced the importance of maintaining high data quality standards, leading to more informed and effective decision-making.
Questions How was $1.3M in missed billable claims uncovered? Through rigorous data cleanliness exercises and the establishment of SmileMD's first Business Intelligence practice, $1.3 million in previously missed billable claims were identified and recovered.
What BI capabilities were established? SmileMD's first-ever Business Intelligence practice was established, providing real-time visibility into flow, capacity, and efficiency across departments, replacing manually maintained Excel-based reporting.
What replaced Excel-based reporting at SmileMD? Manually maintained Excel spreadsheets were replaced with automated BI dashboards providing real-time data hygiene insights, dramatically reducing reporting errors and freeing the team for higher-value analysis.
How was the $1.3M in missed claims identified through data cleanliness? The new BI dashboards exposed data inconsistencies and gaps in billing records that had been invisible in Excel-based reporting. Systematic data cleanliness exercises revealed billable claims that had been missed or incorrectly categorized.
What BI tools and platforms were used at SmileMD? The BI practice leveraged dashboarding and reporting tools integrated with SmileMD's Salesforce Health Cloud data, replacing manually maintained Excel spreadsheets with automated, real-time data hygiene and performance dashboards.
Back to case studies
In development
An end-to-end platform for dental practices.Front desk, clinical charting, insurance, checkout and reporting on one FHIR-based record. Built by a small team directing AI agents inside governed foundations.Product overview 
App Store deployed · Preparing for commercial launch
Eight benefit accounts on one card.Health, commuter and wage-law benefits on a single payment card, with a member app and an admin portal. Run by one person directing AI agents across product, engineering and compliance.Product overview