Congratulations on completing Exercise 1!
When you are ready to submit your solution, click "Reply" to this post and upload your workflow.
You may also download and review the attached solution.
My solution to Practice problem 1
solutions
Exercise 1
1st exercise solution
exercise
Practice Exercise 1
Done!
My solution to Practice Exercise 1
practice
Practice
.
My solution.
Answer
done!
Complete.
it is very helpful for the practice
Here is my exercise 1.
Solution for Practice Exercise 1
Cool!
My solution
v
Solution is here
Load the Data: Use the Input Data tool to load your data into Alteryx.
Drop Unnecessary Columns: Use the Select tool to deselect the “Weekly Sales” and “Store Volume” columns. This will remove these columns from your data.
Filter the Data: Use the Filter tool to keep only the records where the “Region” is “South”.
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.
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.)
Output the Data: Finally, use the Output Data tool to save your results.
An Input Data tool contains 100 records, each representing a unique customer's transaction information. The Customer ID (a unique identifier for each customer) and Customer Segment provide basic information about the customer. The transactions column represents the average number of transactions that customer has made over the past year.
In this exercise, drop the columns "Weekly Sales" and "Store Volume". Then find the 5 customers with the highest average transactions in the "South" region. Your results window should match the Final State Input Data tool.
Done.
Done
Solution attached herewith ...
best regards,
Bronzki
Here's my solution.
