Practice Exercise

Learning Path 1: Exercise 1: General

wojciech_dyrda
5 - Atom

done! :)

mtberry
5 - Atom

Complete.

SakshiShahare
6 - Meteoroid

it is very helpful for the practice

stauf789
5 - Atom

Here is my exercise 1.

tedchen
5 - Atom

Solution for Practice Exercise 1

rachelnicolas
5 - Atom

Cool!

thaodinh9
6 - Meteoroid

My solution

meganpeterson
5 - Atom

v

SakshiShahare
6 - Meteoroid

Solution is here

Amapma
5 - Atom
  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.