SBII

SUNY Business Intelligence Initiative Library Project

Proof of Concept Goals

• Analyze and compare bib collections and circ data
• Filter by subject, pub date, language, fmt, 2nd fmt, repord type, aud, gov't pub
• Identify uniqueness/overlap
• Determine collection age/rate of growth
• Analyze collection usage using circ info
• Analyze circ activity by patron status

Proof of Concept Data

• Bib data to 12/31/08
• Circ data 2006-2008
• Data from ITEC servers
• Schemas created by System Administration DBA
• Data stored in OBIEE data warehouse in SysAdmin

Dashboards

• Collection Analysis
• Circulation Analysis
• Education Overview
• Executive/Financial Overview

OCLC Conspectus used to map call numbers to subjects
z13 & z30 tables used

Can add data from other places: NCES, TPAM

To get access:

1. Go to https://www.suny.edu/security/login/help.do?action=chooseCampus&redirectUrl=https://www2.sysadm.suny.edu/EmployeeServices/Main/employeeportal.cfm
2. Contact the appropriate person