Alteryx

Reshaping Data in Alteryx: A Step-by-Step Guide

Introduction When it comes to data preparation and data analytics, Alteryx is one of the go-to platforms. It provides a perfect platform for integrating data from all your data resources, but often, the data is not in the best format for analysis. Transforming your data …

Read more

Master Class in Alteryx Aggregation

One of the most fundamental actions an analyst can perform is aggregating their data. Simplifying large data sets to support specific investigations and helping decision-makers to understand the overall trends in their business area are central activities that a data analyst will deliver. To Aggregate …

Read more

Mastering Rounding in Alteryx

Any time a calculation is done in Alteryx, it will keep all the detail provided. The downside is that this makes the number difficult to read and interpret quickly. Rounding allows us to simplify a number while keeping it close enough to the original value …

Read more

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

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