I would first suggest reading some articles from the Kimbal group and concentrate on Fact tables - Tranaction, Snapshot and Accumalitve.

You need this understanding to get the measures the reports are requiring.

http://www.kimballgroup.com/