1 / 25

Enterprise Reporting – Striving to be “Best in Class”

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

garvey
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Nextel Communications Enterprise Reporting EvolutionOracleWorld PresentationSeptember 11th, 2003

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

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

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

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

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

  7. Enterprise Reporting Infrastructure

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

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

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

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

  12. Enterprise Reporting Common Business Rules/Presentation

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

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

  15. Enterprise Reporting – Business Intelligence Presentation

  16. Enterprise Reporting Analytical/OLAP Reporting

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

  18. Profitability Reporting – Drill Down Approach First Level View

  19. Profitability Reporting – Drill Down Approach (Cont.) Second Level View

  20. Profitability Reporting – Drill Down Approach (Cont.) Third Level View

  21. Nextel Data Warehouse – Sales Reporting Application

  22. Enterprise Reporting Executive Dashboards/Scorecards

  23. Enterprise Reporting – Dashboard Customization (Sr. Exec)

  24. Enterprise Reporting – Dashboard Customization (Functional Area)

  25. Enterprise Reporting Questions ???

More Related