Data-Analysis-Dashboard

Employee Training and Performance Analysis

Project Overview

This project analyzes employee training data to evaluate its impact on performance. The goal is to provide insights into workforce development and identify trends in employee training programs.

Data Structure

The dataset includes the following sheets:

• Employee Data: Contains employee demographics and job details.
• Training Programme Data: Information on training programs attended by employees.
• Pivot Summary: Aggregated insights derived from pivot tables.
• SUMMARY: A concise report of key findings.
• Dashboard: Visual representation of the analysis using charts and graphs.
• Bonus: Additional calculations and insights.

Key Findings

• **Salary Distribution Across Departments • The Development department has the highest average salary. • Other departments, such as HR and Finance, have significantly lower salaries in comparison.

• **Employee Training Participation • Most employees attended training in Leadership, Technical 1, and Technical 2 categories. • Project Management and Teamwork training had lower participation.

• **Experience by Role • Technicians, Software Engineers, and Job Schedulers have the highest average years of experience. • Analysts and Accountants have the least experience.

• **Average Salary by Role • Software Engineers and Product Analysts earn the highest salaries.

Methodology

• Data Cleaning: Organized and structured raw data.
• Pivot Tables: Created summaries for better analysis.
• Dashboard Design: Implemented charts and visual elements.
• Statistical Insights: Evaluated trends in training participation and impact.

Visualization & Insights

The Excel file includes:

• Interactive dashboards displaying employee training impact.
• Pivot tables summarizing employee participation and performance.
• Conditional formatting to highlight key trends.

Conclusion

This analysis provides valuable insights into employee training programs, helping organizations make data-driven decisions to enhance workforce development.

How to Use the Project

1. Download the Excel file from this repository.
2. Open it in Microsoft Excel or Google Sheets.
3. Navigate through the sheets containing data, analysis, and visualizations.
4. Modify or expand the dataset for further insights.

Contact

For questions or collaboration, reach out via:

• LinkedIn: linkedin.com/in/raymond-tetteh-menetey-a6982b2b1
• Email: meneteyraymondtettehgreat@gmail.com

Dashboard