-
- IT Help Desk
- IT service status
- IT account
- IT equipment and software
- Files and storage
- The University network
- E-learning and Exeter Learning Environment
- AV, video conferencing and learning spaces
- Systems, processes and training
- Telephone services
- IT training
- Open access IT facilities
- IT regulations and policy
- Viruses and Malware
- Sustainability
- See how we are performing against SLA
Business Intelligence (BI) Project
The Business Intelligence project aims to collect, integrate, analyse and present business information to support better business decision making.
This project will provide accessible, accurate, relevant and timely management information at the desktop for VCEG, SMG and managers in Schools and Services.
As the system develops it will ultimately provide reporting capabilities across student, research, HR, finance and estates data with functions that allow for retrospective and forward planning analysis.
The BI project will extract data from relevant databases like SITS and Aptos, transform it into a suitable reporting format and then store the transformed data in a large data warehouse.
Standard or adhoc reports can then be produced from the data warehouse straight to the desk tops of managers in Schools and Services.
This standardised dataset will provide a consistent, accurate, single source of data that everyone understands, upon which business decisions can be made with confidence.
Benefits
The project will deliver the following benefits;
- Reports on demand - KPI reports at your desktop, no need to ask someone else for some information, you will be able to access it easily and promptly.
- Clean and accurate data – all data in the reports will have been cleansed and checked for accuracy.
- Consistent definitions – reports available across Schools and Services will ensure all users have access to the same information, using the same definitions and are comparing like with like.
- Flexible reports – Dashboards will give an overview of the Key Performance Indicators, whilst it will be possible to drill down to increased levels of detail.
- Cross system analysis – holding data from a variety of systems in one place will mean analysis can take place on information that is originally input into a variety of systems.
- Forward planning – will allow for looking at what if scenarios and planning future actions based on timely up to date data.
- Early warnings – the dashboards and reports will provide early warnings of potential downturns in KPI performance.
- Live and up to date information – instead of retrospective analysis, the system will provide data based on current and up to date information held in source systems.
BI Glossary
Not sure what the technical terms mean? The BI glossary should help:
Business Intelligence: A system that collects, integrates, analyses and presents business information to support better business decision making.
Dashboard: Presents the Key Performance Indicators in simple visual graphics, such as gauges, charts and tables. This will be available through the web.
KPI: Key Performance Indicator. The University’s top 10 key performance indicators are;
- National Student Survey
- Research Income per Staff fte
- Research Assessment Exercise (RAE)
- PGR per staff fte
- International Student Population
- % of PGT student population
- Undergraduate Entry Tariffs
- Progression and Achievement
- Graduate Level Destinations
- Earned Income
Data Mart: A subset of the data warehouse, a data mart is a repository of data that holds information on a specific business area, like for example Admissions. The data warehouse will be made up of a number of data marts.
Data Warehouse: A data warehouse combines data from multiple and varied sources into one comprehensive and easily manipulated database. It does not replace existing systems, but draws information from the systems that are currently in place and facilitates reporting and analysis of this data.
Metadata: Data that describes other data and in doing so gives context to the source data. One recognisable form of metadata is the card index catalogues in the library; the information on that card is metadata about a book.
