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:  Karl Pond - School Research, Data and Federal Reporting Manager

System Administrator:  Terra Dominguez - Business Analyst

Report Writer:  Robin Lucarelli - Business Systems Analyst

EDEN Coordinator:  K.C. Elander - Education and Policy Consultant

More about the CEDARS Data Warehouse (CDW)

What data is in the CDW?

What data is in the CDW?

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
What systems feed the CDW?

What systems feed the CDW?

  • EDDIE (Educational Directory and Demographical Information Exchange)
  • PowerSchool
  • ECATS (Exceptional Children)
  • Accountability
  • UID Staff
  • Licensure
How are data from the CDW used?

How are data from the CDW used?

  • Federal, State and local level reporting
  • Research requests
  • Trending and analysis
  • Connects to NC School Works
Who could benefit from having access to the CDW?

Who could benefit from having access to the CDW?

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
How can I get access to the CDW?

How can I get access to the CDW?

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.