How to do a VLOOKUP in Alteryx

What is the VLOOKUP formula? Merging records or data tables into a single source is a common process that Analysts have to do every day. In Excel this is often achieved using the VLOOKUP formula. According to the Microsoft documentation you would: Use VLOOKUP when …

Read more

How to Best Configure Alteryx Server for Load Balancers

If you read my introduction post on configuring load balancers over on the Information Lab Blog, I discussed the basic process for configuring Alteryx Server to use a load balancer. That only covered a setup with no SSL configured and the built in Authentication. The …

Read more

Live on YouTube

One of the projects I have wanted to get started with was creating and sharing videos on YouTube. My biggest problem was always getting the time to write the script, record the video, edit, process and upload. With the current lock-down and keeping everyone at …

Read more

AT Data Science – Tuning for the best sound

In the last entry for this series, we created a Random Forest model to try and predict which passengers survived their trip on the Titanic. Without any customisation of the Random Forest, we were able to achieve an accuracy of 0.75119, not as good as …

Read more

New Year, New Blog

As 2019 starts I have finally made the jump to self-hosting my blog. This is to learn more about building and deploying websites, specifically, I want to start deploying more deep learning models and driving some web application. What this means is I want to …

Read more

AT Data Science – Creating the Models

Last time we ran through the exploratory data analysis to Pre-processing The first step of creating models is the pre-processing of your data. Cleaning the data up to remove nulls, applying any scaling or normalising you need and potentially aggregating the raw data you are …

Read more

AT Data Science–The Titanic

The Journey Begins For any budding Data Scientist to build their data science chops and reputation, they need to develop lots of models in different applications. One of the best resources to do that and see how well you are doing compared to other people …

Read more

Makeover Monday – 2017 Week 48

Its been a while since I have blogged anything (and definitely not achieving the goal of one post each month) but I wanted to submit a Makeover Monday post. This weeks data set was based on the If the World was 100 people website. I …

Read more

Workout Wednesday Week 12

I want to get more involved in the Tableau community events, like Makeover Monday and Workout Wednesday. So here is my first attempt at Workout Wednesday. Nice little project 🙂

Tidy Data in Alteryx

Once you start getting into data science one of the biggest challenges you face, and where much of your time is spent, is getting data into a tidy and usable state. I came across an blog post (by Jean-Nicolas Hould) recently which applied the process …

Read more