Data Analytics & The Divine Comedy:

DANte atNUI Galway

Sinéad Ní Fhaoláin & Caroline Horan

HEAnet Conference 2018

University IT Strategy:

Information Management Programme

Data AnalyticsThe discovery,

interpretation, and communication of

meaningful patterns in data

Business IntelligenceComprises the strategies and

technologies used by enterprises for the data

analysis of business information

Decision Support/Data WarehouseInformation system that supports business or organisational

decision-making activities

The Beginning

HEAnet Conference 2018

ExcelReports exported/

worked over

Per systemSingle source reports

Point in time

Mystery Undocumented decisions/key

definitions

Pre-Project Landscape

HEAnet Conference 2018

Meet a needData Analysis

= answers to our questions = using our data strategically

TechnologyKimball

Microsoft

PeopleCustomers

Consultant & PM

What exactly do we mean

by…?

Role-basedPilot Inception

HEAnet Conference 2018

PeopleTeam: PM, 1 external & 2

internal.Board: Senior Mgt

Getting Approval

Business CaseCustomer requirements

Modest € (€50,000)Benefits???

March – July 2017

HEAnet Conference 2018

Data SourcesStudent

StaffBuilding DB Tables

Requirements Workshops

Identify a process with customersDimensional Modelling

Pilot Modus OperandiQuestions

StaffStudent:

Registration, Fees, P & C

Team MeetingsWeekly at HQ

DeliverReviewAmend

HEAnet Conference 2018

Kimball-Style Bus MatrixDimensional Modelling workshops

Security

Building Commenced!!

HEAnet Conference 2018

Key Technology Elements

Ellucian Quercus

CoreHR

Data Sources Data Warehouse

SQL Server

History StagingProductionSP

BI Layer

DatasetsReportsWorkspacesAppsDashboards

Share

Access

ETL Layer

SSIS

SQL Server Job

SQL Server Views

HEAnet Conference 2018

Power BI Desktop

Power BI Web Service

HEAnet Conference 2018

Low Impact!

3 AppsStudents & Modules

Staff AnalysisStudent Fees

Customers BenefitingManagement Accounts

HR

More DetailsHeadcount & FTE

reportsETL for staff & some

initial explorationBudget vs actual

students numbers & fees

Pilot Outputs

Purgatory

Late 2017: DANte flies in

19/11/2018 HEAnet Conference 2018

HEAnet Conference 2018

We Need a Brand…?

DANte

Looking GoodMethod & Technology

ConsultantSkills Developing

Solid Foundation in Place1 Additional Team Member

Business CaseDeeper & Wider

More € (€220,000)Benefits???

The Big 3 vs Historical Reporting1. Multiple data sources - integrated

2. Live data updated daily3. Single attractive lens for the whole institution

Pilot to Project

HEAnet Conference 2018

StudentStudent Engagement

Progression & Completion

FTEs

FinancialsGeneral budget holder reports

(late addition)

StaffPeople & Posts

SecurityRole-based

AD & PowerBI

DANte Scope

More Data BB / WiFi /

Library / CAO / Agresso

GDPR

HEAnet Conference 2018

More AppsDeveloped

Wider Range of Customers

Deeper AnalysisProgression & Completion

Predictive AnalyticsExposing Student & Staff

Details: Managed Access Key

DANte Outputs

Higher Impact!

Reports in use

HEAnet Conference 2018

“Multiple Data Source” Report

HEAnet Conference 201819/11/2018

Staff Reporting

Paradise on the Horizon…

19/11/2018 HEAnet Conference 2018

HEAnet Conference 2018

The EnablersAn Identified

Need

Consultant

Enthusiastic TeamSupportive

Board

Engaged Customers

Funds

Mature Technology

HEAnet Conference 2018

The ChallengesGDPR

Secure Role-Based Access

Data Quality

Team skills

Customer availability

Historical Data Management

Behaviour Change

HEAnet Conference 2018

‘Having use of the report is beneficial and a great tool to be able

to cross -reference data from other

sources’- College of Business

“provided real time information from different university systems - allowed

me to track student registrations daily and

compare with prior year/budget data”- Mgmt Accounts

Customer feedback

“ gives an insight into student engagement behaviours and an

evidence base from which strategic plans to support

our students can be developed”

- Retention Officer

“particularly useful for Colleges and units with

limited access to analytical skills”

- College of Arts

“The DANte system has proven useful almost immediately for business

planning within the University”

- College of Arts

“is a vital strategic tool providing up to

date data and information on our student population”

- Retention Officer

19/11/2018

Volume

One Version of the Truth

30%Skills

Reflection – Paradise

Data Warehouse

Investment - People - Technology

Training&

Support

10%

60%

Usage

70%

Report Maturity