It can take a lot of effort to "do things right" when that means figuring out
convoluted and undocumented legacy report code.
But issues add up over time, and eventually it's time for an overhaul.
How can you make sure your code stays clean
from now on?
The keys are to
1) Use Data Mart ETL to establish a stable code base, and
2) Document coding standards in a data dictionary.
Managing your reporting code can become a challenge when multiple
people work on it over time. Especially if they have
varying skill levels.
One thing that can help is to create and document standard methods
for including key metrics and other items in reports.
Another area to consider is
SQL Training for the people who develop and maintain your reporting code base.