Examples of dimension & event files

This page gives an example of cQube Dimension & Event schema for better understanding

Dimension Schema

Ex : School Dimension

This is the data for all schools, clusters, blocks and districts in the state.

If CSV is being ingested, the file name should be -> school-dimension.data.csv

Event Schemas:

Ex : Teacher Attendance

This program entails indicators to monitor compliance and performance of teacher attendance. Following are the reports within this program:

  • Teacher Attendance Compliance: This report shows the compliance of attendance being marked by teachers.

  • Teacher Attendance Summary: This report shows the summary of teachers being present in the school (out of the ones marking their attendance).

Following schema will be required to enable the teacher attendance program:

If CSV is being ingested, the file name should be -> teachersattendance-event.data.csv

Note: The name for grammar file & event file should be same. e.g: teachersattendance-event.data.csv , teachersattendance-event.grammar.csv

NOTE : Each metric should be part of a separate event table.

E.g. In teacher attendance event file, we will have 3 tables: one for total_teachers, one for teachers_attendance_marked & one for teachers_marked_present

Last updated