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

You’ll find me on Twitter as @_johnmackintosh.

This blog is mainly about R - an open source statistical programming language. That might not sound exciting, but, anyone who works with data should at least be aware of R.

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 demonstration at our local R user group (InveRness RUG)
  • 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