Learning to RAP
Thirty-nine area profile documents for Highland and Argyll and Bute, published and updated from a single pipeline, and used by local planning groups.
Work
Some of what I've been working on during my time in the NHS
How my career has evolved, from being an Excel whizz to using R, SQL, Qlik, and Power BI across teams in Clinical Governance, Quality Improvement, BI and Public Health Intelligence.
Selected work
Putting learning into action
Applying what I learned in my spare time to the real-life demand of helping clinicians and managers plan a vaccination rollout.
How fixing one spreadsheet changed my career
By improving a spreadsheet, I ended up developing a reporting system spanning over 20 hospitals and 100 GP practices, learning SPC and a host of technical skills in the process.
Expanding my horizons
How discovering horizon plots helped solve a data visualisation problem so executives could see years of patient safety performance at a glance.
Three months of manual reporting, down to five minutes
I taught myself VBA, cut a reporting process from three months to five minutes, and shared the solution so our department could support record keeping audits across all professions, not just one.
Developing a Maternity Services dashboard
Adding value to a business request. I was asked to build a RAG report - but adding a dashboard of SPC charts showing all metrics at a glance transformed the report.