SYSTEM DETECTED
> INITIALIZING NEURAL LINK...
Back to Index
CASE STUDY
Municipal Performance System
Strategy Intern // City of Saskatoon
PROJECT_ID: CITYYEAR: 2025
CONTEXT
Contributed to a city-wide strategic plan for a municipality of 300,000+ citizens, bridging high-level policy goals with execution readiness.
TECH STACK
Power BISQLStrategic PlanningVariance AnalysisData VisualizationProcess AutomationStakeholder ReportingFinancial Analysis
STATS
Strategy85%
Tech75%
Product50%
Leadership40%
01. What I Built
Developed 6 scalable financial dashboards using Power BI and SQL to analyze $1B+ in municipal budget data, translating ambiguous policy into structured performance systems.
02. How It Works
Performed rigorous variance analysis to identify $1M+ in budget optimizations. Automating monthly reporting processes reduced manual cycle time by 30%.
The Outcome
City leadership gained real-time visibility into strategic priorities. Decisions affecting nearly 300,000 residents were grounded in measurable progress rather than static reports.