Differences

This shows you the differences between two versions of the page.

--- emis_user_manual_data_warehouse [2020/09/07 03:42] – [Teachers] ghachey
+++ emis_user_manual_data_warehouse [2022/02/17 15:27] – [Flows] ghachey
@@ Line 141: / Line 141: @@
 <note important>Flows are more advanced indicators with slightly more advanced mathematics behind them then other ratios seen so far.</note>
-Each of these views produce the same data but with different disaggregations (i.e. down to school level, district level and nation wide and by gender). Each record will have the following data which must be used in various formulas to produce the final indicators. There is a bold emphasis on the most important ones to produce most flow indicators with enough precision. These flows use the reconstructed cohort methods and must have consistent collection of enrolments and repeaters for two consecutive years.
+Each of these views produce the same data but with different disaggregations (i.e. down to school level, district level and nation wide and by gender). Each record will have the following data which must be used in various formulas to produce the final indicators. There is a bold emphasis on the most important ones to produce most flow indicators with enough precision. These flows use the reconstructed cohort methods and must have consistent collection of enrolments and repeaters for two consecutive years. Details about the columns names in this view are included below:
   * **Enrol**: the enrolments (e.g. Grade 5 enrolments for 2018-19)
@@ Line 160: / Line 160: @@
   * Transition Rate (year on year) = (EnrolNYNextLevel - RepNYNextLevel) / Enrol
-A sample workbook how this many of the flow indicators with some analysis done in the data is included below.
+A sample workbook showing how these many flow indicators can be calculated including some analysis is included below.
 {{ :user-manual-data-warehouse:flows-ratios.xlsx |}}
@@ Line 172: / Line 172: @@
 ==== Teachers ====
-=== Table warehouse.TeacherQual ===
-Intermediate table to assist in calculation of Certified / Qualified. This table shows, for each teacher, the qualifications reported, and the first year of that report. It is assembled from both the School Surveys, and any named qualifications reported in the web UI.
-<note warning>You do not need to use this table directly.</note>
 === Table warehouse.TeacherLocation ===
@@ Line 374: / Line 369: @@
 Same of warehouse.enrol except this table aggregates this data up to District, Authority, SchoolTypeCode and is used as the basis for higher level aggregations of any of these enrolment data items.
+==== Teachers ====
+=== Table warehouse.TeacherQual ===
+Intermediate table to assist in calculation of Certified / Qualified. This table shows, for each teacher, the qualifications reported, and the first year of that report. It is assembled from both the School Surveys, and any named qualifications reported in the web UI.
+<note warning>You do not need to use this table directly.</note>
-==== Flows ====
@@ Line 440: / Line 442: @@
 <note important>This table is geared towards advanced data people.</note>
-Consolidates the overall result of inspections. Filter on InspectionType to restrict to accreditations
+Consolidates the overall result of inspections with all the typical school disaggregations. Filter on InspectionType to restrict to specific inspections (e.g. School Accreditation, WASH, etc.)
 <note important>This table is useful for pivot tables, and crossfilters, allowing multiple dimensions to be manipulated interactively</note>