Loading…
Attending this event?
Monday, November 4 • 12:00pm - 4:00pm
PivotTables are easier than you think! Simple Yet Powerful Data Visualizations for Librarians with Excel

Sign up or log in to save this to your schedule and see who's attending!

Registration Cost: $150
Register Now
Add to Existing Conference Registration - log in and click gear icon in the "Actions" column to the right of your 2019 Conference registration information. 


Librarians and library staff work with data collected from a variety of sources however data collection doesn’t always translate to data analysis or reporting. Lack of time, budgetary constraints prohibiting the purchase of data visualization software, and potentially steep learning curves regarding using advanced features of existing software to create meaningful data visualizations can all impact individuals’ ability and/or willingness to analyze collected data using data visualizations.

In this session, we will walk all workshop attendees through the process of turning their library data (no matter how disorganized) into meaningful data visualizations using PivotTables in Excel. We will start off the workshop by discussing types of data that are best visualized with PivotTables, using examples of PivotTable visualizations created with our library’s data. We’ll discuss basic data cleaning, and specific concerns to consider when prepping your data for visualizing with Pivot Tables. We’ll share potential limitations of pivot tables and issues that you can encounter when building PivotTables. BYOD (Bring Your Own Device) is encouraged and time will be provided for workshop attendees to create their own data visualizations with the assistance of the workshop presenters.

Speakers
avatar for Monica Rysavy

Monica Rysavy

Director & Assistant Professor, Office of Institutional Research & Training, Goldey-Beacom College
Monica D.T. Rysavy, Ph.D. is the Director of Institutional Research and Training for Goldey-Beacom College in Wilmington, Delaware. In this role she leads all institutional research and data analysis projects for the College. Her office provides faculty and staff training support... Read More →
avatar for Russell Michalak

Russell Michalak

Director (Library, Archives, & Learning Center), Goldey-Beacom College
Russell Michalak, MLIS, joined Goldey-Beacom College (GBC) in 2010. As Director of Library & Learning Center/Assistant Professor, he oversees all operations of the library including the annual budget. In addition, he supervises and hires librarians, tutors, paraprofessionals, as well... Read More →


Monday November 4, 2019 12:00pm - 4:00pm
TBD