Provide the information that the CEO requests as follows:

A$.$ List any invoices that were dropped during cleaning $($due to wrong format, etc.$)$ Use one row

per invoice. Include invoice number, invoice date, product, salesperson, sales quantity, selling

price and the reason why the invoice was dropped. Then just delete these rows from the data

and move on to answering other sections. $(8$ marks$)$

B$.$ Identify the name of the salesperson with the HIGHEST sales $($in dollars not volume$)$ for $2022$

and the name of the salesperson with the LOWEST sales $($in dollars not volume$)$ for $2022.$

Show total sales by salesperson to support the names given, either by sorting the invoices and

subtotaling or in a pivot table beside the invoices. $(2$ marks$)$

C$.$ Provide a visualization showing total sales dollars per product for $2022$ below the list of

invoices dropped. $(2$ marks: $1$ mark for completion, $1$ mark for appropriateness of the

visualization$)$

D$.$The visualization $($see above$),$ describe any other insights derived from your analysis of

sales that you would like to share with the CEO. 

 

Answer rating: 100% (QA)

A To list the invoices that were dropped during cleaning you would need access to the data containin... View the full answer