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