Analytics Afternoon Duluth Live Meeting
May 14, 2024 04:10 PM - 04:50 PM(America/Chicago)
20240514T1610 20240514T1650 America/Chicago Analytics Afternoon: Print and Electronic Serials in a Unified Dashboard: A Case Study in Using Advanced Analytics Techniques to Simplify Staff Work

Comparing print and online journal holdings, coverage, and usage can be a headache. The data is in various Analytics subject areas, and combining reports can take time and expertise. In the interest of creating an always-available solution usable by any staff, we built an Analytics dashboard that combines data from the Physical inventory, E-inventory, Fulfillment and Usage (COUNTER) subject areas. SQL- and variable-driven prompts allow staff to choose titles and usage years they are interested in comparing. Queries return information about print and online holdings, coverage data, and usage data in the same report. As a result, staff no longer have to run reports in multiple subject areas or search for online information in the public catalog. Analytics techniques used include: dashboards, presentation variables, unions, SQL queries, dashboard prompts, bins, and saved filters.

Duluth Ex Libris Knowledge Days and ELUNA Events 2024 eluna-conf-planning@exlibrisusers.org
53 attendees saved this session

Comparing print and online journal holdings, coverage, and usage can be a headache. The data is in various Analytics subject areas, and combining reports can take time and expertise. In the interest of creating an always-available solution usable by any staff, we built an Analytics dashboard that combines data from the Physical inventory, E-inventory, Fulfillment and Usage (COUNTER) subject areas. SQL- and variable-driven prompts allow staff to choose titles and usage years they are interested in comparing. Queries return information about print and online holdings, coverage data, and usage data in the same report. As a result, staff no longer have to run reports in multiple subject areas or search for online information in the public catalog. Analytics techniques used include: dashboards, presentation variables, unions, SQL queries, dashboard prompts, bins, and saved filters.

Systems & Discovery Librarian
,
Central Oregon Community College
 Michael Johnson
Collections Assessment Analyst
,
University Of Minnesota Twin CIties
Senior Manager, Library Operations and Collections Management
,
Corning Museum of Glass
 Susan Bond
Discovery Systems Librarian
,
University of Toronto
Database Integrity & Analysis Specialist
,
George Mason University
 Stephanie Schmitt
Head of Technical Services
,
UC Law San Francisco
 Jay Wiese
Analytics Specialist
,
Florida Virtual Campus (FLVC)
Print and Electronic Serials in a Unified Dashb...
View Download Presentation Submitted by Michele DeSilva 39 View Download Presentation Submitted by Michele DeSilva 21
Upcoming Sessions
160 visits