Data infrastructure and analytics for North Orange County Community College District — managed by NOCCCD District and serving Cypress College, Fullerton College, and North Orange Continuing Education (NOCE).
| Repo | Description | Stack |
|---|---|---|
| nocccd-edw | Enterprise Data Warehouse built with dbt on Oracle — staging, intermediate, and mart layers (dims + facts) |    |
| nocccd-scff | Student Centered Funding Formula data loading, crosswalks, and analysis for district use |   |
| nocccd-sql | Ad-hoc SQL queries organized by campus (Cypress, Fullerton, NOCE, District) | |
| nocccd-streamlit | Ad-hoc reporting dashboards for district use (Oracle / Tableau Cloud) |   |
| nocccd-flexit-docker-deploy | Docker deployment for daily production dbt build refreshes and scheduling, wrapped in the FlexIt web deployment kit |    |
flowchart LR
Banner[(Banner SIS)] --> DWHDB[(Oracle DWHDB)]
Banner --> SQL["Ad-hoc SQL Queries"]
DWHDB --> SQL
subgraph EDW["Enterprise Data Warehouse"]
dbt["dbt - EDW_PROD schema"]
end
Banner --> dbt
dbt -.-> SQL
FlexIt["FlexIt Docker Scheduler"] --> dbt
DWHDB --> DWH["DWH schema mat. views/queries"]
DWH --> SCFF["SCFF Analysis"]
DWH --> Tableau["Tableau Cloud"]
Tableau --> Streamlit["Streamlit Dashboards"]
style Banner fill:#F80000,color:#fff
style DWHDB fill:#F80000,color:#fff
style dbt fill:#FF694B,color:#fff
style Tableau fill:#E97627,color:#fff
style Streamlit fill:#FF4B4B,color:#fff
style FlexIt fill:#2496ED,color:#fff
- Data Warehouse: dbt + Oracle — source staging, transformations, dimensional models (dims & facts)
- Dashboards: Streamlit with Oracle and Tableau Cloud connectors
- Analysis: Python, Pandas, SQL
- Scheduling: FlexIt Docker — daily production dbt refresh orchestration
- Source System: Ellucian Banner (Student Information System)