SUNY Business Intelligence Initiative Library Project

1
SUNY Business Intelligence InitiativeLibrary
Project

• 2009 LiSUG Conference
• Maureen Zajkowski
• SUNY Office of Library and Information Services

2
SBII Overview

• SUNY Business Intelligence Initiative (SBII)
• Part of SUNY-wide effort
• Provide data analysis and reporting tools
• Phase 1
• Banner Student and Financial Aid
• Library
• University-wide Institutional Research
• University-wide Community College Finances
• Using Oracle Business Intelligence Enterprise
  Edition (OBIEE) software

3
SBII Library Project

• Proof of Concept
• (POC)

4
SBII Library Project - POC Goals

• Analyze and compare bibliographic collections and
  circulation data
• SUNY-wide
• SUNY sectors, regions, and campus defined peer
  groups
• Filter by subject, publication date, language,
  format, secondary format, reproduction type,
  target audience, government publication
• Identify uniqueness/overlap among collections
• Determine collection age and rate of growth
• Analyze collection usage using circulation
  information
• Analyze circulation activity by patron status

5
SBII Library POC Data

• Aleph Bibliographic to December 31, 2008
• 1,047,094 records
• Aleph Circulation 2006, 2007, 2008
• 809,099 circulation transactions
• Six POC Campuses
• 2 Colleges of Technology
• 2 Community Colleges
• 2 Comprehensive Colleges
• Data extracted from Aleph servers at ITEC
• Data schemas created by System Administration DBA
• Data stored in OBIEE data warehouse in SUNY
  System Administration

6
SBII Library POC Dashboards

• Collection Analysis
• Circulation Analysis
• Education Overview
• Compare Institutional Research Data with Library
  Data
• Executive/Financial Overview
• Data from National Center for Education
  Statistics (NCES) 2002-2008 Biennial Academic
  Library Surveys

7
SBII Library POC Dashboards

• Each Dashboard composed of multiple pages
• Dashboards and pages created by
• OLIS staff
• Consultant

8
SBII Library Sample Introduction Page
9
SBII Library POC Prompts Page Enables Filtering
by Various Options
10
SBII Library POC Dashboards

• Sample Reports

11
Number of Bibliographic Records by Date of
Publication
12
Circulation Activity for 2006, 2007, 2008 by Date
of Publication
13
Subject Division Breakdown by Publication Dates
1960 - 1989
14
Uniqueness
15
Bib Record Count by Publication Year Range
16
Title Level Detail from Uniqueness Results
17
Group Comparison
Subject Division Language, Linguistics
Literature Publication Dates 1960
1989 Compare Geneseo with Potsdam and all of SUNY
(other POC campuses)
18
Circulation Analysis by Patron Type
Patron Type Undergraduate, Faculty
19
Circulation Count by Patron Type Access to Title
Level Information
Click on value to access title level information
20
Title Level Detail from Patron Type Circulation
Analysis
21
Non-Circulating Analysis
Not Circulated Since 2006, by Format
22
Education Overview Degrees by Subject/Year
Compared to Circulation by Subject/Year
23
Education Overview Student FTE by Sector Compared
to Circulation Activity by Sector
24
Executive/Financial Overview Expenditures by
Campus Type
Source NCES Biennial Academic Library Surveys,
2002 - 2008
25
Executive/Financial Overview Student FTE by
Campus Type Compared to Library Staff FTE by
Campus Type
Source NCES Biennial Academic Library Surveys,
2002 - 2008
26
Executive/Financial Overview ILL Loans Provided,
ILL Loans Received
Source NCES Biennial Academic Library Surveys,
2002 - 2008
27
SBII Library Project Next Steps

• Gather input from POC campuses
• Gather input from interested reviewers
• Evaluation period to end December 2009
• Evaluate input
• If project goes forward
• address possible changes
• develop infrastructure for implementation and
  ongoing support

28
SBII Library ProjectAdditional Dashboards /
Pages?

• Enhancement of
• Financial Reports
• Institutional Research and Library Data
• Electronic Resources Usage Statistics
• Inter-Library Loan Statistics

29
Thank you for your interest

• Questions?
• Contact Maureen Zajkowski
• SUNY Office of Library and Information Services
• maureen.zajkowski_at_suny.edu