Business Intelligence Dashboard

Your manager has asked you to help her prepare a presentation for an upcoming management meeting based on the data ABC Global Sales Data. The manager will be presenting an analysis of sales in 2014. After hours of conversations with the manager, you have scoped down the content of the analysis as the follows:

1. An analysis of trend for monthly sales in 2014

2. An analysis of sales by a salesperson in 2014

3. An analysis of sales by region in 2014

4. An analysis of sales by a customer top 5 customers

5. An analysis of sales count by sales amount

6. An analysis of sales by product category

The manager would like to have the ability to drill in on the above analyses by Region and Sales Person. You figured out what you need is to create 6 PivotTable and PivotChart reports, one for each analysis, and then assemble all PivotChart with Region and Sales Person slicers in one screen to create an interactive dashboard.