Typical Business Need Walk

1
Typical Business Need Walk
Events Rational Challenges
Competitive Excellence is a Journey . . . Data
Excellence IS a Must Have
2
Overview
Definition and Goal
Provide for real time view of GLOBALLY
CONSISTENT business metrics, increasing the
intelligence of business decision making
process
Identification, calculation and population of
Predictive Metrics that will drive forward
looking business decisions
Tool to automatically populate key business
metrics, eliminating current manual collection
process
3
MGPP Approach
Prototype
Pilot
Functional
Digital Reality

• PL/Functional Managers

• Functional Departments

• Fleet SLT / GECS

• Fleet SLT / GECS

Target Audience

• Top 30 metrics across all business locations

• L2/L4 metrics across all business locations

• L4/L8 Transactional metrics

• Global, Single drill down metric

Info Granularity

• Sample of 5 top level metrics

• Identify grading scale, Prioritize metrics

• Gap analysis and redesign

• Validation of metrics / BPMS finalized

Metric Validation

• Manual

• Performance against goals

• Time-series analysis

• Prediction/Extrapolation via what-if wizards

Data Analysis

• Dynamic web pages, Some content for S-1

• Dynamic web pages, S1/S-2 content

• Predictive Modeling, PDA, WAP

• Manual static web page

Presentation

• Dynamic metric menu bar

• Hard coded location / metric menu bars

• Dynamic location menu bar?

• One click solution?

Navigation

• Sub-units / Countries

• Dynamic home page views

• Global / major Poles

• Global

Home pages

• Data mart for web pages, Outline design

• Developed for GEN 2 data, Ability to scale

• Developed for GEN 3 data, multi-currency

• Developed for GEN 4, Full data manipulation

Data warehouse

• Monthly

• Monthly to weekly

• Weekly

• Daily to near real-time

Refresh Rate

• Automated Hyperion data loads

• Auto feeds from multiple DBs/Manual Input

• Internal and external data agents

• Manual Input

Data Load Method

• Customized home pages/email to owner

• Dynamic home pages, pages, email, downloads

• Customized home pages

Escalation Method

• Spec limits

• Rule-based

• Agents/Workflow

Event triggers

• Userid/password

• Role based MS application security

• eSSO Role-based access

• eSSO Role-based access and workflow

Security Access
4
MGPP Summary
Prototype
Pilot
Functional
Digital Reality

• PL/Functional Managers

• Functional Departments

• Leadership Team

• Leadership Team

Target Audience

• Top 30 metrics across all business locations

• L2/L4 metrics across all business locations

• L4/L8 Transactional metrics

• Global, Single drill down metric

Info Granularity

• Sample of 5 top level metrics

• Identify grading scale, Prioritize metrics

• Gap analysis and redesign

• Validation of metrics / BPMS finalized

Metric Validation

• Manual

• Performance against goals

• Time-series analysis

• Prediction/Extrapolation via what-if wizards

Data Analysis

• Dynamic web pages,

• Dynamic web pages,

• Predictive Modeling, PDA, WAP

• Manual static web page

Presentation

• Dynamic metric menu bar

• Hard coded location / metric menu bars

• Dynamic location menu bar?

• One click solution?

Navigation

• Sub-units / Countries

• Dynamic home page views

• Global / major Poles

• Global

Home pages

• Data mart for web pages, Outline design

• Developed for GEN 2 data, Ability to scale

• Developed for GEN 3 data, multi-currency

• Developed for GEN 4, Full data manipulation

Data warehouse

• Monthly

• Monthly to weekly

• Weekly

• Daily to near real-time

Refresh Rate

• Automated data loads

• Auto feeds from multiple DBs/Manual Input

• Internal and external data agents

• Manual Input

Data Load Method

• Customized home pages/email to owner

• Dynamic home pages, pages, email, downloads

• Customized home pages

Escalation Method

• Spec limits

• Rule-based

• Agents/Workflow

Event triggers

• Userid/password

• Role based MS application security

• eSSO Role-based access

• eSSO Role-based access and workflow

Security Access
MGPP Approach Expedites Deployment Minimizes
Execution Risks
5
Metrics
Digital House Of Quality
L1s
MAKE
BUY
SELL
FINANCIAL
Strategy
Cockpit Value Big Ys Xs Alignment
Growth
Key HR Placements
Deals in Pipeline (RT)
NI Tracker Key Top Line Measures Equity MTM
Fulfillment Span
Marketing
Customer Centricity

• Op. Expenses
• Headcount
• IT Infrastructure (RT)

Productivity
Sourcing (RT)
Delinquency Non-Earning Assets Write-Offs
Risk
Qual. Growth Satis. Survey (RT)
Employee Satisfaction
Metrics MUST Align To Business Strategy
Mission Critical Ys
6
Metrics Methodology
Excel, Access
L4

• Leading Indicators
• Predictive
• Actionable

• Lagging Indicators
• Corporate Metrics
• Reactive

L1
Oracle, SQL
Automation Costs
Value
L4

• Data Integrity Issues
• Subjective
• New eMetrics

• Lower-Level Metrics
• Small Audience

L1
Risk
Cost
Hourly / Daily
L4

• Financial Metrics Will Typically Be Quicker Hits
• Ops Quality Measures Typically Take More Time
  Money
• Predictive Market Measures Can Be Game
  Changers

L1
Monthly/Quarterly
Frequency
Rule Sets For Metrics Collection
7
Metrics Methodology
High

• Orders
• Total Volume
• Bus Devt Deals in Pipeline
• Bus Devt Total Assets
• Overall Headcount
• Migration/Relocation HC
• Digitization HC
• Credit Rating
• Delinquency

• NEA
• Net Income
• Total Assets
• Net Premiums
• Investment

• Customer Penetration
• Customer Erosion
• New Customer Penetration
• Operating Costs
• IT Infrastructure
• Pricing Span

• CM
• CM (Blended)
• Service Program Contribution
• Write-offs
• Customer Complaints
• CRD Span
• Ordering Span

• Closed BD deals
• Approved BD deals
• Stretch BD deals
• BD Deals BOD approved
• BD Acquisitions Impact
• Key Placement/Top Jobs Open

Value

• Sourcing Savings
• E-Auction Savings
• Retention
• of e-transactions
• Sales Forecast

• Average Program/Unit

Low
High
Cost
Force-Ranking Reality To Drive Execution Strategy
8
Look Feel Example
Dashboard
ASIA
Quick Location Navigation
Metrics Navigation
DUMMY DATA
Standardized Home Pages
Crisp Line of Sight
North America Europe Asia Australia
Australia Europe
North America Europe
Drill Downs
One Click Drill Downs
Australia Europe
Automatic Alerts
E-Mail Notification
9
Look Feel Example
Homepage The start point for quick pulsing
navigation.
Dashboard
Global Dashboard
ASIA
DUMMY DATA
10
Look Feel Example
Preferred Graph Pre-packaged views to
visualize trending and comparatives.
Dashboard
Global Dashboard
ASIA
11
Top 5 Best Practices

Considerations Risks
90 Of Success Is Determined By These 5
Fundamentals