Billing and Service Utilisation Power BI Dashboard
A Power BI report that compares the units each client could be billed with the units actually billed, tracks billed versus paid by month and follows service use, unsigned notes, staff hours and discharges for a second program.
- Industry
- Behavioral Health (US)
- Deliverable
- Billing and Utilisation Dashboard.pbix
- Built with
- Power BI, Power Query, DAX
Before
Nobody could see quickly whether every billable unit was billed, or which notes were still unsigned.
After
Unbilled units, unpaid claims and unsigned notes show up on one report that refreshes from the EHR exports.
Related projects
Timesheet & Billing Dashboard
Legal Services
A timesheet and payout system for a small legal team. Users log in by role, workers record tasks and hours, and the admin dashboard shows billed,…
Sales Pipeline CRM for an IT Solutions Company
IT and Network Security
A CRM workbook for an IT solutions company that tracks every sales opportunity from first contact to won or lost. Clients are added and removed through…
Attendance & Compliance Automation Tool
Healthcare (Behavioral Health)
A control panel that logs into the electronic health record system with Selenium, downloads client, staff and charting reports and rebuilds the attendance, group capacity and…