Excel for data visualization in academic health sciences libraries: a qualitative case study

Abstract

BackgroundData visualization is a growing topic of discussion and area of educational programming in health sciences libraries. This paper synthesizes information on eight institutions’ experiences in offering Excel-focused data visualization workshops with the goal of providing an overview of the current state of educational offerings in this area.MethodsSemi-structured interviews were conducted by phone and email with librarians at institutions that offer Excel-focused workshops, which were identified by reviewing the websites of Association of Academic Health Sciences Libraries members and the 2019 Medical Library Association annual meeting program.ResultsLibrarians from six institutions were interviewed, online class materials from one institution were reviewed, and information from the author’s institution was included, resulting in a total of eight institutions. Educational offerings in Excel-focused data visualization ranged from one workshop to five workshops in a series, which typically first presented information for beginners and then progressed to more advanced data visualization skills. Regarding motivations for offering these workshops, librarians stated that they were committed to providing instruction in software programs that were already familiar to users. Workshop evaluations, when available, were generally positive.DiscussionBecause of its widespread availability and usage, Excel offers a compelling opportunity for providing hands-on data visualization instruction in health sciences libraries.

Unlicensed/Off-Label Drug Prescriptions at Hospital Discharge in Children: An Observational Study Using Routinely Collected Health Data

“…Descriptive analyses were performed using Microsoft Office Excel (2016) [23]. We used R software [24] version 4.2.1 to carry out the multivariate regression.…”

Exploring the Impact of Work-related Stress in the Nigerian Petroleum Industry

“…The database was in Microsoft Excel format. Microsoft Excel is effective for data organization and visualization [72]. This is the compiling process.…”