Marlandata

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

Getting Your Head Around AWS CloudFormation

The Basics CloudFormation is an AWS service that allows you to provision resources using code quickly and consistently. By building templates you can model your architecture once and deploy as many times as you wish. Better yet, while this might ...

Using Dynamic SQL Queries to Change Column Headers to Rows

Photo by Frank Cone from Pexels Although designed for Tableau Prep, I find Carl Allchin, Jenny Martin, Jonathan Allenby and Tom Prowse’s Preppin’ Data challenges really good for flexing SQL muscles. I decided I wanted to experiment a little with ...

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...