You are hired as the new assistant to the executive board. You are asked to prepare a meeting for tomorrow, in which the board will expect a full briefing based on the data you have been given (raw data set). Remember, they already know the data – your job is to reveal the trends, patterns, find information, and dig for the hidden gems that will help the organization improve.
Excel TabsDo the data analysis and creation of visuals in your Excel file — You should end up with tabs like the following snip (each tab contains the associated ONE PivotTable & THREE Diagrams):
Raw Data — Original Raw Data
The following tabs need to contain ONE PivotTable with 2018 & 2019 data and THREE Diagrams separated in 2018, 2019, and the comparison between 2018 & 2019:
Monthly Sales Overview (Line chart)
Top 10 Customers (Column or Bar chart)
Top 10 Products (Column or Bar chart)
8 Product Categories (Column or Bar chart)
Top 10 Regions (Pie chart. Select Pie for 2018, 2019 and Doughnut chart to present the comparison between 2018 & 2019)
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|