core.noscript.text
My Exercise answer
Customer_ID Store_Number Customer_Segment Region Annual Transactions1128 108 Consumer South 1502911 107 Home Office South 100787 104 Home Office South 86483 105 Corporate South 50466 104 Small Business South 50
Here is the workflow that I came up with to solve Practice Exercise 1
Here is my answer.
The 5 customers with highest average transactions in the south region.
Solution for practice exercise 1
my answer for exercise 1.
1. Sort tool to drop "Weekly Sales" and " Store Volumes"
2. Filter tool: Region equals "South"
3. Sort tool: "TransInYear" in descending order
4. Sample tool: First N rows, where N = 5
Thanks!