Cubic Spline in Python and Alteryx (BaseA!)

As a bit of a thought experiment, I wondered if how hard it would be to create a cubic spline interpolation within Alteryx. As with many of my games BaseA rules apply. Stealing an idea from Tasha Alfano, I thought I would do it in both python and Alteryx from first principles. A quick shout…

Solving Matt Parker’s Coin Puzzle in Alteryx

Matt Parker is publishing a weekly puzzle on his Think Maths website every Wednesday. This week’s puzzle was a Coin Puzzle. This puzzle felt like one that Alteryx would be well suited to solving. Representing the Board’s State The board looks like: Each location can either have a coin or not have a coin. This…

Lets Alteryx the Advent of Code 2019

So the lights are up across London, the weather is atrocious and the trains are going nowhere fast; so it must be time to think about the Advent of Code. For those of you who haven’t heard of it, this is a fantastic set of 25 puzzles released one by one every day in December…

Creating A Quick Python AWS Lambda Using Visual Studio Online

So mostly for entertainment sake and to see how easy it would be, I wondered if I could create a Python-based lambda in AWS using GitHub and Visual Studio Online. So, let’s see how this goes and how long it takes … Pre-Requisites For this little experiment, you will need: A GitHub account An Azure…

Creating A Diabetes Log (Part 2) – Being a Diabetic, and data …

So forever ago (well back in January), I wrote a post on creating a .Net Core lambda. The goal I want to produce is a tool to record and help me track everything I need for looking after me as a diabetic. This post is going to be a personal one telling you about my…

Least Squares in an Alteryx Macro

This post also appeared on the Alteryx Engine Works Blog. A friend on the Alteryx community recently asked me about recreating the Excel trendline capabilities within Alteryx. If you have the predictive tools installed then Alteryx has a Linear Regression tool which will fit a linear model to the set. This uses R and produces…

AWS Summit London – 8th May 2019

A group of my colleagues from Scott Logic and I went to the AWS Global Summit at the ExCel centre this week. It is the biggest of the global summits, and gives a taste of the huge re:Invent conference in Las Vegas. This post is my thoughts from my day and the sessions I attended.…

An Overview of the Alteryx Abacus Add In

This post first appeared on the Alteryx Community The Abacus add in is a collection of custom functions that make writing expressions in Alteryx easier or gives completely new functionality (such as variables). Originally created to make my life easier, they have grown into a powerful extension for Alteryx that can speed up the creation…

RecipeFinder: A Serverless Data Flows, NLP, Elasticsearch in the Cloud Project

So, I have far too many recipe cards… Over the years, I have collected (read hoarded) hundreds of recipe cards from trips to the supermarket. I’ve generally kept them in folders so I can find them when I want but I want to do better. I’d love to be able to search for them, find…

My Experience from AWS and Alteryx Certifications

So I have now completed both the Solution Architect Associate and Developer Associate certifications and thought I would share my thoughts from the process. Why Bother? For a long time, I haven’t been particularly bothered by doing any certifications. I have always believed in proving myself in the work I do, and this was particularly…