Book 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.- 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
Table of contents
- Cover image
- Title page
- Table of Contents
- Copyright
- List of figures
- List of tables
- About the authors
- Chapter 1: Introduction (why this book is needed)
- Chapter 2: Commonalities
- Chapter 3: Defining data
- Chapter 4: Types of data issues
- Chapter 5: Microsoft Excel techniques
- Chapter 6: Data clean-up in Excel
- Chapter 7: Excel: combining data
- Chapter 8: Additional tools
- Chapter 9: Access techniques
- Chapter 10: Access 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
- Chapter 13: Data clean-up in Access
-
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
- Chapter 16: Qualitative data
- Chapter 17: ROI
- Chapter 18: Data collection and analysis
- Chapter 19: Data quality policy
- Chapter 20: Next steps
- Appendix 1: Excel techniques
- Appendix 2: Excel functions
- Appendix 3: Access quick keys
- Appendix 4: Redman’s model data policy
- Bibliography and references
- Index
Product information
- Title: Data Clean-Up and Management
- Author(s):
- Release date: October 2012
- Publisher(s): Chandos Publishing
- ISBN: 9781780633473
You might also like
book
Peer to Peer: Collaboration and Sharing over the Internet
“The author has given a well-written and comprehensive overview of several representative peer-to-peer technologies. It is …
book
Data Stewardship for Open Science
Data Stewardship for Open Science: Implementing FAIR Principles has been written with the intention of making …
book
A Data Scientist's Guide to Acquiring, Cleaning, and Managing Data in R
The only how-to guide offering a unified, systemic approach to acquiring, cleaning, and managing data in …
book
Business Metadata: Capturing Enterprise Knowledge
Business Metadata: Capturing Enterprise Knowledge is the first book that helps businesses capture corporate (human) knowledge …