Trends at a Glance: A Management Dashboard of Library Statistics
DOI:
https://doi.org/10.6017/ital.v31i3.1919Abstract
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
How to Cite
Issue
Section
License
Copyright (c) 2015 Information Technology and Libraries
This work is licensed under a Creative Commons Attribution 3.0 Unported License.
Authors that submit to Information Technology and Libraries agree to the Copyright Notice.
