Data Warehouse Advisory Group: 05-10-21


Meeting Details

Meeting Date:

May 10, 2021

Purpose:

Data Warehouse Advisory Group

Zoom Recording:

Zoom recording link

Participants:

Brian Murphy, Bridget Herin, Craig Hayward, Crystal Hernandez, Denise Inciong, Dulce Delgadillo, Dustin Tamashiro, Jenni Allen, Jon Fanucchi, Manos Stefanakos, Mark Cohen, Valerie Lundy-Wagner, Z Reisz

Agenda

Item

Notes

Item

Notes

1

Adoption update



 

As of today, there are:

  • 100 colleges with access to the Data Warehouse Report Server,

  • 24 districts with Direct (ODBC/JDBC) access to the Data Warehouse (either live, or being configured)

  • 10 CVC/OEI colleges with access to the CVC/OEI enrollment report in the DW Report Server.

2

An update on the recent CCC Data 2.1.0 release and Canvas data

CCC Data 2.1.0 will be released to pilot on May 21st, with the pilot commencing on Friday, May 21st or Monday, May 24th.

5 colleges or districts have signed up to pilot test their Canvas data. Each college will be testing it using the direct connection to confirm that the data appears to complete and no issues found.

If no defects are identified we will go production several weeks later, with access in early June. At this point we can begin setting up canvas data for all colleges.

Instructure is preparing a Canvas Data product overhaul, Canvas 2, which is currently in beta with several colleges. Once released it will affect our data pipelines. It should result in a net positive as the data structure will make learning outcomes data more useful.

CCCTC Enabling Services will engage with colleges to obtain API keys and address potential concerns.

Some colleges reported on what the approval process looks like to obtain permission for the college to release the API key. 

Canvas data within the Data Warehouse will continue to be segmented by college in the CO view. Unlike other data sources in the Data Warehouse there is no cross system view.

3

CCC Data 2.2.0 Release Update

This release will be focused on:

  • Upgrading Jasper Report Version to a more recent version

  • Implementing SSO for user access

  • Additional Data sources, segmented by MIS code, to be made available upon CO approval:

    • Launchboard, with focus on SCFF data

    • MIS

  • Priority Projects as requested from the CO have impacted some release scope for 2.2.0

4

Discussion Continued: Feedback on the tools, or additional infrastructure, the CCC Data would benefit from in support of research/analysis of available datasets

We are currently working on a new draft of the survey. Survey will go out during the Summer following the 2.1.0 release to provide users with more time to use the Data Warehouse. 

At this time there is no additional feedback.

Issues/Questions Resolved

Issue/Question

Resolution/Answer

Issue/Question

Resolution/Answer

1

Date Issue/Question Raised:

 

 

Date Resolved/Answered:

Owner:

2

Date Issue/Question Raised:

 

 

Date Resolved/Answered:

Owner:

Issues/Questions Needing Resolution

Issue/Question

Resolution/Answer

Issue/Question

Resolution/Answer

Action Items/Next Steps

Item

Notes

Item

Notes