There is only one attempt at this assignments.
Use your help video and the data in this Fire this Employee workbook Download Fire this Employee workbookto complete this assignment. Notice that the workbook has five worksheets: AllData, PivotData, Charts, DataModel, and FirethisEmployee.
Save the file to your OneDrive as MyLastName-DashboardsandModels.
Make an Interactive Dashboard
- Insert three pivot tables on the PivotData worksheet.
- Create associated charts.
- Copy and paste your charts on the Charts worksheet.
- Add slicers to your charts and connect them. Be sure your charts and slicers are legible and fully functional.
- On your AllData worksheet, type something you can derive from at least two of your charts that will benefit your business; also type your plan to apply the information. Then copy and paste thumbnails of the charts.
example:
- Schmoe was our best customer in our second year of business, but he stopped purchasing in year three.
- I will have our best sales associate make an appointment to visit and interview him.
Create a Data Model
- From the Fire this Employee Download Fire this Employeeworkbook, on the DataModel sheet, add all four tables to a data model (the four tables are on the DataModel worksheet).
- Relate the tables in the diagram view.
- Insert one pivot table that contains data from two or more of your tables from your data model.
Fire an Employee
- On your FireThisEmployee sheet, type the name of the employee you would most likely fire and explain in a few words the data that helped you make the decision.