1 / 18

Mark Rittman, Technical Director, Rittman Mead

Introduction to Oracle Business Intelligence. Mark Rittman, Technical Director, Rittman Mead Author of the Oracle Press book “Oracle BI Developers Guide”. T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : enquiries@rittmanmead.com W: www.rittmanmead.com. Mark Rittman.

yin
Download Presentation

Mark Rittman, Technical Director, Rittman Mead

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. Introduction to Oracle Business Intelligence • Mark Rittman, Technical Director, Rittman Mead • Author of the Oracle Press book “Oracle BI Developers Guide” T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : enquiries@rittmanmead.com W: www.rittmanmead.com

  2. Mark Rittman • Mark Rittman, Co-Founder of Rittman Mead • Oracle ACE Director, specialising in Oracle BI&DW • 15 Years Experience with Oracle Technology • Oracle BI since 1998 (Discoverer, Designer etc) • OBIEE since 2007 (OBIEE 10g+) • Oracle OLAP/Express since 2000 • OWB, ODI, Oracle RBDMS (OCP) etc • Regular columnist for Oracle Magazine • Author of two Oracle Press Oracle BI books • Oracle Business Intelligence Developers Guide • Oracle Exalytics Revealed • Email : mark.rittman@rittmanmead.com • Twitter : @markrittman T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : enquiries@rittmanmead.com W: www.rittmanmead.com

  3. Regular Speaker at OOW, Blogger, Writer for Oracle Magazine • Presenter on Oracle BI at the last 5 Oracle Open Worlds • Columnist for Oracle Magazine (Oracle BI) • Writer for OTN • Past board member for ODTUG, chair of UKOUG BIRT SIG • Oracle ACE Director • Blogger for Rittman Mead blog • Tweeting at @markrittman T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : enquiries@rittmanmead.com W: www.rittmanmead.com

  4. About Rittman Mead • Oracle BI and DW gold partner • World leading specialist partner for technical excellence, solutions delivery and innovation in Oracle BI • Approximately 30 consultants worldwide • All expert in Oracle BI and DW • UK based • Offices in US, Europe (Belgium) and India • Skills in broad range of supporting Oracle tools: • OBIEE • OBIA • ODIEE • Essbase, Oracle OLAP • GoldenGate • Exadata T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : enquiries@rittmanmead.com W: www.rittmanmead.com

  5. Rittman Mead in the Developer/User Community T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : enquiries@rittmanmead.com W: www.rittmanmead.com

  6. “Oracle BI Developers Guide” : Oracle Press, 2012 • End-to-end development guide for OBIEE 11g (covers up to 11.1.1.6) • From installation and architecture, through to dashboards, integration and team development • Based on 6yrs+ of OBIEE experience, beta program participation, implementation etc • Technical focus, step-by-step instructions along with concepts and product history • Participation by the Oracle BI development team,including technical editing byMike Durran, forward byBalaji Yelamanchili T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : enquiries@rittmanmead.com W: www.rittmanmead.com

  7. “Oracle BI Developers Guide” : Oracle Press, 2012 • Chapter 1 : Oracle Business Intelligence Overview and Architecture • Chapter 2 : Installation and Upgrading of Oracle Business Intelligence • Chapter 3 : Modeling Repositories using Relational, File and XML Data Sources • Chapter 4 : Creating Repositories from Oracle Essbase and Other OLAP Sources • Chapter 5 : Configuring and Maintaining the Oracle BI Server • Chapter 6 : Creating Analyses, Dashboards, KPIs and Scorecards • Chapter 7 : Actionable Intelligence • Chapter 8 : Security • Chapter 9 : Creating Published Reports • Chapter 10 : Systems Management • Chapter 11 : Managing Change • Chapter 12 : Oracle Exalytics In-Memory Machine T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : enquiries@rittmanmead.com W: www.rittmanmead.com

  8. “Oracle Exalytics Revealed”, Oracle Press (ebook), 2012 • Special-edition e-book that took the Exalytics chapter and updated for 11.1.1.6.2 • Additional content on ILOM, testing, aggregate building,11.1.1.6.2 BP1 visuals (trellis charts etc) • “Nowhere will you find a more comprehensive look at Oracle Exalytics from start to finish than in this book … extremely thorough and easy to follow … and I find this narrative incredibly useful to explore the product.” • “The book … delivers what it promises on its title, a thorough review on the most important aspects of this engineered system created by Oracle Corporation” T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : enquiries@rittmanmead.com W: www.rittmanmead.com

  9. What is Oracle Business Intelligence? • Oracle BI provides a set of web-based tools for reporting and analyzing data • Based around dashboards, built around graphs, tables, pivots etc • Multiple server architecture that splits data access / presentation elements • Based on Siebel Analytics technology • Connects to multiple data sources • Oracle DB & Exadata • SQL Server, DB/2, Teradata • Essbase, Oracle OLAP, MSAS • ADF View Objects etc • Integral part of Oracle Fusion Middleware T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : enquiries@rittmanmead.com W: www.rittmanmead.com

  10. Some Cool Things About Oracle Business Intelligence 11g • The Oracle BI Repository (“semantic business model”) • Interactive dashboard analytics • Integrating BI with business processes, rich web applications, and mobile applications T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : enquiries@rittmanmead.com W: www.rittmanmead.com

  11. Example 1: An Enterprise-Wide Business Analytics Semantic Model • All reporting tools within Oracle BI take their data from a shared metadata layer • Defined as dimensional model, embeds common calculations and drill paths • Subject-area and row-level security • Three-layer design to provide abstraction from underlying complicated source systems • Can source data from • Oracle DB + other RBDMSs • Oracle Essbase, OLAP • Oracle ADF, web services • Hadoop • Oracle TimesTen • etc Simplification of the Data ModelIntegration of Disparate DataSourcesAddition of Business Logic and Calculations T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : enquiries@rittmanmead.com W: www.rittmanmead.com

  12. Demonstration • The Enterprise Semantic Model T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : enquiries@rittmanmead.com W: www.rittmanmead.com

  13. Example 2 : Rich Interactive Dashboards, No Programming Needed • Users access information and analytics through rich, analytic role-based dashboards • Can also publish reports to PDF, distribute, or access through MS Office T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : enquiries@rittmanmead.com W: www.rittmanmead.com

  14. Demonstration • Creating dashboards and analyzing data T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : enquiries@rittmanmead.com W: www.rittmanmead.com

  15. Example 3 : Integration Across Oracle Fusion Middleware • BI content can be embedded in ADF and WebCenter applications, share commonlook-and-feel, security, event handling model, tooling • Basis of the Oracle Fusion Applications T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : enquiries@rittmanmead.com W: www.rittmanmead.com

  16. More Information • Thank you for attending this presentation • More information can be found at http://www.rittmanmead.com • Contact us at info@rittmanmead.com or mark.rittman@rittmanmead.com • “Oracle Business Intelligence Developers Guide” and “Exalytics Revealed” out now! • Follow-me on Twitter (@markrittman) or Facebook (facebook.com/rittmanmead) T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : enquiries@rittmanmead.com W: www.rittmanmead.com

  17. Demonstration • Oracle BI Integration with Oracle Fusion Middleware T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : enquiries@rittmanmead.com W: www.rittmanmead.com

  18. Introduction to Oracle Business Intelligence • Mark Rittman, Technical Director, Rittman Mead • Author of the Oracle Press book “Oracle BI Developers Guide” T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : enquiries@rittmanmead.com W: www.rittmanmead.com

More Related