Irene Y. Portfolio

← Back to Projects

Enterprise Power BI Dashboard Suite

Business Intelligence · Camp Australia · 2022–2025

📌 Overview

Designed and delivered 100+ advanced Power BI dashboards integrated with Snowflake, covering state, school, and customer segment performance. Pioneered a "Traffic Lights Priority" framework for 500+ schools enabling at-a-glance performance monitoring.

🏆 Key Contributions

  • Architected the enterprise BI framework from scratch, establishing data models, DAX measures, and standardised KPIs across all business units.
  • Built 100+ dashboards spanning operations, finance, marketing, customer insights, and executive reporting.
  • Pioneered "Traffic Lights Priority" system — a RAG-status framework enabling area managers to instantly identify underperforming schools.
  • Integrated Snowflake as the central data warehouse, building optimised SQL views and incremental refresh schedules.
  • Trained cross-functional teams on dashboard usage and self-serve analytics, increasing data literacy across the organisation.

🛠 Tech Stack

Power BI Snowflake DAX Data Modelling SQL ETL

📈 Outcome

★ Enabled data-driven decisions across Australia's largest OSHC provider. The dashboard suite became the single source of truth for operational and strategic decision-making, used daily by 50+ stakeholders from area managers to the C-suite.