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-k16 | K-16 grant reporting automation — queries Oracle Banner (REPT) and builds a headless Excel pivot dashboard from scratch (no template, no Excel app) |  |
| nocccd-nsc | National Student Clearinghouse (NSC) StudentTracker submission builder and return-file loader into the DWH warehouse schema | |
| 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"]
Banner --> K16["K-16 Excel Pivot Dashboard"]
Banner --> NSC["NSC Submission Builder"]
NSC --> NSCST["NSC StudentTracker"]
NSCST --> DWH
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
style K16 fill:#217346,color:#fff
style NSC fill:#1F6FEB,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
- Reporting pipelines: Python + Oracle — K-16 grant Excel dashboards (excelize, headless pivots) and NSC StudentTracker submission/return processing
- Scheduling: FlexIt Docker — daily production dbt refresh orchestration
- Source System: Ellucian Banner (Student Information System)