Program Operations Power BI Dashboard
A 12 page Power BI report for a behavioral health provider that tracks attendance, clinical charting, signatures, weekly case reviews, discharges, staff performance, collections and bed capacity from the EHR exports, so managers stop building the same reports by hand every week.
- Industry
- Behavioral Health (US)
- Deliverable
- Program Operations Dashboard.pbix
- Built with
- Power BI, Power Query, DAX, Excel
Before
Managers rebuilt attendance, charting and collections checks in Excel from several EHR exports every week.
After
One Power BI report refreshes from the exports and shows missing notes, unsigned forms, collections and bed occupancy on 12 pages.
Related projects
Product Analysis Report Generator
FMCG / Retail Analytics
An automated sales analysis tool for a beverage brand. Raw point-of-sale data is imported, a pivot master is built and the macro produces Pareto, NIS and…
Client Eligibility Verification Master
Behavioral Health (US)
A master list for a behavioral health provider that tracks each client's insurance, redetermination date and next assessment due date. Weekly CSV exports are imported with…
Counselor Service Hours Report
Healthcare (Behavioral Health)
A counselor selector report that shows, for any week, how many minutes of individual, group, treatment coordination and peer support each assigned client received, with alerts…