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…

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…

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…