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
Creator
Author
Subject
Genre
Language
eng
Summary
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
Member of
Cataloging source
N$T
http://library.link/vocab/creatorName
Cox, Brian
Illustrations
illustrations
Index
index present
LC call number
Z678.85
LC item number
.C69 2016eb
Literary form
non fiction
Nature of contents
dictionaries
Series statement
Chandos information professional series.
http://library.link/vocab/subjectName
  • Libraries
  • Quantitative research
  • LANGUAGE ARTS & DISCIPLINES / Library & Information Science / General
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
Color
mixed
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
Dimensions
unknown
Extent
1 online resource (ix, 137 pages)
Form of item
online
Isbn
9780081006719
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Other physical details
illustrations.
Specific material designation
remote
Stock number
828661
System control number
  • (OCoLC)920673608
  • (OCoLC)ocn920673608
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
Color
mixed
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
Dimensions
unknown
Extent
1 online resource (ix, 137 pages)
Form of item
online
Isbn
9780081006719
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Other physical details
illustrations.
Specific material designation
remote
Stock number
828661
System control number
  • (OCoLC)920673608
  • (OCoLC)ocn920673608

Library Locations

  • African Studies LibraryBorrow it
    771 Commonwealth Avenue, 6th Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Alumni Medical LibraryBorrow it
    72 East Concord Street, Boston, MA, 02118, US
    42.336388 -71.072393
  • Astronomy LibraryBorrow it
    725 Commonwealth Avenue, 6th Floor, Boston, MA, 02445, US
    42.350259 -71.105717
  • Fineman and Pappas Law LibrariesBorrow it
    765 Commonwealth Avenue, Boston, MA, 02215, US
    42.350979 -71.107023
  • Frederick S. Pardee Management LibraryBorrow it
    595 Commonwealth Avenue, Boston, MA, 02215, US
    42.349626 -71.099547
  • Howard Gotlieb Archival Research CenterBorrow it
    771 Commonwealth Avenue, 5th Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Mugar Memorial LibraryBorrow it
    771 Commonwealth Avenue, Boston, MA, 02215, US
    42.350723 -71.108227
  • Music LibraryBorrow it
    771 Commonwealth Avenue, 2nd Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Pikering Educational Resources LibraryBorrow it
    2 Silber Way, Boston, MA, 02215, US
    42.349804 -71.101425
  • School of Theology LibraryBorrow it
    745 Commonwealth Avenue, 2nd Floor, Boston, MA, 02215, US
    42.350494 -71.107235
  • Science & Engineering LibraryBorrow it
    38 Cummington Mall, Boston, MA, 02215, US
    42.348472 -71.102257
  • Stone Science LibraryBorrow it
    675 Commonwealth Avenue, Boston, MA, 02445, US
    42.350103 -71.103784
Processing Feedback ...