Using the data tables you created in the previous section or by creating new tables, write a report (750-1,000 words) that addresses the following questions:
- Are all sales persons operating at the same efficiency?
- Are all cities producing the same results?
- Is one product performing better in one city as compared to another city?
- Based on the results, what trends have you identified? What action(s) would you recommend to senior management?
- Based on your use of the Pivot Table:
- Was it easy to use?
- Would you use it again to analyze data?
- Looking at month/year, revenue, and returns, what can be said about the results of the sales force?