Learning Path 1: Exercise 1: General

[wojciech_dyrda]

done! :)

[mtberry]

Complete.

[SakshiShahare]

it is very helpful for the practice

[stauf789]

Here is my exercise 1.

[tedchen]

Solution for Practice Exercise 1

[rachelnicolas]

Cool!

[thaodinh9]

My solution

[meganpeterson]

v

[SakshiShahare]

Solution is here

[Amapma]

1. Load the Data: Use the Input Data tool to load your data into Alteryx.

2. Drop Unnecessary Columns: Use the Select tool to deselect the “Weekly Sales” and “Store Volume” columns. This will remove these columns from your data.

3. Filter the Data: Use the Filter tool to keep only the records where the “Region” is “South”.

4. Sort the Data: Use the Sort tool to sort the data in descending order based on the “Trans In Year” column. This will bring the customers with the highest average transactions to the top.

5. Select Top Records: Use the Sample tool to select the first 5 records. This will give you the 5 customers with the highest average transactions in the “South” region (Configure the Sample Tool: Click on the Sample tool to view its configuration options. Under Sample Method, choose First N Rows. In the N field, enter 5. This will tell Alteryx to select the first 5 records from your sorted data.)

6. Output the Data: Finally, use the Output Data tool to save your results.