Alteryx Walk-through : Aggregate Consumer Purchases


Here’s the problem statement for challenge #8

For this week’s exercise we will look at customer purchase behavior to decide if we should offer a “Meal Deal” that would add a side and drink to a purchase of pizza or a burger.

This week’s Objective:

In order to decide if we should start including a new “Meal Deal” on our menu we want to study the potential impact on recent transactions. Please identify the number and percentage of orders since July 1, 2013 which include the following categories of food: Pizza OR Burger along with a Side and Drink.

Summary of Data:

Point of Sale data includes the ticket level information, and the lookup table categorizes items into higher-level food categories. Continue reading Alteryx Walk-through : Aggregate Consumer Purchases