Marlandata

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

Tips On Passing Your SnowPro Core Exam

Photo by Tom Coomer on Unsplash The other day, I passed my SnowPro Core Exam! What surprised me is that although the exam sounds pretty daunting, it wasn’t one I found very hard at all. While some exams are quilty of trying to trip you up, or inc...

Input from Tableau Server into Alteryx Workflow

A week or so ago I accidentally claimed an Alteryx tool existed that didn’t actually exist. I promise I had no intention to fool anyone, I was simply labouring under a misapprehension. For some reason, I was convinced that sitting beside the Publi...

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