Institutional Research and Reporting

NOTE: To request data from secondary or external sources such as surveys, OCAS, KPI, or labour market data, see Institutional Research Data Request.

Request a tailored data extract from internal College systems for a specific use-case for which there is no existing method to extract data. Extracts are created, developed manually, and may include charts, graphs, maps, and pivot tables, and typically provided as an MS Excel document.

Available to: Employees.
Turnaround time: Variable. Determined on a case-by-case basis.
Lead time: Request 2 weeks in advance.

Include the following details in your request.

1. Date Required:
2. Data Request Purpose: Describe the purpose for the data.
3. Business Impact: Describe the goals and impact the data will have on the business.
4. Data Request Type: Choose one
   • a) New - Never requested before
   • b) Update - exists and requires data refresh
   • c) Update w/Modifications - exists and requires changes
   • d) Consultation - I don't know what I need.
5. Existing/Sample: Provide details on the last data extract such as who provided the data and include the sample.
6. Data Fields Required: Describe or list the desired fields to include in the extract.

Request through IT Self-Service Portal

Request to grant or revoke employee access to Cognos, report distribution lists or modify existing access permissions.

Available to: Employees.
Turnaround time: 2 business days.
Lead time: Request 2 business days in advance.

Include the following details in your request.

1. Employee's MohawkID: MohawkID for the employee requiring access/ removal.
2. Employee's Full name: Full name for the employee requiring access/ removal.
3. Employee's Department: Department name for the employee requiring access/ removal.
4. Employee's Supervisor: Direct supervisor approving access/ removal.
5. Access Permissions Type: Approve/Revoke
6. Access Permissions Purpose: Describe the purpose for the permissions request.
7. Sponsored Systems Access: Provide details on an existing employee account that access permissions can be copied.
8. Report(s)/Distribution List(s): Describe or list the desired reports or distribution lists to include in the request.

Request through IT Self-Service Portal

NOTE: To request changes to permissions for an existing report or dashboard, see Cognos Permissions & Distribution Lists Request.

Request for development of a Cognos report or dashboard that can be run on-demand based on Cognos permissions and extracted into MS Excel, Adobe PDF or burst distribution to recipients.

Available to: Employees.
Turnaround time: Variable. Determined on a case-by-case basis.
Lead time: Request 2 weeks in advance.

Include the following details in your request.

1. Date Required:
2. Report Request Purpose: Describe the purpose for the report or dashboard.
3. Business Impact: Describe the goals and impact the report will have on the business.
4. Report Request Type: Choose one;
   • a) New - Never requested before
   • b) Update w/Modifications - exists and requires changes
   • c) Consultation - I don't know what I need.
5. Existing/ Sample: Provide details on the existing report such as who provided or developed the report and include the sample.
6. Report Fields Required: Describe or list the desired fields to include in the report output.
7. Report Prompts Required: Describe or list the desired prompts to include to filter the report.

Request through IT Self-Service Portal

Note: This request is subject to review and approval.

Request development of an Insights report or dashboard that can be run on-demand based on Insights permissions and extracted into MS Excel, PDF. Report requests are subject to review and approval.

Available to: Employees.
Turnaround time: Variable. Determined on a case-by-case basis.
Lead time: Request 2 weeks in advance.

Include the following details in your request:

1. Report Name: propose a concise and descriptive report name.
2. Date Required: (YYYY-MM-DD)
3. Report Description: Briefly describe the report and its purpose.
4. Importance/Priority: identify the importance of this request.
   High - Report Satisfies a legal requirement, lack of this report constitutes a safety concern, Cannot deliver critical business functions without this report.
   Medium - Important but not vital, operations viable without the report, work around available.
   Low - Wanted or desirable but less important. Workaround is available for the report. Less impact if left out.
5. Report Specification: Complete and attach the Report Specification Template, ensuring all required fields are populated. Requests for new reports that do not include a completed report specification template will be declined.
6. Attachments: attach any additional supporting information as necessary. Do not attach Personally Identifiable Information.
7. Comments: include any additional comments or notes as necessary

Fill out New Insight Report Request Form

Note: This request is subject to review and approval.

Request an enhancement or identify an issue/bug with an existing Insights report or dashboard.

Available to: Employees.
Turnaround time: Variable. Determined on a case-by-case basis.
Lead time: Request 2 weeks in advance.

Include the following details in your request:

1. Report Name and ID: Identify the report name and report ID.
2. Date Required: (YYYY-MM-DD)
3. Change Type: Select all that apply.
   Issue - Relates to an outstanding bug, error, or issue with a report.
   Enhancement - Modify the report, not necessarily related to a bug or issue.
   Other - Not related to an existing issue or report enhancement. Please specify the nature of this change.
4. Importance/Priority: identify the importance of this request.
   High - Report Satisfies a legal requirement, lack of this report constitutes a safety concern, Cannot deliver critical business functions without this report.
   Medium - Important but not vital, operations viable without the report, work around available.
   Low - Wanted or desirable but less important. Workaround is available for the report. Less impact if left out.
5. Change Description: Briefly describe the nature of the change.
6. Attachments: attach any additional supporting information as necessary. Do not attach Personally Identifiable Information.
7. Comments: include any additional comments or notes as necessary

Fill out Existing Insights Report Change Request Form

Note: This request is subject to review and approval.

Request or remove access permissions to an Insights report.

Available to: Employees.
Turnaround time: Variable. Determined on a case-by-case basis.
Lead time: Request 2 business days in advance.

Include the following details in your request:

1. Employee's Mohawk ID: Mohawk ID for the employee requiring access/ removal.
2. Employee's Full name: Full name for the employee requiring access/ removal.
3. Employee's Department: Department name for the employee requiring access/ removal.
4. Employee's Supervisor: Direct supervisor approving access/ removal.
5. Access Permissions Purpose: Describe the purpose for the permissions request.
6. Role(s): identify the insights roles to be added/removed
7. Comments: include any additional comments or notes as necessary

Fill out Insights Permission Request Form

NOTE: To request data from internal sources such as ODS, Banner, FAST, or Access, see Data Request at the top of this page.

Request data from non-local sources, such as OCAS, KPIs, survey data, market research, and environmental scans.

Available to: Employees
Turnaround time: Variable. Determined on a case-by-case basis.
Lead time: Request 2 weeks in advance.

institutional.research [at] mohawkcollege.ca (subject: Institutional%20Research%20Data%20Request) (Request Institutional Research Data Consultation)

Consultation, development, and distribution of surveys to the College community. Surveys may be subject to Research Ethics Board policies.

Available to: Employees
Turnaround time: Variable. Determined on a case-by-case basis.
Lead time: Request 2 weeks in advance.

institutional.research [at] mohawkcollege.ca (subject: Survey%20Consultation%20Request) (Request Survey Consultation)