Skip to content

SamiraSiavash/Students-dashboard

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

5 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

Power BI

πŸŽ“ Students Analytics Dashboard – Power BI

An interactive Power BI dashboard analyzing student-related data, including applicants, students, graduates, dropouts, departments, classes, and courses.

This dashboard was developed as the final project for a Power BI training course, with multi-page reporting and visual exploration of performance indicators across the student lifecycle.


πŸ“Š Dashboard Pages & Highlights

πŸ“ Applicants

  • Over 600,000 records analyzed
  • Gender breakdown of applicants
  • Admission status (Accepted / Rejected)
  • Admission score comparison by gender
  • Application trends by year and state

πŸ“ Students

  • Over 119,000 currently or previously enrolled students
  • Status: Enrolled / Graduated / Dropped out
  • Distribution by gender, grade level, major and geography

πŸ“ Graduates

  • Graduation trends across years
  • Gender and major breakdown
  • Top states for graduate concentration

πŸ“ Dropouts

  • Dropout rate analysis by gender and major
  • Academic level and age distributions

πŸ“ Departments & Courses

  • 11 departments and 20 programs
  • Number of class sessions by course and department
  • Grade distribution: A / B / C / D

πŸ›  Tools & Technologies

  • Power BI Desktop
  • Power Query (M Language)
  • Star schema data modeling
  • Excel & SQL Server as data sources
  • Visuals: KPI cards, bar charts, pie charts, treemaps, tables

πŸ“¦ Downloads

You can download the full Power BI report and SQL backup here:

➑️ Download Dashboard & Backup from Release

Files included:

  • students-dashboard.pbix
  • students_Full.zip

πŸ“Έ Dashboard Screenshots

πŸ“ See /images/ folder for preview screenshots.
Here's an example from the "Applicants" page:

Applicants Overview


πŸ‘©β€πŸ’» Author

Samira Siavash
🌐 LinkedIn | πŸ’» GitHub


πŸ“œ License

This project is licensed under the MIT License – see the LICENSE file for details.