Categories: Power BI / Practice Datasets
Tags:

Here’s a sample dataset you can use for Power BI to analyze student performance based on gender, ethnicity, parental education, and study habits. The dataset simulates what you’d find in the Kaggle “Students Performance in Exams” dataset, with a few added elements for richer analysis.

You can get the dataset here : https://colorstech.net/wp-content/uploads/2025/04/student_performance_100.xlsx


🔹 Sample Data (20 Rows)

Student IDGenderEthnicityParental EducationTest PreparationMath ScoreReading ScoreWriting Score
S001FemaleGroup AAssociate’s DegreeCompleted727470
S002MaleGroup BHigh SchoolNone586260
S003FemaleGroup CBachelor’s DegreeCompleted889086
S004MaleGroup DSome CollegeNone454952
S005FemaleGroup EMaster’s DegreeCompleted929491
S006MaleGroup AAssociate’s DegreeNone555048
S007FemaleGroup BHigh SchoolCompleted656870
S008MaleGroup CSome CollegeNone706566
S009FemaleGroup DBachelor’s DegreeCompleted808582
S010MaleGroup EMaster’s DegreeCompleted909291
S011FemaleGroup ASome High SchoolNone505249
S012MaleGroup BAssociate’s DegreeCompleted737075
S013FemaleGroup CBachelor’s DegreeNone626664
S014MaleGroup DMaster’s DegreeCompleted858788
S015FemaleGroup EHigh SchoolNone495350
S016MaleGroup ASome CollegeCompleted777974
S017FemaleGroup BBachelor’s DegreeNone687069
S018MaleGroup CAssociate’s DegreeCompleted807882
S019FemaleGroup DHigh SchoolCompleted586057
S020MaleGroup EBachelor’s DegreeNone656766

🔸 Suggested Power BI Visuals

  • Bar Chart: Average scores by gender.
  • Stacked Column Chart: Test Preparation vs. average score.
  • Donut Chart: Distribution of parental education.
  • Box Plot (Custom Visual): Score distributions by ethnicity.
  • Scatter Plot: Math vs. Reading scores, colored by gender.