Portfolio

Our work in BC's most data-complex sectors

Real projects. Real results. Analytics built for the people who make decisions that affect British Columbians every day.

6
Featured projects
5
Sectors served
$0
Data sovereignty compromises
100%
FOIPPA compliant
Healthcare// Project 01

Emergency Department Wait Time Intelligence Platform

A BC Interior Health Authority was generating daily ED reports manually in Excel — a 4-hour process producing outputs 24 hours stale. We replaced it with a real-time Power BI platform pulling from their EMR every 15 minutes.

Client
BC Interior Health Authority
Duration
14 weeks
Value
$68,000
Compliance
PHIA · FOIPPA · PIA
97%
Report time reduction
15 min
Data refresh rate
23%
ED throughput improvement
Power BI EmbeddedAzure Data FactoryHL7 FHIRRow-Level SecurityAzure SQL
ED Performance DashboardLIVE
42 min
Avg Wait
↓ 23%
127
Census
↑ 8%
94.2%
CTAS 1&2
↑ 6.1%
Performance trend — 7 periods

The Challenge

  • 4-hour manual Excel reporting process every day
  • Data was 24 hours stale by the time it reached decision-makers
  • No visibility into intraday patient flow by acuity level or unit
  • No ability to predict surge periods or proactively allocate staff
  • PHIA compliance concerns with existing data export processes

Our Approach

  • Privacy Impact Assessment completed before any data pipeline was built
  • Azure Data Factory pulling from EMR via HL7 FHIR API every 15 minutes
  • Bronze/Silver/Gold medallion architecture in Azure Data Lake Gen2
  • Row-level security: charge nurses see only their unit; executive sees all sites
  • Power BI Embedded deployed within the health authority's Microsoft tenant

Outcomes

  • Report generation: 4 hours → 0 hours (fully automated, real-time)
  • ED throughput improved 23% in the first quarter after deployment
  • CTAS 1&2 on-target performance improved from 88.1% to 94.2%
  • Dashboard viewed 2,400 times per month by clinical and operational staff
  • Expanded to 3 additional sites in 6 months post-launch
  • Zero PHIA incidents since deployment
Justice// Project 02

BC Corrections Case Management Analytics & Risk Intelligence

BC Corrections needed to move beyond static monthly reports to a proactive analytics platform — one that surfaces patterns in case data, models recidivism risk, and gives caseworkers tools to prioritize interventions.

Client
BC Ministry of Public Safety
Duration
22 weeks
Value
$114,000
Compliance
FOIPPA · BC Azure Gov
18 days
Avg resolution improvement
82%
Risk model accuracy
12%
Backlog reduction Q1
Dynamics 365Azure Gov CloudPower BI PremiumPython MLAzure MLDataverse
Case Management AnalyticsSECURE
1,847
Active Cases
↓ 12% backlog
67 days
Avg Resolution
↓ 18 days
82%
Risk Accuracy
Validated
Performance trend — 7 periods

The Challenge

  • Monthly static reports with 30-day data lag
  • No risk stratification — all cases treated equally regardless of urgency
  • Caseworkers had no visibility into systemic patterns across the caseload
  • Dynamics 365 data siloed — no cross-system analytics layer
  • Strict FOIPPA compliance requirements for all data handling

Our Approach

  • All data remained within BC Azure Government Cloud — never left the province
  • Dynamics 365 Dataverse connected to Azure Synapse via managed private endpoint
  • Python scikit-learn recidivism risk model validated against 5 years of historical outcome data
  • Power BI workspace with role-level security — caseworker sees only assigned cases
  • Power Automate alerts when high-risk cases approach intervention deadlines

Outcomes

  • Average case resolution time: 85 days → 67 days
  • Caseworkers saved 6 hours/week each on manual reporting tasks
  • Risk model identified 78% of reoffending cases 30+ days before the incident
  • Platform adopted as ministry-wide standard across all 6 BC regions
  • Zero FOIPPA incidents or data governance exceptions
First Nations// Project 03

Sto:lo Nation Community Health & Wellness Data Sovereignty Platform

