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) 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? EDDIE (Educational Directory and Demographical Information Exchange) PowerSchool ECATS (Exceptional Children) Accountability UID Staff Licensure 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? 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? Registering for the CDW is a three-step process. Ensure you have an NCID. (K-12 Public and Charter School employees are registered by the Charter/LEA NCID Administrator) Apply for an account using the CEDARS Data Warehouse Registration System 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.
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) 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? EDDIE (Educational Directory and Demographical Information Exchange) PowerSchool ECATS (Exceptional Children) Accountability UID Staff Licensure 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? 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? Registering for the CDW is a three-step process. Ensure you have an NCID. (K-12 Public and Charter School employees are registered by the Charter/LEA NCID Administrator) Apply for an account using the CEDARS Data Warehouse Registration System 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.
