Today at the Worldwide Partner Conference in New Orleans, Microsoft announced a free web-based version of Microsoft Office 2010. Much like Google Docs, Office users will be able to collaborate on the same document at the same time from anywhere, even without Office installed. Users will be able to edit documents from IE, Firefox, Safari, even iPhones.
I’m completely sold on cloud-based collaboration technologies, and I’ve been an avid user of Google Docs for years. It helps me break down walls between internal and external collaborators. Right now, as we speak, several of us are editing a Google Docs spreadsheet to vote on the winners of the Best Thing I Learned At PASS contest. I was able to set up a new document, share it with several people, and get collaboration working without any VPN problems, permissions, file sharing difficulties, you name it. Presto, any one of several people can edit my spreadsheet.
Now replace “contest results” with “P&L statement”, and start asking questions.
Picture your CFO sharing the P&L results with several high-ranking executives. Are all the cells locked? Are you sure? What happens when someone changes numbers? How good is your change tracking? Where did those sales figures come from? Can you show the family tree for any given cell of data?
When I was a data warehouse administrator, end users constantly came up to me and said, “The data’s wrong in the data warehouse. This here number on my report can’t possibly be right.” To troubleshoot it, I had to ask:
- What’s the calculation used to build this number? Are we sure we’re summing when we’re not supposed to average?
- What’s the SQL query used to get the data? Are the joins right? Are the group-bys right?
- Where did the underlying data come from? Did last night’s ETL bring in some bogus data, or is the data wrong in the source system?
Reports built by end users are troublesome enough, but when data can be shared and edited by anyone under open circumstances, change management gets more challenging. In the future, us database administrators will need to pay even more attention to how reports are built and where those numbers are coming from, lest we get thrown under the bus for spreadsheet edits by L337CPA.