Andrew Lehm

Andrew Lehm

Andrew Lehm

Andrew joined The Data School from a background in Biomedical Science and Emergency Medicine.

Having utilised data analytics in his studies, he enjoyed the practice of distilling complex information into a digestible format, and often leveraged visuals for information transfer. A growing awareness of the widespread misuse of statistical analyses within the scientific community fostered a deeper interest in data analysis best practices, which led him to the field of data visualisation consulting.

Intrigued by the The Data School’s heavy emphasis on storytelling, Andrew applied; through the application process he became a habitual Tableau user. He places an emphasis on minimalist design.

Beyond data, Andrew is passionate about healthcare and medical ethics.

Tableau: proportional brushing with set actions

Set actions have been out for a while now but one of my favourite uses (and probably the easiest to pick up) is proportional brushing.Essentially, proportional brushing allows you to set up a dashboard action to enable you to use a dimension from one chart, to...

Tableau: Creating a customer drop-off tracker

Tracking the rate of your customers' orders so that you can react if a customer appears to be dropping off   A few weeks ago I built a rudimentary customer drop off tracker for a client project and I thought I'd share the technique. It relies on finding the...

Alteryx stats tools for beginners: part 4 – Classification

Alteryx stats tools for beginners This is part four of a five part series introducing the stats tools available in Alteryx explaining the tools and indicating when their use is appropriate. Clustering Data investigation Regression analysis Classification Time Series...

Dashboard Week Day #4

Today Andy set us the task of visualising some data about bike traffic around Seattle. The data comes from about 13 spots around the city where bike traffic is measured. I had a clear idea of what I wanted to achieve in the day. I wanted to make a coxcomb chart, the...

A short introduction to Microsoft’s Power BI

Here at the Data school we are habitual Tableau users; hardly a day goes by, including weekends, without opening Tableau at least once, even if only to make a minor tweak or two. I've been here close to 3 months now, and last week ran a brief intro to Tableau training...

Dashboard Week Day #2

For day 2 of dashboard week we have been looking at metadata around body mounted camera usage by police officers in New Orleans. The data contains the locations, times and duration of the creation of footage.   I decided fairly quickly that the route I would like...

Dashboard Week Day #1

Today's task was to download New York snow plow data but it was us that got plowed.   We were advised to download the data and upload it to Exasol, a columnar storage database which is super fast in Tableau for large data sets. Given that the plow data set is...

Alteryx stats tool for beginners: part 1 – Clustering

Alteryx stats tools for beginners This will be a five part blog series providing an introduction to the Alteryx stats tools available; it is aimed at people new to statistical analysis and/or Alteryx and will give explanations of the tools and when it is appropriate...

Heat maps, heat-maps and heatmaps????

Google "heat map" and you will come across a number of drastically different charts.   I have a slap around the ears from Beth to thank for the inspiration for this blog post, so let's unpick this hotly debated area by creating a few different chart types in...

Alteryx: an introduction to parsing

Parsing: in essence, breaking down a structure into its constituent syntactical parts to analyse individually.   Today Mina walked us through one of her parsing challenges. Alteryx is a lot easier to tackle when someone is guiding you through so maybe this can be...

Alteryx: splitting hairs (strings)

Tom and I had our first experience with Alteryx today and our afternoon task was to tidy up some data gleaned from seafood recipes online. You can see how Tom tackled the task of converting the time data from string to numerical here. My task was to split a string of...