HR Dashboard

Objective

This dashboard centralizes and automates HR data processing, replacing manual Excel-based reporting. It provides a consolidated view of key HR metrics, improving decision-making and reducing manual workload.

Scenario

Previously, the HR department managed monthly reports using multiple Excel files, which required significant manual effort and was prone to errors. The goal was to automate data processing and create a dynamic, user-friendly dashboard.

Workflow

1. Data Extraction & Transformation: The dashboard processes multiple Excel files each month using Power Query.
2. Data Consolidation: The transformed data is merged into a structured format, eliminating manual processing.
3. Modeling & Reporting: The consolidated data is loaded into Power BI, where key HR metrics and trends are visualized.

Key Metrics & Visuals

• Employee headcount.
• Satisfaction.
• Salary analysis and payroll distribution.
• Department-wise performance and workforce distribution.
• Recruitment.

Technologies Used

• ETL: Power Query.
• Data Source: Multiple Excel files.
• Reporting & Modeling: Power BI.

Business Impact

• Time Savings: Eliminated manual data processing, saving several hours per month.
• Error Reduction: Improved data accuracy by automating consolidation.
• Efficiency: Provided HR teams with real-time insights, enhancing workforce planning.

Challenges & Solutions

• File Variability: Developed a robust Power Query logic to handle format inconsistencies across Excel files.
• Performance Optimization: Ensured smooth processing of large datasets by optimizing transformations.