BI Training and Guidance

BI Strategy

The main aim of the University's Business Intelligence (BI) Strategy is to deliver accurate and timely data, analysis and intelligence from our central Data Warehouse to a range of colleagues including SMG, School/RIs and University Services.  This will become our one version of the truth ensuring that discussions about data are meaningful, proactive decisions are made and intelligent analysis is delivered all with the same aim of helping us be world class and a world changing university.

The ulimate aim is really about one thing – organisational change in support of our strategic ambitions.  By implementing our BI Strategy we will improve the likelihood of success in achieving our overall University strategic aims; and the way we conduct our business will change for the better.


BI Online Guidance

BI Online is available from Business Systems using your GUID and password. 

This provides:

  1. HESA Student Headcount Profiles on Degree Classification, Disability, Ethnicity, Gender, Social Class and Term-time Accommodation
  2. HESA Student FTE by School and HESA Cost Centre
  3. Subject Profiles by University, College, School/RI and JACS Principal Subject
  4. Equality Monitoring
  5. Research links to Enlighten or Theses
  6. Staff HR KPI Report

QlikView Guidance

QlikView is a Business Intelligence and data visualisation application that the University uses to allow staff to quickly see data in an easy and accessible format. 

For example there is a Student Dashboard which contains a useful subset of student data from MyCampus.

If you have a license (these are granted on an individual basis) then please select the following URL and use your GUID and password to login:
https://qv-planning.gla.ac.uk/qlikview/FormLogin.htm

Save the above link as a favourite in your web browser. 

Instructions for getting access to QlikView dashboards

  • Place a Supportworks Helpdesk call
  • Select Business Systems > QlikView > Login/Licensing Issue
  • Provide the name(s) of people who need access
  • Provide their GUIDs
  • Let us know which dashboards (e.g. Student Headcount) that they need access to

QLIKVIEW DASHBOARDS:
STUDENT
CENTRAL TIMETABLING (CTT)
DESTINATION OF LEAVERS FROM HIGHER EDUCATION (DLHE)
HR
NATIONAL STUDENT SURVEY (NSS)


Training


Support

There is a yammer page to support the BI strategy at: Business Intelligence Strategy Forum

Feedback for the BI development team is also welcome at bi-strategy@glasgow.ac.uk or see Contact Us

If you are reporting a fault please create a support call at: www.gla.ac.uk/it/selfservice


Student Population Definitions:

In general in BI Online, Planning and Business Intelligence Dashboards we use 1. QlikView Standard Student Headcount Population and 2. QlikView Additional Separate Categories Headcount Population unless specified otherwise. 

Please note that the HESA Standard Registration population and the QlikView Standard population student headcounts cannot be compared. 

  • HESA headcounts are for reporting, i.e. all students, including withdrawn, online learning etc.
  • QlikView student headcounts are for operational use i.e. actual students physically at the university, not including withdrawn, online learning etc. 

QlikView headcounts are less than HESA headcounts because they exclude various categories of students.  To follow is an example for 2017-18 (rounded to the nearest 100):

  • Withdrawn (~700)
  • Online Learning (~500)
  • Distance Learning (~200)
  • Staff Learning (~200)
  • There are other small differences in "not send to HESA" plans which are in QlikView but not HESA.

In summary, if you require operational numbers, i.e. who is physically here, then use the QlikView student headcount model.  If you require the headcount of all students, or to compare against other UK institutions, then use the HESA data. The QlikView student headcount contains students who are physically on campus.  The HESA data contains students who we actually reported to HESA,  for which we are bound by HESA guidelines and coverage rules.


1. QlikView Standard Student Headcount Population

This is also explained in the STUDENT HEADCOUNT (VIA ACADEMIC PLAN OWNER) Guidance tab in the QlikView Student Dashboard.  This population is concerned with students taking up substantial University resources such as estates space and teaching or research staff time and is the main student body.

There are some exclusions as follows:
Academic Prog: 7104 – Clinical Scholar
Higher Doctorate (HD) Students
Academic Plans with a Field of Study labelled as ‘OUTCAMP’
Academic Plans owned by the Learning and Teaching Centre


