The Winnipeg School Division plans to take a phased approach to the data warehouse implementation beginning with student demographic, academic and assessment data followed by staff, financial and operations data. The Solution will serve as a single repository of data with appropriate dashboards and metrics so that stakeholders have the information and tools necessary to continuously improve student performance.
The objective in the Request for Proposal (RFP) is to contract with a qualified proposer to provide “off the shelf” services and products necessary to create a longitudinal data warehouse, from a variety of data sources, and make this data available to stakeholder groups through differentiated dashboards based on stakeholders role. The Winnipeg School Division prefers systems with performance management tools that help the Winnipeg School Division move beyond the data to take action and improve program efficiency. The goal is to define the solution requirements in a clear manner, providing sufficient detail and granularity to allow the successful vendor’s development team to rapidly begin design and implementation. The Division prefers to award a single contract to the proposer that submits a complete Data Warehouse & Intelligence Solution representing the best value with particular attention paid to educator ease of use.
The computing environment is a mixture of Windows and Linux Servers and MS Access /Excel Files. The Division uses both commercial software and custom applications to serve the data processing needs of schools and administration. The Core applications that are supported by the Information Technology Division are Mayet (Student Management System), WeidenHammer CIMS (Human Resources), SDS Harris School Solutions (Financial Systems) and Transfinder ( Transportation and Routing), and TLC (Library Circulation Systems). There are additional systems that may be a source of additional data elements. The solution must also integrate with MS Exchange in order to produce e-mail alerts to administrative staff when effectiveness thresholds are breached.
The proposed solution should be hosted and managed by the selected vendor and must be a web-based application.
The proposed solution will incorporate security features, which should include access controls; audit trails etc. The solution must support encryption for data transfers and should have a hierarchical role based permission structure to manage who can view and make changes to data.
The proposed solution must allow remote access from outside the networks without compromising security. The proposer must provide an overview of the security controls provided in their solution and describe how their solution manages role-based security.