Belfast Met Data Management

Challenge

After a recent restructure of the Management Information Systems (MIS) Team at Belfast Metropolitan College, it was apparent that there was a significant gap between what the College required and what was being delivered, and what could be provided with the existing reporting tools.

 

What We Discovered

Users were very reliant on the existing MIS team for delivery of key reports

Due to the amount of data that their current reporting structure could handle, users had no visibility of low level data

Reporting was inconsistent throughout the College with some Schools using different base data than others

Each reporting area was very much in isolation and wider trends could not be analysed.

 

Approach

Neueda adopted an Agile Business Intelligence implementation approach; understanding what the existing business problems were and analysing the quality of the current data.

 

“It is fair to say that our ability to have real time, meaningful performance discussions, have been revolutionised by the introduction of Qlikview."

Marie–Therese McGivern

Principal and Chief Executive of Belfast Metropolitan College

 

Key Features

Mobilisation – Agreed scope and stakeholders

Capture As–Is – Understood the current business reporting, with feedback from the customer about the quality of these

Assess and Design To–Be – Undertook a number of workshops to define and document the vision and undertook gap analysis

Development – Based on the agreed vision we created an Extract, Transform and Load (ETL) program and integrated the key business systems

Testing – Worked alongside the business to test the data

Training – Had weekly drop in sessions so that users could further their knowledge of the QlikView application

 

Results

All users in the College now have consistent and regular reporting with the ability to view the data that impacts their role at an operational and strategic level. True self service reporting is now in place and with the core reports it allows the College to think how other data could be incorporated.

 

Key Outcomes

Marked attendance registers by tutors increased by 45%

Over 2,000 user sessions of Qlikview per month with all areas of the College represented, from Deputy CEO to School administrators

Users now have the ability to drill down and identify trends about courses and students which was not possible before

An additional set of projects to bring other key College Systems into QlikView