Why do reports take hours to put together?

The time usually goes into finding data, cleaning it, matching different formats, and resolving conflicting definitions. Track those steps separately. Once the sources and definitions are stable, automate the collection and transformation so reporting time is spent reviewing the result instead of assembling it.