Data Warehouse Advisory Group: 09-14-20


Meeting Details

Meeting Date:

Sep 14, 2020

Purpose:

Data Warehouse Advisory Group

Zoom Recording:

https://zoom.us/rec/share/O40rz20OmJyPWgIYRfp-9pFZWUkvnZfYHCxmPB1YusLH3dpeuS5fXo-wwO1Gv3t2.koa_3Htuu96ob02b 

Passcode: Fxz*47W&

Participants:

Crystal Hernandez, Mark Cohen, Steve Klein, Alex Jackl, Bridget Herrin, Craig Hayward, Denise Inciong, Dulce Delgadillo, Dustin Tamashiro, Elaine Kuo, Jake Kevari, Manos Stefanakos, Virginia Moran, Z Reisz

Agenda

Item

Notes

Item

Notes

1

Announcements

  1. CCC Data 1.4.1 in Production

    • CCC Data 1.4.1 release access to the Data Warehouse Report Server

    • Release contains access to the full set of apply application, non-credit application, international application, fee waiver data, and multiple measures platform.

    • Securing access through two factor authentication

    • 80 colleges have been set up with account access as of this meeting

    • Outreach to set up the remaining colleges continues

  2. CCC Data 2.0 going into Pilot

    • The pilot to support direct (ODBC/JDBC) access with the Data Warehouse, includes

      • Working with the Tech Center to set up a point-to-point VPN connection,

      • Creation of log-in credentials to connect with the Data Warehouse, and

      • Connection to the Data Warehouse, with data segmented by MIS code to connect college (or district office) with their data.

  3. Data Warehouse Advisory Group Confluence Space

  4. Research being conducted looking into how we will be bringing MIS data into the Data Warehouse, once data governance is put into place and the Tech Center directed by the CO to share these data with colleges (and district offices).

 

2

Prioritization of proposed data sources

CCC Data: Current & Potential Data Sources

Prioritization Survey (Survey available through Sep 18, 2020)

Program Mapper data file exports

  • Should this be included in the CCC Data: Current & Potential Data Sources spreadsheet?

3

Discussion on how prioritized data sources are to be used

CO trying to make the data warehouse become a useful repository and a useful output

CCCTC will continue to work with Alex and the Chancellor's Office with Student Centered Funding Formula (SCFF) output as the top priority for new data sources from the research perspective based on the feedback.

4

Discuss Change Management

Deferring this topic at this time, will add to next months agenda

  • Tie this into broader topics that fall under CO

Issues/Questions Resolved

Issue/Question

Resolution/Answer

Date Resolved/Answered

Owner

Issue/Question

Resolution/Answer

Date Resolved/Answered

Owner

1

Should we also be tracking program mapper data file exports on the CCC Data: Current & Potential Data Sources spreadsheet?

  • Craig Hayward available to provide background,

  • There is a data file extract

  • Similar to Course Crosswalk, which is available through Datamart

  • Available for colleges who have implemented that program

 

Sep 14, 2020

 

2

Should we also be tracking Sevis on the CCC Data: Current & Potential Data Sources spreadsheet?

 

No requests at this time to include as a Data Source

Sep 14, 2020

 

3

Alex Jackl:

How far away is Data on Demand is meeting student information level business need?

 

 

Elaine Kuo / Dustin Tamashiro

  • Data On Demand is not provided at the student individual level.

  • Data on Demand also takes a day for processing.

  • Data Aggregated if multi-college district

 

 

 

Issues/Questions Needing Resolution

Issue/Question

Resolution/Answer

Date Resolved/Answered

Owner

Issue/Question

Resolution/Answer

Date Resolved/Answered

Owner

1

What do analytics indicate about CO MIS usage with regard to the data mart?

Alex Jackl will work w Todd Hoig to get answer to this question, will share response w Mark and Advisory group.

Per Alex, CO has been running some page web page analytics against people accessing data mart and so we might have some data from that.

Alex will share responses w Mark so that he can share with Advisory group.

 

Alex Jackl

 

 

Action Items/Next Steps

Item

Notes

Owner

Item

Notes

Owner

Deferring discussing Change Management , add to next months agenda. @Mark Cohen

 

@Mark Cohen

Following completion of Data Sources Prioritization Survey, @Mark Cohen will message and inform group with the results of top two data sources identified in the survey

 

@Mark Cohen