Establishing a Unified Data & Insights Solution for Cancer Council NSW
About Cancer Council NSW
Cancer Council NSW is one of Australia’s leading cancer charities, supporting people affected by cancer, funding research, and driving prevention initiatives across the community. The organisation delivers services across prevention, support, research, advocacy, and fundraising, and relies on accurate, accessible data to support decision-making and operational reporting. To improve visibility and strengthen reporting capability, Cancer Council NSW initiated a Unified Data & Insights program focused on rebuilding critical reporting and establishing a scalable enterprise data foundation.
The Challenge

Cancer Council NSW faced a number of interconnected data and reporting challenges that had grown in complexity over time. Data was fragmented across systems and teams, resulting in heavy reliance on spreadsheets, point solutions, and manual reporting processes. The legacy CISS dashboard had become obsolete due to changes in Dynamics 365 CRM fields and lapses in automated data refreshes, leaving the organisation without a reliable view of critical service delivery metrics.

Client Testimonial
“Agile Insights delivered a highly collaborative engagement with strong technical capability and clear communication throughout. The team brought a structured but flexible approach – they kept things on track and worked through challenges constructively as they came up. It was a genuinely positive experience from start to finish. What stood out was the team’s ability to think beyond the immediate deliverables. They didn’t just deliver what was asked – they took the time to understand what we needed and made sure the platform was set up in a way that was sustainable, well-governed, and easy for others to build on down the track. This project was step one for us – laying the foundations and standing up a modern data platform that we can now expand across the organisation. We’re planning to continue working with Agile Insights as we expand the platform and move into the next phase.”

Our Solution

Agile Insights delivered a Microsoft Fabric–based Unified Data & Insights Solution designed to provide a governed and scalable reporting foundation for Cancer Council NSW. The solution introduced a medallion architecture with Bronze and Silver Lakehouses for ingestion and historical conformance, and a Gold Warehouse for curated dimensional reporting.

Agile Insights’ metadata-driven ELT framework was deployed to orchestrate Bronze-to-Silver and Silver-to-Gold processing using Fabric Pipelines, PySpark notebooks, and SQL stored procedures, supported by audit logging and monitoring. A governed Power BI semantic model was built on top of the Gold layer to support CISS reporting, covering service delivery, client demographics, transport-to-treatment analysis, and operational reporting. The engagement concluded with as-built documentation and knowledge transfer to ensure long-term ownership by Cancer Council NSW.

Reporting
Before, the CISS dashboard had become obsolete due to CRM field changes and failed data refreshes, with business logic scattered across Synapse views, Power BI models, and manual calculations, resulting in heavy reliance on spreadsheets and workarounds; after, the dashboard was rebuilt using curated Gold-layer data, with business logic centralised into reusable semantic models to reduce inconsistency and secure, role-based reporting access delivered through Power BI.
Data Platform
Before, the data platform was fragmented and difficult to maintain, with data spread across multiple systems, inconsistent definitions, and limited governance, resulting in unreliable reporting and heavy manual intervention; after, the platform was modernised with a unified architecture leveraging curated Gold-layer data, centralised logic and governance, and scalable, automated pipelines, enabling consistent, trusted insights and secure, role-based access across the business.
Operations
Before, operations lacked structure, with no dependency management or logging in place, leading to high operational risk and limited visibility into pipeline health; after, a metadata-driven ELT framework was implemented with structured orchestration and execution logging, improving transparency, simplifying operations, and enabling ongoing Load Monitor reporting.
Strategy
Copilot said: Before, the strategy lacked clear alignment and direction, with siloed initiatives and limited visibility into priorities, leading to inconsistent decision-making and missed opportunities; after, a structured and aligned data strategy was established, providing clear direction, prioritisation, and governance, enabling more informed decisions and a cohesive approach across the organisation.
Why It Worked

Agile Insights delivered the solution through a structured, phased engagement focused on:

  • Designing a medallion architecture aligned with Microsoft Fabric best practices
  • Deploying a reusable, metadata-driven ELT framework with audit and monitoring capability
  • Embedding governance through structured data models, semantic layers, and documentation
  • Early engagement with the client’s data governance function to ensure long-term alignment
  • Delivering knowledge transfer and as-built documentation for internal team ownership

The Impact

Cancer Council NSW now operates on a modern, scalable, and governed data platform that supports reliable CISS reporting and provides a strong foundation for future expansion. The organisation is better positioned to onboard new reporting domains, strengthen data governance, and deliver improved visibility across the business. The Unified Data & Insights Solution reduces manual effort, increases consistency, and gives Cancer Council NSW the tools it needs to continue growing its analytical capability with confidence.

Download the full case study here.

Get in touch