Citation

Michalak, R. & Rysavy, M. (2019, November). Pivot Tables are easier than you think! Simple yet powerful data visualizations for librarians with Excel. Charleston Library Conference. Charleston, South Carolina. (Workshop).

Abstract

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.

Read more by visiting:

https://2019charlestonlibraryconference.sched.com/event/Qg0E/pivottables-are-easier-than-you-think-simple-yet-powerful-data-visualizations-for-librarians-with-excel

Ready to Track & Reflect on 2021?

Perhaps you're like us & often think that you should give the whole "daily journaling" thing a try. But most templates either cost more than you're interested in paying for or are simply too complicated to keep up with more than a few days. We get it!

Here's where we come in! We've created a new #NotionForAcademics template for you to help you track & reflect on each day of 2021 with three simple daily entries in a free Notion template. And the cost? It's FREE! 

Get the 2021 Tracking Template & receive our #NotionForAcademics Productivity Tips Newsletter by filling out this brief form.

Thanks for trying out our template and signing up for the #NotionForAcademics Newsletter! Please download the template by clicking: https://s3.amazonaws.com/contents.newzenler.com/7214/library/5fe8fbc103cf8_1609104321_2021-daily-summary-mood-energy-tracker-pdf.pdf