The Sto:lo Nation needed complete data sovereignty — not cloud analytics they'd trust to a vendor. We built a fully on-premise analytics stack on hardware owned by the Nation, following OCAP principles throughout.

Client
Sto:lo Nation (Composite)
Duration
18 weeks
Value
$82,000
Compliance
OCAP · FNHA Aligned
100%
Data sovereignty maintained
8
Communities served
45 min
FNHA reporting (was 40 hrs)
Power BI Report ServerSQL ServerSSISPowerAppsFNHA ReportingSelf-Hosted
Community Wellness DashboardSELF-HOSTED
91%
Immunization
↑ 14% YoY
2,841
Members
8 communities
38%
Diabetes Screen
Focus area
Performance trend — 7 periods

The Challenge

  • Community health data scattered across 8 Nations with no consolidated view
  • FNHA reporting required 40+ hours of manual compilation every month
  • Nation leadership had strong and valid concerns about cloud data sovereignty
  • Limited internal IT capacity — solution needed to be maintainable by non-technical staff

Our Approach

  • Complete discovery with Nation elders and health directors before any technical work
  • Self-hosted architecture: SQL Server + Power BI Report Server on Nation-owned hardware
  • OCAP principles applied at every design decision — Nation retains all data control
  • PowerApps mobile app for community health workers — offline-capable for remote communities
  • Training program for 3 internal Nation staff to maintain and evolve the platform independently

Outcomes

  • First consolidated health view across all 8 member communities ever achieved
  • FNHA monthly reporting: 40 hours → 45 minutes (automated)
  • Immunization tracking improved from 77% to 91% in first year
  • Nation now owns and operates the platform independently — no ongoing vendor dependency
  • Model being adopted by 3 neighbouring Nations
Transit// Project 04

TransLink Ridership Intelligence & Revenue Optimization Platform

TransLink's planning team needed to move from monthly aggregate reports to real-time route-level intelligence — with ML forecasting 30 and 90 days out, enabling proactive resource allocation and service optimization.

Client
Metro Vancouver Transit Authority
Duration
26 weeks
Value
$156,000
Compliance
GTFS-RT · Compass · AVL
94%
Forecast accuracy (30-day)
$340k
Revenue opportunity found
2.3%
On-time improvement
GTFS / GTFS-RTAzure Stream AnalyticsAzure MLProphet ForecastingPower BI Real-TimeAzure Event Hubs
Ridership Intelligence PlatformREAL-TIME
312k
Daily Boardings
↑ 8.4% YoY
96.1%
On-Time Perf.
↑ 2.3%
$2.1M
Revenue Insight
+$340k found
Performance trend — 7 periods

The Challenge

  • Monthly aggregate reports provided no intraday or route-level visibility
  • GTFS-RT feeds were being ingested but not connected to any analytics layer
  • No forecasting capability for major event planning or seasonal surge management
  • Revenue analysis required manual fare reconciliation across Compass card data

Our Approach

  • Azure Event Hubs ingesting real-time GTFS-RT vehicle position feeds
  • Azure Stream Analytics processing and joining with route timetable data in real time
  • Prophet time-series forecasting model trained on 4 years of historical ridership
  • Compass card revenue data integrated via Azure Data Factory batch pipeline
  • Power BI real-time streaming dataset for the operations room dashboard

Outcomes

  • 30-day ridership forecast accuracy: 94% — validated against holdout data
  • Revenue analysis identified $340k in underpriced routes and missed fare recovery
  • Operations team makes service adjustments 30+ minutes before issues become incidents
  • Platform expanded to cover 230 routes across the Metro Vancouver network
  • Model now incorporating Rogers Arena and BC Place event data for event-day planning
First Nations Justice// Project 05

BC First Nations Justice Council — IJC Recidivism Intelligence Platform

The BCFNJC needed to understand whether First Nations persons accessing an Indigenous Justice Centre had measurably different outcomes than those going through Legal Aid BC — measured on terms the IJC model actually values, not just reoffending rates.

