Introduction to Oracle Business Intelligence

translatoryazooInternet and Web Development

Nov 12, 2013 (3 years and 9 months ago)

234 views

T :
+44 (0) 8446 697 995
or

(888) 631 1410 (USA)



E :
enquiries@rittmanmead.com

W:
www.rittmanmead.com

Mark Rittman, Technical Director, Rittman Mead

Author of the Oracle Press book “Oracle BI Developers Guide”


Introduction to Oracle Business Intelligence

T :
+44 (0) 8446 697 995
or

(888) 631 1410 (USA)



E :
enquiries@rittmanmead.com

W:
www.rittmanmead.com

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

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

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

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

“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 by

Mike Durran, forward by

Balaji Yelamanchili

T :
+44 (0) 8446 697 995
or

(888) 631 1410 (USA)



E :
enquiries@rittmanmead.com

W:
www.rittmanmead.com

“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

“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 us
eful 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

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

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

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 Model

Integration

of Disparate DataSources

Addition of
Business Logic

and
Calculations

T :
+44 (0) 8446 697 995
or

(888) 631 1410 (USA)



E :
enquiries@rittmanmead.com

W:
www.rittmanmead.com

The Enterprise Semantic Model


Demonstration

T :
+44 (0) 8446 697 995
or

(888) 631 1410 (USA)



E :
enquiries@rittmanmead.com

W:
www.rittmanmead.com

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

Creating dashboards and analyzing data


Demonstration

T :
+44 (0) 8446 697 995
or

(888) 631 1410 (USA)



E :
enquiries@rittmanmead.com

W:
www.rittmanmead.com

Example 3 : Integration Across Oracle Fusion Middleware


BI content can be embedded in ADF and WebCenter applications, share common

look
-
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

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

Oracle BI Integration with Oracle Fusion Middleware


Demonstration

T :
+44 (0) 8446 697 995
or

(888) 631 1410 (USA)



E :
enquiries@rittmanmead.com

W:
www.rittmanmead.com

Mark Rittman, Technical Director, Rittman Mead

Author of the Oracle Press book “Oracle BI Developers Guide”


Introduction to Oracle Business Intelligence