The size of the data Concord Direct wanted to report on belied the complexity of their requirements. A simple three field file of 10 year giving history needed to be rolled up by dynamic periods of time and several segmentation schemes that members moved in and out of depending on their giving history. A dozen or so metrics were needed with some presented as year-to-date and others by time period.
Finally the ability to forecast and also drill down into sophisticated charts and tables. A full suite of reports would be needed at any given time for any number of clients.
On the surface this all sounded reasonable enough. The devil was most definitely in the details.