1 / 29

SUNY Business Intelligence Initiative Library Project

SUNY Business Intelligence Initiative Library Project. 2009 LiSUG Conference Maureen Zajkowski SUNY Office of Library and Information Services. SBII Overview. SUNY Business Intelligence Initiative (SBII) Part of SUNY-wide effort Provide data analysis and reporting tools Phase 1

ima-hurst
Download Presentation

SUNY Business Intelligence Initiative Library Project

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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@suny.edu

More Related