Power BI Transition Project

Adult Social Care (ACS) and Hertfordshire County Council (HCC) are currently undergoing a significant transition from legacy reporting systems to Power BI and Microsoft Fabric. This move is essential to ensure the continuity, resilience, and future scalability of both operational and statutory reporting functions. A key area of focus is supporting the Connect and Prevent programme, a major cost-saving initiative within ACS. This programme aims to reduce demand on services through early intervention and prevention. To support this, ACS is developing a robust data model and Power BI reporting outputs that will track progress and demonstrate financial impact. Specialist technical support is needed to ensure these tools are accurate, timely, and aligned with strategic objectives. ACS is also working closely with the Inclusion and Skills service to support their transition to Power BI and Microsoft Fabric. This collaboration is helping them build internal capability and improve data maturity. ACS is leading by example, acting as a pioneer in adopting modern data platforms and setting a standard that other HCC departments can follow.