• so we can do reporting from our numerous sources

    Consider whether you just want a more convenient place to perform system specific operational reporting, or whether you want to match and conform data across different systems, and thereby derive more enlightening KPI's (i.e. Department Cost from your Finance System / headcount from your HR system)

    This might flush out some more specific requirements, and your data warehouse should be driven primarily by business requirements.