Data @ West Notts College

Ricky CoxonInformation Systems Manager

The College

• Near Mansfield across 10 sites• £50m turnover; £1.4 surplus• Beacon Status; top 75 public companies• “Outstanding” Ofsted inspection• “good use of data to aid planning and

delivery”

Data Services

• Split across 4 teams– Learner Records & Exams– Learner Performance– Funding & Planning– Systems & Reporting

Systems & Reporting

• Team of 5 computing graduates– Reporting– Structured business data (databases)– Business Systems (applications)

• Student (incl. performance & tracking)• Finance• HR & Payroll

• SQL, Reporting and .Net skills

Objective

• Was:– To create accurate, timely and easy to use

reporting systems for all levels of user• New:

– To create a single data centre that meets the information needs of all levels of user

Systems

Process

• Gather data from various systems• Store in reporting system• Display in web pages• Display in SQL Server Reporting Services

Structure

• Staff data• Corporate data• Operational data• Reports

Future

• Data warehouse• MyData• Single Data Portal• New UI