Dashbaords

Please consult each dashboard's documentation to know which seeds, adapters are required by each one (if any) and to get details about the optional configuration settings.

What is a dashboard ?

Within the context of the store, a dashboard is a .pbit file. Every dashboards is stored in the core.dashboards_store/reporting folder (lookup the dashboard you wan't to deploy by it's name).

To deploy a dashboard, you will need to :

  1. Enabling it, as well as all it's dependencies (marts, interfaces, etc.). Please refer to the enabling a dashboard section for more information.
  2. Optionaly : configure it, by overriding some of the models it's based upon or by adding custom seeds.
  3. Deploy the PowerBi file to your PowerBi service, and update the pbit connection so it points to your <store_dev|store_prod> database.

Which dashboards are available ?

Education Services

DashboardDescriptionOwner
res_epreuvesTrack the percentage of success for each one of the mandatory and optional evaluations of the schoold boardHugo Juhel (ext), Mohamed Sadqi (CSSVDC)
suivi_resultatsTrack the results of the students with a failed courseMohamed Sadqi (CSSVDC), Hugo Juhel (ext)
effectif_cssTrack the population count in each school in the CSS(CSSVT) Frédéryk Busque , Mohamed Sadqi (CSSVDC)
chronic_absenteeismDisplay general metrics abunt the student's absenteeism assessed through the number of days with at least one absence for every students.(Sciance) Hugo Juhel
res_scolairesTrack the percentage of success and the average result for each one of selected academic subjects and skills of the schoold board(CSSVT) Frédéryk Busque, Mohamed Sadqi (CSSVDC)
predictive modelling : aggreagtedTracks the number of students with a high risk of dropping out of school, of failing a grade or of not graduating on time and provides a way to compare schools.(Sciance) Hugo Juhel
absenteeismTracks the long term absences among students and compute various absenteeism rate at a school and CSS level.(Sciance) Hugo Juhel
diplomeMonitors secondary 5 students on the possibility of obtaining a secondary school diploma under the J5 system.(CSSVT) Frédéryk Busque, Mohamed Sadqi (CSSVDC)

Human Ressources

DashboardDescriptionOwner
emp_congeMonitor employees absences and leavesGabriel Thiffault (CSSVT), Frédéryk Busque (CSSVT)
emp_actifList all employees currently enroled in the CSS(CSSSDGS) Nicolas Pham
retirementTracks the number of retired employees by job categories and workplace. Forecast, for up to five years, the number of retiring employees(Sciance) Hugo Juhel

School Organization

DashboardDescriptionOwner
anomaliesTracks GPI inconsistenciesAlimurat Dinchdonmez (CSSPI)

direction_generale

DashboardDescriptionOwner
pevrSuit les indicateurs du ministère PEVR selon le plan stratégique de 2023-2027Frédéryk Busque (CSSVT)