Trends at a Glance: A Management Dashboard of Library Statistics

Authors

  • Emily G Morton-Owens Microsoft, Redmond, Washington
  • Karen L Hanson NYU Health Sciences Libraries, New York, New York,

DOI:

https://doi.org/10.6017/ital.v31i3.1919

Abstract

Systems librarians at an academic medical library created a management data dashboard. Charts were designed using best practices for data visualization and dashboard layout, and include metrics on gatecount, website visits, IM reference chats, circulation, and ILL volume and turnaround time. Several charts draw on EZproxy log data that has been analyzed and linked to other databases to reveal use by different academic departments and user roles (such as faculty or student). Most charts are bar charts and include a linear regression trendline. The implementation uses Perl scripts to retrieve data from eight different sources and add it to a MySQL data warehouse, from which PHP/Javascript webpages use Google Chart Tools to create the dashboard charts.

References

“Annual Statistics,” accessed November 7, 2001, http://www.aahsl.org/mc/page.do?sitePageId=84868.

“ARL Statistics,” accessed November 7, 2011, http://www.arl.org/stats/annualsurveys/arlstats/.

“dashboard_beta :: dashboard information,” accessed January 5, 2012, http://library.brown.edu/dashboard/info/.

Edward R. Tufte, The Visual Display of Quantitative Information. (Cheshire, CT: Graphics, 2001).

Scott Bateman, Regan L. Mandryk, Aaron Genest, David McDine, and Christopher Brooks. "Useful Junk? The Effects of Visual Embellishment on Comprehension and Memorability of Charts," CHI ’10 Proceedings of the 28th International Conference on Human Factors in Computing Systems. (2010). Accessed November 7, 2011, doi: 10.1145/1753326.1753716.

Stephen Few, Information Dashboard Design: the Effective Visual Communication of Data (Beijing: O'Reilly, 2006),98.

Rasmussen, Nils , Claire Y. Chen, and Manish Bansal, Business Dashboards: A Visual Catalog for Design and Deployment (Hoboken, NJ: John Wiley & Sons, Inc, 2009), chapter 4.

Roiger, Richard J., and Michael W. Geatz. Data Mining: A Tutorial-Based Primer (Boston: Addison Wesley, 2003), 186.

“Fitting Functions to Data: Linear and Exponential Regression,” http://people.hofstra.edu/Stefan_Waner/RealWorld/calctopic1/regression.html, accessed January 5, 2012.

Morton-Owens, Emily G. “Editorial and technological workflow tools to promote website quality.” Information technology & libraries. 2011; 30(3):92-98.

“GAPI - Google Analytics API PHP Interface,” accessed January 5, 2012, http://code.google.com/p/gapi-google-analytics-php-interface/

Karen A. Coombs, “Lessons learned from analyzing library database usage data,” Library HiTech 23 (2005):4, 598-609. Accessed November 7, 2011. doi: 10.1108/07378830510636373

Downloads

Published

2012-09-10

How to Cite

Morton-Owens, E. G., & Hanson, K. L. (2012). Trends at a Glance: A Management Dashboard of Library Statistics. Information Technology and Libraries, 31(3), 36–51. https://doi.org/10.6017/ital.v31i3.1919

Issue

Section

Articles