Marlandata

A blog to share thoughts, knowledge and techniques from the world of data.

Filling in Missing Dates in SQL

Photo by Waldemar Brandt on Unsplash A few months ago, for the sake of learning SQL, I started doing Preppin’ Data challenges via SQL. A method that I found incredibly effective after months and months during lockdown where I’d read endless PDF t...

Building a Socially Distanced Seat Allocator in Alteryx

As mentioned in a previous blog, I wanted to create a social distancing seat-allocator app so that we could maximise the numbers of people being able to attend a service, whilst still keeping them safe. To do so, we first had to create a spatial o...

Creating Spatial Objects in Alteryx with CMs and Degrees

As we were nearing the end of lockdown in England, there was concern about how social distancing regulations would impact places of worship – could these old and heavy buildings contain entire congregations of worshipers in full? Well, possibly. W...