- Expanded and optimized Operational Data Store (ODS) which integrates data from banner and other systems to be identified.
- Deploy Enterprise Data Warehouse (EDW) which provides data for end user reporting from Banner and other systems to be identified.
- Packaged and Delivered Enterprise information (see Deliverables Table, below):
- Operational reports using Cognos Business Intelligence Suites
- Analytical reports using Cognos PowerPlayTransformer (OLAP)
- Collaborative Forecasting using IBM TM1 (OLAP)
- Identification, transformation and elimination of shadow systems (see Deliverables Table, below)
- Simplification and standardization of processes and policy (See Deliverables Table, below)
- Project website & communication plan
- Training for ad-hoc report report writing for Subject Matter Experts (SMEs) in central administrative offices
- Report Access and Delivery Policy & Procedures
- Review and optimize existing Cognos reports
- Subscribe to a remote DBA Service to provide DBA back-up assistance
- Evaluate and migrate all required BI Query reports to Cognos and sunset the BI Query tool.