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

Alteryx Server User Management

In my previous post, I introduced the Alteryx Server Content Best Practices, discussing the overarching concepts of how content is managed in the Alteryx Gallery. This post will focus on the best practices for managing users so they can access the content across your Alteryx …

Read more

Alteryx Server Best Practices

Your Alteryx server is the heart of your organisation’s analytic operation. It enables an explosion of value, transforming proof of concept works into production applications. The challenge is that explosion of value can come at the expense of an eruption of analytic chaos. Burying the …

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

Unlocking the Potential of Your Data with Alteryx and DataOps

Learn how Alteryx and DataOps can improve data management & analysis in this informative blog post. Discover the benefits of automation, collaboration & more

What is concatenation, and how do we Concatenate with Alteryx?

Concatenation is the process of combining multiple string fields into a single field. The simplest way to do this is to use a formula tool and combine the strings with a + operator. You can also concatenate using aggregation tools, like summarise and cross tab. …

Read more

Interviewed By AlterTricks

With the release of my book, Data Engineering with Alteryx, I was invited to join Chris Goodman and Joshua Burkhow on the AlterTricks podcast. We had a great discussion about the release of my book and how Data Engineering can be achieved with Alteryx. Hop …

Read more

Data Engineering with Alteryx

Over the past year, I have been writing flat out, but none of it has arrived on my blog, why? I have been writing a book, Data Engineering with Alteryx (amazon link). This has been a massive project, consolidating all my thoughts and learnings into …

Read more

Architecting AWS for an Alteryx Server

Intro Deploying your Alteryx server onto EC2 on AWS is a great way to get your server up and running fast. The problem is that if you treat EC2 just like a Virtual Machine provided by your IT team, you don’t get any of the …

Read more