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 …
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 …
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 …
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 …
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 …
Learn how Alteryx and DataOps can improve data management & analysis in this informative blog post. Discover the benefits of automation, collaboration & more
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. …
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 …
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 …
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 …