Every few weeks, someone will send me some data.
Most of the time, it winds up being high-level summary data. They'll give me the number of apples sold in a month, but won't send me the log of apples being sold.
What I want is to be given a list of everytime an apple was sold, its weight, the store it was at, who was on the register, and everything.
I'm told this is "too much data". Excel can only do about 65536 rows at any one time (yeah, I've got 2003), but I can edit it down using other desktop tools. Namely, I'd use Access to query it down to what I'm interested in.
Yet, the various Analysis departments I work with (with the notable exception of the Department of Transportation) don't seem to see the utility in having more than the high-level data.
I'm not sure how to make folks become less afraid of a full data sheet. But it needs to happen, so that folks with the know-how will have the tools that they need.
Friday, March 27, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment