Skip to main content
View Cart

Data Clean-Up and Management

A Practical Guide for Librarians

  • 1st Edition - October 22, 2012
  • Latest edition
  • Authors: Margaret Hogarth, Kenneth Furuta
  • Language: English

Data use in the library has specific characteristics and common problems. Data Clean-up and Management addresses these, and provides methods to clean up frequently-occurring data… Read more

Early spring sale

Nurture your knowledge

Grow your expertise with up to 25% off trusted resources.

Shop now

Description

Data use in the library has specific characteristics and common problems. Data Clean-up and Management addresses these, and provides methods to clean up frequently-occurring data problems using readily-available applications. The authors highlight the importance and methods of data analysis and presentation, and offer guidelines and recommendations for a data quality policy. The book gives step-by-step how-to directions for common dirty data issues.

Key features

  • Focused towards libraries and practicing librarians
  • Deals with practical, real-life issues and addresses common problems that all libraries face
  • Offers cradle-to-grave treatment for preparing and using data, including download, clean-up, management, analysis and presentation

Readership

Practitioners and students of Library and Information Science

Table of contents

  • List of figures
  • List of tables
  • About the authors
  • Chapter 1: Introduction (why this book is needed)
    • Abstract:
    • What makes this book unique?
    • Why library data is important
    • The book’s outline
  • Chapter 2: Commonalities
    • Abstract:
    • Microsoft Office Excel
    • MarcEdit
    • Microsoft Access
    • XML
    • Commonalities
    • Capture and use
    • Standardization
    • Data import issues
    • Technical skills
    • Project management challenges
  • Chapter 3: Defining data
    • Abstract:
    • Rule 1: define data points
    • Rule 2: apply data point definitions
    • Rule 3: count the right apples
    • Rule 4: avoid capturing redundant data
  • Chapter 4: Types of data issues
    • Abstract:
    • Microsoft Excel vs Microsoft Access
    • General data-handling edicts
    • Data issues: importing data
  • Chapter 5: Microsoft Excel techniques
    • Abstract:
    • Creating datasheets
    • Selecting cells
    • Copying
    • Sorting
    • Filter
    • AutoSum
    • Sum
    • Fill
  • Chapter 6: Data clean-up in Excel
    • Abstract:
    • Common dirty data scenarios
    • The usefulness of delimiting
    • System limitations
    • Removing extra characters
  • Chapter 7: Excel: combining data
    • Abstract:
    • IF statements
    • The TEXT function
    • PivotTables and filtering
    • VLOOKUP
    • HLOOKUP
    • MATCH
  • Chapter 8: Additional tools
    • Abstract:
    • PDFs
    • Notepad
    • Microsoft Word
    • Global update in an integrated library system
    • Regular expressions
    • Excel
    • Access
    • Macros
    • XML
    • MarcEdit
    • The MARC tools window
  • Chapter 9: Access techniques
    • Abstract:
    • What is a database?
    • Access
    • Planning a database
    • Preparing data for a database
    • Adding a table to a database
  • Chapter 10: Access forms
    • Abstract:
    • Types of form
    • Parts to a form
    • Form controls
    • Validating data
    • Option buttons
    • Combo boxes
    • For a Spin Button:
    • Tab control techniques
    • Multiple-table forms
  • Chapter 11: Access reports
    • Abstract:
    • Creating a report using the Report Wizard
    • Controls
    • Making additions to a report
    • AutoFormat a report
    • Working with report properties
    • Inserting a control into a report
    • Conditional formatting
    • Sizing reports
    • Moving controls in Access
    • Publishing reports
    • Sorting and grouping options
    • Adding calculations to reports
    • Launching reports
    • Creating a subreport
  • Chapter 12: Access queries
    • Abstract:
    • Sorting in Access
    • Filtering in Access
    • Queries
    • Entering data
    • Query properties
    • Access relationships
  • Chapter 13: Data clean-up in Access
    • Abstract:
    • Prevention is the best cure
    • Extra characters
    • Access data upload errors
    • ISSN issues
  • Chapter 14: Access -- combining data
    • Abstract:
    • Combining data from one or moredata sources
    • Query with a sum
    • Types of operators
    • Totals queries
    • Parameter queries
    • Action queries
    • Update queries
    • Delete queries
    • Make-Table queries
    • Append queries
    • PivotTable queries
    • SQL in Access
    • Parameter Queries in SQL
    • Export data to Excel
    • Finding unique values in a dataset
    • Matching on ISSN
  • Chapter 15: Strategies for missing data
    • Abstract:
    • Resources are missing ISBNs
    • Resources are missing ISSNs
    • Richard Jackson’s OCLC look-up strategy
    • Chapter 16: Qualitative data
    • Abstract:
    • The definition of qualitative data
    • Qualitative data is valuable
    • Types of qualitative data
    • Qualitative data techniques
    • SWOT analysis
    • Tools
    • The whole picture
  • Chapter 17: ROI
    • Abstract:
  • Chapter 18: Data collection and analysis
    • Abstract:
    • What data do you need to answer the question?
    • Does the data measure what you need to measure?
    • Analysing data
    • Data presentation
    • Charts
    • Stacked charts
  • Chapter 19: Data quality policy
    • Abstract:
    • Poor data quality
    • Data as an asset and a product
    • Apply quality principles
    • Process design
    • Framework for a data quality policy
  • Chapter 20: Next steps
    • Abstract:
  • Appendix 1: Excel techniques
  • Appendix 2: Excel functions
  • Appendix 3: Access quick keys
  • Appendix 4: Redman's model data policy
  • Bibliography and references
  • Index

Review quotes

"This excellent book is highly recommended; it will be keenly sought out and become a well-used tool. Whilst a key text for students of this subject, it is also particularly suited for staff using Excel, Access and other applications to improve the quality of the information available for decision-making."—The Australian Library Journal, Vol. 63, No. 1, 2014

Product details

  • Edition: 1
  • Latest edition
  • Published: October 22, 2012
  • Language: English

About the authors

MH

Margaret Hogarth

Margaret Hogarth is Electronic Resources Coordinator and Subject Specialist for Environmental Sciences, Water and Soils for the University of California, Riverside Libraries. She has a B.A. in English from the University of California, Santa Barbara, an MLIS from San Jose State University and an M.S. in Environmental Studies from California State University, Fullerton. She has been a librarian since 1999.

KF

Kenneth Furuta

Kenneth Furuta, a Reference/Information Technology librarian for the University of California, Riverside Libraries. His B.A. was a double major in Psychology & Music from the University of California, Riverside. In addition to his MLS from the University of Arizona he has a Masters of Administration (emphasis in Management Information Systems) from UC Riverside. He has been a librarian since 1990.
Affiliations and expertise
University of California, USA

View book on ScienceDirect

Read Data Clean-Up and Management on ScienceDirect