Announcements

1. Data Warehouse Advisory Group Confluence Space

   • New Confluence space created for DW Advisory, where meeting notes will be posted and shared with the group

   • DW Advisory Meeting Notes, FY 20/21

General Discussion and Feedback on Data Warehouse Report Server

CCC Data 1.4.1 release access to the Data Warehouse Report Server

• 94 Colleges have been setup with access to the

• Feedback has been really good

• Confluence space to support Data Warehouse project including the report server, CCC Data Warehouse Public Documentation, will be aggregate of information from support team and community

• New support support site from Get Satisfaction to Vanilla Forums, link and information will be shared with the group soon.

• Launched with limitation set with row limit of 20k and have updated to 100k

• Suggestion: Frequently Asked questions page, and Webinar

• Suggestion: Leverage someone from the community to present and share tips

Update on pilot of DW Direct Connection (CCC Data 2.0)

• Intention for the report server to be one of two methods of accessing the data in the data warehouse, the other being provide a direct connection to that data

• Our next release the 2.0 release it is focused on providing that direct connection

• Deployed to pilot server, in the process over the next week to begin with pilot participants (6-7 colleges)

• Will a role defined access be needed in the future?

Review results of prospective data sources prioritization survey

CCC Data: Current & Potential Data Sources

Prioritization Survey

• The survey can be found at: https://www.surveymonkey.com/r/R2RKDBG

• Details on the ranking criteria and data sources can be found linked from the header of the survey, or at this link: https://bit.ly/3aX0hhp 

• This becomes part of our ongoing conversation with the chancellor's office as we Continue to build out our roadmap for this current fiscal year and this becomes part of that conversation in terms of prioritization of activities with this particular set of data sets has one of those discussion points and we will certainly update this group.

Prioritization of MIS tables to the Data Warehouse (pending data governance put in place)

• We were looking to better understand which are the tables that are of the highest priority so we can work with the Chancellor's Office on trying to get access to share those tables

• Survey will be shared out to the group listserv to collect more responses 12 Oct 2020

Change management discussion

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

• Tie this into broader topics that fall under CO

• Mark will reach out to Alex and Manos to possibly adds guest to next months meeting to add to the conversation

Discussion whether it would be possible for districts to to share to agree to have data from the data warehouse shared with other colleges or other districts

• Has come up a few times

• Not supported with the current design

• Would this be across aggregates or at local level?

Steve Klein:

Is there a cycle in which you access LGBTQ data that falls in a regular cycle or is that a when needed kind of request for that data from their server.

It doesn’t necessarily fit into any cycle.

12 Oct 2020

Advisory Group

Manos Stefanakos:

And Mark I assume the security stuff the limits of what data is available to each of the pilot colleges their organization and stuff has already been taken care of.

For 2.0 release the bulk of the work for that release was getting all that segmentation in place so that so that all of the data in the data warehouse is segmented by MIS as code so that when a college is provided direct access to the data warehouse that access is made over a site to site VPN.

12 Oct 2020

Mark Cohen

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

Vision for success and student equity measurements metrics to be included

Manos Stefanakos will look into it and report back to the group on whether it's something that will be published. Again, or or what the formula is in terms of how its produced

Manos Stefanakos

Jake Kevari:

Discussion with possibility of sharing data from the data warehouse shared with other colleges or other districts

Would this be across aggregates or at local level?

Mark Cohen

• Mark will reach out to Alex and Manos to possibly adds guest to next months meeting to add to the Change management discussion

• Mark will add Vision for success update to November agenda

Mark Cohen

• In addition to documentation, look into creating a Webinar for the group

• 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