What are the best ways to input data for consistency?

4300 pts.
Tags:
Business Intelligence
Consistency Control
data input
As business intelligence and analytics adoption expands within organizations, there's a natural push from business users to add more types of data from disparate sources -- often external ones -- to BI systems. That raises questions about the validity, consistency and overall quality of the data being added.  What are the best ways to make sure that data is input with quality and consistency so that errors in data reporting can be minimized?

Answer Wiki

Thanks. We'll let you know when a new response is added.
The best method of ensuring consistency when it comes to business data would be to use a data validation process. This can be set up as a standardized user interface that runs business logic routines. Within the data validation methods, you can have the methods listed below.

 •  Batch Totals: This allows a program to check for missing records.
 •  Cross-system consistency: The system you set up can check to ensure consistent data in the fields are filled in properly.
 •  Logic Checks: A program that checks the input for logical errors.”

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Abushahd

    In fact, I have migrated the Domino server's OS from win2k3 to win2K8 R2 which reduced the time of Consistency Checking in a remarkable way .

     

    4,050 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following