Learning to RAP
Thirty-nine area profile documents for Highland and Argyll and Bute recreated and enhanced using R.
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 in a single consolidated view.
Three months of manual reporting, down to five minutes
I taught myself VBA and cut a reporting process from three months to five minutes, which meant our department could support regular record keeping audits across all professions.
Developing a Maternity Services dashboard
I was asked to build a RAG report. I built it and added SPC charts for all metrics on one sheet, showing changes over time relative to targets. This was developed into a reporting application that covered multiple sites and teams.