Mabel Naa Densua Offei

ALTERA CO. HR ANALYTICS REPORT Mabel Naa Densua Offei 31st July, 2024 CONTENTS Table of Contents ALTERA CO. | HR ANALYTICS REPORT 2024 02. Introduction 03. Data Preparation 04. Dashboard Design and Features 05 - 07. Key Insights 08. Recommendations 09. Conclusion 10. Acknowledgement 01 INTRODUCTION In today's data-driven business environment, optimising human resources through analytics is crucial for organisational success. This HR Analytics Dashboard for Altera Co. provides key insights into workforce demographics, training initiatives, and performance metrics to support strategic decisionmaking. Scope and Key Highlights With a total employee of 23,490, Altera Co. has a predominantly young, female workforce with a strong focus on training and development. Demographics: The majority of employees are between 20 and 35, and 63.26% are female. Training: The company has invested in significant training, with 29,462 training hours recorded and 84.29% of training KPIs met. Recruitment channels include social media and the company's website, and there is a potential gender gap in performance ratings. Recruitment: Social media and the company's website have been effective recruitment channels, with a combined 23,490 hires. Social media has been particularly successful, accounting for 13,529 hires. Performance: The average previous rating for female employees is slightly higher than for male employees, suggesting a potential gender gap. This dashboard allows us to identify trends, improve processes, and celebrate achievements, ultimately enhancing employee engagement and driving organisational growth. ALTERA CO. | HR ANALYTICS REPORT 2024 02 DATA PREPARATION Accurate and reliable data is the cornerstone of effective analytics. The data used for this HR Analytics Dashboard was meticulously prepared to ensure it meets the highest standards of quality and usability. 01 DATA SOURCE 02 DATA CLEANING 03 PREPARATION The data for this dashboard was provided by the HR department of Altera. To ensure accuracy and reliability, the data underwent thorough cleaning: Empty rows in the average rating column were replaced with 0. Values in the contract type column were renamed from "pt" and "ft" to "Part Time" and "Full Time" for clarity. Transformations included standardising column names and formatting data for consistency before visualisation. ALTERA CO. | HR ANALYTICS REPORT 2024 03 DASHBOARD DESIGN AND FEATURES The HR Analytics Dashboard for Altera Co. provides critical insights into various aspects of the workforce: Employee Demographics: Total number of employees, gender distribution, employment status. Educational Qualifications: Breakdown of employees' educational levels. Departmental Allocation: Number of employees in each department. Training Efforts: Total and average training sessions. Performance Metrics: Key performance indicators met by employees. Geographical Distribution: Map of employee locations. The dashboard includes detailed charts and features: Employee Tenure: Line chart showing length of service. Training by Department: Bar chart of training sessions. Departmental Awards: Number of awards by department. Recruitment Channels: Bar chart of employees hired through different channels. Performance Ratings by Gender: Comparison of average ratings. Interactive Filters: Options to filter data by gender, contract type, service length, location, and department. These insights enable strategic HR management and optimisation of workforce-related processes ALTERA CO. | HR ANALYTICS REPORT 2024 04 KEY INSIGHTS 1. Altera Co. has a predominantly young, female workforce. The majority of employees are between 20 and 35, and 70.65% are female. Altera exhibits a trend of sustained long-term employment, even with a steady influx of younger applicants. Over 300 employees have been with the company for more than a decade. ALTERA CO. | HR ANALYTICS REPORT 2024 05 KEY INSIGHTS 2. Altera Co. has significantly invested in training, recording 29,462 sessions, with 8,429 KPIs exceeding 80% met. The Sales and Marketing department recorded the highest number of trainings, while the Legal department recorded the least. The average previous performance rating for female employees is slightly higher than for male employees, suggesting a potential gender gap. ALTERA CO. | HR ANALYTICS REPORT 2024 06 KEY INSIGHTS Although both Altera’s website and social media platforms have proven effective for recruitment, a significant portion of applications are sourced from social media. ALTERA CO. | HR ANALYTICS REPORT 2024 07 RECOMMENDATIONS Based on the insights gathered, here are some strategies and improvements I recommend: Strategies Enhance employee retention and innovation Implement career development and recognition programs for long-tenured staff Leverage social media for diverse recruitment Promote cross-generational collaboration. Improvements Expand data collection to include metrics on employee satisfaction and retention. This will help refine the analysis by segmenting the data, allowing for a clearer understanding of trends and their impact on organisational performance. ALTERA CO. | HR ANALYTICS REPORT 2024 08 CONCLUSION In wrapping up this report, it’s important to reflect on the insights derived from the dashboard and the implications they hold for Altera. This report reveals Altera's youthful workforce and high retention. The dashboard shows how social media recruitment supports a dynamic yet stable workforce. Recommendations focus on boosting engagement and social media use, while improvements aim to refine data analysis for better insights. I recommend adding metrics on employee satisfaction and reasons for departure. Enhancing the dashboard with these elements will offer a clearer view of workforce dynamics and support more effective strategy development. ALTERA CO. | HR ANALYTICS REPORT 2024 09 ACKNOWLEDGEMENTS Heartfelt thanks to Joycelyn Otchere for her exceptional support throughout this project. Appreciation also goes to the community at Only Quality Data, whose collaborative spirit and assistance were crucial to our success. I am grateful for the collective contributions that made it possible. Thank you, Altera, for entrusting us with your data and allowing us to support your business. CONTACT Mabel Naa Densua Offei https://www.linkedin.com/in/naa-densua/- ALTERA CO. | HR ANALYTICS REPORT 2024 10