A non-programmers guide to enhancing and making sense of EZ Proxy logs. Issue 3 (11th November 2019)
- Record Type:
- Journal Article
- Title:
- A non-programmers guide to enhancing and making sense of EZ Proxy logs. Issue 3 (11th November 2019)
- Main Title:
- A non-programmers guide to enhancing and making sense of EZ Proxy logs
- Authors:
- Murphy, Sarah Anne
- Abstract:
- Abstract : Purpose: Libraries throughout the world use OCLC's EZproxy software to manage access to e-resources. When cleaned, processed, visualized and enhanced, these logs paint a valuable picture of a library's impact on researcher's lives. The purpose of this paper is to share techniques and procedures for enhancing and de-identifying EZproxy logs using Tableau, a data analytics and visualization software, and Tableau Prep, a tool used for cleaning, combining and shaping data for analysis. Design/methodology/approach: In February 2018, The Ohio State University Libraries established an automated daily process to extract and clean EZproxy log files. The assessment librarian created a series of procedures in Tableau and Tableau Prep to union, parse and enhance these files by adding information such as user major, user status (faculty, graduate or undergraduate) and the title of the requested resource. She last stripped the data set of identifiers and applied best practices for maintaining confidentiality to visualize the data. Findings: The data set is currently 1.5m rows and growing. The visualizations may be filtered by date, user status and user department/major where applicable. Safeguards are in place to limit data presentation when filters might reveal a user's identity. Originality/value: Tableau used in concert with Tableau Prep allows an assessment librarian to clean and combine data from various sources. Once procedures for cleaning and combining data sources areAbstract : Purpose: Libraries throughout the world use OCLC's EZproxy software to manage access to e-resources. When cleaned, processed, visualized and enhanced, these logs paint a valuable picture of a library's impact on researcher's lives. The purpose of this paper is to share techniques and procedures for enhancing and de-identifying EZproxy logs using Tableau, a data analytics and visualization software, and Tableau Prep, a tool used for cleaning, combining and shaping data for analysis. Design/methodology/approach: In February 2018, The Ohio State University Libraries established an automated daily process to extract and clean EZproxy log files. The assessment librarian created a series of procedures in Tableau and Tableau Prep to union, parse and enhance these files by adding information such as user major, user status (faculty, graduate or undergraduate) and the title of the requested resource. She last stripped the data set of identifiers and applied best practices for maintaining confidentiality to visualize the data. Findings: The data set is currently 1.5m rows and growing. The visualizations may be filtered by date, user status and user department/major where applicable. Safeguards are in place to limit data presentation when filters might reveal a user's identity. Originality/value: Tableau used in concert with Tableau Prep allows an assessment librarian to clean and combine data from various sources. Once procedures for cleaning and combining data sources are established, the data driving visualizations can be set to refresh on a set schedule. This expedites the ability of librarians to derive actionable insights from EZproxy data and to share the library's positive impact on researcher's lives. … (more)
- Is Part Of:
- Performance measurement and metrics. Volume 20:Issue 3(2019)
- Journal:
- Performance measurement and metrics
- Issue:
- Volume 20:Issue 3(2019)
- Issue Display:
- Volume 20, Issue 3 (2019)
- Year:
- 2019
- Volume:
- 20
- Issue:
- 3
- Issue Sort Value:
- 2019-0020-0003-0000
- Page Start:
- 186
- Page End:
- 195
- Publication Date:
- 2019-11-11
- Subjects:
- Data visualization -- Library assessment -- Data cleaning -- EZproxy -- Tableau -- Tableau Prep
Libraries -- Evaluation -- Periodicals
Libraries -- Quality control -- Periodicals
025.005 - Journal URLs:
- http://www.emeraldinsight.com/journals.htm?issn=1467-8047 ↗
http://www.emeraldinsight.com/ ↗ - DOI:
- 10.1108/PMM-08-2019-0034 ↗
- Languages:
- English
- ISSNs:
- 1467-8047
- Deposit Type:
- Legaldeposit
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library DSC - 6423.831312
British Library DSC - BLDSS-3PM
British Library HMNTS - ELD Digital store - Ingest File:
- 12214.xml