Turning Spreadsheets into Corporate Data

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