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.
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.
Agile Insights delivered the solution through a structured, phased engagement focused on:
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
| Cookie | Duration | Description |
|---|---|---|
| cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
| cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
| cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
| cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
| cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
| viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |