UAlbany Business Analytics (UBA) is a Business Intelligence (BI) environment that uses the latest Oracle BI technologies. The UBA provide insights to key decision makers that can drive business practice changes with accurate and reliable data used with confidence, especially in our current fiscally demanding environment.
The primary benefit of this innovative service is the empowerment of Department Chairs, Deans, and Administrators to generate sophisticated representations of metrics (dashboards, bar graphs) with minimal technical expertise. Data is integrated from disparate, separately owned data sources into a single format/display to easily generate historical comparisons and trend data to use in operational and strategic decision making. UBA has reduced the need for ad hoc reports, shadow systems and query-based analysis and will eventually replace the existing data warehouse.
Simplifying the complexity of Campus data and establishing consensus on data definitions and data sources, has improved the quality of University data overall. Data anomalies are captured during nightly processing, and, if appropriate, data quality is always fixed at the source system.
UAlbany is the first SUNY campus to implement a complete Cost per Academic Program analytics, an invaluable metric for management.
UAlbany Business Analytics
UAlbany Business Analytics Screen Shots
Login and Landing Page
Costs and Expenditures
Each of the screen shots below begin with the Comprehensive Campus Analysis. The user then can easily drill down and add columns to obtain the analytics he/she is interested in. Once a user creates an analytic in this way, say one that looks only at his/her program, the analytic can be saved for the user, and refreshed with new data whenever he/she chooses.
- Direct Instructional Expenditures by School, Department and Program (cost per credit by term)
- Drill Down to Department for Cost per Credit by Instructor across Terms
- Drill Down to Department for Cost per Credit by Instructor, single Term
- Sample Screen shot to 'Add a Column' to an existing dashboard
- Expenditure Bar Graph for a School by Department
Enrollment
These screens show enrollment analytics over time and for a specific term. What is most interesting, is that the School of Computing and Information enrollment distinction between genders is following the national trend of gender ratios.
- Enrollment Dashboard
- Trending Graphs depicting Total Campus Enrollment over Terms and Campus Enrollment by Degree
- STEM (Computer Science) Enrollment Trends by Gender
Workforce
These analytics look at the workforce for trends and actionable items:
- Faculty Head Count by Type of Instructor
- Faculty Head Count by Type of Instructor grouped by Gender (other demographics can be chosen via the "Include Column" function)
The following dashboard includes an age demographic column from the main dashboard, and can be used for succession planning and/or recruitment
The following analytic differs from Head Count in that complex logic in the transformation process computes the Full Time Equivalent that each instructor actually teaches (what department pays him/her, what department is he/she teaching in, number of courses, etc)
The drill down to the individual instructor provides insight into faculty who may also be doing research, publications, etc.