Skip to main content

Use of student data: dashboards

The University's Student Systems team have built a prototype dashboard for our academic schools, to display information about students on the schools' programmes and courses.  The prototype has several tabs, presenting information about applications for programmes, completion results, survey results, demographics, and assessment.  The team consulted with other universities about what works for them, took the best results we found and applied that experience to the needs of our University.

The next stage is to turn this into a robust service and this where the architecture team have a role.  We are currently working to define an architecture for the university's BI/MI data, both at the technology level (e.g. a data warehouse) and at the modelling level.  Much of the data used in the prototype has been scraped together using a combination of existing data marts and Excel, with significant effort needed to write complex reports across these multiple sources.  That is fine for a prototype but needs refinement for a production service.
The architecture team are working with the Student Systems team to define a roadmap for the BI data that underlies the dashboards.  There are some immediate tasks that the dashboard designer has already identified, such as standardising certain values in order to simplify table joins, and building BI universes for the data that is currently in Excel.  Moving beyond this, we are defining a target architecture based on a single data mart that will incorporate all the necessary data and be more flexible than the existing database.  Business logic will be moved from the BI universes into the data mart, reducing the complexity of the presentation layer and opening the way for adopting different dashboard tools.

In the long term, it would be desirable to link to data from other systems.  For example, a school may wish to know the current cost of a course, including data about the costs of the space and other resources used.  This cross-unit reporting is a particular focus of our wider BI architecture work, which I'll write about later.

Comments

Popular posts from this blog

Changing Principles

In EA, architecture principles set a framework for making architectural decisions.  They help to establish a common understanding across different groups of stakeholders, and provide guidance for portfolios and projects.  Michael Durso of the LSE gave a good introduction to the idea in a webinar last week for the UCISA EA community.

Many organisations take the TOGAF architecture principles as a starting point.  These are based on the four architectural domains of TOGAF: business, information/data, applications, technology/infrastructure.  These principles tend to describe what should be done, e.g. re-use applications, buy in software rather than build it, keep data secure.  See for example the principles adopted at Plymouth University and the University of Birmingham.

Recently though, I encountered a different way of looking at principles.  The user experience design community tend to focus more on how we should do things.  E.g. we should start with user needs, use iterative developm…

Why the UCISA Capability Model is useful

What do Universities do?

This may seem a strange question to ask and the answer may seem obvious.  Universities educate students and undertake research.  And perhaps they work with industrial partners and create spin-off companies of their worn.  And they may work with local communities, and affiliation bodies for certain degress, and they definitely report on their activities to government bodies such as HEFCE.  They provide student services and support.  The longeryou think about it, the more things you can think of that a University does.

In business, the things that an organisation does are called "capabilities", which is a slightly strange term.  I think it is linked to the HR idea of a combination of the CAPacity and ABILITY to do a task.  Whatever the name, it is a useful concept.  A capability is more basic than a process: a University may change the way it educates students but as long as it remains a University it will educate them one way or another.

A capability …

A brief summary of our major initiatives

I notice that in 2016 I wrote 34 posts on this blog.  This is only my fifth post in 2017 and we're already three-quarters of the way through the year.  Either I've suddenly got lazier, or else I've had less time to spend writing here.  As I'm not inclined to think of myself as especially lazy, I'm plumping for the latter explanation.

There really is a lot going on.  The University has several major initiatives under way, many of which need input from the Enterprise Architecture section.

The Service Excellence programme is overhauling (the buzzword is "transforming") our administrative processes for HR, Finance, and Student Administration.  Linked to this is a programme to procure an integrated ERP system to replace the adminstrative IT systems. 

Enabling Digital Transformation is a programme to put the middleware and architecture in place so that we can make our processes "digital first".  We're implementing an API framework, a notification…