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)
Duane Brown
Authoring Organization(s)
CEDS Team & Data Warehouse Expansion Project Workgroup
Email Address
duane.brown@aemcorp.com
Use Case Title
Provide a concise description that defines the use case.
Enhancements from the Data Warehouse Expansion Project V9.1.0.0
Use Case Overview
This update includes the following changes to the Warehouse (Note: Additional documentation is provided in the release):
Add new dimension and fact tables designed by the data warehouse expansion project working group around the three uses cases (adult education, special education, NCES census poverty measure)
Provide metadata linking dimension table column names to their corresponding CEDS element technical name and Global ID in the extended properties of the column. Some Fact table columns are included as well where applicable.
Rename columns to better align with their corresponding CEDS technical name.
Provide additional scripts to populate junk dimensions, primarily around the 3 new use cases.
Provide documentation for each Fact Table indicating the grain and definition for the table.
Pull Request Number(s) (If applicable)
Use Case Background
The new fact and dimension tables are being created to support the work done through the CEDS Data Warehouse Expansion Project. The column name changes/updates are done to create better consistency and alignment with the actual CEDS element technical names.
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) Duane Brown Authoring Organization(s) CEDS Team & Data Warehouse Expansion Project Workgroup Email Address duane.brown@aemcorp.com Use Case Title Provide a concise description that defines the use case. Enhancements from the Data Warehouse Expansion Project V9.1.0.0 Use Case Overview This update includes the following changes to the Warehouse (Note: Additional documentation is provided in the release):
Pull Request Number(s) (If applicable)
Use Case Background The new fact and dimension tables are being created to support the work done through the CEDS Data Warehouse Expansion Project. The column name changes/updates are done to create better consistency and alignment with the actual CEDS element technical names.