1 / 25

NOT AN OFFICIAL UNCTAD RECORD

NOT AN OFFICIAL UNCTAD RECORD. Financial Insights With Oracle Business Intelligence. Charles Gichobi Technology Manager – E. & Southern Africa Charles.gichobi@oracle.com Oracle Africa Operations. Oracle Corporation. Largest enterprise software vendor 55,000+ employees

Download Presentation

NOT AN OFFICIAL UNCTAD RECORD

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. 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 …..?”

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

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

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

  20. 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)

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

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

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

More Related