Project Title: NADA Outcomes Dashboard
Synthetic AOD reporting pipeline built with Python, PostgreSQL, SQL, and Power BI — modelled on NADA-style service reporting and NADAbase outcome monitoring.
View on GitHub View on LinkedIn
AOD non-government organisations need structured, reliable reporting to support funding accountability, clinical oversight, and equity-focused service planning — but operational data is often difficult to interpret without a structured analytics workflow.
Built a complete end-to-end synthetic AOD data pipeline: generated five synthetic datasets in Python, cleaned and loaded into PostgreSQL, developed 13 SQL queries including a 4-table joined dashboard view, and visualised in Power BI — replicating NADAbase reporting logic.
Supports governance and funding accountability · Enables data quality monitoring · Provides equity reporting across Indigenous status and gender · Scalable for Azure cloud deployment
