We identified the data sources for analysis, and the following approaches were taken:
- Data were extracted and studied from JSON strings on edX using string functions in SQL to identify available data elements, check completeness, and ensure accuracy.
- Exploratory data analysis was performed to identify the right test group for the study on user groups.
- After the analysis, two user groups were identified to conduct the study: users who signed up on edX prior to the window of enrolment into the client’s courses and users who signed up on edX and enrolled in the client’s courses.
- Exhaustive analysis was conducted on both user groups; TurnB designed a user engagement index to measure the user group’s engagement with the courses.
- Multiple hypotheses were tested for all user segments.
- The analysed outputs were evaluated, and findings were summarized.
- An additional deep-dive analysis was performed to derive insights at a granular level wherever required.