A Sales Analysis Solution for Oracle Applications

1
A Sales Analysis Solution for Oracle Applications
2
Business Issues

• One-to-one Marketing
• New E-Business Systems

3
BI Alternatives

• Library of Reports
• Data Warehouse
• Data Mart
• Packaged Data Warehouse
• BI Toolset

4
Spectrum Connect

• Discovery
• Definition and Design
• Build and Validate
• Deployment
• Value Assessment

5
Common Sales Analysis Applications

• Sales Analysis
• Key Customer Analysis
• Revenue Plan/Forecast Analysis
• Sales Pipeline Analysis
• Sales Rep Performance Analysis

6
Sales Analysis

• Gain/Loss Reporting
• Current period and year to date
• multi-dimensional
• Trend Reporting
• Rolling periods
• multi-dimensional

7
Key Customer Analysis

• Customer Satisfaction Reporting - RYG Status
• Customer Ranking
• Customer Alerts

8
Other Analysis

• Sales Forecast Analysis
• Sales Pipeline Analysis
• 30, 60, and 90 day funnel analysis
• Opportunity win rates
• Sales Rep Performance Analysis
• Peer Ranking
• Quota Performance

9
Oracle Applications

• Rich Transaction Repository
• Limited Sales Analysis

10
Solution Architecture

• Operational data into fact views
• Dimensional data into star views
• Historical data into custom tables
• Reconcile data issues
• Granularity between facts and dimensions
• Historical data
• Implement an appropriate toolset

11
Conclusion

• Sales Analysis can provide high business value
• There are several valid alternatives
• Knowledge of Sales Analysis applications and the
  Oracle transaction repository is essential
• We can help you be successful!