HR analysis using Excel & Dashboard For HR Management

An HR analytics project aimed at driving strategic HR decisions. Used Python, SQL, and Excel for data management and analysis. Utilized Jupyter Notebook and Pandas for data processing, and Power BI for interactive visualizations. Applied UI/UX design principles to create user-friendly dashboards, delivering actionable insights.

HR Management Dashboard created using Excel

HR Management Dashboard created using Excel

HR Analytics Management Dashboard in Excel

Made an HR management dashboard in Excel that provides a visual overview of key HR metrics and KPIs in a single, organized platform using Power Query and Power Pivot tools.

No description available

No description available

Creating an interactive HR Management dashboard from scratch using Excel's Power Query and Power Pivot tools.

An Excel-based HR Management App designed to simplify employee tracking, payroll processing, and commission calculation. The system integrates employee databases, weekly and yearly work summaries, and an automated paysheet, allowing seamless computation of wages and performance

Transforming HR management with data-driven insights! 👥 Explore my comprehensive HR analytics project, featuring: 📊 Power BI Dashboards 📂 Excel Dashboards

Professional Attendance MIS Dashboard in Excel using KPIs, Pivot Tables, Charts, and Slicers for HR & management reporting.

Automated Excel HR dashboard with VBA macros, data entry forms, KPI tracking, and dynamic reporting for employee management

A full-featured, responsive HR web app with employee management, real-time stats, interactive dashboards, advanced filters, and Excel export.

HR Workspace is a modern HR management dashboard designed for Admins & Employees. It features role-based access, employee performance tracking, file uploads (CSV/Excel), automated visualizations, PDF/Excel reports, time tracking, leave & payroll management, notifications, and chatbot support.

Welcome to the HR Analytical Dashboard repository! This project involves the design and implementation of an Analytical Human Resource (HR) Dashboard using Tableau for data visualization and Excel spreadsheets for data management.

The HR Analytics Dashboard in MS Excel helps HR teams analyze employee data, track key HR metrics, and improve workforce management. It includes insights on employee demographics, attrition rates, performance, recruitment, and satisfaction levels using Pivot Tables, Charts, and Excel formulas.

HR Analytics Dashboard (Power BI + Excel), an in-depth HR Analytics report which helps HR teams and management track attendance patterns, improve workforce efficiency, and make data-driven decisions regarding remote work and employee well-being.

This repository contains an interactive HR Dashboard created using Power BI, leveraging data from "HR Analytics Data" and "HR Employee Data" in Excel. The dashboard provides insightful visualizations and analyses to help HR professionals track key metrics, identify trends, and make data-driven decisions for effective workforce management.

A professional Enterprise Management System built with the MERN stack. Features a real-time financial dashboard, CRM for customer tracking, HR & Payroll management, and automated Excel reporting.

Developed a multi-department Excel dashboard (Sales, Inventory, HR) analyzing 14,500+ records with KPIs across revenue, stock management, and workforce analytics. Tools Used: Microsoft Excel, Pivot Tables, Data Modeling, Slicers, KPI Analysis, Dashboard Design.

A collection of beginner to intermediate Excel data analysis projects covering payroll, education, HR, decision-making, and inventory management with practical dashboards and insights.

This repository showcases a comprehensive and interactive HR Analytics dashboard built entirely in Microsoft Excel. Designed to provide key insights into an organization's workforce, this dashboard transforms raw HR data into actionable intelligence for strategic talent management.

An HR analytics dashboard in Excel is a powerful tool that allows human resources professionals to collect, analyze, and visualize various HR metrics and data to make informed decisions, tract key performance indicators (KPIs), and enhance overall HR management.

Excel-based HR analytics and process automation dashboards built during my tenure at Acclime Malaysia, covering recruitment tracking, onboarding management, turnover analysis, and hiring requisitions.

This project provides a strategic HR Attendance & Leave Management Dashboard built in Microsoft Excel. It transforms raw employee data into interactive dashboards that help HR managers, department heads, and executives analyze attendance trends, absenteeism rates, and leave distribution in real-time.

This project is an HR Analytics Dashboard in MS Excel, aimed at providing key insights into employee data, including demographics, tenure, salary distribution, and leave balance. The dashboard helps HR teams make data-driven decisions regarding workforce management and employee retention.

Developed a comprehensive HR dashboard in Power BI using Excel data, featuring custom visuals and interactive elements. Key insights include performance, retention, engagement, recruitment, and diversity, enhancing decision-making, efficiency, accuracy, and scalability for HR management.

An HR Analytics Management Dashboard built entirely in Excel. This project features interactive data visualizations, KPI tracking, and automated reporting for workforce metrics like attrition, headcount, and performance. Leverages advanced Excel functions, pivot tables, and slicers to transform raw HR data into actionable business insights.

Developed a comprehensive HR dashboard in Power BI using Excel data, featuring custom visuals and interactive elements. Key insights include performance, retention, engagement, recruitment, and diversity, enhancing decision-making, efficiency, accuracy, and scalability for HR management.