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

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

I can alteryx that #5

HR POSITION FINDER APPLICATION | ALTERYX WEEKLY CHALLENGE #5 | I CAN ALTERYX THAT

HR POSITION FINDER APPLICATION | ALTERYX WEEKLY CHALLENGE #5 | I CAN ALTERYX THAT Your company has an HR hierarchy full of employee numbers. Your goal is to build an analytic app so that a user can select an employee … Read More

I Can Alteryx That - Download Data and Parse JSON

DOWNLOAD DATA AND PARSE JSON | WEEKLY CHALLENGE #7 | I CAN ALTERYX THAT

DOWNLOAD DATA & PARSE JSON | WEEKLY CHALLENGE #7 | I CAN ALTERYX THAT In this challenge, you’ve been given a URL that returns a set of data in the JSON format. Your goal is to download that data, parse … Read More