Using the attached file $($product$\_$data.txt$),$ answer the following question: "What salesperson had the highest percentage of total order value?"

product$\_$data.txtDownload product$\_$data.txt

Instructions:

Load the $$product$\_$data.txt$$ file into Power Query

Accomplish the following steps to prepare the data for further analysis.

Remove the top row

Promote first row as headers

Split the Category & Product into two columns

Rename the columns to Category and Product

Remove the rows that have empty category values

Accomplish changing the salesperson column to last name, comma, first name format

Change the Order Date to a date data type

Add a column named Revenue which multiplies Unit Price field by the Quantity field

Format the Revenue column as currency

Add an Order Total column that adds the shipping value to the Revenue value

Format the Total column as currency

Use $$Close and Load to$...$ to populate a new worksheet

Insert a pivot table into a new worksheet

Use the pivot table to answer: What salesperson had the highest percentage of total order value?