BI Technical Infrastructure Approach

1. BI Technical Infrastructure Approach May 15, 2013

2. Drivers for Change At a lower, more sustainable cost of ownership

3. Current BI Environment Multiple data warehousing storage methods that contain inconsistent data. No Support for OLAP No consistency in data definitions and business rules Limited ways to view data All reporting needs have to go through Central IT, resulting in bottlenecks Business logic in multiple places and inconsistent with each other. Business logic not transparent to customers Heavy reporting load on transactional systems

4. Design Guiding Principles • Keep it Simple; Eliminate redundancies and failure points • Reduce licensing costs and total cost of ownership • Provide BI self-service capabilities • Promote transparency

5. Future BI Environment Business logic is transparent to customers More visualization choices Consistent business logic in one place Single data warehouse that contains consistent data Support for OLAP Self Service BI Mashup Data! Reduced IT bottlenecks Data is persisted in models; reduced load on transactional systems

6. Migration Plan

7. EXAMPLE - Standardize on Microsoft SQL Server

8. BI Infrastructure – Stakeholder Analysis

9. BI Infrastructure Projects - Timeline