Drilling Down Into Your Library Data Tami Oliphant

Drilling Down Into Your Library Data Tami Oliphant & Ali Shiri School of Library and Information Studies University of Alberta Library Conference, 29 April 2016

Outline • Data definitions and types • Data literacy • Data analysis—Edmonton Public Library example • Tools for data visualization and presentation • Open source tools for data analysis

What has your data done for you lately? • Data-driven decision-making (Massis, 2016) • Reviewing and classifying reference statistics (Le. Mire et al. , 2016) • GIS and in-library use data (Mandel, 2010) • Data visualization and library assessment (Murphy, 2015)

Data Definitions

Data are a string of symbols. Information is data that is communicated, has meaning, has an effect, has a goal. Fidel, R. (2012). Human Information Interaction. Cambridge, MA: MIT Press. Big Data are difficult to define

Data in context

Types of library data • • • Circulation data Open data Qualitative data Search behaviour data Social media data Usability data Image from the British Library

Tweet analysis and categorization 8

Map of EPL branches in Edmonton

Search for “Libraries”

Public Libraries Statistics Data

Data Literacy

Data Literacy “Data literacy is the new skill” “…the component of information literacy that enables individuals to access, interpret, critically assess, manage, handle and ethically use data. ” (Calzada et al. , 2013) 17

Temporal Queries from EPL

• June 21 -July 21 Data collected Total number of searches: 1, 123, 152 ▫ Total sessions: 136, 861 ▫ Total searches: 374, 271 ▫ Total unique searches: 321, 085 • July 22 -Aug. 21 ▫ Total sessions: 129, 635 ▫ Total searches: 368, 242 ▫ Total unique searches: 315, 991 • Aug. 22 -Sept. 21 ▫ Total sessions: 140, 050 ▫ Total searches: 380, 639 ▫ Total unique searches: 328, 359 19

Data collected Total sessions and searches by day of the week Monday Tuesday Wednesday Thursday Friday Saturday Sunday Sessions 63, 905 63, 164 63, 249 61, 897 58, 395 48, 542 48, 663 Total searches 172, 954 170, 697 168, 928 168, 549 155, 539 138, 297 136, 675 Unique searches 147, 272 144, 925 144, 416 143, 808 131, 995 121, 459 120, 774 20

Means searching plot by day of week 21

World Cup 2014 • First task: determine search terms for World Cup: • • • FIFA Soccer Football World Cup Stars such as Messi, Ronaldo • Total number of searches related to soccer and/or the World Cup: • June 21 -July 21: 576 • July 22 -Aug. 21: 506 • Aug. 22 -Sept. 21: 412 22

World Cup 2014—Examples of search terms Search terms "Diary of a Soccer Star" Pele King of Soccer -- Great Britain -- Juvenile Films. argentina soccer a beautiful game World Cup (Soccer) -- History. Colombia soccer team soccer books stars of world cup fifa 2014 xbox soccer cats The story of the World Cup history soccer Soccer Magazines world cup 201$ How Soccer Explains the World Soccernomics world cup colombia 2014 messi soccer Soccer -- Brazil -- History. world cup corruption Soccer -- England -- History. World soccer legends 23

World cup 2014 searched by format • Videogames: includes xbox, wii, pro-evolution soccer, ps 3 & 4, etc. • Videogames: June 21 -July 21: 45% (257 searches) • Videogames: July 22 -Aug. 21: 55% (280 searches) • Videogames: Aug. 22 -Sept. 21: 57% (236 searches) 24

FIFA 15 • June 21 -July 21: FIFA 15 searches: 5 • July 22 -Aug. 21: FIFA 15 searches: 19 • Aug. 22 -Sept. 21: FIFA 15 searches: 51 25

Robin Williams—Died on August 11, 2014 • Bibliocommons searches for Dead Poets Society • June 21 -July 21: 7 • July 22 -Aug. 21: 141 • Aug. 22 -Sept. 21: 58 This image is provided under a creative commons license at https: //www. flickr. com/photos/webmonk 26

Most popular searches Search term harry Harry potter Twilight business divergent dvd ps 3 & ps 4 English Stephen Stewart minecraft google Game of thrones Fault in our stars (including The fault in our stars) Frozen Captain America Frequency > 6194 2619 > 3234 > 2979 > 2032 > 1745 > 1675 > 1539 > 1420 > 965 > 893 > 863 > 772 > 688 > 400 27

EPL’s long tail: Number of searches for “vegan”- 452 ▫ Number of searches with one unique search: 372 vegan 5 30 minute vegan 1 Vegan vegan becoming vegan eat vegan on $4 a day Mayim's vegan table vegan cooking Vegan Cooking. vegan cupcakes veganist 100 gluten free vegan 22 day vegan 4 4 3 3 3 2 2 2 2 2 1 1 30 minute vegan taste of europe 350 best vegan recipes Afro American vegan Afro-Vegan afro-vegan artisan vegan Artisan Vegan Cheese Becoming Vegan BECOMING VEGAN becoming vegan Becoming vegan but i could never go vegan But I Could Never Go Vegan Afro American vegan Afro vegan 1 1 1 1 28

Sun. , June 22, 2014 Sun. , June 29, 2014 29

Mon. , June 23, 2014 Tues. , June 24, 2014 30

Wed. , June 25, 2014 Thurs. , June 26, 2014 31

Fri. , June 27, 2014 Sat. , June 28, 2014 32

Nature of Seasonal Queries at EPL

Findings: RQ 1: What are the characteristics of seasonal/temporal queries in a large public library system? 34

35

36

Comparison between the two datasets (Oct. 6 – 9; Oct. 10 – 12, 2014) Category Total Percentage Oct. 6 -9 Percentage Oct. 10 -12 100% Title- Adult 22. 70% 20. 77% Youth Material 10. 92% 12. 29% Author 12. 10% 12. 18% Nonfiction 11. 21% 11. 46% Unknown 15. 50% 11. 44% Movies/TV shows/ NF DVDs 7. 91% 8. 54% Music 5. 85% 7. 67% Movie or book 2. 43% 3. 13% Format 2. 30% 2. 75% Games 1. 59% 2. 06% Actor/director/TV personality/Comedian 1. 20% 1. 37% 37

Tools for Data Analysis & Visualization

https: //data. edmonton. ca

EPL Open data https: //data. edmonton. ca

Number of holds by EPL branch

Comments made by readers of Twilight on EPL Catalogue (Tagxedo) 44

Medicine Hat Public Library Collection Management Policy

Putting library data to work Data is useful for: – Story telling – Exploring novel ways of providing new services and programs – Supports assessment activities – Evidence-based demonstration of the value of library services – Formulating new research questions

We wish to thank Pilar Martinez and Peter Schoenberg for granting access to EPL search data and for feedback regarding this project. We also wish to thank our research assistants Lydia Zvyagintseva, Claire Tunney, and Corina Surcel for all their hard work.

Thank you for your attention! Ali Shiri: ashiri@ualberta. ca Tami Oliphant: toliphan@ualberta. ca