Data Analytics

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

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

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

Predictive Analytics – Book Review

I read Predictive Analytics: The Power to Predict Who Will Click, Buy, Lie, or Die by Eric Siegel thinking it was an introduction to the mechanics of creating and choosing the best predictive models, it is not. This book is an introduction to why to …

Read more

Do Stuff, The Preparation – Alteryx 101

A while ago I looked at the tools to get data into Alteryx. While getting data into a workflow is the first step of an analysis the preparation tools is where the real work starts. The Tools of the Trade Auto Field The auto field …

Read more

Getting Data to Big Query

Co-posted on the Information Lab blog The Problem I have recently been working with a client who wanted to get their data into a Google Big Querytable with Alteryx. It sounded like a simple problem and should have been pretty easy for me to get …

Read more

Data In, Data Out – Alteryx 101

Alteryx is a hugely powerful tool for data preparation, spatial and predictive analytics. It can be a bit confusing with how to get started with Alteryx, creating workflows and making your life that much easier. I have wanted to get this series going for a …

Read more

Signal Book Review

Signal is the latest book by Stephen Few covering data visualisation. Like all of the Few books I have read the focus is once again on leveraging the preattentive visual processing and inherent the ability of people to compare lengths, positions, hue and saturation to …

Read more