Dear Trainer,
Please Find attached my completed workflow for Practice Exercise 1.
Task - Identify the top 5 customers with highest average transactions in the south region.
Approach -
1. Imported the dataset using the input tool.
2. Applied a filter to select only South Region.
3.Used the summarize tool to group by all the necessary columns, and calculate the Average Transaction Amount.
4. Sorted the Average in descending order .
5. Used the sample tool to select the First 5.
6.Applied the select tool to reorder and rename the fields.
Output- The workflow resulted in generating 5 customers in south region with the highest average transactions.
This exercise was very useful for building my practical knowledge of Alteryx and helped me understand how different tools can be utilized to solve real world problems.
I sincerely thank you for your guidance.
Regards
K Hari Priya.
