Turning complex public investment data into evidence for advocacy, consultation, and local decision-making. Trosi data buddsoddi cyhoeddus cymhleth yn dystiolaeth ar gyfer eiriolaeth, ymgynghori, a gwneud penderfyniadau lleol.
For years, European Structural and Investment Funds (ESIF) channelled significant investment into local government areas across England via Local Enterprise Partnerships. As the UK prepared to leave the EU, those funding streams were set to be replaced by the UK Shared Prosperity Fund — a transition that carried real consequences for councils, communities, and local economies.
Am flynyddoedd, sianelwyd buddsoddiad sylweddol gan Gronfeydd Strwythurol a Buddsoddi Ewropeaidd (ESIF) i ardaloedd llywodraeth leol ledled Lloegr drwy Bartneriaethau Menter Leol. Wrth i'r DU baratoi i adael yr UE, roedd y ffrydiau cyllido hynny i gael eu disodli gan Gronfa Ffyniant Gyffredin y DU — trawsnewidiad a oedd yn cario canlyniadau go iawn i gynghorau, cymunedau, ac economiau lleol.
The Local Government Association needed a clear, evidence-based picture of what had been invested, where, and through which structures — so that councils could engage with the transition from a position of knowledge rather than uncertainty.
Roedd angen darlun clir, seiliedig ar dystiolaeth ar Gymdeithas Llywodraeth Leol o'r hyn a fuddsoddwyd, ble, a thrwy ba strwythurau — fel y gallai cynghorau ymgysylltu â'r trawsnewid o safbwynt gwybodaeth yn hytrach nag ansicrwydd.
The LGA appointed VDB UK to analyse how ESIF-related investment had reached local government areas via Local Enterprise Partnerships, and to help councils understand the likely implications of the move to the UK Shared Prosperity Fund.
Penododd y LGA VDB UK i ddadansoddi sut yr oedd buddsoddiad cysylltiedig ag ESIF wedi cyrraedd ardaloedd llywodraeth leol drwy Bartneriaethau Menter Leol, ac i helpu cynghorau i ddeall goblygiadau tebygol y symud i Gronfa Ffyniant Gyffredin y DU.
Our task was to make complex public investment data usable — not just analytically, but politically and operationally — so the LGA could advocate effectively and individual councils could prepare for what came next.
Ein tasg oedd gwneud data buddsoddi cyhoeddus cymhleth yn ddefnyddiadwy — nid yn unig yn ddadansoddol, ond yn wleidyddol ac yn weithredol — fel y gallai'r LGA eirioli'n effeithiol a gallai cynghorau unigol baratoi ar gyfer yr hyn a ddaeth nesaf.
Making complex public investment data usable for advocacy, consultation, and local decision-making. Gwneud data buddsoddi cyhoeddus cymhleth yn ddefnyddiadwy ar gyfer eiriolaeth, ymgynghori, a gwneud penderfyniadau lleol.
Detailed analysis of historic ESIF-related investment data, including time-series and longitudinal review of how funding flowed through local growth structures and into place-based activity across England. Dadansoddiad manwl o ddata buddsoddi hanesyddol cysylltiedig ag ESIF, gan gynnwys adolygiad cyfres amser a hydredol o sut y llifodd cyllid drwy strwythurau twf lleol ac i weithgarwch seiliedig ar le ledled Lloegr.
Consulted local councils to test the data against lived experience on the ground, ensuring the findings were useful not only analytically but also politically and operationally. Ymgynghorwyd â chynghorau lleol i brofi'r data yn erbyn profiad byw ar lawr gwlad, gan sicrhau bod y canfyddiadau'n ddefnyddiol nid yn unig yn ddadansoddol ond hefyd yn wleidyddol ac yn weithredol.
Produced a detailed analytical report setting out the findings in a form that the LGA could use in policy discussions, consultations, and advocacy with central government. Cynhyrchwyd adroddiad dadansoddol manwl yn gosod y canfyddiadau mewn ffurf y gallai'r LGA ei defnyddio mewn trafodaethau polisi, ymgynghoriadau, ac eiriolaeth gyda'r llywodraeth ganolog.
Built an interactive, map-based dashboard so the LGA and individual councils could compare historic investment patterns with the emerging UK Shared Prosperity Fund landscape — a practical tool for local and national decision-makers. Adeiladwyd dangosfwrdd rhyngweithiol ar sail map fel y gallai'r LGA a chynghorau unigol gymharu patrymau buddsoddi hanesyddol â thirwedd newydd Cronfa Ffyniant Gyffredin y DU — offeryn ymarferol i benderfynwyr lleol a chenedlaethol.
The transition from EU structural funds to the UK Shared Prosperity Fund was one of the most significant changes to local government funding in a generation. Without a clear evidence base, councils risked entering consultations and policy conversations without the data they needed to make their case.
Roedd y trawsnewid o gronfeydd strwythurol yr UE i Gronfa Ffyniant Gyffredin y DU yn un o'r newidiadau mwyaf arwyddocaol i gyllido llywodraeth leol mewn cenhedlaeth. Heb sylfaen dystiolaeth glir, roedd cynghorau'n wynebu'r perygl o fynd i ymgynghoriadau a sgyrsiau polisi heb y data yr oedd ei angen arnynt i wneud eu hachos.
Turning complex historic investment data into a practical tool that every council could use to understand what the funding transition meant for their area. Trosi data buddsoddi hanesyddol cymhleth yn offeryn ymarferol y gallai pob cyngor ei ddefnyddio i ddeall beth oedd y trawsnewid cyllido yn ei olygu i'w hardal.
Our work gave the LGA and its member councils a shared evidence base. It meant that advocacy could be grounded in data, that consultation responses could be specific and locally informed, and that decision-makers at every level could see the real picture of how funding had reached their communities.
Rhoddodd ein gwaith sylfaen dystiolaeth a rennir i'r LGA a'i gynghorau aelod. Golygai y gallai eiriolaeth fod wedi'i seilio ar ddata, y gallai ymatebion ymgynghori fod yn benodol ac wedi'u llywio'n lleol, a bod penderfynwyr ar bob lefel yn gallu gweld y darlun go iawn o sut yr oedd cyllid wedi cyrraedd eu cymunedau.
The LGA used the analysis and dashboard as an advocacy tool in its engagement with central government on the UK Shared Prosperity Fund. Individual councils were able to use the interactive dashboard to compare their historic ESIF investment with the emerging replacement landscape — giving them the evidence they needed to engage in consultations with confidence.
Defnyddiodd yr LGA'r dadansoddiad a'r dangosfwrdd fel offeryn eiriolaeth yn ei ymgysylltiad â'r llywodraeth ganolog ar Gronfa Ffyniant Gyffredin y DU. Roedd cynghorau unigol yn gallu defnyddio'r dangosfwrdd rhyngweithiol i gymharu eu buddsoddiad ESIF hanesyddol â'r dirwedd newydd — gan roi'r dystiolaeth yr oedd ei hangen arnynt i ymgysylltu ag ymgynghoriadau'n hyderus.
The work demonstrated that complex public investment data, when properly analysed and made accessible, can become a powerful tool for accountability, planning, and informed debate at every level of government.
Dangosodd y gwaith, pan gaiff data buddsoddi cyhoeddus cymhleth ei ddadansoddi'n briodol a'i wneud yn hygyrch, y gall ddod yn offeryn pwerus ar gyfer atebolrwydd, cynllunio, a thrafodaeth wybodus ar bob lefel o lywodraeth.