Book a Call
Streamlining project delivery for NSW Public Works Advisory with an end-to-end automated solution
Removing Friction with Power Platform, SharePoint & Power BI.
The Opportunity
NSW Public Works Advisory (PWA), the delivery engine behind some of New South Wales’ most crucial infrastructure projects, needed to replace legacy systems and eliminate inefficiencies in project management – gaining greater visibility and control over projects while saving time and reducing risks.
The Delivery
Agile Insights delivered an end-to-end automated solution leveraging Power Apps, Power Automate, SharePoint, and Power BI – replacing legacy systems with a bespoke platform for data capture, cloud storage, automated workflows, and interactive reporting.
The Outcome
Multiple legacy systems and manual processes replaced with a single automated solution, countless hours saved through automation, improved project oversight with real-time insights into progress, spend and risks, and better team collaboration through a centralised cloud-based platform.
Book a free consultation
About NSW Public Works Advisory
NSW Public Works Advisory (PWA) plays a vital role in delivering essential infrastructure projects across New South Wales. Their remit includes the construction and maintenance of hospitals, dams, water treatment plants, and high schools. Efficient data management and reporting are critical to their mission of delivering high-quality projects on time and within budget.
The Challenge

PWA faced significant challenges with their existing systems and processes:

  • Reliance on multiple legacy systems, files, and templates, leading to inefficiencies.
  • Limited visibility into project progress and associated risks.
  • Lack of an integrated platform for data capture, workflow, storage, and reporting.
  • Time-consuming manual processes for managing critical project information.
Client Testimonial
"Agile Insights has transformed the way we manage projects. The end-to-end solution built on Microsoft's Power Platform has eliminated inefficiencies, increased visibility, and significantly reduced risks. Their expertise and commitment to delivering value have set us up for success."
Manager
NSW Public Works Advisory

Our Solution

Agile Insights implemented a tailored Power Platform solution to address PWA’s challenges. Key components included:

Data Capture
Utilised Power Apps to streamline the collection of project data, including open projects, spend, and risks.
Cloud Storage
Centralised all data on SharePoint for secure and scalable storage.
Automated Workflows
Created workflows for assurance purposes using Power Automate, ensuring consistency and efficiency.
Interactive Reporting
Designed Power BI dashboards to provide real-time visibility and insights into project performance.
Why It Worked

Our solution to resolve the challenge was executed over a period of three months. To deliver a best-of-breed solution, we kept to a meticulous project timeline.

  • Assessment: Conducted a comprehensive review of PWA’s existing systems and identified inefficiencies.
  • Solution Design: Developed an integrated platform that consolidated data capture, workflow automation, and reporting into a single streamlined solution.
  • Implementation: Deployed Power Apps, Power Automate, SharePoint, and Power BI to replace legacy systems and manual processes.
  • Training & Support: Provided customised training to PWA’s team to ensure seamless adoption and ongoing success.

The Impact

  • End-to-End Automation: Replaced multiple legacy systems and manual processes with a single automated solution.
  • Enhanced Efficiency: Saved countless hours by automating data capture, workflows, and reporting.
  • Increased Visibility: Improved project oversight with real-time insights into progress, spend, and risks.
  • Reduced Risks: Streamlined processes and enhanced data accuracy, minimising project risks.
  • Improved Collaboration: Centralised data and workflows in a cloud-based platform, enabling better team collaboration.

Get in touch