Learning Path 1: Exercise 1: General

[myermg52]

Finished Practice 1

[franne52]

Finish practice exercise one

[Rishi6450]

Find the five customers with the highest number of transactions in the Southern region and remove the "Weekly Sales" and "Store Volume" columns.

Based upon the requirement, I used input data to import data, then SELECT tools to unselect 2 columns named "Weekly Sales" and "Store Volume" and changed the name and gave rename of transInYears to Cust_Transactions, then FILTER tool used by using basic filtering as region based SOUTH required, then added SORT tool to order the transaction column in DESCENDING order to get the highest values and lastly used SAMPLE tool to get first 5 rows to get the derived results.

[zervae52]

Finished practice exercise one

[Rishi6450]

Done finished

[Rishi6450]

Find the five customers with the highest number of transactions in the Southern region and remove the "Weekly Sales" and "Store Volume" columns.

Based upon the requirement, I used input data to import data, then SELECT tools to unselect 2 columns named "Weekly Sales" and "Store Volume" and changed the name and gave rename of transInYears to Cust_Transactions, then FILTER tool used by using basic filtering as region based SOUTH required, then added SORT tool to order the transaction column in DESCENDING order to get the highest values and lastly used SAMPLE tool to get first 5 rows to get the derived results.

[daniel_widak]

Exercise 1

[daniel_widak]

Exercise 1

[Yulei]

Hi! Here is my solution to solve the practice exercise 1.

[franciscom_]

solution