EMPLOYEE DATASETS
ANALYSIS USING EXCEL
STUDENT NAME: TEJA SRI S
REGISTER NO:422200522
NM ID:44D534E975AAF79B34F4B697E32280BF
Department:B.COM(ISM)
COLLEGE:VALLIAMMAL COLLEGE FOR WOMEN
PROJECT TITTLE
Employee salary analysis using excel
AGENDA
PROBLEM STATEMENT
PROJECT OVERVIEW.
WHO ARE THE END USERS.
OUR SOLUTION AND IT’S VALUE PROPOSITION.
DATASET DESCRIPTION.
THE “ WOW” IN OUR SOLUTION.
MODELLING.
RESULT.
CONCLUSION.
PROBLEM STATEMENT
This salary analysis is used to find out whether the salary of the employee
is increased or not
PROJECT OVERVIEW
Analyse the salary of the employee by considering various factors of like
Gender , Employee ID, Start date , Employee type , Department , etc.. We
use these in order to identify the trends , patterns of different categories of
employee Salary like very high , high , medium and low
WHO ARE THE END USERS
OUR SOLUTION AND IT’S
VALUE PROPOSITION
Conditional Formatting –Blank values.
Sort & Filter –Filter –Remove Blank Values.
Formula –Salary .
Pivot Table –Summary.
Graph –Data Visualization.
DATASET DESCRIPTION
Employee Dataset –Edunet Dashboard.
11 Features .
5 Features
Employee ID –Numerical Values.
Name –Text
Gender –Text.
Salary –Numerical Values.
Start Date –Numerical Values.
THE “ WOW “ IN OUR
SOLUTION
We use this formula
=IFS(Z8>=5,”VERYHIGH”,Z8>=4,”HIGH”,Z8>=3,”MED”,TRU E,”LOW”)
To find the salary level of the employee.
MODELLING
DATA COLLECTION :
Naan mudhalvan .
Edunet Dashboard.
FEATURE SELECTION :
11 Features.
5 Features.
DATA CLEANING :
Colour blank values
Filter –Remove Blank Values
SALARY LEVEL :
Very High.
High
Medium.
Low
PIVOT TABLE :
▪ Employee ID.
▪ Name.
▪ Gender.
▪ Salary.
▪ Salary level
Start date.
Employee Type.
CHART :
Employee ID.
Name.
Gender.
▪ Salary.
▪ Salary Level.
▪ Start Date.
▪ Employee Type.
▪ Data Visualization.
RESULTS
CONCLUSION
While comparing the salary level of the employee , the employee’s are
getting their salary according to their employee type and start date.
