Data Management - Adjustments

[rene_at_coco]

I asked a similar question before and maybe that discussion may give you an idea on how to approach your specific situation.

Identify best practices for working with changing data

What will work depends on the skills of the analysts and obtaining the cooperation of gatekeepers like the IT department. The original sin is if the csv files derive from spreadsheets, which are vulnerable to entry errors and untrapped logic. Using a relational data base management system for data entry provides the opportunity for validation to at least prevent errors like entering a literal string $1,023.10 in a numeric field. On the other hand, in addition to user training on data entry, hosting is needed that may not fit comfortably on existing servers and sooner or later a database administrator will be needed to keep the system running. Coming back to Earth, the obvious candidate is …