helped MedEx uncover
approximately $1M annually in lost billing
CLIENT:
![Screen Shot 2022-08-23 at 1.02.12 PM Screen Shot 2022-08-23 at 1.02.12 PM](https://www.leapfrogbi.com/wp-content/uploads/elementor/thumbs/Screen-Shot-2022-08-23-at-1.02.12-PM-qrcvad9rup376cenv1bhtgbdl30xddwj8qeccoby56.png)
INDUSTRY AND TYPE OF COMPANY:
HEALTHCARE,
MEDICAL
EQUIPMENT
COMPANY SIZE:
$40M+
800+ CLINICS
CLIENT SINCE
2018
NUMBER OF DATA SOURCES:
BUSINESS SYSTEMS / APPLICATIONS
1 BUSINESS SYSTEMS
GOALS
- Spend less time developing reports and more time focusing on core business.
- Resolve operational inefficiencies tied to revenue cycle management.
- Enhance core application features through automation of business process logic.
CHALLENGES
- Data quantities are exceeding capabilities of Excel and growing daily.
- Valuable data is accessible, but lack resources required to build targeted solutions.
- Preparing data for reporting is slow and labor-intensive.
- Data preparation consumes all available resources leaving little time to analyze results
SOLUTIONS
- Created a data warehouse focused on operation and finance subject areas.
- Using Power BI, built core reports that enable easy, fast, and accurate access to critical KPIs.
- Automated manual revenue cycle processes.
- Created alerting systems to trigger key RCM activities and create work queues.
- Automated common accounting tasks such as credit card payment postings and write offs.
RESULTS
- Revealed nearly $1M annually in lost billing.
- Time gained allowing MedEx team to focus on core business.
- Automated manual tasks resulting in decreased labor cost.