I’m an NHS data analyst / BI developer based in Scotland.

This blog is mainly about R - an open source statistical programming language, which helps me do more, in less time, than I could otherwise.

In addition to R, and driven by the large scale data requirements of my role, I’ve also developed skills in:

  • SQL, including complex T-SQL queries
  • SQL Server Integration Services (SSIS)
  • SQL Server Reporting Services
  • QlikView
  • Qlik Sense
  • Exensive experience of using data for improvement, particularly the use of run charts and Statistical Process Control

In addition:

  • Excel Dashboards / Advanced Excel
  • VBA, including custom functions and manipulating other MS Office software from within Excel

About this blog:

This is a forum for me to show some R work:

  • Anything I produce for demonstrations or workshops
  • Notes to myself on things I’ve learned (the hard way) at work
  • Chart makeovers using R
  • Exploring techniques and technology that I don’t currently use in my role

Code examples

If the full code is not in my blog post, there will be a gist or a link to a github repo


It does bug me when I see an interesting blog post but when you try to copy it at home you can’t reproduce it because of errors or other dependencies.
My R skills are not as awesome as I’d like. My code may not always be optimal But I am confident that if you run my code as is it will work.
There may be a slicker way of doing things, but there will be an end result.


Please do get in touch if you have any comments - I really appreciate comments from readers and feedback provides encouragement to keep going.

Email: johnmackintosh dot jm at gmail dot com

LinkedIn : https://www.linkedin.com/in/john-mackintosh-inv

Twitter : @_johnmackintosh

Thanks for reading this far