NASIG 2016 has ended
NASIG 2016
Embracing New Horizons
Albuquerque, NM, June 9 to 12
Back To Schedule
Friday, June 10 • 10:30am - 11:30am
Concurrent Session A5 -- Show Me the Value!

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

In early 2014, the Electronic Resource Committee (ERC) of the Triangle Research Libraries Network (TRLN), which includes North Carolina State University, Duke University, and the University of North Carolina at Chapel Hill, needed a more accessible database to display summary information about their consortial serials packages in order to assess the value of those deals.  The result was a Microsoft Access database that brought together several assessment metrics to produce summary information about one of these consortial packages.  Over the course of the next 2 years, this database evolved into an analytical tool capable of presenting title-level analyses, collection-level graphs, and institutional-level comparisons in addition to the higher-level summary statistics stemming from its original purpose.  It also incorporates built-in functions to look for data integrity issues, reconcile title lists and calculate what the package might look like with a different title set.  With seven years of data included, the functions in this tool run in real time from an updatable data set while the database remains small enough to be conveniently distributed among the libraries.  This presentation focuses on the design and construction of this database tool in the context of its original intention, namely to show value.  Therefore, rather than presenting an analysis of the data, I intend to demonstrate what can be done to transform data into information that displays value.


Matthew Harrington

Data Projects and Partnerships, NC State University
Matthew Harrington currently works on database projects and financial reconciliation in the Acquisitions and Discovery Department at NC State University's James B. Hunt Jr. Library.  Since returning to libraries from an academic career in 2009, he has designed, constructed and presented... Read More →

Friday June 10, 2016 10:30am - 11:30am PDT
Alvorado F