Data and Analytics

Join

Need Course Offering Enrollments ADS in Analytics Builder

Katherine.F.342
Katherine.F.342 Posts: 13 Analytics Builder Transition
edited May 7 in Social Groups

I have created several dashboards within Analytics Builder for compliance trainings (ie Title 6/9, Digital Accessibility, etc) for stakeholders at my college. However, I am struggling to get an accurate list of the "current" enrollments for these course shells, as sometimes users are removed from the list.

Previously, I was using the "User Enrollments" dataset assuming it would only show active/current enrollments, but that is not the case.

I saw that there is a new ADS that shows exactly what I need: Course Offering Enrollments (https://community.d2l.com/brightspace/kb/articles/5560-data-hub-new-advanced-data-set-course-offering-enrollments) BUT this data set is not in Analytics.

I have tried to take the "Enrollments and Withdrawals" dataset, filter it into 2 separate tables for Enroll and Unenroll actions, and then rejoin them based on OrgUnit and UserId to identify users that have been enrolled and then unenrolled from the courses. However my joins always end up with no results.

How have y'all created a "Current Enrollments" dataset within Analytics builder?

image.png
Tagged:
· Share on Twitter

Answers

  • Miguel.B.106
    Miguel.B.106 Posts: 44 🤝🏼 image

    Hi @Katherine.F.342,

    Thank you for reaching out to the Brightspace Community!

    The Course Offering Enrollments ADS you referenced exists in the Data Hub as an Advanced Data Set, but it is not available in Analytics Builder.

    Instead, you may consider joining the following BDS to retrieve the enrollment data in Analytics Builder.

    Primary data set: User Enrollments (which returns a list of enrollments for all users in your organization)

    Joined with the organizational Units data set (which returns details about all org units within your organization)

    (OrgUnitId → OrgUnitId)

    Joined with the Users data set

    (UserId → UserId)

    Joined with the Enrollments and Withdrawals data set

    (UserId + OrgUnitId → UserId + OrgUnitId)

    This may give you the equivalent output fields of the Course Offering Enrollments ADS.

    Please find below the following documentation regarding the User Enrollments BDS, including the entity relationship diagram:

    https://community.d2l.com/brightspace/kb/articles/4740-users-data-sets#entity-relationship-diagram

    We hope this helps, and please feel welcome to reach out with more questions!

    Best regards

    Miguel B.

    · Share on Twitter

Categories