Coverart for item
The Resource How libraries should manage data : practical guidance on how, with minimum resources, to get the best from your data, Brian Cox

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

Label
How libraries should manage data : practical guidance on how, with minimum resources, to get the best from your data
Title
How libraries should manage data
Title remainder
practical guidance on how, with minimum resources, to get the best from your data
Statement of responsibility
Brian Cox
Title variation
Practical guidance on how, with minimum resources, to get the best from your data
Creator
Author
Subject
Language
eng
Member of
Cataloging source
UMI
http://library.link/vocab/creatorName
Cox, Brian
Dewey number
025.1
Illustrations
illustrations
Index
index present
LC call number
Z678.85
Literary form
non fiction
Nature of contents
dictionaries
Series statement
Chandos information professional series
http://library.link/vocab/subjectName
  • Libraries
  • Quantitative research
  • Libraries
Label
How libraries should manage data : practical guidance on how, with minimum resources, to get the best from your data, Brian Cox
Instantiates
Publication
Copyright
Note
Includes index
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
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
Control code
922640781
Dimensions
unknown
Extent
1 online resource (1 volume)
Form of item
online
Isbn
9780081006719
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Other physical details
illustrations
http://library.link/vocab/ext/overdrive/overdriveId
cl0500000651
Sound
unknown sound
Specific material designation
remote
System control number
(OCoLC)922640781
Label
How libraries should manage data : practical guidance on how, with minimum resources, to get the best from your data, Brian Cox
Publication
Copyright
Note
Includes index
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
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
Control code
922640781
Dimensions
unknown
Extent
1 online resource (1 volume)
Form of item
online
Isbn
9780081006719
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Other physical details
illustrations
http://library.link/vocab/ext/overdrive/overdriveId
cl0500000651
Sound
unknown sound
Specific material designation
remote
System control number
(OCoLC)922640781

Library Locations

    • Ellis LibraryBorrow it
      1020 Lowry Street, Columbia, MO, 65201, US
      38.944491 -92.326012
    • Engineering Library & Technology CommonsBorrow it
      W2001 Lafferre Hall, Columbia, MO, 65211, US
      38.946102 -92.330125
Processing Feedback ...