Compass for Success

ETL Design Documentation

Posted: December 8th, 2015

EQAO Files

Posted: December 8th, 2015

Graduation Cohort Analysis Package v1.0

Posted: April 1st, 2015

“This package contains components to support the analysis on the Graduation Cohort. It allows user to analyze the cohort graduation data along with the cohort students enrollment history, IEP/FNMI/ELL/Exceptionality, Grade 6, 9 EQAO and OSSLT, RC, and Credit accumulation data.

It contains:
— the business requirement document.

— ETL/Database package (including the implementation instructions). The query included in the ETL folder is developed against the Trillium SIS. If you are using PowerSchool, you can use your existing query “Student_Award-304001…..sql” as the template to customize query 70401 for your environment. If you need help on query mapping, please contact us.

— FM model component (including the document on how to deploy the FM package to your Cognos BI environment).

— Reports: a sample report is included to demonstrate the analysis possible with the  Graduation Cohort


Data Warehouse FM Updates

Posted: January 29th, 2015

This version includes the following updates:

  1. Add Impact Index datamart into Student Performance Package.
  2. Add School_Name column in ERC snapshot table (ETL / FM change).

ETL Update Packages

Posted: January 29th, 2015

Cognos/IBM Upgrade