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…

Creating a Simple AWS Lambda in C#

I’ve been using AWS Lambda for a little while now. It’s a great platform and allows you to rapidly get something up and running. So far, I’ve built them in both JavaScript and Python – both of which have been very straightforward. I’ve spent a fair chunk of my development life working in C# so…