Change Through Sport (Canada)
Driving community impact through governed data and inclusive insight
Client Overview
Client
Change Through Sport | Changer par le Sport (CTSC)
Industry
Not-for-profit, Community & Inclusion
Services
Fabric foundations, Salesforce integration, reporting & insights, lightweight governance, AI-readiness
Technology
Microsoft Fabric, Power BI, OneLake, Fabric Data Pipelines, RBAC, Governance policies
At a Glance
Reporting cycles reduced from days to near real-time dashboards
Automated report packs for funders and board, improving transparency
Clear visibility of participation, demographics, retention across programs
Scalable foundations to support growth into Montreal and Barrie - without extra admin load
AI-ready medallion architecture for next-gen impact measurement
The Challenge
CTSC serves diverse communities - Rexdale youth and visually impaired athletes across the Greater Toronto Area - yet data lived in Salesforce silos, requiring manual collation for funders and internal decisions. With expansion on the horizon, the administrative burden risked diverting focus from program delivery. The organisation needed trusted, timely insight to tell its story with data, target equity gaps, and scale sustainably.
What We Delivered
nexwave partnered with CTSC to establish a modern reporting platform on Microsoft Fabric, integrating Salesforce into governed, AI-ready insights.
1) Microsoft Fabric foundations
- Provisioned Fabric capacity with secure workspaces and RBAC
- Applied governance policies to uphold privacy and responsible use
2) Salesforce data integration
- Built automated ingestion pipelines for participants, volunteers and programs
- Standardised data structures to support consistent reporting and future analytics
3) Reporting & insights
- Developed Power BI dashboards tracking participation, demographics and retention trends
- Delivered automated report packs for funders and the board, cutting manual effort
4) Data governance & AI enablement
- Introduced a lightweight governance framework with ownership and stewardship
- Implemented medallion architecture (Bronze/Silver/Gold) to support AI use cases (e.g., retention risk, schedule optimisation)
Outcomes
Operational efficiency
Reporting moved from manual, multi-day cycles to near real-time access
Funding readiness
Automated, trustworthy reporting improved transparency for grant applications and partner updates
Engagement uplift
Tracking attendee tenure highlights both highly engaged and low-participation individuals, enabling targeted outreach to boost overall program participation
Capacity maximisation
Monitoring attendance and utilisation rates enables smart overbooking, ensuring more sessions are delivered to more participants without wasted capacity
Scalable growth
Fabric architecture supports expansion to new regions without additional admin overhead
Future-ready
Trusted, governed environment sets the stage for AI-driven impact measurement and program design
Change Management & Enablement
We co-designed dashboards and definitions with program leaders, delivered role-based walkthroughs, and left CTSC with a simple governance playbook so insight creation is repeatable - and trusted.
What's Next
Change Through Sport Canada plans to add new data sources and pilot AI-assisted insights to deepen inclusion outcomes, while continuing to streamline reporting for funders and the community.
Ready to Transform Your Organization with Data?
Let's discuss how nexwave can help you unlock insights and drive impact in your community.