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

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

Alteryx’s Output Data Tool

Alteryx’s Output Data Tool You’ve spent most of your time so far automating your data wrangling, so where do you go from here?  The Output Data tool! The Output Data Tool Check Out the 2-Minute Tool Playlist!

Alteryx’s Record ID Tool

Alteryx’s Record ID Tool “Chicka Chicka Yeah, RecordID RecordID” – McLovin'[Data] Not having an ID on your Record getting you down? Just use the Record ID tool! The Record ID Tool Check Out the 2-Minute Tool Playlist!

Alteryx’s Tool Container Tool

Alteryx’s Tool Container Tool The tools in your workflow getting away from ya a bit?  Put ’em in a box, using the Tool Container tool!  The Tool Container Tool https://youtu.be/QAfOYyPLpSI Check Out the 2-Minute Tool Playlist!

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

ANALYTICS RANKING | WEEKLY CHALLENGE #9 | I CAN ALTERYX THAT

Analytics Ranking | WEEKLY CHALLENGE #9 | I CAN ALTERYX THAT In this weekly challenge, the goal is to create a ranking field that accounts for ties. The most challenging part of this problem is using the Multi-Row Formula tool to … Read More

I Can Alteryx That #6 - Spatial Route

SPATIAL ROUTE | WEEKLY CHALLENGE #6 | I CAN ALTERYX THAT

SPATIAL ROUTE | WEEKLY CHALLENGE #6 | I CAN ALTERYX THAT You’ve been handed a data set containing locations that different sales reps visits. Your goal is to map the route that each rep takes and calculate the distance traveled … Read More