Modeled for longitudinal storage and reporting of P-20W data, the Common Education Data Standards (CEDS) Data Warehouse implements star schema data warehouse normalization techniques for improved query performance.
This is for capturing needs not currently supported by the CEDS model. Please do not send or share actual data as examples in this issue or in attachments.
Author(s)
Ben Silberglitt and Tori Ryan
Authoring Organization(s)
Cedar Labs and Maine DOE
Use Case Title
Graduation Data Warehouse working group
Use Case Overview
Maine would like to leverage the CEDS DW to support public-facing reporting around graduation outcomes. Currently, Maine's reporting on this domain includes some data that the CEDS DW data schema is not equipped to handle. For example, graduation outcomes are broken out into 4yr, 5yr, and 6yr cohorts. Also, outcomes are tracked by graduation, continuing, dropout, and unknown. Maine and Cedar Labs consulted with AEM, and it sounds like a new fact table will be the best approach. We'd like to form a working group with any and all interested parties, to determine what schema this fact table should have, to serve as many needs as possible.
Pull Request Number(s) (If applicable)
N/A
Use Case Background
See use case overview above
Components AffectedCEDS Data Warehouse (complete DW Design Overview Table)CEDS Data Migrations (complete Data Migration Impact Analysis Table)
CEDS Element Gap Analysis
Provide link to CEDS Align Map or Connection.
INTEGRATED DATA STORE DESIGN OVERVIEW
Description of Proposed Changes
Provide a concise description of the proposed changes.
As-Is Diagram
Add as an attachment in this issue.
Proposed To-Be Diagram
Add as an attachment in this issue.
DATA WAREHOUSE DESIGN OVERVIEW (Includes Dim, Fact, and Report tables)
Description of Proposed Changes
Provide a concise description of the proposed changes.
As-Is Diagram
Add as an attachment in this issue.
Proposed To-Be Diagram
Add as an attachment in this issue.
DATA MIGRATION IMPACT ANALYSIS
Description of Proposed Changes
Provide a concise description of the proposed changes.
New Business Rule
Provide a concise and comprehensive description of the new business rule.
Existing Business Rule
Provide a concise and comprehensive description of the existing business rule.
Changed Business Rule
Provide a concise and comprehensive description of the changes to be made to the business rule.
This is for capturing needs not currently supported by the CEDS model. Please do not send or share actual data as examples in this issue or in attachments.
Author(s) Ben Silberglitt and Tori Ryan
Authoring Organization(s) Cedar Labs and Maine DOE
Email Address ben.silberglitt@cedarlabs.com victoria.ryan@maine.gov
Use Case Title Graduation Data Warehouse working group
Use Case Overview Maine would like to leverage the CEDS DW to support public-facing reporting around graduation outcomes. Currently, Maine's reporting on this domain includes some data that the CEDS DW data schema is not equipped to handle. For example, graduation outcomes are broken out into 4yr, 5yr, and 6yr cohorts. Also, outcomes are tracked by graduation, continuing, dropout, and unknown. Maine and Cedar Labs consulted with AEM, and it sounds like a new fact table will be the best approach. We'd like to form a working group with any and all interested parties, to determine what schema this fact table should have, to serve as many needs as possible.
Pull Request Number(s) (If applicable) N/A
Use Case Background See use case overview above
Components Affected CEDS Data Warehouse (complete DW Design Overview Table) CEDS Data Migrations (complete Data Migration Impact Analysis Table)
CEDS Element Gap Analysis Provide link to CEDS Align Map or Connection.
INTEGRATED DATA STORE DESIGN OVERVIEW
Description of Proposed Changes Provide a concise description of the proposed changes.
As-Is Diagram Add as an attachment in this issue.
Proposed To-Be Diagram Add as an attachment in this issue.
DATA WAREHOUSE DESIGN OVERVIEW (Includes Dim, Fact, and Report tables)
Description of Proposed Changes Provide a concise description of the proposed changes.
As-Is Diagram Add as an attachment in this issue.
Proposed To-Be Diagram Add as an attachment in this issue.
DATA MIGRATION IMPACT ANALYSIS
Description of Proposed Changes Provide a concise description of the proposed changes.
New Business Rule Provide a concise and comprehensive description of the new business rule.
Existing Business Rule Provide a concise and comprehensive description of the existing business rule.
Changed Business Rule Provide a concise and comprehensive description of the changes to be made to the business rule.