Turning Spreadsheets into Corporate Data

Spis treści książki

• Introduction
• 1: Brief History of Spreadsheets
  • The IT Labyrinth
  • End User Acceptance of the Spreadsheet
  • Spreadsheet Hell
  • A Tradeoff
  • ResponsibilityThe Flip Side of Control
  • Managements Problem
  • Differences Between Two Types of Data
  • In Summary
• 2: Spreadsheet Paradox
  • Public Data
  • The Spreadsheet as a Medium of Exchange
  • Recurring/Non-Recurring Spreadsheets
  • The Spectrum of Spreadsheets
  • The Cost of Transforming a Spreadsheet
  • Factors Other than Cost
  • Transcription of Data
  • Cell Formula
  • Spreadsheet Descriptors
  • Artificially Supplying Descriptors
  • In Summary
• 3: Spreadsheet Varieties
  • Simple Demarcationxlstab
  • Other Special Characterseold and Linefeed
  • The Internal View of a Spreadsheet
  • A Missing Column Heading
  • A Missing Value
  • A Multiline Row
  • The Standard Spreadsheet Format
  • Managing the User of the Spreadsheet
  • The ssdef Table
  • The Spreadsheet Processing Log
  • The Lineage of Spreadsheet Data
  • The Cell Formula
  • Relating to the Real World
  • Identifying the Header Line
  • In Summary
• 4: The PDF Spreadsheet
  • The Importance of Special Characters
  • PDF and OCR
  • A Final Option
  • In Summary
• 5: The Basics of Spreadsheet Formatting
  • The System Name
  • Unreliability of Report Name
  • Multiple Sheets in a Spreadsheet
  • Other Special Characters
  • Identifying Column Headings
  • Similar Column Headings
  • Blocking Off Sections of a Spreadsheet
  • Non-Standard Spreadsheet Structures
  • A Spreadsheet that Cannot be Mapped
  • A Spreadsheet in a TXT Format
  • In Summary
• 6: Spreadsheet Disambiguation
  • Selecting Spreadsheets for Inclusion into Corporate Data
  • Recasting the Spreadsheet
  • Logging the Spreadsheet for Transformation
  • Entry into the Path Queue
  • Defining the Spreadsheet Headings
  • Pairing the ssdef Specification to the Spreadsheet
  • Finding and Creating Database Definitions and Values
  • The Intermediate Database
  • Some Anomalies
  • What if an Error is Discovered?
  • Manual Effort Required
  • Spreadsheet Width
  • Subdividing a Spreadsheet
  • No Value for a Column Name
  • No Column Headings
  • Creating the ssdef Specification Once
  • In Summary
• 7: The Intermediate Database
  • Finding Errors
  • The Contents of the Intermediate Database
  • Functions Served by the Data Elements
  • Alternate Name
  • Adding Context to Data Values
  • Editing Data in the Intermediate Database
  • In Summary
• 8: The ssdef Database
  • Organizing Data Inside the ssdef Table
  • Processing Using ssdef Records
  • Searching the Full Path Queue
  • In Summary
• 9: The Corporate Database
  • From Intermediate Data to Corporate Data
  • Grouped Corporate Data
  • Tracing the Lineage
  • In Summary
• 10: The Mnemonic Dictionary
  • The Contents of the Mnemonic Dictionary
  • Grouping Like Data Elements
  • Applying Naming Conventions
  • Value of the Mnemonic Dictionary
  • In Summary
• 11: Political Considerations Within the Organization
  • Shifting Control
  • Immutability of Data
  • The Importance of Alternate Names
  • Limited Editing
  • Super Classifications of Data
  • The Lineage of Corporate Data
  • Relative Volumes of Data
  • In Summary
• 12: Data Modeling and the Spreadsheet Environment
  • The Entity Relationship Diagram
  • The Data Item Set
  • The Physical Model
  • The Data Model
  • The Data Model and Spreadsheet Data
  • Correctness of Data
  • Aligning Data from Different Spreadsheets
  • An Algorithmic Resolution
  • An Indexed Resolution
  • Resolution and the Data Model
  • Spreadsheet Data in the Data Warehouse
  • Changing Spreadsheet Data
  • In Summary
• 13: Case Study
• Glossary
• Index

pokaż cały spis treści

ukryj recenzje