Keep it Data

Everyone’s heard of the KISS principle. Introducing the KID principle.

How many times have you heard someone say “I need a Report”?
If you’re like me the answer is way too often.

Over time users have been conditioned to believe that if they just had one more report they could get what they needed. Maybe a report sorted this or that way or maybe a report aggregated at a certain level. And by the way, IT folks aren’t immune from this report frenzy either. They are all too willing to crank em out to the point where one report becomes virtually indistinguishable from another.

So how would you obtain needed information without these reports? After all, sometimes you need things sorted this way and sometimes you need them summed at this level and sometimes you only need information for  a specific region. What in the world would you do without these various reports?

The answer, in a word is KID, Keep It Data. Keeping your information as data, and not a picture, will allow you to do anything you want with it.  You can sort it and aggregate it to your heart’s content.  Rather than having 28 reports that all essentially extract from the same tables you could have one query that pulls in the data, allowing you to begin your manipulation.

As an added bonus you can actually get away with NOT having to re-key your data into a workbook environment. I have to laugh when I see people running reports, then manually keying information from those reports into a spreadsheet. I guess folks like upping the odds that something will go wrong.

I contend that if users would learn data manipulation techniques they wouldn’t need a gazillion reports, their error rate would drop to virtually zero, and they would get their tasks done much more quickly. With data extraction and a little VBA inside Excel, you can save a lot of time.

If you’re an Access guru who uses that environment because you thought it to be a handy way to extract data, then check out the Tutorial Videos on Queries. This is especially true if you turn right around and port that data into Excel.

You’re already using information; the only question remaining is whether or not to …… Keep it Data.

Check out the Tutorial videos associated  with The Data Wand. See if you think the KID principle is right for you.

Posted in: Featured on August 1st by admin

No comments yet

No comments yet.

RSS feed for comments on this post.

Sorry, the comment form is closed at this time.