What action(s) would you recommend to senior management?
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?
For any questions, feedback, or comments, we have an ethical customer support team that is always waiting on the line for your inquiries.