ArticlesBase.com - Free Articles Directory
Free Online Articles Directory
07.10.2008 Sign In Register Hello Guest
Email:
Password:
Remember Me 
forgot your password?


When Business Data Goes Bad!

Author: David Badurina Author Ranking Blue | Posted: 08-09-2006 | Comments: 0 | Views: 158 | Rating:  (50) Article Popularity - Green (?) Got a Question? Ask.
Sign Up Now!

Every business collects data. Whether it's something as simple as keeping track of contacts or as complicated as a full-scale inventory, data is vital to every businesses' bottom-line.

All important data is stored in some sort of database – sometimes it's a small Microsoft Access database or an enterprise-level Oracle database – but the database is always the nerve-center of the business.

Any statistic you need or information you must find can be extracted from a properly designed database. And that's the key: there is only one correct way to design databases.

This is where many businesses run into trouble. Errors occur, data is wrong, and headaches abound when a database isn't designed following a strict set of rules. How do you know if your database isn't designed well? Think about your business and answer these questions:

1. Are you keeping track of information in Microsoft Excel?
If you're only keeping track of information in Microsoft Excel, then you're not using a database. Excel is wonderful for crunching numbers, but not for storing related data. Using Excel as a database, even for basic information, is like using a hammer for brain surgery. Technically it's possible, but it's not the right tool, and you'll likely end up with a massive headache when you're done.

2. When entering information, do you repeatedly type the same word or phrase?
A tell-tale sign of bad databases is the need to purposely duplicate data. For example, entering someone's name in two different places means the database is designed improperly, creating an environment that's doing more harm than good. Typos always happen, but in a well-designed database they don't create nearly as much trouble.

3. Do you have to work hard to get simple statistics?
This is the ultimate test of bad business data. If something as simple as showing all sales from last month or showing all of your contacts that live in a specific town takes you more than 10 seconds to accomplish, your time is being wasted.

So what happens when you find your database lacking? The best plan for moving forward is to organize all of your information. Write down what you currently track (either on paper or digitally), what you would like to keep track of, and what you need your information to tell you.

Once you have a handle on what information your business relies on, you can begin planning to have a database designed, or start shopping for industry-specific software. Always remember, designed well, a database can save your business time, money and frustration. Designed poorly, and they'll hurt like a hammer to your head.

Rate this Article: Current: 0 / 5 stars - 0 vote(s).

Article Source: http://www.articlesbase.com/non-fiction-articles/when-business-data-goes-bad-53873.html

Print this Article Print article   Email to a Friend Send to friend   Publish this Article on your Website Publish this Article   Send Author Feedback Author feedback  
About the Author:
David Badurina, President of Blue Moose Technology, LLC, is a relational database design expert specializing in turning hideous data nightmares into efficient, intuitive database applications. Watch David's database design tutorial videos right now at www.bluemoosetech.com.
Submitting articles has become one of the most popular means of generating quality backlinks and targeted traffic to your website. Join us today - It's Free!

Article Comments

Comment on this article Comment on this article
Your Name
Your Email:
Comment Body
Enter Validation Code: Captcha


Got a Question? Ask.

Ask the community a question about this article:

Frequently Asked Questions

MS Access Database that Retrieves and opens .pdf files
By: janell | 25-08-2008
How do I create an Access Program or Database that will pull up a .pdf file that I designate using an Access form?  I took a class on access and Visual Basic 11 years ago, but don't remember how it works.

What are all the real time issues in a real time ...
By: anil | 23-06-2008
what are all the real time issues in a real time supporting project using hyperion essbase 9.3.1

Where can i can get a statement of account?
By: kryptoBran | 29-05-2008
where can i can get a statement of account?

Problem in Microsoft Access
By: simino | 28-04-2008
How can I assign a value of my choice to a Microsoft Access table?Thanks.

Asynchronous jobs in sql server
By: beytz | 02-01-2008
Is there a way to run asynchronous jobs in sql server?I'm looking for an equivalent to Oracle's dbms_job.

What is simple for the user is complex for the developer...
By: drabsv | 20-04-2007
More often than not, an intuitive interface, an easy to navigate database, a good product design are simple to the end user at the expense of being too complex (a task) to the developer. Do you know some products (web sites, databases, physical products) that are both user-friendly and easy to produce/ maintain on the developer side?

Q&A Powered by:
Powered by Yedda 

Latest Non-Fiction Articles

Book Marketing: the Day That is Different for Your Career Strategy
By: Rosey Dow | 06/10/2008
Make an informed decision about the direction of your writing career--print or online, or both.

In the Lap of the Gods 22
By: Steve Morgan | 05/10/2008
For those who have read the other 21 chapters

A Week in the Life of the Single Working Mother
By: Karen Dosw | 03/10/2008
A humorous article about a week in the life of one South African, single mom with two adult children and two little ones.

Why You Should Write for Free
By: Deborah Owen | 01/10/2008
Write for free? I can hear you saying, “Are you nuts?” Write for free, so you can get paid. Read more inside.

Why You Should Write for Free
By: Deborah Owen | 01/10/2008
You asked if they had a job opening. They said no. They told me “no”, too, but I got the job anyway. Read more inside.

Becoming a Reporter is Easy
By: Deborah Owen | 01/10/2008
Do you want to be a reporter? It’s a great way to break into print, and the jobs aren’t that hard to get. Read this article to learn more.

Writing it Down
By: Galina Nemirovsky | 29/09/2008
Lately I’ve developed a compulsion to write everything down. Stringing words together and composing sentences in the shower, I want to write it all down – remember it – capture it. I stare at people in the subway and craft their character descriptions in my head...

The Modern Lily Tomlin
By: Galina Nemirovsky | 29/09/2008
I’m waiting in a conference room that smells like the corner of career aspiration and stale office carpet. The overly heavy and overly bitter receptionist has a voice that is piercing through the makeshift conference room with walls that only go up about 7 feet. Like an annoying hiccup, she keeps repeating “Good morning, Hudson. Your name? Hold please.” Over and over again. She is an extra large version of what the rest of the world has automated already.

More from David Badurina

Marketing Lessons From a Rabid Chipmunk
By: David Badurina | 28/08/2006 | Marketing
What can a ferocious, acorn-hunting chipmunk in suburbia teach you about marketing and business? Plenty, and it's quite a cautionary tale ...

Magical Marketing Juice - REVEALED!
By: David Badurina | 28/08/2006 | Viral Marketing
We have finally discovered the most sought-after concoction known to mankind - Magical Marketing Juice! But ... what does it taste like?

Don't Fear the F-Word!
By: David Badurina | 28/08/2006 | Online Promotion
"Free" might be a four-letter word to customers and to business owners, but if you strike the right balance it can lead to relationships that are profitable for years to come!

The Secrets of Ownership Selling
By: David Badurina | 28/08/2006 | Online Promotion
One of the most powerful emotions related to sales is ownership. Master this, and you'll turn prospects into buyers in no time.

Article Categories






Give Feedback

Sign up for our email newsletter

Receive updates, enter your email below