CCC Data Services Program Public Documentation

CCC Data Program Overview

A part of the Data Management Grant from the California Community Colleges Chancellor's Office, CCC Data provides the necessary infrastructure to the California Community College System to aggregate data across disparate systems to an enterprise data warehouse. 

Access to these data is provided to institutional researchers, college and district administrators, and other decision makers at the 116 California Community Colleges, district offices, and the Chancellor’s Office, where these critical data may be used to support instructional and institutional decision-making aligned with the Chancellor's Vision for Success.

Search All CCC Data Services Public Documentation

Search

Data Warehouse Resources

(Skip to main content)

Data Available in the CCC Data Warehouse

 

CCC Data Overview

Info Graphic showing Data Pipelines, CCC Data Warehouse, CCC Data Lake, and the Report Server, with bullet points on what each component provides. Bullet points are provided below.

Data Pipelines:

  • Several proven methods available to integrate data with CCC data Extract, Transform, and Loads data.

  • Runs nightly (or more frequently)

CCC Data Warehouse

  • Collects data, preserving changes

  • Used to power Data Warehouse, Data-Marts, and analytics

  • built on Amazon AWS S3

CCC Data Warehouse

  • Structured source of master data segmented by MIS code

  • Connects data to generate reports and analytics for end users

  • Built on Amazon AWS Redshift

Report Server (Optional)

  • Researchers can connect their own tools or use the Report Server

  • Business intelligence tool

  • Provides access to data in the Data Warehouse

  • Built on Tibco Jaspersoft

 

Architecture Overview

The CCC Data project is an AWS-centric, cloud-based solution that stores and structures data sets from the CCC data sources. The data is quickly discovered, retrieved, and used for analytics, reporting, or data mining.

Flowchart showing the database inputs to the Data Warehouse, and outputting to the CCC Report Server and the Direct Connect Data Warehouse.

Support

Need help? 

  • Contact CCCTC Support to submit a support request

  • Or CCC Data support site for questions and answers regarding the CCC Data Warehouse, DW Report Server, and DW direct connection.

News & Information

CCC Data awarded the 2020 Best of California Award for “Best Application Serving an Agency’s Business Needs.”