1 ✅ Part 1: Metrics Summary Table for Quarterly/Annual Tracking

##KPIs are trackable measurse a business watches overtime to gauge its growth and success.

KPI Name Description
Total Charges Sum of srvc_tot
Average Charges per Day Mean of daily totals within the period
Average Charges per Patient sum(srvc_tot) / unique(patient_id)
Unique Patients Number of unique patients treated
Total Services Sum of count or record rows
Avg Units per Service Mean of unit_ct
Avg Charge per Unit Mean of unit_crge
Key Performance Indicators by Month
Month Total_Charges Avg_Charges_per_Day Unique_Patients Total_Services Avg_Units_per_Service Avg_Charge_per_Unit
2024-11-01 391.18 65.20 5 5.70 2.00 32.60
2024-12-01 331.60 66.32 5 5.00 2.00 33.16
2025-01-01 8263.34 64.06 62 123.78 1.99 32.13
2025-02-01 8078.44 63.11 54 126.55 2.01 31.48
2025-03-01 13303.64 74.74 79 198.50 2.55 30.07
2025-04-01 16111.69 80.16 85 212.70 2.46 32.00
2025-05-01 17316.89 64.14 114 251.60 2.20 29.98
2025-06-01 3694.51 57.73 52 55.95 1.97 30.17
NA 0.00 NaN 1 0.00 NaN NaN



## ✅ Part 2 :Monthly, Weekly and Daily Charge Summaries















## Part 3: % Percent Change of KPI’s Month Over Month ##✅ Interpretation Positive values = growth

Negative values = decline

2 NA in the first row (e.g., March) is expected — no prior month to compare to.

Month-over-Month % Change in KPIs
Month Total_Charges_Change Avg_Charges_per_Day_Change Unique_Patients_Change Total_Services_Change Avg_Units_per_Service_Change Avg_Charge_per_Unit_Change
2024-11-01 NA NA NA NA NA NA
2024-12-01 -15.2 1.7 0.0 -12.3 0.0 1.7
2025-01-01 2392.0 -3.4 1140.0 2375.6 -0.5 -3.1
2025-02-01 -2.2 -1.5 -12.9 2.2 1.0 -2.0
2025-03-01 64.7 18.4 46.3 56.9 26.9 -4.5
2025-04-01 21.1 7.3 7.6 7.2 -3.5 6.4
2025-05-01 7.5 -20.0 34.1 18.3 -10.6 -6.3
2025-06-01 -78.7 -10.0 -54.4 -77.8 -10.5 0.6
NA -100.0 NaN -98.1 -100.0 NaN NaN