Question
You figured out what your need is to create 6 PivotTable and PivotChart reports, one for each analysis, and then assemble all PivotChart with Region
You figured out what your 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.Business Intelligence Dashboard Your manager has asked you to help her prepare 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 sales person in 2014
3.An analysis of sales by region in 2014
4.An analysis of sales by 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 your 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started