© 2011 University of Osnabrück
virtUOS
Center for Information Management and Virtual Teaching
Slide 1
Data Warehouse Based Decision Support
for Higher Education Management
¾ Our BI-Approach
¾ Decision-Makers and Scenarios
¾ Lessons Learned
Professor
Management Support and Information Systems
bodo.rieger@uos.de
Member of the Board
Center for Information Management and virtual Teaching (virtUOS) http://www.virtuos.uni-osnabrueck.de
Dr.-Ing. Bodo Rieger
University
of
Osnabrueck
Enrollment
:
10000
Programs
:
175
(69
undergraduate /
106
graduate
)
Employees
:
1543
(840
academic
/
703
non
‐
academic)
IT
staff:
50
FTE
three
technology
departments
© 2011 University of Osnabrück
virtUOS
Center for Information Management and Virtual Teaching
Slide 3
(1) Support
internal
decison
‐
making
(operational
and
strategic)
(2) Improve
operational
process
performance
(3) Public
representation
of
the
university
(external
reporting)
BuiSy Stud.IP HIS-POS HIS-SOS HIS-ZUL PICA SAP-HR ForschungsDB AlumniOS Facility -Manag ement SAP-FI/CO/PSM Lecture-M anageme nt Literature-Person al-Manag ement F ina nc ial M ana gem ent Applicants Enrollment E xam s alum ni Res earc h Data Warehouse Reporting/Analyses Decision Support
Our
BI
‐
Architecture
© 2011 University of Osnabrück
virtUOS
Center for Information Management and Virtual Teaching
Slide 5
Stud.IP HIS
myMIS - Decsion Support Portal
Derived DSS Data Reconciled Data . . . Data Warehouse
(Partly Bi-directional) Data Extraction, Transfer and Load
Interactive Standard-Reports ... Top Management Deans Lecturers Students Analytics ... Top Management Deans Lecturers Students
Our
BI
‐
Architecture
dean higher management
Lecturers
Lecturers
Students
Students
Decision-Makers in Higher
Education
Top
Management
Top
Management
Deans
Deans
© 2011 University of Osnabrück
virtUOS
Center for Information Management and Virtual Teaching
Slide 7 Thesis: if students make wrong decisions Æ it (also) affects the university Dean higher management
Lecturers
Lecturers
Students
Students
Top
Management
Top
Management
Deans
Deans
Self‐MonitoringDecision-Makers in Higher
Education
Individual
Benchmark
Student Student WT 2006 Information Systems I WT 2006 Marketing ST 2007 Business Intelligence WT 2008 Leadership WT 2008 Information Systems II ST 2009 Operations Research ST 2009 Algorithmsown grade best 25 % 25 %median better than 25 % below median weakest 25 %
© 2011 University of Osnabrück
virtUOS
Center for Information Management and Virtual Teaching
Slide 9
Mobile
Access
Student
Student
•
Web
‐
based
application
for
smartphones
(platform
independent)
•
Online
registration
for
examinations
•
Online
access
to
exam
dates
and
results
•
SMS
notification
•
E
‐
reminder
Thesis: if students make wrong decisions Æ it (also) affects the university Dean higher management
Lecturers
Lecturers
Students
Students
Top
Management
Top
Management
Deans
Deans
Self‐MonitoringDecision-Makers in Higher
Education
© 2011 University of Osnabrück
virtUOS
Center for Information Management and Virtual Teaching
Slide 11 Thesis: if students make wrong decisions Æ it (also) affects the university Thesis: administrative self‐management is not a core competence of lecturers Dean higher management
Lecturers
Lecturers
Students
Students
Top
Management
Top
Management
Deans
Deans
Self‐Monitoring Exam Date SchedulingDecision-Makers in Higher
Education
Lecturer
Lecturer
Conflict
Check
Mr. Miller, lecturer for economics, checks possible exam dates
© 2011 University of Osnabrück
virtUOS
Center for Information Management and Virtual Teaching
Slide 13
Lecturer
Lecturer
Exam
Date
Optimization
Start:
Targets
Targets
List of exams conflicting targets
List of exams conflicting targets
1. Mark an exam to reschedule 2. Room (capacity) is checked 3. Possible dates are checked
4. Critical exam dates are highlighted 5. Choose the date to reschedule
Re‐scheduling candidate Re‐scheduling candidate Consider students wishes Consider students wishes Re‐scheduling based on the heuristic optimization results
Thesis: if students make wrong decisions Æ it (also) affects the university Thesis: administrative self‐management is not a core competence of lecturer Dean higher management
Lecturers
Lecturers
Students
Students
Top
Management
Top
Management
Deans
Deans
Self‐Monitoring Exam Date SchedulingDecision-Makers in Higher
Education
© 2011 University of Osnabrück
virtUOS
Center for Information Management and Virtual Teaching
Slide 15 Thesis: if students make wrong decisions Æ it (also) affects the university Thesis: administrative self‐management is not a core competence of lecturer Dean higher management Thesis: increasing competition requires sophisticated incentives
Lecturers
Lecturers
Students
Students
Top
Management
Top
Management
Deans
Deans
Self‐Monitoring Exam Date Scheduling Resource AllocationDecision-Makers in Higher
Education
What
‐
If
Analysis
Mr. Brown, the academic dean, can allocate the budget according to the performance of chairs. Deans Deans Scenario Scenario Effects Effects Basic model Basic model Performance criteria Performance criteria changes changes Parameter Results
© 2011 University of Osnabrück
virtUOS
Center for Information Management and Virtual Teaching
Slide 17
Simulation-based
Resource Allocation
SD
DWH Allocation‐ formula SibEUS DSS 2. Model configuration 1. Formula configuration 4. Reporting configuration OLAPMIS Target value based sim results Interaction Decision‐ maker Performance indicators Simulation results Financial results 3. Reporting Deans Deans
Simulation-based
Resource Allocation
Deans Deans scenarios scenarios Selected target Selected target© 2011 University of Osnabrück
virtUOS
Center for Information Management and Virtual Teaching
Slide 19 Thesis: if students make wrong decisions Æ it (also) affects the university Thesis: administrative self‐management is not a core competence of lecturer Dean higher management Thesis: increasing competition requires sophisticated incentives
Lecturers
Lecturers
Students
Students
Top
Management
Top
Management
Deans
Deans
Self‐Monitoring Exam Date Scheduling Resource AllocationDecision-Makers in Higher
Education
Thesis: if students make wrong decisions Æ it (also) affects the university Thesis: administrative self‐management is not a core competence of lecturer Dean higher management Thesis: increasing competition requires sophisticated incentives What‘s left?
Lecturers
Lecturers
Students
Students
Top
Management
Top
Management
Deans
Deans
Self‐Monitoring Exam Date Scheduling Resource allocation Strategic ManagementDecision-Makers in Higher
Education
© 2011 University of Osnabrück
virtUOS
Center for Information Management and Virtual Teaching
Slide 21
Balanced
Scorecard
Drill
through
to
detailed
information
Top Management Top ManagementHR
IT
IT AdministrationAdministration LibrariesLibraries FacultiesFaculties SenateSenate
Management
Dashboards
Top Management
© 2011 University of Osnabrück
virtUOS
Center for Information Management and Virtual Teaching
Slide 23 Thesis: if students make wrong decisions Æ it (also) affects the university Thesis: administrative self‐management is not a core competence of lecturer Dean higher management Thesis: increasing competition requires sophisticated incentives What‘s left?
Lecturers
Lecturers
Students
Students
Top
Management
Top
Management
Deans
Deans
Self‐Monitoring Exam Date Scheduling Resource allocation Strategic ManagementDecision-Makers in Higher
Education
Decision-Makers in Higher
Education
© 2011 University of Osnabrück
virtUOS
Center for Information Management and Virtual Teaching
Slide 25
Lessons
Learned
• Early and continuous
involvement of users
• Start with open-minded
users (students)
• Easy to use interactive
web-based user
interface
• Top-level support
necessary
• Be visionary and
patient!
Bottom
‐
up
roll
‐
out
Top
‐
down
DWH
design
Future
City
of
DSS
•
Extend
the
DWH
•
Integrate
the
operational
systems
•
Business
Process
Optimization
•
Sustainability
•
Standardization
Thank
you!
Questions?
Prof. Dr.‐Ing. Bodo Rieger bodo.rieger@uni‐osnabrueck.de Thomas Haarmann thomas.haarmann@uni‐osnabrueck.de