top of page

Create Your First Project

Start adding your projects to your portfolio. Click on "Manage Projects" to get started

RCM Funnel Analytics – US Healthcare (Power BI)

Project type

Portfolio

Date

December 2025

This project demonstrates a comprehensive Revenue Cycle Management (RCM) analytics solution developed in Power BI to track claim movement, financial outcomes, and denial trends within the US healthcare billing ecosystem.

The dashboard is designed for executive and operational stakeholders, providing insights into:

Revenue performance and collection efficiency

Claim lifecycle conversion rates

Denial root causes and financial impact

Accounts receivable (AR) aging and cash flow risks

🗂 Data Transparency

This project uses a synthetic but industry-aligned healthcare claims dataset, modeled on real US RCM workflows and payer reimbursement logic.
No real patient data is used, ensuring HIPAA compliance while maintaining operational authenticity.

🔧 Tools & Concepts

Power BI & DAX

Healthcare RCM & AR analytics

Funnel analysis & KPI design

Data storytelling for decision-making

Github Project Link :- https://github.com/pp75517-png/RCM-Funnel-Analytics-PowerBI

CONTACT ME

  • LinkedIn
  • GitHub
  • Facebook
  • Instagram

US Healthcare Analyst.

Phone:

+91 9163226683

Email:

© 2025 By Piyush Pandey. Powered and secured by Wix

bottom of page