Business intelligence · Performance reporting
One framework.
A clearer picture.
KPI frameworks and Power BI dashboards that help leaders connect workforce trends, operational activity, and strategic priorities.
The question
Performance reporting becomes harder when teams use different definitions, source logic, or reporting schedules. Leaders need a shared understanding of the measures before they can use them to guide decisions.
The approach
I designed and governed enterprise KPI frameworks across more than five programs, covering more than 40 KPIs and reporting cadences from daily to monthly. I built or supported more than eight Power BI dashboards for executives, clinical programs, operations, and workforce planning.
The work combined stakeholder requirements, source validation, reporting logic, quality assurance, documentation, and training. At Sunnybrook, I use read-only SQL queries and temporary tables for analysis; permanent transformations and ETL pipelines are managed by the Business Intelligence team.
Selected reporting work
- Health Human Resources: replaced manual Excel reporting with governed views of staffing, recruitment, vacancies, and retention.
- Absenteeism reporting: restricted-access department trends supporting workforce planning and operational coverage.
- Health-profession workload: standardized activity reporting to support staffing and resource-allocation discussions.
- Enterprise performance: operational, workforce, quality, and strategic measures across programs.
What makes it useful
Definitions, data dictionaries, QA processes, and stakeholder training help reporting remain consistent after the dashboard has been built. The public summary stays at a high level and includes no employee data or private screenshots.
What matters
Shared definitions and reliable reporting logic are as important as the visual itself.
Keep exploring