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!

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

Alteryx’s Summarize Tool

Alteryx’s Summarize Tool Slice and dice to your heart’s content! Just like a Pivot Table in Excel, the Summarize tool lets us aggregate our data into a more concise level of detail. The Summarize Tool Check Out the 2-Minute Tool … 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