nextel communications enterprise reporting evolution oracleworld presentation september 11 th 2003
Download
Skip this Video
Download Presentation
Enterprise Reporting – Striving to be “Best in Class”

Loading in 2 Seconds...

play fullscreen
1 / 25

Enterprise Reporting – Striving to be “Best in Class” - PowerPoint PPT Presentation


  • 75 Views
  • Uploaded on

Nextel Communications Enterprise Reporting Evolution OracleWorld Presentation September 11 th , 2003. Enterprise Reporting – Striving to be “Best in Class”.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Enterprise Reporting – Striving to be “Best in Class”' - garvey


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
nextel communications enterprise reporting evolution oracleworld presentation september 11 th 2003

Nextel Communications Enterprise Reporting EvolutionOracleWorld PresentationSeptember 11th, 2003

slide2
Enterprise Reporting – Striving to be “Best in Class”
  • A Best in Class approach enables the enterprise to gain competitive advantage by reducing the time and effort required to acquire, distribute and respond to new information
  • The Enterprise Reporting program will deliver the following over a two year period:
    • Common, secure, single sign-on access path to Nextel information
    • Improved data accuracy
    • Improved strategic decision making
    • Tools that make data analysis user friendly
    • Shared data across business functional areas
    • Compliance with Security and Privacy requirements
    • Compliance with Sarbanes-Oxley requirements
    • A ‘single version of the truth’
    • Reduced maintenance costs
    • Better visibility into financial and operational information
slide3
Enterprise Reporting – Governance Model
  • Steering Committee Organization
    • Quarterly Face-to-Face meetings
    • Monthly dashboard updates
    • Executive Sponsor VP Organizations:
      • IT
      • Internal Audit
      • Finance
      • Finance Ops
      • Sales Operations
      • Customer Operations
      • Tax
      • Employee Services
      • HR Development
      • Indirect Distribution
      • Corporate Communications
  • Oversight Committee Organization
    • Working team of representatives from various business areas
    • Monthly meetings
    • Definition of business priorities
    • Serve as business owners to define business rules for respective areas
  • IWS
  • Marketing
  • Revenue Assurance
  • Supply Chain
  • Customer Care
  • Regional Sales
  • Strategy
  • HR
  • Compensation/Benefits
  • Engineering
slide4
Enterprise Reporting - Approach
  • Balanced Scorecard
  • Dashboards

What is the ARPU, OCPU, and CPGA for the month of April ?

Executive

  • Multi- Dimensional Reporting
  • OLAP Applications
  • Strategic Decision Making

What is our most profitable sales channel ?

Strategy

  • Key Performance Indicators
  • Common Business Rules
  • Transformed/Summarized Data

What is the Customer Churn Rate for April ?

Business Rules

How many orders were processed today ?

  • Transactional Data
  • Un-manipulated Data
  • Batch Reporting

Infrastructure

Reporting Tier Structure

slide5
Enterprise Reporting - Building Blocks

Executive View

Balanced Scorecard

Smart Growth Strategy

6 Quarter Forecasts

Strategic

Investments

3 Year Plan

Business Rules/Reporting

Sales

Subscriber

Activity

Tax

Revenue

Billing

Profit

CRR

Infrastructure

APIs

Single

Sign-on

Privacy &

Security

Intranet

PeopleSoft

NDW

Oracle

Ordering

& Billing

slide6
Enterprise Reporting – Reporting Evolution

1 %

5 %

  • Un-actionable reporting to executives
  • Limited tools for strategic analysis
  • Conflicting business rules
  • Many users accessing
  • raw data
  • Actionable reporting to executives
  • Robust tools for strategic analysis
  • Consistent business rules
  • Few users accessing
  • raw data

ExecutiveReporting

4 %

20 %

AnalyticalReporting

50 %

20 %

Functional Reporting

75 %

25 %

Transactional Reporting

2002 Reporting Model

2004 Reporting Model

Enterprise Reporting Evolution

slide7
Enterprise Reporting

Infrastructure

slide8
Nextel Data Warehouse – Standard Operating Environment
  • Servers
    • HP Superdome
    • Sun Fire 12000
    • HP/Compaq
  • Storage
    • EMC Symmetrix
    • EMC DMX
    • HP Storage
  • Backups
    • EMC EDM
    • HP Omni back
  • Software/Tools
    • Oracle (Various Products)
    • SAS
    • Hyperion Essbase
    • Business Objects
    • Crystal Reports
    • SQL /PLSQL
    • Quest Shareplex
    • CA TNG
    • CA Autosys
    • TOAD
    • Web Sphere
