The last month or so has been a whirlwind of awesomeness with a veritable bevvy of user group and conference talks on my part! I thought I would share the materials with you and provide some brief thoughts on how each presentation went.

Sessions

• SQL Saturday Exeter : Stats 101
• London Business Analytics (LBAG) : Skilling up to code with data
• SQLBits & TUGA : Cut the R Learning Curve
• SQLBits & TUGA : R in the Microsoft Data Platform (full day of training)
• IT Pro Portugal : Being lazy with infrastructure

SQL Saturday Exeter

My presentation, in my opinion, was exceedingly brave. One, I got people to fill in a survey real-time and I used that as the sole basis of my session – so relying on wifi, data entry skills & knowledge of what QR codes were. Two, my session aimed to introduce the concepts of statistics in a non-maths and non-technical way. The session worked out surprisingly well and the feedback received from the attendees bowled me over. I got a bit sidetracked with making snazzy revealjs slide decks but didn’t have chance to make the visualisations as good as I’d hoped before the presentation.

LBAG

I really like the London BA Group run by Mark Wilcock. It’s an interesting blend of attendees, and they cover some excellent topics. They usually do a single session and then have beers & networking afterwards. I only wish it didn’t cost so much to travel to London from Cardiff so I could attend!

I did a session aimed at convincing people why they should shift from GUI to code, and I think it was fairly well-received. I hope I convinced people to go further down this route, and maybe they’ll start attending R User Groups in London like Chiin’s R-Ladies Coding Club (London), or Mango’s LondonR. As a beginner session to DataOps, I think it did OK but there’s definite room for tweaking to hit the right pain points!

SQLBits

I was very lucky to deliver a training day with Andrew Fryer, aiming to teach people R fundamentals in the morning and how to use R in the Microsoft Data Platform in the afternoon. We tried using Microsoft Data Science VMs but setting up infrastructure on the day caused us some delays. It then took me longer to get through the R fundamentals than I’d hoped. This left us with little time to get hands on with the Microsoft tools and we instead had to show demos. I didn’t have an adequate amount of assistants for providing help during exercises – the rule of thumb is one person per fifteen attendees. I think people, by and large, enjoyed the day and learnt a fair bit, but I think there was definite room for improvement!

One of the limitations of the training day is I don’t teach people much in the way of modern R. All the data manipulation is done in base R, charting is done in ggplot2, and we don’t have the time to teach people much in the way of administration or development best practices. Consequently, I was really happy to have a 2-hour session to provide an overview that tackled those issues. Only 15-20 minutes actually teaches people a little R, the rest was pure overview. I think this actually worked well, especially for the senior BI people who were evaluating whether R can work in their organisation. Perhaps the main issue with the session was I used the whole two hours – the poor attendees didn’t get a break in the middle or the opportunity to ask a huge amount of questions at the end.

IT Pro Portugal

Firstly, when Andre Melancia asked me if I’d like to present at the IT Pro group whilst I was in Portugal, I had to ask what an IT Pro was! This is something I hear a lot and it seems the key differentiator between an IT Pro and a developer is that any scripts an IT Pro writes are incidental to the job, not the outcome. Or perhaps from another perspective, an IT Pros scripts help them get their job done, whilst a developer produces scripts that allow others to get the job done.

I was rather nervous about talking infrastructure to a room full of people who would undoubtedly have 10 times more infrastructure knowledge than I did, but instead of tackling “core” infrastructure stuff like storage, I looked at some of the ways around my tendency to break my machine! Between a decent overview of chocolatey, a reminder they ought to be using Powershell, and a view of how Docker can help try stuff without impacting their machines, it went alright. For the most part, people laughed with me, rather than at me, but I think I’d still be nervous about delivering the talk or similar again!

TUGA

At TUGA I got to do the same setup as Bits i.e. a training day on R & the Microsoft Data Platform, and my Cut the R Learning Curve session. There were some differences in terms of constraints:

• I didn’t have Andrew as wingman
• I didn’t have access to any Azure vouchers
• I only had 70 minutes for my R session

I beefed up the sections on the Microsoft Data Platform, including using R to call SQL Server to call R! I also circumvented the requirement for people to install things on their machines by hosting a VM with SQL Server 2016 on, and another VM with RStudio Server – people were able to then use RStudio for the entire day. My attendees were fantastic and I felt the day went much better than the Bits version, not least because I was able to reclaim the better part of an hour from setup. I think I’m still a little light on the Data Platform, esp. because there are so many more prerequisite installations, and I’ll improve that over time.

The shorter R session went well. I knew I had to cover slides in less depth so that I could move faster through them, and this worked OK although I didn’t get to cover the administration considerations as much as I would have liked to. All in all, I’m quite happy with the slide deck and it seems to be a good mid-ground session between telling people how to do something and why they ought to do something.

If you saw any of my presentations, please give me feedback! I can’t get better without it

The post Recent presentations appeared first on It's a Locke.