Sharing my Power BI template: Education Management - Cumulative GPA by Athletic Team

Rebecca Sundquist
Rebecca Sundquist Blackbaud Employee
Eighth Anniversary Kudos 2 Name Dropper Participant
edited June 21 in SKY Developer General Discussions

- Description: These materials are for Blackbaud K12 User Conference 2026 workshops

  1. Power BI (Part 1): Data Modeling and Validation for Student Reporting
  2. Power BI (Part 2): Designing Interactive Reports for Student Insights

- Required connections: CSV files provided in attached .zip

- Suggested skill level required to use this template: Beginner

- Configuration details: Build a Power BI report with sample data from Education Management lists including a Student List with Cumulative GPA fields and an Advanced List with Athletic Team rosters.

- Category: Report sample

- Instructions:
Workshop companion guide is included and covers topics:

  1. Connect to data
  2. Manage table relationships
  3. DAX measures and columns
  4. Slicers and Sync Slicers controls
  5. Report field parameters
  6. Tips for consistently beautiful reports
  7. Refresh date and time zone conversion
  8. How to switch data connection from local csv files to SharePoint hosted files

Contents of .zip include:

BBEM_PowerBI_AthleticsGPA.pdf - Companion guide. START HERE.

BBEM_Lists_AthleticsGPA.pdf - instructions to create the two data files from Education Management lists.

CumulativeGPA.csv - sample data file

AthleticsRoster.csv - sample data file

Part1_Data_Modeling_and_Validation.pbix - example solution for Part 1

Part2_Build_Report.pbix - example solution for Part 2

CumulativeGPA_AthleticTeam_Example.zip
Tagged:

Answers

  • Eric Eskildsen
    Eric Eskildsen
    Sixth Anniversary Kudos 1 Name Dropper Participant
    edited June 22

    Rebecca - as someone who likely won't be able to make the UC this year but would very much like to - and is hoping to go to the next one if they continue - thanks so much for posting this.

    Question … we (used to?) have to calculate GPA ahead of time and create a stored value to pull it in a student list. Am I understanding correctly that that is not necessary using the SKY list method you shared?

  • Rebecca Sundquist
    Rebecca Sundquist Blackbaud Employee
    Eighth Anniversary Kudos 2 Name Dropper Participant

    @Eric Eskildsen , the grades in the Student List are from Grade Calculations. I hope that helps!

Categories