Supply of children’s social care – Power BI dashboard development support

Overview

This contract extension is to enable continuity in delivering significant value in terms of essential BI support, for a further 6 months from 1st October 26 to end March 27. This is to enable continuation of providing ongoing, business-critical BI dashboard development support spanning both adults and children’s, focusing on the following key areas: • Development of essential new BI dashboards required for Children’s Social Care • Continuing to support the BFC performance team in developing their use of Cascade and Power Bi for Children Social care Dashboards from Mosaic data • Further development and continuous improvement of the Data Warehouse to align with the new processes and forms • Support and further embed implementation of reports and dashboards for children’s social care • Providing BI input and expertise to support: • Delivery of Final CSC Reporting Dashboards • Troubleshooting and resolution of any outstanding issues with Dashboard delivered in the previous phases • Providing continued support to Performance team with upskilling and improving confidence around: o SQL scripting o Mosaic data structures o Power BI Dashboard development. • Providing enhancements to the Cascade DS and DM scripts if/when current functionality needs to be extended, until such time that the team is confident to develop these themselves • Providing additional Dashboard or data mapping resource to the Performance team if internal capacity to develop is not able to meet operational deadlines for delivery. CSC dashboard development specifically will focus on the following: • Child In Need • Children Looked After • Missing, CSE, CCE • PLO • Leaving Care • Step Ups and Step Downs • RAS • LADO (Local Authority Designated Officer) The proposed contract extension is to further extend and sustain a range of BI benefits and improvements delivered in previous phases including delivering further improvements in terms of efficiency and effectiveness - particularly in relation to reporting and delivery of both adults and children’s dashboards. Contract details notice published as the value of the extension means the total value now exceeds £30,000 inc VAT.