This flashcard is just one of a free flashcard set. See all flashcards!

Just Click on Below Link To Download This Course:

https://mindsblow.com/product/mis-660-topic-3-visual-representation-data-gcu/

MIS 660 Topic 3 Visual Representation of Data GCU

The purpose of this assignment is to use pivot tables and pivot charts to aggregate data and to explain the process used for data aggregation.
For this assignment, you will use the “Claims 2” dataset. Use Excel pivot tables and pivot charts for this exercise.
Part 1:
Create a dashboard describing the data by age group (e.g., 21-30 yrs, 31-40 yrs, 41-50 yrs, 51-60 yrs, and 61-70 yrs). The dashboard should include the graphs and charts listed in the locations described. The dashboard should be a separate tab in Excel that only includes the five items below. A sample layout is provided below the dashboard description.