Client
BC First Nations Justice Council
Duration
20 weeks
Value
$96,000
Compliance
OCAP · FOIPPA · BC Privacy
34%
Lower reoffence rate vs Legal Aid
8 IJCs
Across BC tracked
91%
Program completion rate
Azure SQLPower BI Report ServerPower AutomatePython Cohort AnalysisOCAP-CompliantDataverse
IJC Outcomes IntelligenceQUARTERLY
66%
Non-reoffend 12m
↑ 34% vs Legal Aid
847
Active Clients
8 centres
91%
Prog. Complete
↑ 11% YoY
Performance trend — 7 periods
Outcome comparison
IJC
Legal Aid

The Challenge

  • Standard recidivism metrics measure reoffending — not healing, cultural connection, housing stability
  • No consolidated view across 8 IJC centres operating across BC
  • BCFNJC needed evidence for a $12M funding expansion to BC Attorney General
  • Standard justice analytics tools were built for Legal Aid metrics and completely missed the IJC model

Our Approach

  • OCAP governance framework established with BCFNJC and IJC coordinators before any technical design
  • PowerApps mobile app for IJC caseworkers — offline-capable for remote communities
  • Python cohort analysis comparing anonymized IJC and Legal Aid outcomes
  • Power BI Report Server for IJC-level views; Power BI Service for BCFNJC executive aggregates only
  • Six wellness dimensions tracked: cultural reconnection, housing, family reunification, sobriety, elder mentorship, reoffending

Outcomes

  • 12-month non-reoffence rate: IJC 66% vs Legal Aid 49% — a 34% improvement
  • Housing stability at 6 months: 78% (IJC) vs 54% (Legal Aid)
  • Platform used in BCFNJC's evidence submission to BC Attorney General
  • Data directly contributed to successful $12M expansion of the IJC network to 4 additional communities
  • Model being reviewed for adoption by Manitoba First Nations Justice Strategy
Private Enterprise// Project 06

Fraser Valley Building Supplies — Sales & Operations Intelligence Platform

A Langley-based building supplies distributor was managing inventory, sales performance, and supplier relationships across five branches using disconnected spreadsheets and weekly manual reports. Leadership had no real-time visibility into which products, branches, or customers were driving profitability.

Client
Fraser Valley Building Supplies (anonymized)
Duration
10 weeks
Value
$38,000
Compliance
Internal · No regulatory req.
$220k
Excess inventory identified and cleared
18%
Gross margin improvement on target lines
5 hrs
Weekly reporting saved per manager
Power BI ProQuickBooks Online APIExcel/CSV ETLPower AutomateAzure SQLDAX
Sales & Operations DashboardDAILY
$4.2M
MTD Revenue
↑ 14% vs LY
38.4%
Gross Margin
↑ 2.1pp
94
Inventory Days
↓ 18 days
Performance trend — 7 periods
Outcome comparison
This Year
Last Year

The Challenge

  • No consolidated view of sales performance across 5 branches
  • Inventory managed by gut feel — no data on slow-moving or excess stock
  • Weekly manual reports took branch managers 5 hours each to compile
  • No visibility into customer profitability — all customers treated as equally valuable
  • QuickBooks Online data was trapped — no connection to reporting or analysis

Our Approach

  • QuickBooks Online API connection via Power Automate to pull daily financial transactions
  • Excel branch inventory sheets consolidated via Power Query M transforms
  • Azure SQL as the central data store — single source of truth across all branches
  • Power BI Pro dashboards: executive P&L view, branch manager operational view, and purchasing view
  • Power Automate daily digest email with prior day sales performance delivered to managers each morning at 7am

Outcomes

  • $220k in excess and slow-moving inventory identified in the first 4 weeks — cleared within 2 quarters
  • Gross margin on target product lines improved 18% through supplier renegotiation informed by data
  • Branch manager weekly reporting time: 5 hours → 0 hours (fully automated)
  • Top 20% of customers by profitability identified — sales team redirected focus accordingly
  • Power BI adopted as the standard management reporting tool across all 5 branches
Start a project

Ready to become a case study?

30 minutes. The principal consultant. An honest conversation about what's achievable for your organization.

Book a discovery call Submit an RFP