1 / 27

Enhancing Financial Modelling through Available Data: Insights from North Wales

Dr. Helen Adams and Christine Couchman present a comprehensive approach to financial modelling used by Gwynedd LHB. They mapped financial expenditures down to individual GP practices utilizing the best available data, despite the time-intensive process. This initiative now serves as a valuable resource across North Wales. They discuss the Four Quadrants methodology for assessing data quality and using financial data in conjunction with various healthcare datasets to improve local understanding and decision-making, emphasizing that while data may be inadequate, it is still more beneficial than none.

rama-davidson
Télécharger la présentation

Enhancing Financial Modelling through Available Data: Insights from North Wales

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Inadequate data are better than no data at all Dr Helen Adams & Christine Couchman

  2. 4QM An Approach to Financial Modelling

  3. A Financial Dimension Gwynedd LHB undertook an exercise in mapping all financial expenditure down to each individual GP Practices using the best available data. That process was time intensive but now provides a valuable financial resource. The process is now being completed for the whole of North Wales.

  4. 4QM The Four Quadrants

  5. What About Data Quality?

  6. From GP Based Data to Geographical Data

  7. Ability to use that costed data as the foundation to look at some / all costs by: GP Practice Geographical Area – MSOA / LHB Locality Provider Service eg District Nursing Ability to compare costs with other data sets GP Practice costs vs QOF Disease Registers MSOA – vs NPHS EASR data

  8. Service Mapping Using Information to Enhance Local Understanding

  9. Data Sources Practice population data (Exeter) QOF figures Secondary care information Inpatient Outpatient (not coded by condition) A&E (not currently available) Community services Local Authority Social Care information Voluntary / 3rd Sector information Census data (out of date) Healthcare studies NPHS, NLIAH, Health Solutions Wales etc.

  10. Population breakdown by cluster

  11. Population breakdown – over 65s

  12. Population hotspots

  13. QoF - Number of patients on COPD register From 59 to 362

  14. QoF - COPD register as a percentage of over 65s From 5.2% to 15.8%

  15. Acute Respiratory episodes From 1 to 8 episodes

  16. Are services in the right place?

  17. Practice Population – Bangor…

  18. …plus Bethesda…

  19. …plus Y Felinheli…

  20. Cluster Working

  21. Using the information Social Services reorganisation District Nursing establishments HSCWB strategy Locality Profiles Small scale locality projects Ad-hoc information requests Etc…

  22. In summary… There is data out there… It’s not always exactly what we need, but bringing it together helps to enhance our understanding of the Localities and ensures that decisions are based on information rather than assumption…

  23. Thank you! In your thirst for knowledge, be sure not to drown in all the information

More Related