John MacKintosh

About me

I am an NHS public health intelligence analyst, and a large proportion of my working life has been in healthcare here in Scotland.

I love taking messy operational data and creating something that makes use of it, and helps it make sense to others. Sometimes that is a plot that reveals a previously hidden pattern, and sometimes it is an analytical dashboard that answers the question people actually asked.

My specialism is Statistical Process Control (SPC). Ever had a panicked call from someone senior, or seen short meetings turn into long projects - all because a number on a report was going in a different direction to the previous value? It's not a nice place to be. SPC charts (also known as Process Behaviour Charts) can stop this sort of thing happening, no matter what the number in question represents. And though most of my experience is in healthcare, these methods work in any setting. I've made these specialist charts with Excel, developed custom packages in R, and built dynamic charts natively inside Qlik and Power BI - no 3rd party extensions necessary.

Away from work, I'm a former rock drummer, and I still like my music loud. I'm currently learning Linux, which is why I now know the memes about exiting vim aren't actually jokes.