Purpose

Analytics end-users may want to slice and filter presentation views by grading period information, especially for viewing and aggregating grades. These calendar-related dimensions are distinct from the DateDim View because that view provides an industry-standard concept of a Date Table, whereas the school calendar dimension fields are specific to the education domain. The two could be combined; however, keeping them separate helps isolate their roles and provide flexibility on further refinements. Part of the Core View Collection.

SQL Object Name

analytics.GradingPeriodDim

Data Source

Same for both data standards.

Structure