Revenue

Revenue is a critical input for anlaysis. The OLAP & data mining components of OADM provide revenue analysis at multiple levels of detail. You can connect OADM to all existing revenue sources for completeness of the analysis. While tracking revenue, OADM also records your costs sources, so that you can calculate profit and margin.

The Revenue business area provides reports and analysis in the following subject areas:

• Revenue Analysis
  • Standard average revenue per user and employee, by service and geography
  • Earnings Before Interests and Tax, Depreciations and Amortization (EBITDA) report
  • Bill payment
  • IC Revenue vs. Costs
• Sales
  • Gross and Net sales reports
• Debt Collection
  • Debt ageing
  • Daily debt collection report
• Revenue Assurance
  • Refund & adjustment to customer (account)
  • Expected vs. Billed revenue
  • Percent of revenue not billed (any party)
  • Invoice collection report
  • Contract summary
  • Commission performance
• Revenue per Usage
  • Usage reports
  • Customer call type analysis
  • CDR analysis

Advanced Capabilities

OADM also provides the following advanced capabilities by leveraging the data mining and OLAP features of Oracle 11g Database:

• Data Mining
  • Customer and Dealer Fraud Detection, including:
    • Dealer Commission fraud: high % of churn or “0-usage”
    • SIM Card Clone Fraud
• OLAP
  • Revenue Cube: Contains revenue, debt and contract data for each organization, geography location, price package, customer class and time period. (ROLAP or MOLAP)
  • Revenue Forecast Cube: Provides projections of the Revenue Cube for planning with various forecast methods. (MOLAP only)