Interactive HR Dashboard

I have designed a comprehensive and interactive HR and Sales Dashboard that presents data in a visually engaging format. This dashboard enables management to make data-driven decisions based on accurate figures.

Key Analytical Components

1. Key Performance Indicators (KPIs)

The dashboard prominently features the most crucial metrics:

Average Sales: 24.82K

Total Employees: 689

Total Sales: 17M

2. Analysis by Departments

The dashboard displays the Top 5 Departments by Average Salary.

Facilities/Engineering leads with an average salary of 1.59M, followed by Training at 0.45M.

This analysis helps in identifying departments with the highest budgetary consumption in terms of payroll.

3. Employee Distribution by Centers

The Main center holds the largest percentage of employees at 36.43% (251 employees).

The South center follows with 30.04% (207 employees).

This distribution clearly shows the concentration of the workforce and areas that may require additional support.

4. Employee Distribution by Countries

Egypt leads the geographical distribution with 55% (379 employees).

The UAE is second with 22.64% (156 employees), followed by Saudi Arabia, Syria, and Lebanon.

This illustrates the company's geographical spread and the regional distribution of its workforce.

5. Employee Growth Trend (2016 – 2020)

The company saw significant growth in employee count, rising from 51 employees in 2016 to a peak of 248 employees in 2019.

The number of employees decreased in 2020 to 162, which may indicate economic effects or internal restructuring.

6. Interactive Filters

The dashboard includes flexible filters to enhance data analysis:

Gender

Years of Service

Year