BI Rationalization

1. BI Rationalization Simplification & Standardization Presented by: Vince Belanger

2. TODAY’S ROADMAP • Current State of Market • BI Rationalization • Why Oracle? • Why TUSC?

3. Current State- Market Direction The primary focus for IT Directors and CIO’s in the Business Intelligence domain is to reduce internal and overhead (I&O) cost through: • Unified BI Solutions • Sharing between departments • Reduction in BI Shelf ware • Leverage what has already been created • Realize ROI, which was original intent - Gartner Group

4. A growing number of clients realize the value of enterprise-wide BI deployments “How widespread is your organization’s adoption of BI, data warehousing, and data integration initiatives?” Base: 82 IT decision-makers(percentages do not total 100 because of rounding) Source: August 2008 Global BI And Data Management Online Survey

5. DW/BI TOOL The Evolution of BI Tools: What happened? Sales & Marketing

6. BI Tool 2 BI Tool 2 The Evolution of BI Tools - continued Sales & Marketing Finance

7. Even as BI environment consolidation efforts continue, many still use several BI tools “How many different BI products do you have in your own department, and across the entire enterprise?” Base: 82 IT decision-makers Source: August 2008 Global BI And Data Management Online Survey

8. BI Tool 1 End Result - A Proliferation of Tools Data Warehouse Business Units Data Warehouse Multiple BI Tools Disparate Systems Finance BI Tool 2 Sales & Marketing BI Tool 3 Customer Service Custom Built Reporting Solution Operations

9. BI Tool 1 End Result – High Cost of Support Data Warehouse Business Units Data Warehouse Multiple BI Tools On-going System Cost $1,650,000 Finance $2,300,000 BI Tool 2 Sales & Marketing $1,850,000 BI Tool 3 Customer Service Custom Built Reporting Solution $2,100,000 Total Cost: $7,900,000 Operations

10. Why now is the time to Activate! • Costs, Risks and missed Opportunities • Multiple tools strap organizations with excessive support cost and reduce user adoption. • Economic weakness brings renewed focus on reducing cost. • Inability to differentiate your organization from information driven opportunities. • Organizational growth is constrained without insight provided via accurate and readily available information.

11. Why now is the time – Enabled by Tools! BI Rationalization – Oracle BI Tool Enablement Data warehouse Reporting OLAP Analytics Dashboards Data mining Database ETL Until recently a company would have to purchase multiple tools to meet information delivery needs. This is no longer the case. Product 1 Prod. 2 Product 2 Pre 2007 Product 3 Product 4 Product 5 2007+ Oracle

12. Microsoft Office Interactive Dashboards Ad hoc Analysis Proactive Detection and Alerts Reporting & Publishing BI Publisher Financial Reporting Interactive Reporting SQR Production Reporting Web Analysis Common Enterprise Information Model Oracle BI Server SetGoals Plan Align InsightPerformanceAction Financial Performance Management Applications DataWarehouse Data Mart SAP, Oracle PeopleSoft, Siebel, Custom Apps Files Excel XML Report Monitor OLTP & ODS Systems Business Process HyperionEssbase Analyze answers the call Oracle BI Suite Enterprise Edition Plus

13. Rationalized BI Organization Business Units Data Warehouse Reduced BI Tools On-going System Cost Reduction of $1,650,000 Finance $2,300,000 BI Solution 2 Sales & Marketing Reduction of $1,850,000 Customer Service $2,100,000 Custom Built Reporting Solution Total Cost: $4,400,000 Savings of: $3,500,000 Operations

14. TUSC cuts conversion costs and time by up to 50%. The struggle of standardization Standardizing on a single business intelligence (BI) reporting and analysis solution is a good idea in theory . . . companies can save money by standardizing but must plan for a long, slow migration that may not be practical. (Forrester Research)

15. Don’t hide, TUSC can help

16. TUSC answers the call with Rolta Business Intelligence Exchange A proven Methodology paired with industry leading tool kits that systematically coverts one BI reporting environment into another. Saving 30% - 50% less time versus manual effort.

17. Utility that automates migration of: • Queries • SQL • Reports • Data Models • Rules • Interactivity • Universes rBIX Our Approach – Roadmap to Rationalization: Migration time and Expense Reduced by up to 50% Data and Technology Assessment Road Map Development Cleansing Environment Conversion to Target Platforms

