apa_alteryx

Analytic Process Automation: Why APA is not just for Alteryx

Analytic Process Automation (APA) Here to stay, and why this matters to you Warning: hyperlinks and references to space travel await you… Since you’re reading this, it’s very likely you saw Alteryx’s huge announcement last week of their launch of … 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

Alteryx’s Multi-Row Formula Tool

Alteryx’s Multi-Row Formula Tool How can you talk with your data that’s not in the same row? The Multi-Row Formula tool! Your walk-talkie to communicate (and change!) data that’s up and down in your fields. The Multi-Row Formula Tool Check … Read More