Reporting projects are the kind of projects which never seem to end. After a couple iterations I’ve come to the following conclusions:

Absolutely no reports should run on a production database.
Moving/aggregating data from a production database to a reporting database using ETL tools prone to synchronization issues and pretty unreliable.
The best option is to set…