This project presents an interactive workforce analytics dashboard built using Power BI to analyze employee attendance patterns, work-from-home trends, and leave distributions.
The dashboard transforms raw attendance data into clear visual insights that help HR teams monitor workforce availability, identify attendance trends, and support better operational decision-making.
Human Resource teams often rely on large spreadsheets to track employee attendance, work-from-home activity, and leave records. Analyzing this information manually is time-consuming and makes it difficult to quickly identify patterns or workforce availability trends.
This project solves that problem by converting raw attendance data into an interactive dashboard that provides clear insights into workforce presence and attendance behavior.
- Microsoft Power BI
- Power Query (Data Cleaning & Transformation)
- Microsoft Excel (Dataset)
The dataset contains employee attendance records collected over multiple months.
Main attributes include:
- Employee ID
- Department
- Attendance Status (Present / Work From Home / Sick Leave)
- Date
- Monthly Attendance Records
The dataset used in this project is available inside the dataset folder.
The project follows a structured data analytics workflow:
-
Data Collection
Attendance dataset containing employee presence, work-from-home status, and leave records. -
Data Cleaning
Data inconsistencies were handled using Power Query by standardizing attendance categories and validating date fields. -
Data Transformation
Monthly metrics and attendance percentages were calculated to support trend analysis. -
Data Visualization
Interactive dashboards were created to monitor workforce presence and attendance patterns. -
Insight Generation
The dashboard helps identify attendance trends, remote work behavior, and workforce availability patterns.
Before building the dashboard, the dataset was cleaned and transformed using Power Query.
Steps performed:
- Removed duplicate records
- Standardized attendance labels (Present, Work From Home, Sick Leave)
- Converted date fields to proper date format
- Extracted month information for monthly analysis
- Validated and handled missing values
These steps ensured the dataset was structured correctly for analysis and visualization.
The Power BI dashboard provides the following analytical capabilities:
- Monthly workforce presence tracking
- Work-from-home trend analysis
- Sick leave monitoring
- Attendance percentage metrics
- Department-level workforce comparison
- Interactive filtering for monthly insights
The overview dashboard summarizes key workforce metrics including presence percentage, work-from-home distribution, and leave trends.
Displays workforce presence, work-from-home percentage, and sick leave patterns for April.
Highlights attendance trends and workforce distribution across different attendance categories.
Shows attendance performance and workforce presence metrics for June.
- Workforce presence remains consistently high across most months.
- Work-from-home patterns fluctuate depending on operational requirements.
- Sick leave percentages remain relatively low within the observed dataset.
- Hybrid work behavior can be observed through the distribution of remote work trends.
Organizations can use this dashboard to:
- Monitor workforce availability
- Identify absenteeism patterns
- Track hybrid work trends
- Support workforce planning and HR decision-making
- Improve operational productivity through data-driven insights
This project demonstrates the following data analytics skills:
- Data Cleaning
- Data Transformation
- Data Visualization
- Dashboard Design
- Business Insight Generation
- HR Data Analysis
Junaid Khan
Data Analytics & Business Intelligence Enthusiast
GitHub: https://github.com/belike007