Turning Spreadsheets into Corporate Data by Bill Inmon

Turning Spreadsheets into Corporate Data

byBill Inmon

Paperback | April 28, 2017

Pricing and Purchase Info

$29.25 online 
$32.50 list price save 10%
Earn 146 plum® points

Prices and offers may vary in store

Quantity:

In stock online

Ships free on orders over $25

Not available in stores

about

For years, business users have leveraged spreadsheets for storing and communicating data. Although spreadsheets may be easy to create and update, making important corporate decisions based on spreadsheets is risky due to the lack of data credibility. Whether you are a manager, developer, end user, or student, this book will help you turn spreadsheet data into credible, useful, reliable data that can be trusted in order to make important decisions.

A chapter is dedicated to each of the following topics:

  • Brief history of spreadsheets
  • Spreadsheet paradox
  • Spreadsheet varieties
  • The PDF spreadsheet
  • Spreadsheet formatting
  • Spreadsheet disambiguation
  • The intermediate database
  • The ssdef database
  • The corporate database
  • The metadata database (mnemonic database)
  • Political considerations
  • Data modeling and the spreadsheet
  • Case study
Title:Turning Spreadsheets into Corporate DataFormat:PaperbackDimensions:130 pages, 9 X 6 X 0.28 inPublished:April 28, 2017Publisher:Technics Publications, IncorporatedLanguage:English

The following ISBNs are associated with this title:

ISBN - 10:1634622286

ISBN - 13:9781634622288

Appropriate for ages: All ages

Look for similar items by category:

Table of Contents