slide9
Nextel Data Warehouse – Data Sourcing

NDW Inputs

Listings (WSJ)

ABI

Dun & Bradstreet

Brightpoint

Commissions

RPAS

Harte-Hanks

Lightbridge

Nextel Online

Telcordia

Motorola

Network Elements

Telemarketing

Vendors

Voice Response Units

Ordering

HR

Customer Care

Financials

Billing

Supply Chain

Usage

Nextel Retail Stores

ACT Load

IP Billing

UPLink (Web Clicks)

Nextel World Wide

Sales Leads

NDW Systems

Horizontal/Cross Fleet

Web Sales

slide10
Enterprise Reporting – Delivery Approach

i-Connect

(Intranet Portal)

NexStep

Billing

Data

IWS

Data

Switch

Data

WNP

Data

Other

Sources

HR

Finance

SCM

Business

Intelligence

Page

Data Replication

PS Query

PL SQL

nVision

SQR

Transactional

Reporting

Operational Data Store (ODS) Layer

1 – Data Staging into a Common Data Source

Business Rules,

Summarization,

Data Transformation

Business Objects

Crystal Reports

SAS

KPI Builder

PeopleSoft

Data

Warehouse

Others

Combined

Data

Warehouse

Billing

Data

Warehouse

Functional

Reporting

Data Warehouse Layer

Analytical

Reporting

Data Mart Layer

Hyperion Apps

CRR

Dashboards

Scorecards

Finance

Marketing

Sales

Revenue

Profit

Data Repackaging,

De-normalization,

Cube Building

3 - Common Presentation and Security

2 – Apply Common Business Rules and ‘Single Version of the Truth’

Nextel Data Warehouse

slide11
Enterprise Reporting – Leveraging Oracle 9i RAC

i-Connect (Intranet Portal)

Application Users

Reporting Users/Data Warehouse

PeopleSoft

Application

PeopleSoft

Reporting

Oracle 9i RAC

HR

Benefits

  • Isolates application users from reporting users
  • Instances can be tuned separately
  • Provides fail-over for application users
  • Provides real-time reporting capabilities
  • Reduces need for data replications
slide12
Enterprise Reporting

Common Business Rules/Presentation

slide13
Enterprise Reporting – Corporate Reports of Record

Metrics (Sample)

Data Sorts (Sample)

Sales Focus

Total Subscribers

Gross Adds

Churn (%)

Net Adds (units)

Revenue

ARPU

Penetration

Financial -- Cost Focus

CPGA

OCPU

Network Focus

Dropped Calls

Network Uptime

Network Operating Cost per MOU

Total Cell Sites

Financial -- Performance Focus

Days Sales Outstanding (DSO)

Bad Debt as a % of Revenue

EBITDA

Operating Margin

Free Cash Flow

EPS

Valuation Focus

Lifetime Customer Value (LTV)

Employee Focus

Total Headcount

Employee Turnover Rate

Customer Focus

Customer Satisfaction % (CSI)

Service Level % (answer < 30 seconds)

Channel

Segment/Industry

Vertical Segment

Geography

Smart Growth Category

Competition

Product Line / Product

Service Plan

slide14
Enterprise Reporting – User Access Methodology

Nextel

Enterprise

Directory

(LDAP)

NEXTEL DATA WAREHOUSE

User Authentication Request

Operational Data Store

2

NDWSAP

Enterprise Data Warehouse

Nextel

i-Connect

1

User

Login

3

PRESENTATION

LAYER

User Authorization

Enterprise Data Marts

Business

Intelligence

Tab

Enterprise OLAP environment

4

5

Departmental Silos

Present Links

As Per User Credentials

slide16
Enterprise Reporting

Analytical/OLAP Reporting

slide17
Nextel Data Warehouse – Profitability Reporting

Source Data

UNITS

REVENUE

USAGE

COST

RECONCILIATION

LOAD PROCESS

Profit OLAP Cubes

Profit Data Mart

Standard / Ad-Hoc Reporting

(Wide Audience)

Ad-Hoc Reporting

(Narrow Audience)

Financial Analysts &

Business Analysts

Executive Management

Management / Operations

slide22
Enterprise Reporting

Executive Dashboards/Scorecards

ad