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.
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
-
Download the sales Excel file and get familiar with the data
-
Upload the data to Alteryx and consolidate them using a union function into a single dataset
-
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
- 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
- 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
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 Top5
Challenge252 Solution Average Products Per Order
Challenge252 Solution Sales By Month
Challenge252 Solution Sales By Region
Challenge252 Solution Average Order Value
Solution Video: Challenge 252|ALTERYX – Retail Reveal