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

I’m not a data scientist but my role involves writing code, statistics and data visualisation.

I begun using R intermittently, and, over time, it has become integral to my workflow.

The ability to produce many plots, with just a few lines of code, has become crucial when I have hundreds of charts to produce each month.

The main packages I use are ggplot2 and qicharts for plotting, dplyr for data manipulation and RODBC for linking to MS SQL Server.

I’m also getting to grips with data.table, because it’s super fast and has some very useful functions, as do ggExtra and janitor

I’ve also used R for:
- mapping (ggmap)
- text mining (specifically tm and tidytext)
- social media analysis (twitteR)

I’m also interested in using R for time series ( using forecast) and predictive analytics.

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

  • Excel Dashboards / Advanced Excel
  • VBA, including custom functions and manipulating other Office software from within Excel
  • SQL, including complex t-sql queries and SQL Server Integration Services (SSIS)
  • Exensive experience of using data for improvement, particularly run charts and Statistical Process Control

In addition to visualisation with R and Excel, I have also experience of:

  • SQL Server Reporting Services
  • QlikView (relatively new to this though)

I’m also interested in PowerBI and Tableau.

About this blog:

I can’t demonstrate my work publicly, so 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

Most of the code I write will appear on my github as a gist or repository.

My code is pretty well commented, so I don’t go into too much depth in these posts.

Some posts will be related to things I am learning about for my own development, so they may not go into a lot of detail but I aim to update these as my learning increases.

Please check the session info on the code scipts for details of loaded packages and dependencies.
If you like what you read here, please let me know!

John