BI Rationalization

1
BI Rationalization

• Simplification Standardization
• Presented by Vince Belanger

2
TODAYS ROADMAP

• Current State of Market
• BI Rationalization
• Why Oracle?
• Why TUSC?

3
Current State- Market Direction

• The primary focus for IT Directors and CIOs in
  the Business Intelligence domain is to reduce
  internal and overhead (IO) 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 organizations 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
The Evolution of BI Tools What happened?
Sales Marketing
6
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
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
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
Analytics
OLAP
Reporting
Data mining
Dashboards
ETL
Database
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
Oracle BI Suite Enterprise Edition Plus
answers the call
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
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
Dont 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
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




Transition
Inception
Elaboration
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 Justification
Baseline 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.

Cost Classification Cost Estimate
Software Support Maintenance (based on 20) 400,000
Hardware Costs 300,000
Internal Resource Support Avg.3-5 Resources 300,00
Total 1,000,000
That is clear concise ROI Justification upfront!
Saving your organization more than 600K in first
year!
20
rBix Rationalization Manual vs
Cost Estimate

• In comparison here is the cost to consolidate
  this platform doing a completely manual
  conversion compared to using

Cost Comparison - Based on 500 Reports Consolidation via Manual Process Consolidation using
Estimated Time Savings 5000 Hours 2500 Hours
Estimated Cost 850,000 425,000
CUT TIME COST IN HALF!
21
Roadmap to BI Rationalization




Transition
Inception
Elaboration
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
Construction-Conversion Phase Our Proprietary
Tool Kits Power to the Solution

• 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.

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
Time to Implement
User Training
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_at_tusc.com