國立虎尾科技大學 |

How libraries should manage data = practical guidance on how with minimum resources to get the best from your data /

Record Type:	Language materials, printed : Monograph/item
Title/Author:	How libraries should manage data/ Brian Cox.
Reminder of title:	practical guidance on how with minimum resources to get the best from your data /
Author:	Cox, Brian,
Published:	Waltham, MA ;Chandos Publishing is an imprint of Elsevier, : 2016.,
Description:	1 online resource (ix, 137 p.) :ill. :
Notes:	Includes index.
Subject:	Libraries - Evaluation. -
Online resource:	https://www.sciencedirect.com/science/book/9780081006634
ISBN:	9780081006719 (electronic bk.)

How libraries should manage data = practical guidance on how with minimum resources to get the best from your data /
Cox, Brian,

How libraries should manage datapractical guidance on how with minimum resources to get the best from your data /[electronic resource] :Brian Cox. - Waltham, MA ;Chandos Publishing is an imprint of Elsevier,2016. - 1 online resource (ix, 137 p.) :ill. - Chandos information professional series.. - Chandos information professional series..

Includes index.

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!

Have you ever looked at your Library's key performance indicators and said to yourself "so what!"? Have you found yourself making decisions in a void due to the lack of useful and easily accessible operational data? Have you ever worried that you are being left behind with the emergence of data analytics? Do you feel there are important stories in your operational data that need to be told, but you have no idea how to find these stories? If you answered yes to any of these questions, then this book is for you. How Libraries Should Manage Data provides detailed instructions on how to transform your operational data from a fog of disconnected, unreliable, and inaccessible information - into an exemplar of best practice data management. Like the human brain, most people are only using a very small fraction of the true potential of Excel. Learn how to tap into a greater proportion of Excel's hidden power, and in the process transform your operational data into actionable business intelligence.

ISBN: 9780081006719 (electronic bk.)Subjects--Topical Terms:

863900
Libraries
--Evaluation.Index Terms--Genre/Form:

554714
Electronic books.

LC Class. No.: Z678.85 / .C69 2016eb

Dewey Class. No.: 025.1

How libraries should manage data = practical guidance on how with minimum resources to get the best from your data /
LDR:04266cam a2200325 a 4500 001 1000594
006 o d
007 cnu|unuuu||
008 201225s2016 maua o 001 0 eng d
020 $a 9780081006719 (electronic bk.)
020 $a 0081006713 (electronic bk.)
020 $a 9780081006634
020 $a 0081006632
035 $a (OCoLC)920673608
035 $a EL2020413
040 $a N$T $b eng $c N$T $d N$T $d YDXCP $d OCLCO $d IDEBK $d OCLCO $d CDX $d OPELS $d OCLCO $d EBLCP $d OCLCO $d OSU $d OCLCO $d COO $d OCLCO $d VLB $d OCLCA $d DEBSZ $d OCLCQ $d VT2 $d U3W $d OCLCF $d INT $d OCLCQ $d COCUF $d AU@ $d OCLCQ
041 0 $a eng
050 4 $a Z678.85 $b .C69 2016eb
082 0 4 $a 025.1 $2 23
100 1 $a Cox, Brian, $e author. $3 1293284
245 1 0 $a How libraries should manage data $h [electronic resource] : $b practical guidance on how with minimum resources to get the best from your data / $c Brian Cox.
260 $a Waltham, MA ; $a Kidlington, Ox, UK : $b Chandos Publishing is an imprint of Elsevier, $c 2016.
300 $a 1 online resource (ix, 137 p.) : $b ill.
490 1 $a Chandos information professional series.
500 $a Includes index.
505 0 $a 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!
505 8 $a 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
505 8 $a 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
505 8 $a 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
520 $a Have you ever looked at your Library's key performance indicators and said to yourself "so what!"? Have you found yourself making decisions in a void due to the lack of useful and easily accessible operational data? Have you ever worried that you are being left behind with the emergence of data analytics? Do you feel there are important stories in your operational data that need to be told, but you have no idea how to find these stories? If you answered yes to any of these questions, then this book is for you. How Libraries Should Manage Data provides detailed instructions on how to transform your operational data from a fog of disconnected, unreliable, and inaccessible information - into an exemplar of best practice data management. Like the human brain, most people are only using a very small fraction of the true potential of Excel. Learn how to tap into a greater proportion of Excel's hidden power, and in the process transform your operational data into actionable business intelligence.
588 $a Description based on print version record.
650 0 $a Libraries $x Evaluation. $3 863900
650 0 $a Quantitative research $x Libraries. $3 1293285
655 4 $a Electronic books. $2 local $3 554714
830 0 $a Chandos information professional series. $3 933702
856 4 0 $u https://www.sciencedirect.com/science/book/9780081006634