Using the Optimization Tool in Alteryx

Using the Optimization Tool in Alteryx As any user can attest, Alteryx is a fantastic and powerful tool. With well over 100 pre-built tools you can quickly and easily clean messy data, perform calculations, or analyze spatial information. Because Alteryx … Read More

Sentiment Analysis word cloud

Code-free Sentiment Analysis for Business

What is Sentiment Analysis? “This is the worst!” cried Reginald. Cynthia, his long-time business partner, hurried into the room. “Is everything alright?” she asked. Reginald, usually an exuberant man, sighed and said “we lost the Smithfield account. I don’t know … Read More

GOTTA CATCH ‘EM ALL! | WEEKLY CHALLENGE #215 | I CAN ALTERYX THAT

GOTTA CATCH ‘EM ALL | WEEKLY CHALLENGE #215 | I CAN ALTERYX THAT Everyone knows and loves Pokemon. From the adorable Pikachu to the also adorable Cubone, they’re all just so cute. In this week’s challenge, your goal is to … Read More

U.S. MILITARY & HIGH POINTS | WEEKLY CHALLENGE #214 | I CAN ALTERYX THAT

U.S. MILITARY & HIGH POINTS | WEEKLY CHALLENGE #214 | I CAN ALTERYX THAT In this week’s challenge, we have two data sets and three goals. One of the data sets, MIRTA Sites, is ready for analysis. The other data … Read More

So You Want to Build Alteryx Macros (Part 4)

So You Want to Build Alteryx Macros (Part 4) This is Part 4 of a four-part series covering macros in Alteryx. In this post, I will walk you through how to build an iterative macro in Alteryx. An iterative macro … Read More

So You Want to Build Alteryx Macros (Part 2)

So You Want to Build Alteryx Macros (Part 2) This is Part 2 of a four-part series covering macros in Alteryx. In this post, I’ll walk you through how to build a standard macro in Alteryx. In a previous job, … Read More

So you Want to Build Alteryx Macros (Part 1)

So You Want to Build Alteryx Macros (Part 1) I was first introduced to Alteryx in January 2019 and instantly recognized the incredible power of the tool. If I had Alteryx in previous jobs, it would have saved me from … Read More

I Can Alteryx That 8 - Aggregate Consumer Purchases

AGGREGATE CONSUMER PURCHASES | WEEKLY CHALLENGE #8 | I CAN ALTERYX THAT

AGGREGATE CONSUMER PURCHASES | WEEKLY CHALLENGE #8 | I CAN ALTERYX THAT In this week’s challenge, our goal is to take a large table of consumer orders and aggregate them to evaluate the feasibility of creating a new “meal deal.” … Read More

PARSING VIDEO GAME DATA | WEEKLY CHALLENGE #207 | I CAN ALTERYX THAT

PARSING VIDEO GAME DATA | WEEKLY CHALLENGE #207 | I CAN ALTERYX THAT In this challenge, we’ve been provided with a list of video game data. Unfortunately, the data is all in one column, so we must use Text To Columns … Read More

HOTEL RESERVATIONS | WEEKLY CHALLENGE #206 | I CAN ALTERYX THAT

HOTEL RESERVATIONS | WEEKLY CHALLENGE #206 | I CAN ALTERYX THAT Given a list of hotel bookings, the goal for this challenge is to calculate the average length of each stay and count the number of reservations per month. In … Read More