Unique-System-Data-Analysis (Interactive Dashboard using PowerBI)

Project Objective:

Employee Details dataset contains information such as employee ID, name,position, salary, and attendance. This information can be used to gain insights into the company's workforce, their performance, and overall productivity.

Dataset Used:

• Data2020
• Data2021
• Data2022
• DataEMP

Questions KPIs:

1. What is the count of employees in the dataset?
2. What is the average salary of employees in the dataset?
3. What is the average salary of employees in the dataset?
4. How does the sum of salary vary with experience levels of employees in the dataset?
5. How many employees are there from each country in the dataset?
6. What is the salary and department of each employee in the dataset?
7. How does the total attendance vary with year and gender in the dataset?
8. How many employees are there in each department and gender in the dataset?

Dashboard Interaction:

• View Dashboard

Process:

1. Installation Power BI
2. Data cleaning
3. Data view
4. Visiual insight
5. Creating Dashboard

Dashboard

Project Insight:

1. Count of employee id is 38.
2. Average Salary of employee is 8.17k.
3. Total count of department is 11.
4. Sum of salary by junior is more than fresher.
5. Sum of salary by age 38 is more than other

Final Conclusion:

This project highlights how Power BI can transform raw HR data into insightful, actionable visualizations. By integrating data cleaning, modeling, and interactive visual storytelling, this project reinforces Power BI’s capabilities in business intelligence and strategic decision-making. The use of conditional logic, time functions, and multi-chart visuals enhances data accessibility and comprehension for all users.