Technologies: Data Architecture, Automation, SharePoint Sites, Power BI
Title: Transforming Retrofit Management: A Microsoft-Powered Solution
Project Overview:
The challenge faced by Northumberland County Council was significant—managing complex housing retrofit projects demanded a robust system for applications, contractor relationships, and project monitoring. When the attempt to procure a bespoke system failed due to cost constraints, we stepped in to implement a Microsoft-powered solution.
Solution: Leveraging Microsoft Licences for Comprehensive Project Management
To ensure the high-quality capture of data, we implemented a series of SharePoint Lists with bespoke (json-driven) columns and interactive buttons. This innovative approach was complemented by over 50 Power Automate flows, enabling a streamlined workflow for a team of 20 across multiple project stages: Eligibility Checks, Retrofit Assessment, Coordination, Design, and Installation.
Dashboard Insights: Real-Time Monitoring and Individual Journeys
The project delivered a series of dashboards that provide real-time insights. These dashboards not only allow quick retrieval of information about individuals’ journeys but also offer a bird’s-eye view of the overall project progress. This enhanced visibility ensures efficient decision-making and progress tracking.
Maximizing Existing Licences: A Cost-Effective Approach
In the face of a failed procurement attempt, our solution became a shining example of how existing Microsoft licenses can be maximized to enhance project management. By creatively utilizing available technical solutions, we demonstrated that a comprehensive system can be achieved without the need for additional costly licenses or separate bespoke solutions.
Outcome: Quality Enhancement and Cost-Effective Project Delivery
Our implemented system stands as a testament to effective project management, enhancing quality and ensuring progress without the need for an expensive bespoke solution. The success of this project showcases the power of innovation and resource optimization in leveraging existing licenses for maximum efficiency.