We will use a real-world dataset from AtliQ Technologies for this end-to-end data analytics project, with an emphasis on employee attendance during a three-month period. In order to assist the HR team in understanding employee attendance trends, we will build a Power BI dashboard. This useful, job-worthy project makes use of real data and provides a hands-on introduction to real-world analytics.
The dataset used in this project is sourced from AtliQ Technologies and contains employee attendance information over a three-month period, from April to June, aligning with the company's fiscal year. This real-world dataset will be analyzed to provide key insights into employee presence and attendance patterns during this three months.
- ./DataSet/Attendance Sheet 2022-2023_Masked : Raw data.
- ./DataSet/final_data : Processed data.
- Analyze work-from-home trends, focusing on Mondays and Fridays, to understand employee preferences and possible reasons for this behavior.
- Calculate the percentage of sick leave taken by employees to provide insights into attendance patterns.
- Upload the Excel worksheet to Power BI.
- Create a template from the data.
- Process the data (adjust columns, remove unwanted rows).
- Apply custom functions.
- Load the final data.
- Create matrices and measures.
- Develop visualizations and calculate required percentages.
- Power BI
- Excel
This study shows how data analytics methods may be applied to solve practical business issues. Our goal is to obtain important insights that help improve HR strategies and decision-making procedures by examining employee presence data.
- YouTube : https://www.youtube.com/@codebasics
- WebSite : https://codebasics.io/resources/resume-project-data-analytics
Thank you, Hemanand Vadivel, for sharing your expertise in data analysis, Power BI, and dashboarding, and thank you, Dhaval Patel, for organizing this insightful session.