A DATA WAREHOUSE FOR DECS

1
A DATA WAREHOUSEFORDECS

• Data Management Accountability

2

AGENDA

• Welcome
• Housekeeping
• Purpose
• Background
• Overview of LaN datamart
• Demonstration and practice

3
BACKGROUND

• The situation we faced
• 600 schools
• No central data repository
• No linkage when a student moved school
• Reporting in a disjointed range of formats

4
BACKGROUND cont

• Moving forward
• Information Management Policy developed
• Two main strands
• - Unique Student Identifier (USI)
• - Data Warehouse
• USI now in place
• - Data transferred to centre (CEDS) nightly
• - New students allocated a USI
• - USI emailed to schools
• - Transferring students matched and given correct
  USI
• Data Warehouse developed

5
BACKGROUND cont

• What is a Data Warehouse?
• Single repository of data
• Holds data from a range of sources
• Single version of the data
• Only contains data needed for reporting
• Composed of datamarts
• Accessed via on-line reporting/analysis tools

6
BACKGROUND cont

• Current Situation
• LaN datamart completed
• First of several datamarts
• Datamarts to be integrated (linked, use common
  data)
• Business Intelligence software purchased
• Cognos Business Intelligence
• World leader
• On-line
• Web-based

7
OVERVIEW OF LaN DATAMART

• Main features of LaN datamart
• Easy access to Literacy and Numeracy Test results
  for the past five years
• Students linked across years
• Census data linked
• Data available at the student, school, district
  and State (DECS) levels
• A tool for educators to monitor literacy and
  numeracy performance

8
LaN DATAMART

• Who can access the LaN Data Mart?
• Access will only be granted to authorised DECS
  employees
• working in
• - Schools
• - District Offices
• - Central Office

9
LAN DATAMARTHow will the datamart be accessed?

• Everyone will utilise the datamart in a similar
  manner
• The type of access will depend on user role
• Assigning User Roles (security restrictions)
• - School User
• - District User
• - Corporate user

10
LaN DATAMART

• The School User will typically be a principal or
  teacher at one or more
• schools
• The School User will see
• aggregate results for the state
• aggregate results for every district
• aggregate results for their school(s)
• individual student results for students enrolled
  at their school(s)
• The School User will not see
• results for students obtained at schools other
  than their own

11
LaN DATAMART

• The District User will typically be an officer
  in a District Office
• The District User will see
• aggregate results for the state
• aggregate results for every district
• aggregate results for schools within their
  district
• The District User will not see
• results for schools in districts other than
  their own
• results for individual students

12
LaN DATAMART

• The Corporate User will typically be an officer
  located in Central Office
• The Corporate User will see
• aggregate results for the state
• aggregate results for every district
• aggregate results for every school
• The Corporate User will not see
• results for individual students

13
LaN DATAMARTHow will a User access the datamart?

• The datamart is accessed via the DECS Application
  Portal
• (the Eduportal) at the following web
  address www.eduportal.sa.edu.au
• Users will be given authority to access the
  datamart by the system administrator
• Users will be prompted to enter their employee ID
  and a password of their choice
• Need to log in again to access the LaN datamart

14
LaN DATAMARTWhat information can be obtained
from the datamart?

• A set of standard reports will provide summary
  data on
• Mean scores
• Benchmarks
• Skill band distribution
• Progress
• Test Participation
• Users will be also be able to create their own
  views of the data using
• COGNOS Analysis Studio

15
LaN DATAMARTWhat is the relationship with SPeRS?

• SPeRS School Performance Reporting System
• Data for schools to facilitate annual reporting
• Aggregate data for districts
• Replaces site data overviews and district data
  mart

16
DEMONSTRATIONandPRACTICE