Educational service

Student headcount

Tracks a defined population within a school service centre. The dashboard shows the total number of students in each school.

Deployment

tag:effectif_cssnew in v0.7.0

Databases

The gpi database must be linked to the project. Please refer to the linking a database section for more information about how to link a database.

Marts

The following marts must be enabled for the dashboard to work. Please refer to the enabling a mart section for more information about how to enable a mart.

  • educ_serv

dbt project specification

Update your cssXX.dashboards_store/dbt_project.yml file with the following snippet

# cssXX.dashboards_store/dbt_project.yml
models:
  core_dashboards_store:
    marts:
      educ_serv:
        +enabled: True
    dashboards:
      effectif_css:
        +enabled: true
    interfaces:
      gpi:
        +enabled: true

Splitting the regular preschool students from the Passe-Partout students

You can configure the dashboard to split the regular preschool students from the Passe-Partout students. This is done by populating an sql file identifying the Passe-Partout students. By default, no student is identified as a Passe-Partout student. To identify these students, you need to override the stg_check_passepartout model in your project and provide your own custom logic to identify them. The documentation for the stg_check_passepartout model can be found in the core/models/dashboards/educ_serv/effectif_css/staging/stg_check_passepartout.sql file and in the core/models/dashboards/educ_serv/effectif_css/staging/schema.yml file.

Starting from v0.1.8, the stg_check_passepartout model is prepopulated as part of spinning up a fresh project from the cookiecutter template.

Copyright © 2026