Can you identify the top, average, and bottom profitable customers?
Welcome back to the Workout Wednesday series for Week 15! Today, we're diving into identifying the top and bottom five profitable customers and calculating the average for all others. This is a great challenge to test your level of detail calculation knowledge in Sigma. Let's dive in!
Step 1: An overview of the challenge objectives - 0:00
Step 2: Getting set up - 0:26
Step 3: Creating average profit per customer- 0:34
Step 4: Creating Groupings - 0:58
Step 5: Create Profit Per Order - 1:31
Step 6: Create Average Profit Per Customer- 1:52
Step 7: Create Ranking Calculation - 2:40
Step 8: Create Bar Chart - 4:22
Step 9: Create Bar Labels - 5:19
Step 10: Create Bar Colors - 6:33
Step 11: Create Average Profit Bars - 7:11
Step 12: Create Filters for Region and State - 8:11
Step 13: Formatting - 9:37