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 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.

Other skills and tech

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 Introduction to SQL Server
  • SQL Server Integration Services (SSIS)
  • SQL Server Reporting Services
  • Qlik See me talk about SPC in Qlik
  • Exensive experience of using data for Quality 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

I used to work exclusively in Excel, in fact I would not have envisaged that I would ever stop.

It still has its place, but I like to automate, and I prefer to write R code over VBA, and indeed, prefer dplyr or data.table syntax instead of complex, multi level nested SQL queries.


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 :)


© 2016 - 2021. All rights reserved.