Overview SUNY Business Intelligence Initiative SBII Library Dashboards Circulation Analysis Collection Analysis

1. 1 Overview SUNY Business Intelligence Initiative (SBII) Library DashboardsCirculation AnalysisCollection Analysis

2. What is SBII? The SUNY Business Intelligence Initiative (SBII) is a SUNY-wide effort to provide data analysis and reporting tools for a wide range of university information. SBII is using the Oracle Business Intelligence Suite Enterprise Edition (OBIEE) software tools. An article in SUNYergy provides an overview of the project: http://www.sunyconnect.suny.edu/sunyergy/40SBII.htm 2

3. Purpose of the Circulation and Collection Reports analyze and compare aggregate holdings SUNY-wide by SUNY sectors, by regions, and campus defined peer groups compare data between/among selected campuses and sectors/regions access collection usage using circulation information analyze circulation activity by patron status 3

4. Purpose of the Reports cont�d analyze collections, circulation activity and patron status usage by subject, publication date, language, format, other qualifiers (secondary formats, material description, target audience, form of item, government publication) determine collection age and rate of growth view overlaps and gaps of the SUNY Library Collection identify unique campus holdings 4

5. Not a Campus-Specific Tool The goal of these dashboards is to provide for SUNY wide collection analysis rather than create a specific campus reporting tool. 5

6. 55 Campuses, All Bib Records,5 Years Circulation The data available for reports is: taken from 55 of the campuses on the shared Aleph servers (the 4 U Centers and Alfred U are not included) 6

7. See �Library Data Details� Link for More For a detailed description of the oracle tables and fields used in this project, please see the �Library Data Details� link to the MS Word Document 7

8. Circulation Analysis Dashboard Seven Dashboard Pages were created to help analyze and compare circulation activity by most of the attributes identified in the Collection Analysis Dashboard. In addition, circulation activity can be analyzed by year of circulation, patron type and by lending policy. 8

9. Collection Analysis Dashboard Seven Dashboard Pages were created to help analyze and compare bibliographic holdings SUNY-wide, by sectors and regions, and with selected campuses. The analysis includes identification of unique holdings and overlap of holdings among campuses; review of collections� ages and rate of growth based on publication dates; and the ability to filter by a variety of attributes including subject areas, language, and format. 9

10. All Dashboard Pages Offer: Introduction Page - each of the Library Dashboards has an Introduction Page which provides information on the Pages associated with that Dashboard. Print/Download Options � are available from each Dashboard Page and from the Title Details Report. Printing options are available in HTML and PDF formats. Download options include output to .csv format, Excel, Powerpoint, and Web Page (MHTML). 10

11. Workflow connect your web browser to: http://www.suny.edu/analytics log-in with your campus username and password select Circulation Analysis or Collection Analysis from the Business Intelligence Utilization navigation menu review the Introduction dashboard and decide which report you need go to the Prompts dashboard and select the criteria for filtering your reports (Overview reports do not need Prompt filters) select a dashboard and run the reports you need 11

12. open your web browser connect to http://www.suny.edu/analytics 12 Connecting

13. 13 Choose Your Campus from the Menu