Microsoft Information Technology (MSIT) uses a set of solution patterns which provide a balance between the need to collect and integrate data for its Enterprise Data Warehouse (EDW) and the need to have immediate, tactical solutions. This approach creates a powerful framework for a single commonly supported infrastructure with high data quality and flexibility.