This HR Analytics dashboard provides a clear view of workforce attrition and its key drivers. It analyzes a workforce of 1.47K employees, with 313 exits and an overall attrition rate of 21%. 

Attrition is examined across departments, gender, education level, age group, tenure, and salary band. 

Key insights reveal higher attrition among mid-salary employees, a strong concentration in the 30–49 age group, and notable exits even among long-tenured staff. 

Built using Power BI, DAX, and data modeling techniques, the dashboard supports data-driven decision-making, helping leadership improve workforce planning, retention strategies, and targeted HR interventions.

This project demonstrates an HR Weekly Report automation built with n8n to seamlessly connect Google Forms, Google Sheets, and Gmail. Employee data is captured via a Google Form and stored centrally in Google Sheets. A scheduled trigger in n8n runs weekly to retrieve relevant records, while a JavaScript node cleans, structures, and summarizes the data. The processed output is appended to a reporting sheet and automatically emailed to HR stakeholders through Gmail. This automation eliminates manual reporting, improves data accuracy, and ensures timely insights.

Management Recommendation:
Adopt similar workflow automations across HR operations to reduce repetitive tasks, improve reporting consistency, and enable faster, data-driven decision-making.

Business Challenge:
Employee information was fragmented across paper files, WhatsApp messages, and multiple spreadsheets, making it difficult to access accurate and up-to-date records. Core HR processes such as leave requests, staff updates, and document management were handled manually, resulting in delays, errors, and inconsistent data. Management also lacked real-time visibility into headcount, leave utilization, and workforce structure, limiting effective planning and decision-making.

Project Impact:
By implementing Zoho People, all employee records were centralized into a single, reliable system of record. Automated leave management and employee update workflows reduced manual effort and improved operational efficiency. Leadership gained access to accurate, real-time HR reports, enabling better workforce planning and data-driven decisions.

Management Recommendation:
Continue expanding HR automation and analytics within the HRIS to improve scalability, compliance, and strategic workforce insights.