Druid Data Model - Course Batch

Introduction:

This wiki explains ingestion specification for the Course Batch and its related objects to compute required metrics and compose dashboards using Druid.

Design:

Below are the objects related to course batch

Course
Course Batch
Enrollment
User
Location
Content
organization

To denormalize Course, User, Location and Content details we use the properties part of the Telemetry ingestion spec.

We use below prefix for each object for easy understanding.

Object	Prefix
Course	course_
Course Batch	batch_
Enrollment	batch_enrollment_
User	user_
Location	location_
Content	content_

Data Model:

Dimension in Druid	The field in Course Batch	Description	Data Type
batch_name	name	Name of the Course Batch	String
batch_id	batchId	Identifier of the Course Batch	String
batch_createdBy	createdBy	Course Batch - created by	String
batch_createdDate	createdDate	Course Batch - created date	Date
batch_createdFor	createdFor	Course Batch - created for (organizations)	String
batch_enrollmentType	enrollmentType	Course Batch Type - open or invite-only	String
batch_startDate	startDate	Course Batch - start date	Date
batch_endDate	endDate	Course Batch - end date	Date
batch_enrollmentEndDate	enrollmentEndDate	Course Batch - enrollment end date	Date
batch_status	status	Course Batch - status	Long
batch_updatedDate	updatedDate	Course Batch - updated date	Date
batch_enrollment_active	active	Enrollment active or inactive	Boolean
batch_enrollment_completedOn	completedOn	Enrollment completed on	Date
batch_enrollment_completionPercentage	completionPercentage	completion percentage	Long
batch_enrollment_enrolledDate	enrolledDate	Enrollment date	Date
batch_enrollment_progress	progress	Count of complete contents in the course	Integer
batch_enrollment_updatedBy	updatedBy	Last updated by	String
batch_enrollment_updatedDate	updatedDate	Last updated date	Date
batch_enrollment_certificates	certificates	Certificates assigned to the enrollment. Considering only `name`, `lastIssuedOn`, `lastReIssuedOn`	Array[Object]
content_type	contentType	type of the content	String
content_assessment_attemptid	attempt_id	AttemptId for the content assessment	Sttring
content_assessment_attemptscore	total_score	total score for the assessment attempt	Integer
content_assessment_maxscore	total_max_score	total score for the assessment attempt	Integer
user_id	userId	Enrolled user id	String
user_name	username	Enrolled username	String
user_email	email	Enrolled user email	String
user_phone	phone	Enrolled user phone	String
user_organization	orgname(organisation table)	Enrolled user organisation name	String
user_school
user_enrollment_date	enrolleddate(user_courses table)	Enrolled user enrolled Date	Date
user_board	framework.board	Enrolled user : board	String
user_grade	framework.grade	Enrolled user : grade	Array[String]
user_medium	framework.medium	Enrolled user : medium	Array[String]
user_subject	framework.subject	Enrolled user : subject	Array[String]
user_signup_date	createdOn	Enrolled user : createdOn Date	Date
user_course_progress	progress(user_courses table)	Enrolled user : course progress	int
user_signin_type	user_signin_type	Enrolled user : Mode of Signin	String
user_login_mode		Enrolled user : Mode of device(app/portal/desktop)	String
user_org_externalId	externalid	Enrolled user : organisation external id	String
location_district	name(location table)	district Location of the enrolled user	String
location_block	name(location table)	block Location of the enrolled user	String
course_id	courseid	unique id of the course	String
course_name	courseadditionalinfo.courseName	name of the course	String
course_author	coursecreator	author of the course	String