SGA Dental Partners
Labor Analysis Dashboard
Sign in to continue
SGA Dental Partners

Labor Analysis — Start & End of Day

Loading...
How it works: The threshold defines the acceptable window for clocking in before the first appointment and after the last appointment. Any time outside this window is overage. All costs below recalculate dynamically when you change the threshold.
Overview
Position Breakdown
Overage Cost by Position
Staffing Curve — Employees vs. Appointments
Start of Day — Daily Overage Cost
End of Day — Daily Overage Cost
Location Comparison
Opportunity Prioritization: Every location ranked by annualized savings potential at the current 30-minute threshold. Focus on the top of this list for the highest-impact interventions.
Top 25 Offices by Annualized Savings Opportunity
All Locations — Ranked by Opportunity
Employee Drill-Down: Select a location to see which employees are driving overage costs. Each person's overage is calculated at the current 30-minute threshold.
Excluded Employees — Audit Trail
Staff removed from analysis (e.g. night-shift workers outside clinic hours). Excludes apply to all employee-level views. Revertable.
👤
Select a location above to see employee-level detail
Or click a location row on the Opportunity Summary page
Time Card Analysis: Mirrors the Power BI "TimeCard Employees Charted" report. Shows non-productive minutes, clock-in lead, and clock-out lag using the same 30-minute grace period. Filter by position to focus on hygienists or other roles.
Staffing Curve — Clocked-In Employees vs. Appointments by Hour
Practice Summary — Non-Productive Time
Insights: Trend analysis, threshold sensitivity, and day-of-week patterns to identify persistent overage drivers. All views respect the current filters (location, ROD, date, threshold, first-appt cutoff).
Weekly Overage Trend
Week-by-week cost, so you can see where overage is accelerating vs improving.
Threshold Sensitivity
Network annualized cost at every threshold from 0 to 60 min. Use it to pick a defensible policy.
Day-of-Week Pattern
Average daily overage by weekday. Flat means uniform; spikes flag scheduling problems.
Persistent Offenders
Locations in the top quartile of overage for the most weeks in the filter range — these are the chronic underperformers, not one-off spikes.
Did the conversation work? Pick a baseline window (before the coaching) and a coaching window (after). Every employee, position, and office is scored on whether their average overage moved in the right direction. Threshold and first-appt cutoff from the global filter bar still apply.
Office Movement — Baseline vs Coaching (Avg overage min/day)
Bars show how each office's daily overage minutes shifted. Green = improved, red = worsened.
Position Movement — Network Average
Avg overage minutes per employee-day, before vs after, by position category.
Office Scoreboard
Sorted by improvement (best at top). Click an office row to drill into its employees below.
Top Improvers — Employees
Largest reductions in average overage minutes per day (eligible: meets min-days in both windows).
Sliding Backward — Employees
Largest increases in average overage minutes per day. These need a follow-up conversation.
Employee Drill — Did the conversation stick?
Pick an employee to see their daily clock-in lead and clock-out lag across the coaching window, with the baseline average drawn as the line they need to beat.
🔎
Select an employee above to see day-by-day movement
Try Keaton Toms (New Horizons) — coached on May 1
Conversation Log: Record every coaching conversation you have with an office. We track who you spoke to, when, and which employees you discussed. Touched employees auto-flag on the Are We Improving? page so you can see whether the conversation moved the mark.
Log a Conversation
Pick an office to see its employees.
Recent Conversations
Your last 100 logged conversations. Admins see everyone's.
Admin Audit: Are RODs actually using the dashboard? This view shows logins, time in the system, page-by-page usage, and how many coaching conversations each ROD has logged. If a ROD isn't viewing Are We Improving AND Conversations, they aren't moving the mark.
Generated
User Engagement
Green = healthy use of both Are We Improving and Conversations. Red = not engaging with the solution.
Recent Sign-Ins (last 200)
Page Activity (last 500)
All Conversations
Every coaching conversation logged across all RODs.
Practice Exceptions: Overage analysis needs BOTH sides — the appointments feed AND the timeclock punches. Practices missing either side can't be analyzed. This lists them and flags which feed is missing, so the data gap can be chased down.
Practices Missing a Data Set
Data Quality: Surfaces problems in the underlying data so you can decide what to trust. Flags coverage gaps, appointment-window anomalies, and punches that can't be evaluated.
First-Appointment Time Distribution
Distribution of days by first-appointment hour. Most practices cluster at 7–9am.
Early Clock-Ins — >2 Hours Before First Appointment
Locations ranked by number of times an employee clocked in more than 2 hours before that day's first scheduled appointment. Click a row to see the employees, dates, and clock-in times.
Punches Without Appointment Coverage
Punches on loc+date combos where no appointment record exists. These are silently skipped from overage calc.