18. Roadmap to BI Rationalization Inception Elaboration Transition Transition Construction Iteration (X) Plan Analyze & cleanse Design Convert & Build Test Deploy Project Definition & Scope & Milestones Current architecture review Design Logical Data Model Build Technical Infrastructure Plan Parallel & System Testing Plan Deployment Build Universe/ Data Model Deploy to Production Design Output Templates Execute Parallel & Integration Testing Identify Redundancy and Commonality BI Assessment and Solution Framework Create target output from conversion Design Data Mappings Conduct Training User Acceptance Testing Design Technical Architecture Stakeholder Identification Resource Plan Establish Test Strategy Report Creation Plan Operations Support Design Universe Presentation Layer Quality Assurance

19. During Inception Phase: The Cost JustificationBaseline Cost Structure Based on Industry Averages typical BI spend per 1000 user, 500 report deployments incur the following cost structures: Using we can consolidate this platform in 2,500 hours and at a cost of $425,000. That is clear concise ROI Justification upfront! Saving your organization more than $600K in first year!

20. rBix Rationalization Manual vsCost Estimate In comparison here is the cost to consolidate this platform doing a completely manual conversion compared to using CUT TIME & COST IN HALF!

21. Roadmap to BI Rationalization Inception Elaboration Transition Transition Construction Iteration (X) Plan Analyze & cleanse Design Convert & Build Test Deploy Project Definition & Scope & Milestones Current architecture review Design Logical Data Model Build Technical Infrastructure Plan Parallel & System Testing Plan Deployment Build Universe/ Data Model Deploy to Production Design Output Templates Execute Parallel & Integration Testing Identify Redundancy and Commonality BI Assessment and Solution Framework Create target output from conversion Design Data Mappings Conduct Training User Acceptance Testing Design Technical Architecture Stakeholder Identification Resource Plan Establish Test Strategy Report Creation Plan Operations Support Design Universe Presentation Layer Quality Assurance

22. Our solution programmatically reads all BI metadata about each report object in source system and seamlessly translates that definition into the target platform report object. Construction-Conversion Phase: Our Proprietary Tool Kits – Power to the Solution

23. BI Rationalization – Final Result • Results of moving to a single BI platform: • Transparency into total cost of ownership (TCO) and will lead to clear ROI determination. • Single view of company business. • Increase user base. • Significant reduction in TCO. • Leveraging a tool that best meets the needs of the business. • Effort to move to single BI Platform with TUSC recovered in 0-3 years. Hard ware costs Software Costs Support and Maintenance BI Functionality TCO BI Architecture & Scalability Data Architecture User Training Time to Implement

24. BI Rationalization Success Stories • SITUATION: • Dissatisfied with current BI software • Expiring maintenance contract; cost about to increase by 135% • Four months to select vendor and convert existing environment • 500 users on legacy (Cognos) software • SOLUTION: • Developed requirements and assisted in vendor selection • Implemented new environment • Transitioned from Cognos to Oracle • RESULT: • Automated conversion of 90% of reports within four months • Reduced annual cost by $435,000 and improved user satisfaction • Increased consistency and credibility of data • Increased user base (for Oracle) by 20%

25. BI Rationalization Success Stories, cont. SITUATION: • Customer paying to support, maintain, and develop multiple BI reporting environments • Users unsure which system to leverage for various reporting needs • Concern about cost and time to consolidate to one BI environment SOLUTION: • Rolta EICT developed road map to reduce steep costs and user conversion by consolidating to one target Oracle BI Platform • Transitioned customer from Microstrategy and others to Hyperion RESULTS: • Completed originally estimated 15 month engagement in 6 MONTHS • Consolidated 3500+ reports into 40 reports! • Cut software maintenance fees by $450,000 (by ending Microstrategy agreement) • Eliminated production and back up servers required for Microstrategy environment • Reduced dedicated time of support and development staff to free up for new initiatives • Increased consistency and credibility of data • Eliminated “user confusion” making the lines of business more productive in a single environment

26. BI Rationalization: Now is the Time! • High Costs • Information Silos • BI is a barrier instead of an enabler • Clear ROI Justification • Programmatic Migration of BI Content • Assists every step of the way • Major Organizational Cost Savings • Create a streamlined and agile enterprise • Drive efficiency and competitive differentiation in market

27. THANK YOU FOR YOUR TIME TODAY!Contact InfoVincent BelangerTUSCPartner – BI & Data Managementbelangerv@tusc.com