Name: Swetha P
Roll Number: 23BAD119
This experiment focuses on designing an interactive analytical dashboard using Power BI. The dashboard presents key performance indicators (KPIs) and interactive visualizations to analyze attendance and academic performance across departments and semesters. It enables real-time interaction and deeper insight through filters and drill-down features.
The dataset contains academic information related to students and departments, including:
- Department
- Semester
- Attendance percentage
- Academic performance metrics
The data is used to compute KPIs and generate visual insights for smart campus monitoring.
- Power BI Desktop
- Data Visualization and Dashboard Design Tools (Power BI)
- Designed KPI cards to display:
- Average Attendance Percentage
- Average Academic Performance
- Implemented interactive slicers for:
- Department-wise filtering
- Semester-wise filtering
- Created bar charts to visualize attendance by department.
- Linked multiple visuals to enable drill-down analysis.
- Ensured all visuals update dynamically based on user selections.
- KPI Cards: Display average attendance and academic performance
- Slicers: Enable department-wise and semester-wise analysis
- Bar Charts: Show attendance distribution across departments
- Drill-Down Analysis: Allows detailed analysis at department and subject levels
- Interactive Views: Real-time updates of KPIs and visuals
The Power BI dashboard file (.pbix) has been attached for reference and evaluation.
This experiment demonstrates the effective design of an interactive analytical dashboard using Power BI. The dashboard enables real-time monitoring of attendance and academic performance through KPIs, interactive filters, and drill-down capabilities. Such dashboards play a vital role in AI-based smart campus systems by supporting data-driven insights and informed academic decision-making.