INTRODUCTION 1 1: BRIEF HISTORY OF SPREADSHEETS 5 THE IT LABYRINTH 6 END USER ACCEPTANCE OF THE SPREADSHEET 7 SPREADSHEET HELL 8 A TRADEOFF 9 RESPONSIBILITY—THE FLIP SIDE OF CONTROL 10 MANAGEMENT’S PROBLEM 10 DIFFERENCES BETWEEN TWO TYPES OF DATA 11 IN SUMMARY 11 2: SPREADSHEET PARADOX 13 PUBLIC DATA 13 THE SPREADSHEET AS A MEDIUM OF EXCHANGE 14 RECURRING/NON-RECURRING SPREADSHEETS 15 THE SPECTRUM OF SPREADSHEETS 16 THE COST OF TRANSFORMING A SPREADSHEET 18 FACTORS OTHER THAN COST 20 TRANSCRIPTION OF DATA 21 CELL FORMULA 21 SPREADSHEET DESCRIPTORS 22 ARTIFICIALLY SUPPLYING DESCRIPTORS 24 IN SUMMARY 24 3: SPREADSHEET VARIETIES 27 SIMPLE DEMARCATION—XLSTAB 28 OTHER SPECIAL CHARACTERS—EOLD AND LINEFEED 29 THE INTERNAL VIEW OF A SPREADSHEET 30 A MISSING COLUMN HEADING 31 A MISSING VALUE 32 A MULTILINE ROW 33 THE “STANDARD” SPREADSHEET FORMAT 34 MANAGING THE USER OF THE SPREADSHEET 35 THE SSDEF TABLE 36 THE SPREADSHEET PROCESSING LOG 37 THE LINEAGE OF SPREADSHEET DATA 38 THE CELL FORMULA 39 RELATING TO THE REAL WORLD 39 IDENTIFYING THE HEADER LINE 40 IN SUMMARY 41 4: THE PDF SPREADSHEET 43 THE IMPORTANCE OF SPECIAL CHARACTERS 44 PDF AND OCR 45 A FINAL OPTION 45 IN SUMMARY 46 5: THE BASICS OF SPREADSHEET FORMATTING 47 THE SYSTEM NAME 47 UNRELIABILITY OF REPORT NAME 48 MULTIPLE SHEETS IN A SPREADSHEET 49 OTHER SPECIAL CHARACTERS 49 IDENTIFYING COLUMN HEADINGS 50 SIMILAR COLUMN HEADINGS 50 BLOCKING OFF SECTIONS OF A SPREADSHEET 51 NON-STANDARD SPREADSHEET STRUCTURES 52 A SPREADSHEET THAT CANNOT BE MAPPED 54 A SPREADSHEET IN A TXT FORMAT 54 IN SUMMARY 54 6: SPREADSHEET DISAMBIGUATION 57 SELECTING SPREADSHEETS FOR INCLUSION INTO CORPORATE DATA 57 RECASTING THE SPREADSHEET 59 LOGGING THE SPREADSHEET FOR TRANSFORMATION 59 ENTRY INTO THE PATH QUEUE 60 DEFINING THE SPREADSHEET HEADINGS 60 PAIRING THE SSDEF SPECIFICATION TO THE SPREADSHEET 60 FINDING AND CREATING DATABASE DEFINITIONS AND VALUES 61 THE INTERMEDIATE DATABASE 62 SOME ANOMALIES 62 WHAT IF AN ERROR IS DISCOVERED? 64 MANUAL EFFORT REQUIRED 64 SPREADSHEET WIDTH 65 SUBDIVIDING A SPREADSHEET 65 NO VALUE FOR A COLUMN NAME 66 NO COLUMN HEADINGS 66 CREATING THE SSDEF SPECIFICATION ONCE 66 IN SUMMARY 67 7: THE INTERMEDIATE DATABASE 69 FINDING ERRORS 69 THE CONTENTS OF THE INTERMEDIATE DATABASE 70 FUNCTIONS SERVED BY THE DATA ELEMENTS 71 ALTERNATE NAME 71 ADDING CONTEXT TO DATA VALUES 73 EDITING DATA IN THE INTERMEDIATE DATABASE 73 IN SUMMARY 74 8: THE SSDEF DATABASE 77 ORGANIZING DATA INSIDE THE SSDEF TABLE 77 PROCESSING USING SSDEF RECORDS 78 SEARCHING THE FULL PATH QUEUE 78 IN SUMMARY 79 9: THE CORPORATE DATABASE 81 FROM INTERMEDIATE DATA TO CORPORATE DATA 82 GROUPED CORPORATE DATA 82 TRACING THE LINEAGE 83 IN SUMMARY 83 10: THE MNEMONIC DICTIONARY 85 THE CONTENTS OF THE MNEMONIC DICTIONARY 86 GROUPING LIKE DATA ELEMENTS 86 APPLYING NAMING CONVENTIONS 88 VALUE OF THE MNEMONIC DICTIONARY 88 IN SUMMARY 89 11: POLITICAL CONSIDERATIONS WITHIN THE ORGANIZATION 91 SHIFTING CONTROL 91 IMMUTABILITY OF DATA 92 THE IMPORTANCE OF ALTERNATE NAMES 93 LIMITED EDITING 94 SUPER CLASSIFICATIONS OF DATA 94 THE LINEAGE OF CORPORATE DATA 95 RELATIVE VOLUMES OF DATA 95 IN SUMMARY 95 12: DATA MODELING AND THE SPREADSHEET ENVIRONMENT 97 THE ENTITY RELATIONSHIP DIAGRAM 97 THE DATA ITEM SET 98 THE PHYSICAL MODEL 98 THE DATA MODEL 100 THE DATA MODEL AND SPREADSHEET DATA 100 “CORRECTNESS” OF DATA 101 ALIGNING DATA FROM DIFFERENT SPREADSHEETS 101 AN ALGORITHMIC RESOLUTION 102 AN INDEXED RESOLUTION 102 RESOLUTION AND THE DATA MODEL 103 SPREADSHEET DATA IN THE DATA WAREHOUSE 104 CHANGING SPREADSHEET DATA 105 IN SUMMARY 105 13: CASE STUDY 107 GLOSSARY 113 INDEX 115