Data+Information

=Data Information= For the past several months, the MNPS Data Warehouse Team has worked to build the DWH to create a database and reporting environment that allows data from many different sources to be brought together in an integrated manner to provide an initial suite of reports. This makes information easily accessible to instructional leaders and support personnel. The DWH does not replace any existing system. The existing systems are designed to facilitate the collection of information in order to record the activities of the organization. In contrast, the DWH is //optimized// for the presentation, analysis, and reporting of information.
 * This is the latest information distributed by the board on the data warehouse roll-out.**
 * Data Warehouse Status **

In Phase 1 of the DWH project, most of this initial work, of necessity, focused on technical, data, and process issues. Accordingly, the initial suite of reports is not yet comprehensive across everyone’s needs.

Currently, the DWH contains the following types of data:
 * Schools
 * Students
 * Teachers
 * Enrollment
 * Attendance
 * Student Schedules

In Phase 2 of the DWH project focuses primarily on the addition of assessment data and on expanding the suite of reports to meet a much wider variety of needs.

Phase 2 additions coming this spring: Once the DWH goes into Production status, the goal is the have the SMS data updated/loaded every night so that each day, you see everything that happened prior… including yesterday. During the Beta Test period, we plan to update on the same cycle, though we are still working out some source system technical issues that may delay the update for a day or two.
 * Student Grades
 * Discipline
 * Assessments (a very long list!)
 * Permanent Security Method
 * Wide variety of additional reports covering all above subject areas