Brightspace Data Sets reference and ERD
Every D2L Brightspace Data Set (BDS) with its columns, primary keys and joins, plus one entity relationship diagram (ERD) of all 144 data sets.
Brightspace Data Sets Guides: Reports, SQL and ERD
Step-by-step guides for Brightspace admins: build reports from Brightspace Data Sets with tested SQL, join keys and an ERD of every data set.
8 guides
At-risk students in Brightspace: who has not opened a course in 5 days
Find students with no course access in 5 days across Brightspace courses, using a changeable cutoff for follow-up rather than a risk prediction.
Brightspace accreditation reporting: ABET student outcomes data
Set up Brightspace outcomes for ABET and accreditation evidence, then report results by outcome, course and assessment from Brightspace Data Sets with SQL.
Brightspace course enrollment report: every course in a term
Build a Brightspace course enrollment report from Data Hub extracts: list all courses in a semester and count distinct students per course.
Brightspace Data Sets full vs differential: avoid duplicate rows
Understand full and differential data sets in Brightspace, keep the newest row for each key, and check combined enrollments for duplicate rows.
Brightspace login history beyond 30 days: logins per user
See login history past 30 days with Brightspace Data Sets. Count logins per user for a chosen date range, including people with no login.
Failing students across Brightspace courses: final grades below a pass mark
Review final grades across Brightspace courses below a common pass mark, with adjusted grades first, to prepare a list for follow-up.
How to join Brightspace Data Sets: keys and a worked query
Learn how to join Brightspace Data Sets using enrollment, course, user and grade keys, with a worked SQL query and a reference ERD.
No guides match