Overview
I led the dashboard end-to-end, combining Mitacs intern records, LinkedIn employment history, Google Search, and Google Scholar research into one decision-ready reporting product.
Power BI Case Study
Labour Market Outcomes Dashboard
Turning 14,000+ post-internship career records into a clear Power BI reporting system for funding, strategy, retention analysis, and labour market impact.
14,000+Mitacs interns included in the dataset
16%of interns eventually found a business
70%stay in Canada in R&D roles
Challenge
Teams relied on spreadsheets and one-off KPI requests, making it difficult to answer where interns worked, which roles they entered, and how long-term outcomes supported program value.
The Solution
Built as a connected outcome reporting system
01
Public Data Research
Employment outcomes were gathered from LinkedIn, Google Search, and Google Scholar when profile data was incomplete.
02
Data Validation
Career records were cleaned, checked, and standardized so outcomes could be compared across cohorts.
03
Power BI Modeling
The dataset was shaped into a model for employers, roles, retention, entrepreneurship, and R&D outcomes.
04
Executive Reporting
Leadership could explore impact evidence directly instead of waiting for manual spreadsheet requests.
Workflow Proof
From public data to decision-ready insights
The workflow transformed scattered career information into a structured reporting system that made retention, entrepreneurship, employers, and role outcomes easier to inspect.
Dashboard Proof
Outcome reporting leadership could use directly
The dashboard became a central source of truth for leadership, government partners, and internal teams during funding conversations and long-term program planning.
Business Impact
Results
14,000+
Intern outcome records organized into one dashboard
16%
Founder outcome insight surfaced for executive storytelling
70%
Canada-based R&D retention evidence made visible
Key Insight
The biggest impact came from replacing anecdotal reporting with visual evidence that could support funding negotiations, strategic planning, and a clearer story about long-term labour market impact.
From complex outcome data to strategic decisions.
That is the difference between reporting numbers and communicating long-term impact.
Let's Talk ↗