Record:   Prev Next
作者 Hogarth, Margaret
書名 Data Clean-Up and Management : A Practical Guide for Librarians
出版項 Witney : Elsevier Science & Technology, 2012
©2012
國際標準書號 9781780633473 (electronic bk.)
9781843346722
book jacket
說明 1 online resource (579 pages)
text txt rdacontent
computer c rdamedia
online resource cr rdacarrier
系列 Chandos Information Professional Ser
Chandos Information Professional Ser
附註 Cover -- Data Clean-up and Management: A practical guide for librarians -- Copyright -- Contents -- List of figures -- List of tables -- About the authors -- 1 Introduction (why this book is needed) -- What makes this book unique? -- Why library data is important -- The book's outline -- 2 Commonalities -- Microsoft Office Excel -- MarcEdit -- Microsoft Access -- XML -- Commonalities -- Capture and use -- Standardization -- Data import issues -- Technical skills -- Project management challenges -- 3 Defining data -- Rule 1: define data points -- Rule 2: apply data point definitions -- Rule 3: count the right apples -- Rule 4: avoid capturing redundant data -- 4 Types of data issues -- Microsoft Excel vs Microsoft Access -- General data-handling edicts -- Data issues: importing data -- 5 Microsoft Excel techniques -- Creating datasheets -- Selecting cells -- Copying -- Sorting -- Filter -- AutoSum -- Sum -- Fill -- 6 Data clean-up in Excel -- Common dirty data scenarios -- The usefulness of delimiting -- System limitations -- Removing extra characters -- 7 Excel: combining data -- IF statements -- The TEXT function -- PivotTables and filtering -- VLOOKUP -- HLOOKUP -- MATCH -- 8 Additional tools -- PDFs -- Notepad -- Microsoft Word -- Global update in an integrated library system -- Regular expressions -- Excel -- Access -- Macros -- XML -- MarcEdit -- The MARC tools window -- 9 Access techniques -- What is a database? -- Access -- Planning a database -- Preparing data for a database -- Adding a table to a database -- 10 Access forms -- Types of form -- Parts to a form -- Form controls -- Validating data -- Option buttons -- Combo boxes -- ActiveX controls -- Tab control techniques -- Multiple-table forms -- Command buttons -- 11 Access reports -- 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 -- 12 Access queries -- Sorting in Access -- Filtering in Access -- Queries -- Entering data -- Query properties -- Access relationships -- 13 Data clean-up in Access -- Prevention is the best cure -- Extra characters -- Access data upload errors -- ISSN issues -- 14 Access - combining data -- Combining data from one or more data 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 -- 15 Strategies for missing data -- Resources are missing ISBNs -- Resources are missing ISSNs -- Richard Jackson's OCLC look-up strategy -- 16 Qualitative data -- The definition of qualitative data -- Qualitative data is valuable -- Types of qualitative data -- Qualitative data techniques -- SWOT analysis -- Tools -- The whole picture -- 17 ROI -- 18 Data collection and analysis -- 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 -- 19 Data quality policy -- Poor data quality -- Data as an asset and a product -- Apply quality principles -- Process design -- Framework for a data quality policy -- 20 Next steps -- Appendix 1: Excel techniques -- Appendix 2: Excel functions -- Appendix 3: Access quick keys -- Appendix 4 : Redman's model data policy -- Overall -- Centralized functions
Throughout the enterprise -- Suppliers and creators of data -- Those who store and process data -- Users -- Bibliography and references -- Index
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
Description based on publisher supplied metadata and other sources
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2020. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries
鏈接 Print version: Hogarth, Margaret Data Clean-Up and Management : A Practical Guide for Librarians Witney : Elsevier Science & Technology,c2012 9781843346722
主題 Libraries -- Data processing.;Data editing
Electronic books
Alt Author Furuta, Kenneth
Record:   Prev Next