CIS 3100 - Business Intelligence Case Equal Pay Assessment for Sonoma Industries, Inc.

Criteria

Points Possible

Points Earned

A. MyAnalysis.xlsx file

1. Successful creation of the MyAnalysis.xlsx file

(5)

5

B. Census Sheet

1. Successful data migration from Sample_Dataset

2. Durations for current and terminated employees

3. Evaluation scoring and performance rating

(5)

(5)

(5)

15

C. Male_ Employees Sheet

1. Successful data migration from Census sheet

(5)

5

D. Female_ Employees Sheet

1. Successful data migration from Census sheet

(5)

5

E. Salary_Pivot

1. Successful results displayed as directed

(10)

10

F. Occupation_Pivot

1. Successful results displayed as directed

(10)

10

G. Data_Analysis (Executive Summary)

1. Data Analysis Format

2. Salary Comparison Report

3. Salary Bracket

4. Average Salary by Occupation

5. Top 10 Highest Paid Positions

6. Visualization Charts as directed

(5)

(10)

(10)

(10)

(5)

(10)

50

Total

100