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:

An analysis of trend for monthly sales in 2014

An analysis of sales by a salesperson in 2014

An analysis of sales by region in 2014

An analysis of sales by a customer top 5 customers

An analysis of sales count by sales amount

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. You have drawn a sketch of the dashboard as below.

The sketch above is merely a suggestion for contents needed in the dashboard, please use your creativity to design a functional and eye-pleasing Business Intelligence dashboard. Please also write a brief description of each of your dashboards components to sell your ideas.