Design and Implementation of an Interactive Power BI Dashboard for Monitoring Academic Performance, Attendance and Student Risk in a College

There is a wealth of information available about students in colleges. This information is, however, usually kept in various spreadsheets, and looked at just once at the end of each semester. As a result, it is often too late to help those that are struggling. To overcome this issue, a College Academic Performance Dashboard has been developed using Microsoft Power BI. The data model contains 4 tables which are included on the Dashboard: Students, Courses, Grades, Semester_Summary. The dashboard includes measures to give an insight into the students’ academic performance. These are Average CGPA, Average SGPA, Pass Rate, Average Attendance, Total Backlogs and At Risk Students. There are 4 pages on the dashboard: Overview, Academic Performance, Attendance, and Risk. 1500 students were included in the data. The pass rate was 87.29%, the average CGPA was 7.03 and the average attendance was 77.91%. But 557 students had attendance below 75%. In addition, 516 students had backlogs and 607 students (40.47%) were identified as at risk. This dashboard illustrates that an average that is acceptable can be deceiving. This project has some restrictions, such as the definition of students' at-risk status. The dashboard gives some information regarding past performance and cannot predict the future.

Authors

Publication Details

Journal
Zenodo (CERN European Organization for Nuclear Research)
Published
2026-11-15
DOI
https://doi.org/10.5281/zenodo.24250171
Primary Topic
Online Learning and Analytics
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
article

Design and Implementation of an Interactive Power BI Dashboard for Monitoring Academic Performance, Attendance and Student Risk in a College

Harshada Bedse*, Pushpaj Mistari, Dr. Ganesh Ragade
Zenodo (CERN European Organization for Nuclear Research)
Online Learning and Analytics
article

Design and Implementation of an Interactive Power BI Dashboard for Monitoring Academic Performance, Attendance and Student Risk in a College

Harshada Bedse*, Pushpaj Mistari, Dr. Ganesh Ragade
article en

Abstract

There is a wealth of information available about students in colleges. This information is, however, usually kept in various spreadsheets, and looked at just once at the end of each semester. As a result, it is often too late to help those that are struggling. To overcome this issue, a College Academic Performance Dashboard has been developed using Microsoft Power BI. The data model contains 4 tables which are included on the Dashboard: Students, Courses, Grades, Semester_Summary. The dashboard includes measures to give an insight into the students’ academic performance. These are Average CGPA, Average SGPA, Pass Rate, Average Attendance, Total Backlogs and At Risk Students. There are 4 pages on the dashboard: Overview, Academic Performance, Attendance, and Risk. 1500 students were included in the data. The pass rate was 87.29%, the average CGPA was 7.03 and the average attendance was 77.91%. But 557 students had attendance below 75%. In addition, 516 students had backlogs and 607 students (40.47%) were identified as at risk. This dashboard illustrates that an average that is acceptable can be deceiving. This project has some restrictions, such as the definition of students' at-risk status. The dashboard gives some information regarding past performance and cannot predict the future.

Zenodo (CERN European Organization for Nuclear Research)
Online Learning and Analytics
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.

Laika access coming soon
Design and Implementation of an Interactive Power BI Dashboard for Monitoring Academic Performance, Attendance and Student Risk in a College — Harshada Bedse*, Pushpaj Mistari, Dr. Ganesh Ragade · Zenodo (CERN European Organization for Nuclear Research) (2026) | TGRS Research Map | TGRS