openedx / aspects-dbt

The dbt project for Open edX Aspects!
Apache License 2.0
2 stars 5 forks source link

feat: implement fact_student_status model #53

Closed Ian2012 closed 6 months ago

Ian2012 commented 7 months ago

Description

This PR creates an MV for the latest course enrollment status for a learner and renames the fact_grade_status to fact_learner_status with information of the current grade, current approving status and current enrollment status.

It also updates the fact_video_plays model to include video duration and visualization progress.

openedx-webhooks commented 7 months ago

Thanks for the pull request, @Ian2012! Please note that it may take us up to several weeks or months to complete a review and merge your PR.

Feel free to add as much of the following information to the ticket as you can:

All technical communication about the code itself will be done via the GitHub pull request interface. As a reminder, our process documentation is here.

Please let us know once your PR is ready for our review and all tests are green.

Ian2012 commented 7 months ago

@daniriosp Does this model update make sense to you?

SoryRawyer commented 6 months ago

@Ian2012 I think my first question above isn't relevant anymore, but I'm still interesting in the answer to my second question. Are there specific charts or dashboards that this dataset is meant to support?

daniriosp commented 6 months ago

@SoryRawyer There are 2 charts using this report. They are in the course dashborad V1 and are called Learners with passing grade and Distribution of Current Course Grade, both in the performance tab.

Ian2012 commented 6 months ago

@SoryRawyer I'm still missing the course_run field on all those models. I will let you know when it's done

openedx-webhooks commented 6 months ago

@Ian2012 🎉 Your pull request was merged! Please take a moment to answer a two question survey so we can improve your experience in the future.