LoriTechFROM DATA TO RESULTS← Back to solutionsLet's connect ↗
CASE STUDY / FIDUCIARY OPERATIONS

Team Capacity
& SLA Monitoring.

I built an activity tracking and reporting tool so fiduciary teams could see how work was distributed, identify workload peaks and review capacity alongside service commitments.

Explore & try the tool ↓

480 minutesDaily capacity per employee

2,400 minutesCapacity for a five-day workweek

Activity benchmarksCompare recorded time with configured estimates

THE BUSINESS PROBLEM

Make workload peaks
visible to teams.

Coordinators needed a clearer picture of available capacity and where employees were spending their time. I developed the Power Apps workflow, the Power Automate integration with Access, and the Power BI reporting layer with Python.

Activity estimates help explain the effort behind the work. SLA performance uses service completion records and agreed deadlines.

INTERACTIVE WALKTHROUGH

Log an activity and review the workload.

Illustrative screens recreated to protect business confidentiality. Employee identities, activity estimates, and service records are fictional. Entries stay in this browser session.

  1. 01 · Verify employee
  2. 02 · Log activity
  3. 03 · Compare capacity
  4. 04 · Review workload and SLA

Verify employee record

Power Apps checks the current employee against the directory without a separate app login. Select a fictional identity to try both outcomes.

Verify an employee to open the activity form.

Verify a sample employee to begin.