Data Warehouse Advisory Group: 07-13-20


Meeting Details

Meeting Date:

Jul 13, 2020

Purpose:

Data Warehouse Advisory Group

Zoom Recording:

https://zoom.us/rec/share/_tJFHpGu30dIAbPKuWb1Q7c7O5nMX6a8gXdL__oFyxvuotKKFV3TpqYhIqp5B64H 

Password: 2y!$284g

Participants:

Mark Cohen, Steve Klein, Crystal Hernandez, Craig Hayward, Alex Jackl, Denise Inciong, Dulce Delgadillo, Dustin Tamashiro, Elaine Kuo, Jake Kevari, Jenni Allen, Valerie Lundy-Wagner, Virginia Moran, Z Reisz

Agenda

Item

Notes

Item

Notes

1

Update of where the CCC Tech Center is with Data Center project

2

Review of the prioritized of work for CCC Data for the current fiscal year

CCC Data: Data Source Prioritization - Draft

  • For Employment Development Department Unemployment Insurance Wage File, EDD is no longer accepting individual requests from colleges, making data set higher priority

  • Add column noting the level of detail for that data set

  • If unitary records not available, some kind of vetted standard or threshold of acceptable performance would be more helpful than just some high-level aggregation

  • Data on demand at District level

  • Student Tracker: lower than student level, student enrollment and degree level

  • Suggestion to do followup on notes to further capture notes during advisory meeting.

  • It will be good to use that to clarify what's in the DWAG and what's for another venue.

Issues/Questions Resolved

Issue/Question

Resolution/Answer

Date Resolved/Answered

Owner

Issue/Question

Resolution/Answer

Date Resolved/Answered

Owner

1

Dulce Delgadillo:

Does the CCCApply application data include CCCApply Noncredit application data as well?

Yes, it does.

 

Jul 13, 2020

 

2

Do we know which data will be included for the Canvas Data?

We do, Canvas has an API that we are leveraging. We will be leveraging API key provided by administrator from local college to pull data set out and into the data warehouse. It is a very robust data set, and we do have data dictionary for the Canvas data to have an idea of what is there.

Canvas_Data_Domains 20170801.xls

Jul 13, 2020

 

3

In terms of Canvas Data, understanding is all that is needing is Canvas API key, is additional effort needed?

All that is needed is Canvas API key, additional effort on the college side is not needed. How to obtain key is pretty straightforward.

Jul 13, 2020

 

4

Steve Klein:

Is the Employment Development Department Unemployment Insurance Wage File data, what is currently being collected as part of the MIS data that CO does collect? The EDD data?

Dulce Delgado:

  • It is being matched by social security numbers and is part of Adult Ed launch board and Strong Workforce and possibly student success metrics.

Craig Howard:

  • The CO gets a direct match with EDD, but it is not part of MIS.

  • The EDD data shows up in Salary Surfer.

  • But colleges only see the aggregated data.

  • It's already a CO tool.

  • https://salarysurfer.cccco.edu/SalarySurfer.aspx

  • It contains EDD data but the issue is that the MOU does not allow the CCCCO to distribute that EDD data to colleges at a level that is more granular (i.e., appropriate to include in the DW).

Jul 13, 2020

 

5

Mark Cohen:

Should we be tracking Salary Surfer as a potential data set for CCC Data?

At this time there is no need for it, Advisory feedback.

Jul 13, 2020

 

6

Dulce Delgadillo:

Can you please send out that Data dictionary please? That would be great!

Action Item noted. Data Dictionary will be shared via CCC Data Services Program Public Documentation.

Aug 11, 2020

Mark Cohen

7

Dulce Delgadillo:

Are we saying that all of this data (data currently listed under Potential Data Sources) will be at a student level?

That is the goal.

Valerie Lundy-Wagner:

That is the goal, but part of the data sharing and governance that will need to be worked out.

Jul 13, 2020

 

8

Valerie Lundy-Wagner:

Mark, will you summarize the questions, concerns, and share them with the CO?

We need some documentation of what's being raised.

Google Docs perhaps to list those questions

Action Item noted. DW Advisory Meeting notes will be documented and shared via CCC Data Services Program Public Documentation, all meeting minutes can be found at DW Advisory Meeting Notes, FY 20/21.

Aug 11, 2020

Mark Cohen, Crystal Hernandez

9

The unitary data would be at a district level? Because data is submitted at a district level.

Yes, Student Center Funding formula is allocated at a district level.

For Multi-college district it would be meaningful to have way to drill down

Need college codes, at student-enrollment level would need college code

Jul 13, 2020

 

 

Action Items/Next Steps

Item

Notes

Owner

Item

Notes

Owner

Send out Data Dictionary to Advisory Group

Action Item noted. DW Advisory Meeting notes will be documented and shared via CCC Data Services Program Public Documentation, all meeting minutes can be found at DW Advisory Meeting Notes, FY 20/21.

Mark Cohen

Create Spreadsheet to monitor questions brought up during Advisory meetings

This is documented above.

Crystal Hernandez