NOT AN OFFICIAL UNCTAD RECORD

1. NOT AN OFFICIAL UNCTAD RECORD

2. Financial Insights With Oracle Business Intelligence Charles Gichobi Technology Manager – E. & Southern Africa Charles.gichobi@oracle.com Oracle Africa Operations

3. Oracle Corporation • Largest enterprise software vendor • 55,000+ employees • Over 275,000 customers • Global operations

4. 6 of the top 7 integrated oil & gas companies run Oracle ERP (Reuters) 9 of the top 10 oil field services companies run Oracle ERP (Reuters) 7 of the 11 diversified energy companies in the 2004 Fortune Global 500 run Oracle ERP 15 of the 32 petroleum refining companies in the 2004 Fortune Global 500 run Oracle ERP Oracle inOil & Gas Did You Know?

5. Intelligence BuildAsset OperateAsset Manu-facture Plan /Procure Service Technology Oracle Oil &Gas Solutions Enable you to: • Accelerate Asset Development and Deployment • Improve Asset Utilization and Worker Safety • Drive Efficient Planning and Procurement • Optimize Refining and Manufacturing Processes • Streamline Service and Repair Operations http://www.oracle.com/applications/home.html

6. It’s information that matters. But getting high quality information to decision makers has been challenging.

7. Enabling the Insight-Driven Enterprise • Empower Everyone – Every person is provided with relevant, complete information tailored to their role. • Provide Real-time Intelligence – Deliver insight that predicts the best next step, and deliver it in time to influence the business outcome • Use Insight to Guide Actions – lead people to take action based on facts to optimize decisions, actions and customer interactions Becoming an insight-driven enterprise will drive the next level of value creation and competitive advantage for organizations.

8. Monitoring Reporting Planning Analysis GIS Businesses Need a Unified View of All Information

9. ReportingEngine Security? OLAPEngine TransformationEngine Name/Address Scrubbing Database Transformation Engine GIS App. Portal ETL Tool Analytic Apps MiningEngine Query & Analysis Enterprise Reporting Common Reporting EnvironmentMulti-Vendor, Un-integrated • Protracted and complex implementation • Escalating maintenance costs • Poor and incomplete BI solution

10. Oracle Business Intelligence PlatformComplete and Integrated

11. Relational OLAP Data Mining Transformation Spatial Oracle Business Intelligence PlatformComplete and Integrated

12. Relational OLAP Data Mining Transformation Spatial Oracle Business Intelligence PlatformComplete and Integrated Warehouse Builder Discoverer & Reports BI Beans Portal MapViewer

13. Oracle10G DiscovererQuery, Analysis, Reporting, Publish, Personalization & Administration An intuitive ad-hoc query, reporting, analysis, and Web-publishing tool that empowers business users to gain immediate access to information from data marts, data warehouses, and online transaction systems. • Build, Modify, and format Reports • Drag-Drop Layout • Wizard Driven • Dynamic drill, pivot • 100% HTML • Centralized Metadata • SQL Function (Analytical, financial, Arithmetic, Logical) • Query Governor • Query re-direction

14. Easily Create Reports • Drilling and paging • Point & Click Simplicity • Drag & Drop Layout • Interactive Hints • Right-Click For Options • Wizards For Multi-Step Tasks

15. Over 50+ Graph Types

16. Answers to the OLAP type Questions “On Demand” • “What are my top ten Customers based on profit?” • “What is the 3 month moving average of my Sales ?” • “What is the cumulative sum of my Revenue by area?” • “How do the number of profit by product thisyear compare to last year?” • “What is the ranking of my Regions this year compared to last year based on …..?”

18. Oracle OLAPMultidimensional Calculations • Uni-dimensional “What are my top ten customers?” • Multidimensional ‘What was the percent change in market share for a grouping of my top 20% of products for the current three month period versus same period year ago for accounts which grew by more than 20 percent in revenue”

19. Aggregation Rules Month Quarter Year Customer Manufacturer Product Share Brand Sales Year to Date Allocation Rules Product Sales Item Profit Average Selling Price Time Forecast Rules Dimensional Model

20. Oracle Data Mining • Oracle Data Mining (ODM) sifts through massive amounts of data to find hidden patterns and information — valuable information that can help you better understand your customers and anticipate their behavior • ODM insights can be revealing, significant, and valuable e.g. • Predict which customers are likely to churn • Discover what factors are involved with a certain disease • Identify fraudulent behavior

21. Data Mining Examples • Typical problems addressed by data mining include:What is the probability that a person will… • Buy product X (Marketing) • Stop buying my product and start buying a rival’s product (Churn) • Default on a loan (Credit Risk) • Submit a false insurance claim (Fraud) • Predict parts failure • Contract a certain type of Leukemia (Life Sciences)

22. Query & Analysis Dashboards Reporting Collaboration Activity Monitoring Balanced Scorecard Real Time & Predictive Guided Analytics Intelligent Workflow Enterprise Bus. Intelligence SuiteOpen, Extensible, Best-of-Breed, Integrated Data Integration Common Enterprise Information Model Unified Business Intelligence Infrastructure

23. For More Information • Database and Options http://www.oracle.com/database/index.html • Middleware and Options http://www.oracle.com/products/middleware/index.html • Business Intelligence http://www.oracle.com/appserver/business-intelligence/index.html

24. Q & Q U E S T I O N S A N S W E R S A