Alex Jackl, Bridget Herin, Crystal Hernandez, Denise Inciong, Dulce Delgadillo, Dustin Tamashiro, Elaine Kuo, Jake Kevari, Jenni Allen, John Sills, Manos Stefanakos, Mark Cohen, Steve Klein, Virginia Moran
Agenda
Item
Notes
1
Update on CCC Data 2.0 release
CCC Data 2.0 Pilot:
Deployed to Pilot
Several colleges involved and able to complete Pilot testing
Very successful pilot
results were good the feedback was excellent
Testing helped support implementation process
Pilot Activities:
Testing did include colleges installing a custom vpn working in coordination with with our team
vpn is used to secure the data so that the data warehouse is only accessed when using a direct connection, over site to site vpn
Pilot colleges connected either using Tableau or Power BI
Pilot testing also included colleges running direct sequel direct queries using MySQL Workbench
We were not able to test colleges connect tables from the data warehouse to a local data warehouse as external tables, pilot colleges IT did not have bandwidth to support
As we continue to roll out direct connection, we look forward to engaging colleges to test and document this process
CCC Data 2.0 Production:
Deployed to Production
Adoption of DW direct connect
15 colleges working with our Enabling Services group and are in various stages of going live on direct connection to the Data Warehouse
96 colleges using the report server
Difference between DW Report Server and DW Direct Connect
Question/Answers:
Dulce Delgadillo (She/Her): Once connected can CCCTC provide guidance on how to query
Where can find documentation to support local researchers use of DW direct connect
Mark will continue to work with team and colleges to develop the direct access user guide to link up more into Data Dictionaries to provide compete roadmap
Dustin Tamashiro: Helpful to see upfront on documentation what type of sequel language is compatible
2
Overview of the upcoming CCC Data 2.1 release
CCC Data 2.1
New data sources in DW segmented by MIS code & made available to CCC’s through DW Report Server (DWRS) and direct DW access:
Canvas (as opted-in to by individual colleges)
MyPath
COCI
New data sources in DL & made available to CCCCO
Nova
Launchboard
Adoption of 2.1
When we released we will be providing instructions on how to initiate implementation process and begin coordination with our Enabling services group
Question/Answers:
Dulce Delgadillo (She/Her): Is the Canvas data by institution or district?
Denice Inciong: We have it by colleges but our district has access for connections to our SIS. But, the owners for us are the colleges.
Mark Cohen: What data comes across as based on the API key
John Sills: Any district colleges that have their own instance they're all set up at the district level and those API keys are generated the district level so getting it set up, I think, initially would probably require a district type decision.
3
Discussion on a proposed survey for feedback on how colleges are accessing and using CCC Data Warehouse resources.
We currently have 96 colleges that are engaging in some level with with the data warehouse survey will help to better understand:
How they are connecting to the DW?
How they would like to connect to DW?
What data sources they're using?
What they're doing with the data?
What applications are they connecting when using direct connection?
Gathering feedback from advisory group to determine best approach on how to engage research community
4
Questions and Feedback
Dulce Delgadillo (She/Her): Non credit regional group may be a forum where we can include in the agenda once survey is ready to be shared
Announcement
Have submitted the data access policy, policy for dictating what access is appropriate to what data, will be reviewed again by general counsel, will be shared with group once reviewed and approved by legal
5
Issues/Questions Resolved
Issue/Question
Resolution/Answer
1
Date Issue/Question Raised:
Dulce Delgadillo (She/Her)
Once connected can CCCTC provide guidance on how to query?
Date Resolved/Answered:
Owner: Mark Cohen
Where can find documentation to support local researchers use of DW direct connect
Denice Inciong: We have it by colleges but our district has access for connections to our SIS. But, the owners for us are the colleges.
Mark Cohen: What data comes across as based on the API key
John Sills: Any district colleges that have their own instance they're all set up at the district level and those API keys are generated the district level so getting it set up, I think, initially would probably require a district type decision. Going to need to be a governance issue, all the colleges are probably going to have to agree before it gets uploaded
3
Issues/Questions Needing Resolution
Issue/Question
Resolution/Answer
1
Date Issue/Question Raised:
What do analytics indicate about CO MIS usage with regard to the data mart?
Alex Jackl will work with 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 with Mark so that he can share with Advisory group.
Date Resolved/Answered:
Owner: Alex Jackl
2
Date Issue/Question Raised:
Should 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 what the formula is in terms of how it is produced
Date Resolved/Answered:
Owner: Manos Stefanakos
3
Date Issue/Question Raised:
Dustin Tamashiro: What type of sequel language is compatible when accessing DW
Date Resolved/Answered:
Owner: Mark Cohen
Action Items/Next Steps
Item
Notes
Date Action Item Raised:
Date Action Item Resolved:
Mark Cohen In addition to documentation, look into creating a Webinar for the group
Date Action Item Raised:
Date Action Item Resolved:
Mark Cohen will continue to work with team and colleges to develop the direct access user guide to link up more into Data Dictionaries to provide compete roadmap, and followup w Advisory on this effort
Date Action Item Raised:
Date Action Item Resolved:
Mark Cohen Send message to this DW advisory body to inform members of the discussion areas and the crowdsourcing resources available