Nathan Henderson, CPA
Personal site for projects and writing.

Operational dashboard suite

Private Anonymized

A role-based dashboard suite built on a SQL warehouse and Power BI models.

Operational billing dashboard showing KPI cards and multi-series trend line

What I built

  • Unified exports and operational sources into a SQL warehouse.
  • Built DAX measures and role-based views per team.
  • Automated refreshes with validation and runbooks.

Context

Mid-size firm · 50–200 users

Stack

SQL Server / Power BI / DAX / ETL pipelines

Outcomes

  • Reduced manual reporting and improved job profitability visibility with role-based views.
  • Sped up reporting cadence from ad-hoc from system to daily from database.
  • Designed and implemented KPI regime with senior management to steer business.

Details available on request.

Screenshots and examples use synthetic or redacted data.

Notes

A self-serve BI portal for role-based operational reporting.

Additional dashboard views

User summary dashboard (gauge and utilization)

Executive overview dashboard