Alteryx

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

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

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

Alteryx 101–The Alchemy

So far in this series we have looked at the tools to get data into Alteryx and to make some changes. In this post we are going to look at the tools to bring many different data sources together. The posts in this series so …

Read more

Getting Your (Alteryx) Alias On

When your connecting to databases with Alteryx you are always looking to connect to ODBC drivers. While I would love to see some more custom optimised connectors which store the connection information with the connection (the SalesForce Connector is heading in that direction), the current …

Read more

Alteryx Inspire Europe

What a fantastic couple of days it has been. It started with the Alteryx User Group then followed with 2 days at Alteryx Inspire Europe. I’m going to put down my thoughts and I would love to hear any experiences from other people. Alteryx User …

Read more