A collection of interactive Power BI dashboards developed as part of the CodeAlpha Data Analytics Internship.
This project focuses on transforming datasets into meaningful visual insights using Power BI, DAX, interactive filters, and data-driven analysis.
An interactive dashboard designed to analyze financial performance and identify important business trends.
Key Features:
- Total Sales
- Total Profit
- Total COGS
- Profit Margin
- Total Units Sold
- Profit contribution by product
- Sales vs Profit analysis
- Profit drivers analysis
- Sales by country
- Profit margin target
- Sales trend and forecasting
- Interactive Country, Segment and Product filters
An HR analytics dashboard designed to understand workforce distribution, employee attrition and employee performance.
Key Features:
- Total Employees
- Attrition Count
- Attrition Rate
- Active Employees
- Average Job Satisfaction
- Average Performance Rating
- Employee distribution by department
- Attrition analysis by department
- Workforce distribution by job level
- Employee distribution by age
- Department-wise HR performance summary
- Interactive Department, Job Role and Gender filters
An educational analytics dashboard created to analyze student academic performance, engagement and areas requiring academic support.
Key Features:
- Total Students
- Average Math Score
- Average Absence Days
- Average Study Hours
- Subject-wise academic performance
- Performance comparison by gender
- Student engagement analysis
- Average absence by career aspiration
- Interactive Gender, Career Aspiration and Part-Time Job filters
- Microsoft Power BI
- Power Query
- DAX
- Microsoft Excel
- Data Visualization
- Data Analysis
CodeAlpha_Data_Analytics_Dashboards/
│
├── Task_1_Financial_Health_Dashboard/
│ ├── CodeAlpha_Financial_Health_Dashboard.pbix
│ └── Financial_Health_Dashboard.png
│
├── Task_2_HR_Analytics/
│ ├── CodeAlpha_HR_Analytics_Dashboard.pbix
│ └── HR_Analytics_Dashboard.png
│
├── Task_4_Educational_Performance/
│ ├── CodeAlpha_Educational_Performance_Resource_Allocation.pbix
│ └── Educational_Performance_Dashboard.png
│
└── README.md