Data Report Improvements: Detailed Student Data Dashboard

[ahmed-arb]

1. Goal:

Facilitate data-driven decision-making by offering clear insights into learners’ enrollment patterns and completion rates, improving overall oversight and planning.

2. Overview of requirements:

Following the proposed design by Ahmed Khalid, this additional dashboard view should include the following features:

• Display every detailed enrollment in the platform
• Query enrollments by:
  • Learner username
  • Course title
  • Enrollment status (Enrolled/Completed)
  • Certificate (if applicable)
  • Enrollment and completion dates
• Display results in a sortable and clear table format.
• Ensure real-time data updates and accuracy.

[!NOTE]
This new development effort should already include unit tests for reliability and efficiency in future improvements.

3. Total Estimated Development Time:

32 - 48 hours

[rmaungwmf]

Hi @ahmed-arb ! I just want to confirm (as this is described as a dashboard view) that this will also be available as a table that can be exported from the platform. Thanks!

[ahmed-arb]

No, but with some extra effort, we can add that in.

[rmaungwmf]

Per a conversation on Slack, we are clarifying the scope of this improvement: Instead of a dashboard, we are adding a new report to the reports dashboard exportable as a csv, with a row for every user-course instance in Wikilearn with the following columns:

• user
• course title
• enrollment date
• completion date

The intended use is that this table will be ingested by an analyst to track learning outcomes and impact on our (WMF's) projects.