Practice Exercise

New Course: Time Series Forecasting

Check out our four new lessons in the Data Science Learning Path that will help you stay entertained and learn some new skills while you're stuck at home!

Data Science Learning Path
9/18/2020 3:30 pm MST: We are aware of an issue with interactive lessons which are resulting in some users being unable to access the videos. Some quick workarounds to try include 1. Try using a different browser to access the lessons. 2. Clear your browser's cache and reattempt to access the videos. If either of the above options are unsuccessful, you can email community@alteryx.com so we can notify you when the videos are accessible again.

Learning Path 1: Exercise 1: General

Highlighted
7 - Meteor

My Exercise answer

Highlighted
5 - Atom

Customer_ID Store_Number Customer_Segment Region Annual Transactions
1128 108 Consumer South 150
2911 107 Home Office South 100
787 104 Home Office South 86
483 105 Corporate South 50
466 104 Small Business South 50

Highlighted
6 - Meteoroid

Here is the workflow that I came up with to solve Practice Exercise 1

Highlighted
5 - Atom

Here is my answer.

Highlighted
6 - Meteoroid

The 5 customers with highest average transactions in the south region.

Highlighted
5 - Atom

Solution for practice exercise 1

Highlighted
5 - Atom

  

Highlighted
6 - Meteoroid

my answer for exercise 1.

Highlighted
5 - Atom

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

Highlighted
5 - Atom

Thanks!