Scribd
Upload
8 views12 pages

Employee Performance Analysis in Excel

The document presents a project on Employee Performance Analysis using Excel, focusing on the sales and production departments. It outlines the problem statement, project overview, end users, and the solution's value proposition, which includes data visualization techniques like graphs and charts. The analysis concludes that the area sales manager has a higher employee rating compared to production technicians.

Uploaded by

avengerdeepak12
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
8 views12 pages

Employee Performance Analysis in Excel

The document presents a project on Employee Performance Analysis using Excel, focusing on the sales and production departments. It outlines the problem statement, project overview, end users, and the solution's value proposition, which includes data visualization techniques like graphs and charts. The analysis concludes that the area sales manager has a higher employee rating compared to production technicians.

Uploaded by

avengerdeepak12
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

Employee Data Analysis using Excel

STUDENT NAME: POOJA. P


REGISTER NO: 312209852
NM ID: CEA7791D5CFFA04979E4755DC415696F
DEPARTMENT: Bcom Accounting & Finance
COLLEGE: Valliammal College for Women

1
PROJECT
TITLE
Employee Performance Analysis
using Excel

2
AGEN
DA [Link] Statement
[Link] Overview
[Link] Users
[Link] Solution and Proposition
[Link] Description
[Link] Approach
[Link] and Discussion
[Link]

3/21/2024 Annual 3
Review
PROBLEM
STATEMENT

The employee performance analysis using excel will be


helpful for the growth and
improvement of the organisation.

4
PROJECT
OVERVIEW
•.

This analysis is based on the features, sales and production departments


of the organisation and can find out the trends.

5
WHO ARE THE END
USERS?

The end users are the employer, employees, managers and


higher officials of the company.

6
OUR SOLUTION AND ITS VALUE
PROPOSITION
Conditional formatting

Filtering

Pivot table

Graph

Pie chart

7
Dataset Description

Data collected – Edunet dashboard

Features

Gender

Employee rating
THE "WOW" IN OUR
SOLUTION

The performance analysis of sales and production departments are


easily visualised
with the help of graphs and charts.

3/21/2024 Annual 9
Review
MODELLI
NG
1. Data collection – Edunet

2. Features – all features

3. Data cleaning – sorted and filtered

4. Performance – high score

5. Data visualisation – Graphical representation

10
RESUL
TS
Employee Performance Analysis
9
8
Current Employee Rating

7
6
5
Sum of Current Employee Rating
4
Count of Performance Score
3
2
1
0
Sales IT/IS Sales Sales Sales
Contract Full-Time Contract Full-Time
Area Sales Manager Production Technician I
DepartmentType

11
conclusion

With the comparison of the area sales manager and


the production technicians,
the sum of current employee rating is higher.

You might also like