Analyze the order transaction data of Play Around Toys Inc. over the past six months to answer the following the questions:
What is the distribution of sales by region?
Do customers prefer shopping online or going to the local store? Is this preference region specific?
Which regions have the higher average of sales?
Create pivot tables to answer the above questions.
- Prepare a report of your findings and describe how the company can use this information to increase revenue.
Attachment:- bu1410_week5_lab1.xlsx