search

Ed-Fi-Exchange-OSS / Ed-Fi-Analytics-Middle-Tier

The Analytics Middle Tier is a set of denormalized analytics views over the Ed-Fi ODS database tables, satisfying the user story: "As a district data analyst, I want to build intelligent reporting on the Ed-Fi ODS with minimal learning curve and low risk of breaking changes, so that I can deliver timely data to educators and administrators."
Apache License 2.0
0 stars 0 forks source link

Date, School, and Student Dimension Views #98

Closed stephenfuqua closed 3 weeks ago

stephenfuqua commented 3 weeks ago

Jira Description

h1. Date Dimension h2. Story

As an Early Warnings System Analytics Data Modeler, I want to import a Date Dimension Table from the ODS, so that I can easily provide date filter capabilities to analytics end users. h2. Acceptance Criteria

The data for a Date Table should include the following columns.

h2. Implementation Notes

See [https://techdocs.ed-fi.org/display/EDFIODS/Date+Dimension+View] h1. School Dimension h2. Story

As an Early Warnings System Analytics Data Modeler, I want to import a School Dimension Table from the ODS, so that I can provide School-related dimension fields to analytics end users. h2. Acceptance Criteria

Must include the following columns:

h2. Implementation Notes

See [https://techdocs.ed-fi.org/display/EDFIODS/School+Dimension+View|https://techdocs.ed-fi.org/display/EFDS20/Education+Organization+-+UDM+v2.0] h1. Student Dimension h2. Story

As an Early Warnings System Analytics Data Modeler, I want to import a Student Dimension Table from the ODS, so that I can provide Student-related dimension fields to analytics end users. h2. Acceptance Criteria

Must include the following columns:

StudentName should concatenate First, Middle, and Last Names together, with a single space between each. If middle name is blank/null, then there should still be only one space between first and last names. h2. Implementation Notes

See [https://techdocs.ed-fi.org/display/EFDS20/Student+Identification+and+Demographics+-+UDM+v2.0]

Jira Metadata

Created: 2018-07-19T10:37:01.000-0500 Reporter: Stephen Fuqua

stephenfuqua commented 3 weeks ago

Jira Comment

2018-08-02T13:15:56.180-0500

Jira Metadata

Created: [~cyjones] please review. There are some C# changes but nothing major compared to what you've already seen. Mostly looking for sanity check on the views. Commenter: Stephen Fuqua

stephenfuqua commented 3 weeks ago

Jira Comment

2018-09-05T11:01:06.287-0500

Jira Metadata

Created: Merged through a combined pull request. Commenter: Stephen Fuqua