EMPOLYEE DATASETS ANALYSIS USING EXCEL
• STUDENT NAME: GOVARDHANI.S
• REGISTER NO: 422200481
• NAAN MUDHALVAN ID:4618D195F6B1711A845435683B627D2A
• DEPARTMENT: B.COM(ISM)
• COLLEGE NAME: VALLIAMMAL COLLEGE FOR WOMEN
PROJECT TITLE
• EMPOLYEE SALARY ANALYSIS USING EXCEL
AGENDA
• PROBLEM STATEMENT
• PROJECT OVERVIEW
• END USERS
• OUR SOLUTION AND PROPOSITION
• DATASET DESCRIPTION
• MODELLING APPROACH
• RESULTS AND DISCUSSION
• 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 THIS IN ORDER TO IDENTIFY THE
TRENDS,PATTERNS OF DIFFERENT CATEGORIES OF EMPLOYEE SALARY
LIKE VERY HIGH,HIGH,MEDIUM, AND LOW,.
WHO ARE 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.
RESULT
CONCLUSION
• While comparing the salary level of the employee , the employee’s
are getting their salary according to their employee type and start date.
