helped MedEx uncover
approximately $1M annually in lost billing
CLIENT:
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.