2. QlikView Additional Separate Categories Headcount Population

These are the remaining students who are not counted in the QlikView Standard Student Headcount Population i.e.:

Exam Only
Christie's Auction House
Thesis Pending
Erasmus Outgoing
Exchange Out
Language Year Out
Distance Learning
Online
Singapore Institute of Technology (Engineering)
Singapore Institute of Technology (Computer Science)
University of Electronic Science and Technology China (UESTC)
Scottish Universities Environmental Research Centre (SUERC)
Majan University College, Oman
Nankai University
Sabbatical







3. QlikView FTE Population

This is simply defined as any student with a non-zero FTE in Agresso.


4. The HESA standard registration Headcount Population

This is generally only used in some BI Online and Planning and Business Intelligence web pages which are clearly labelled.  QlikView generally uses population types 1,2 or 3.

The HESA standard registration population has been derived from the HESA Student record, from all registered higher education and further education student instances active at a reporting institution in the reporting period 1 August to 31 July, following courses that lead to the award of a qualification or institutional credit, and ensures that similar activity is counted in a similar way irrespective of when it occurs.

The population splits the student experience into years of study. The first year is deemed to start on the commencement date of the student instance, with second and subsequent years starting on, or near, the anniversary of that date. Student instances are counted once for each year of study. However students who leave within two weeks of their instance start date, or anniversary of their start date, and are on a course of more than two weeks duration, are not included in the standard registration population.

Also excluded from this population are:

    dormant students (those who have ceased studying but have not formally de-registered)
    incoming visiting and exchange students
    postdoctoral student instances
    instances where the whole of the programme of study is outside of the UK
    instances where the student has spent, or will spend, more than 8 weeks in the UK but the study programme is primarily outside the UK
    Teaching Agency (TA) Subject Knowledge Enhancement (SKE) student instances
    students on sabbatical, and
    writing-up students.

The HESA standard registration population forms the basis for most counts of first year and continuing student instances.

The standard registration population changed in 2007/08. Data published prior to this included sabbatical and writing-up students. Data published in recent (2007/08 to 2009/10) Statistical First Releases covering earlier years have been re-calculated using the new standard registration population, and may therefore not match data published before 2007/08.

Please note, the following students are included as standard in HESA populations:

    Students registered at, but not taught by the reporting institution - this is usually through a collaborative/franchising agreement. It may be for the whole or a proportion of the academic year.
    Students based in the UK on distance learning programmes.
    Student based outside of the UK on funded distance learning programmes e.g Crown servants overseas and the Services
    On industrial placement for the whole or a proportion of the academic year.
    On study year abroad for the whole or a proportion of the academic year.

If you require, HESA is able to remove any of these students from bespoke data requests. Please be aware that any alterations to standard HESA populations will mean that data will not align with HESA data published elsewhere.


5. HESA session FTE Population

This is generally only used in some BI Online and Planning and Business Intelligence web pages which are clearly labelled.  QlikView generally uses population types 1,2 or 3.

Full-time equivalent (FTE) data represents the institution's assessment of the full-time equivalence of the student instance during the reporting period 1 August to 31 July.

The HESA session population forms the basis for counts of full-time equivalent (FTE) student instances. It includes all registered higher education and further education student instances active at a reporting institution at any point in the reporting period 1 August to 31 July, following courses that lead to the award of a qualification or institutional credit, except:

    dormant student instances (those who have ceased studying but have not formally de-registered)
    incoming visiting and exchange student instances
    postdoctoral student instances
    instances where the whole of the programme of study is outside of the UK
    instances where the student has spent, or will spend, more than 8 weeks in the UK but the study programme is primarily outside the UK
    Teaching Agency (TA) Subject Knowledge Enhancement (SKE) student instances, and
    students on sabbatical.

Incoming visiting and exchange students are excluded from the session population in order to avoid an element of double-counting with both outgoing and incoming students being included.