
How Libraries Should Manage Data
Practical Guidance On How With Minimum Resources to Get the Best From Your Data
Resources
Description
Key Features
- Recognize and overcome the social barriers to creating useful operational data
- Understand the potential value and pitfalls of operational data
- Learn how to structure your data to obtain useful information quickly and easily
- Create your own desktop library cube with step-by-step instructions, including DAX formulas
Readership
This book is aimed at any Library staff responsible for managing or interpreting data. Because it is also meant to be a broad road map on how to use data effectively, this book is also aimed at Executive Library Managers and may also be useful for students undertaking information and library studies.
Table of Contents
- Dedication
- 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 formulas
- Formulas 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
- 8. Moving beyond basic pivots
- Relational databases
- PowerPivot
- How to use PowerPivot
- Creating a PowerPivot PivotTable
- The 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
- Adding calculated columns to PowerPivot
- Creating relationships
- Writing measures
- Some suggested views
- 10. Beyond the ordinary
- Index
Product details
- No. of pages: 150
- Language: English
- Copyright: © Chandos Publishing 2015
- Published: September 4, 2015
- Imprint: Chandos Publishing
- Paperback ISBN: 9780081006634
- eBook ISBN: 9780081006719
About the Author
Brian Cox
Affiliations and Expertise
Ratings and Reviews
There are currently no reviews for "How Libraries Should Manage Data"