Nextel communications enterprise reporting evolution oracleworld presentation september 11 th 2003
This presentation is the property of its rightful owner.
Sponsored Links
1 / 25

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


  • 53 Views
  • Uploaded on
  • Presentation posted in: General

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

Download Presentation

Enterprise Reporting – Striving to be “Best in Class”

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


Enterprise reporting striving to be best in class

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


Enterprise reporting striving to be best in class

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


Enterprise reporting striving to be best in class

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


Enterprise reporting striving to be best in class

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


Enterprise reporting striving to be best in class

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


Enterprise reporting striving to be best in class

Enterprise Reporting

Infrastructure


Enterprise reporting striving to be best in class

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


Enterprise reporting striving to be best in class

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


Enterprise reporting striving to be best in class

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


Enterprise reporting striving to be best in class

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


Enterprise reporting striving to be best in class

Enterprise Reporting

Common Business Rules/Presentation


Enterprise reporting striving to be best in class

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


Enterprise reporting striving to be best in class

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


Enterprise reporting striving to be best in class

Enterprise Reporting – Business Intelligence Presentation


Enterprise reporting striving to be best in class

Enterprise Reporting

Analytical/OLAP Reporting


Enterprise reporting striving to be best in class

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


Enterprise reporting striving to be best in class

Profitability Reporting – Drill Down Approach

First Level View


Enterprise reporting striving to be best in class

Profitability Reporting – Drill Down Approach (Cont.)

Second Level View


Enterprise reporting striving to be best in class

Profitability Reporting – Drill Down Approach (Cont.)

Third Level View


Enterprise reporting striving to be best in class

Nextel Data Warehouse – Sales Reporting Application


Enterprise reporting striving to be best in class

Enterprise Reporting

Executive Dashboards/Scorecards


Enterprise reporting striving to be best in class

Enterprise Reporting – Dashboard Customization (Sr. Exec)


Enterprise reporting striving to be best in class

Enterprise Reporting – Dashboard Customization (Functional Area)


Enterprise reporting striving to be best in class

Enterprise Reporting

Questions ???


  • Login