Library Hours
Monday to Friday: 9 a.m. to 9 p.m.
Saturday: 9 a.m. to 5 p.m.
Sunday: 1 p.m. to 9 p.m.
Naper Blvd. 1 p.m. to 5 p.m.
Limit search to available items
Results Page:  Previous Next
Author Cox, Brian, author.

Title How libraries should manage data : practical guidance on how, with minimum resources, to get the best from your data / Brian Cox. [O'Reilly electronic resource]

Publication Info. Waltham, MA : Chandos Publishing, [2016]
QR Code
Description 1 online resource (1 volume) : illustrations
Series Chandos information professional series
Chandos information professional series.
Note Includes index.
Contents Front Cover; How Libraries Should Manage Data; Copyright Page; Dedication; Contents; About the author; 1 Introduction; 2 Lifting the fog; First steps -- project management; 3 Step away from the spreadsheet -- common errors in using spreadsheets, and their ramifications; The ten table commandments; 4 Starting from scratch; How low do you go?; Measuring loans and accounting for variation; Visits and how to organize the data into columns; Browsed items and avoiding false conclusions; 5 Getting the most out of your raw data; Keep it simple stupid!
Make it easy stupid! Absolute and relative formulasFormulas you must know; Typical error messages and what they mean; Managing error messages; 6 Stop, police!; Protecting data; Data validation; Using tables; Using a table to populate a validation list; Dependent lookups; 7 Pivot magic; How to create a pivot table; Anatomy of a pivot table; Bringing it all together; Set up the Contents sheet; Set up the Pivot sheet; Set up the RawData sheet; Set up the Validation sheet; Done!; 8 Moving beyond basic pivots; Relational databases; PowerPivot; How to use PowerPivot; Adding calculated columns.
Creating a PowerPivot PivotTableThe difference between a measure and a calculated column; Adding a measures; 9 How to create your own desktop library cube; Making the "desktop cube"; Sourcing the datasets; Using MS Access to create a merged dataset; Linking PowerPivot to the merged dataset; Adding a few more tables; IP address table; Resources table; Frequency table; Date table; Adding calculated columns to PowerPivot; FormattedDate; ResourceUsed; KeyMinutesActive; FrequencyMinutesTotal; KeyYearMonthDay; FrequencyMinutesDay; Location; GroupMinutesDay; GroupMinutesTotal; Creating relationships.
Writing measuresDistinctStudents; MinutesActive; AverageMark; Some suggested views; Minutes of usage by resource accessed and faculty; Frequency distribution of student usage of resources by faculty; Frequency usage by hours; Average mark by frequency of library usage; 10 Beyond the ordinary; Index; Back Cover.
Subject Libraries -- Evaluation.
Quantitative research -- Libraries.
Libraries -- Evaluation. (OCoLC)fst00997397
Genre Electronic books.
Added Title Practical guidance on how, with minimum resources, to get the best from your data
Other Form: Print version: Cox, Brian. How Libraries Should Manage Data : Practical Guidance On How With Minimum Resources to Get the Best From Your Data. : Elsevier Science, ©2015
ISBN 9780081006719
Patron reviews: add a review
Click for more information
No one has rated this material

You can...
- Find similar reads
- Add a review
- Sign-up for Newsletter
- Suggest a purchase
- Can't find what you want?
More Information