# 252|ALTERYX – Retail Reveal

**URL:** <https://www.techhub.training/t/252-alteryx-retail-reveal/4836>\
**Category:** Challenges\
**Tags:** alteryx, intermediate\
**Created:** [April 17, 2025, 1:10am UTC](https://www.techhub.training/t/252-alteryx-retail-reveal/4836 "2025-04-17T01:10:17Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Saul\_Esplin](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/saul_esplin/32/7325_2.png) [@Saul\_Esplin](https://www.techhub.training/u/Saul_Esplin)\
**Post date:** [April 17, 2025, 1:10am UTC](https://www.techhub.training/t/252-alteryx-retail-reveal/4836/1 "2025-04-17T01:10:17Z")

</div>

_BYU Student Author_: @Saul_Esplin  
_Reviewers_: @Michael_Barney, @Kylie_Larsen17  
_Estimated Time to Solve_: 45 Minutes

We provide the solution to this challenge using:

- Alteryx

Need a program? Click [here](https://www.techhub.training/t/information-about-software-used-on-techhub-training/138).

**Overview**  
You have been hired as a data analyst for ShopEase, an online retailer that sells products across multiple regions. The company wants insights into its sales performance, best-selling products, and revenue trends to optimize business decisions.

Your task is to clean and analyze sales data from multiple sources to generate key insights.

**Instructions**

1. Download the sales Excel file and get familiar with the data

2. Upload the data to Alteryx and consolidate them using a union function into a single dataset

3. Clean the data

- Remove duplicates based on Order ID and Product
- Remove rows with missing values in the price and quantity columns
- Standardize the order date format to YYYY-MM - \_DD

1. Calculate key metrics

- Create a new column for total sales. (Price \* Quantity)
- Determine the top 5 best-selling products by total revenue
- Calculate total revenue per region

1. Generate summary reports

- Compute total revenue by month and sort in ascending order
- Find the average order value for each region
- Determine the average number of products per order

**Data Files**

- [Challenge252\_Detail\_Reveal\_Sales\_Data.xslx](https://byu.box.com/shared/static/8gat1q5fyivvkhjrrrfjmy38vak542gs)

> **Suggestions and Hints**
>
> - After filtering out rows with null values you should have 982 records
> - After removing duplicates there should be 886 records

**Solution**

[Challenge252\_Solution.yxmd](https://byu.box.com/shared/static/pjy9coxre63v86yxn7qtkleee9dmbal5)

Challenge252 Solution Top5

 ![Challenge252_Solution_Top5](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/c/ce13cd7b40f8fe7fb4fc92f33889ab9e4c77dbe5.png)

Challenge252 Solution Average Products Per Order  
 ![Challenge252_Solution_Average_Products_Per_Order](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/e/ea9b3656fe74600708f5c07db7d60ed071d6d492.png)

Challenge252 Solution Sales By Month

 ![Challenge252_Solution_Sales_By_Month](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/0/082dd3116ffabf49862b99cd62bcf9e36897e536.png)

Challenge252 Solution Sales By Region

 ![Challenge252_Solution_Sales_By_Region](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/9/9de4084b8f713cc21cde74ebc350db0d07c8afea.png)

Challenge252 Solution Average Order Value

 ![Challenge252_Solution_Average_Order_Value](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/b/b49e3c15b8b44d19c2b96312d701efad2f80fcd4.png)

_Solution Video:_ [Challenge 252|ALTERYX – Retail Reveal](https://youtu.be/JuolUQy_oXs)

[](https://youtu.be/JuolUQy_oXs)