Data Warehouse and Reporting System

The CEDARS Data Warehouse and Reporting System is the centralized data repository containing statewide longitudinal data and the reporting and analysis tools for accessing the data repository.

The reporting system allows for the analysis of relationships between various educational factors and student performance over time. CEDARS supports the data sharing and reporting needs of DPI staff, school principals, and local administrators, state and federal policy and decision makers, researchers, and other consumers of educational data. It will also improve the state's ability to share and exchange data with external entities, including institutes of higher education, and other state agencies.

The user will interface with the reporting and analysis tools through Oracle Business Intelligence Enterprise Edition (OBIEE). The OBIEE tools include reports, dashboards, query options, and graphic displays of reports and data analysis.

Business Owner:  Diane Dulaney - Director, Office of Data, Reporting and Privacy

System Administrator:  Terra Dominguez - Business Analyst II

Report Writer:  Eric Marshall- Applications Systems Analyst II

EDEN Coordinator:  K.C. Elander - Section Chief, Enterprise Federal Reporting

More about the CEDARS Data Warehouse (CDW)

Tab/Accordion Items

LEA and School examples include:

  • Demographics
  • General Ledger
  • Charter or Magnet Status
  • AYP Indicator
  • Dropout Percentages

Student examples include:

  • Demographics
  • Enrollment
  • Attendance
  • Course and Grades
  • Assessments and Program Participation

Staff examples include:

  • Demographics
  • Hire Date
  • National Board Certification
  • Highest Degree Earned

  • EDDIE (Educational Directory and Demographical Information Exchange)
  • PowerSchool
  • ECATS (Exceptional Children)
  • Accountability
  • UID Staff
  • Licensure

  • Federal, State and local level reporting
  • Research requests
  • Trending and analysis
  • Connects to NC School Works

The CEDARS data warehouse is secure and available to state and local education employees.  Each employee must have an NCID.

Staff members who might benefit from access include but are not limited to:

  • Administrators
  • Tech Directors
  • Data Analysts
  • Report Writers
  • Coordinators (all programs, including PowerSchool)
  • Data Managers

Registering for the CDW is a three-step process.

  1.     Ensure you have an NCID. (K-12 Public and Charter School employees are registered by the Charter/LEA NCID Administrator)
  2.     Apply for an account using the CEDARS Data Warehouse Registration System
  3.     Log into the reporting interface (OBIEE) after account confirmation

Each LEA and charter must have at least one staff member who has been designated the Security Officer in the CEDARS Data Warehouse.  This staff member will be notified via email each time a user requests access and may then functionally approve or deny the registration request in the Registration system.  If there is no Security Officer at the local level the account will not be approved.

View the latest Security Officer list to determine if your LEA or charter has a staff member in place.