Oracle Business Intelligence Applications - PowerPoint by pdr21450

VIEWS: 326 PAGES: 28

Oracle Business Intelligence Applications document sample

More Info
									  Making Sense of Oracle’s
Business Intelligence Tools
                 July 19, 2007

                    Erez Azaria
Agenda
 Introduction
 Understanding the Pieces
 Business Intelligence Tools
 – Standard Edition
 – Enterprise Edition
 – In Review - Platforms
 Business Intelligence Applications
 –   DBI
 –   Fusion Intelligence
 –   Oracle BI Applications
 –   In Review - Applications
 OBI EE: Delivering Value in the Real World
 Who is Zanett?
Since 1993, Zanett has focused on helping organizations
achieve sustainable value from their IT investments.

     Enterprise Applications
      – E-Business Suite
      – PeopleSoft Enterprise
      – JD Edwards
     Business Intelligence
      – Oracle Business Intelligence
      – Cognos
     Technology
      – Middleware
      – Custom Solutions
     Managed Services
      – Hosting
      – Virtual Administration
     Program Management
Who is Zanett?
         Zanett Commercial Solutions is a
         wholly-owned subsidiary of Zanett, Inc.
         (Nasdaq: ZANE)

         Comprised of Four Regional Brands

         200+ Delivery Professionals & 300+
         Projects

         Service a wide variety of Industries with
         sizes ranging from SMBs to Fortune
         100
Agenda
 Introduction
 Understanding the Pieces
 Business Intelligence Tools
 – Standard Edition
 – Enterprise Edition
 – In Review - Platforms
 Business Intelligence Applications
 –   DBI
 –   Fusion Intelligence
 –   Oracle BI Applications
 –   In Review - Applications
 OBI EE: Delivering Value in the Real World
Understanding the Pieces
Understanding the Pieces
Agenda
 Introduction
 Understanding the Pieces
 Business Intelligence Tools
 – Standard Edition
 – Enterprise Edition
 – In Review - Platforms
 Business Intelligence Applications
 –   DBI
 –   Fusion Intelligence
 –   Oracle BI Applications
 –   In Review - Applications
 OBI EE: Delivering Value in the Real World
Oracle BI Standard Edition

                              Optimized to work with an
                              Oracle environment!!

Oracle BI Discoverer          Common Component
                              Architecture
Oracle BI Warehouse Builder   –   Oracle BI Discoverer
                              –   Discoverer Portlets
BI Spreadsheet Add-in         –   Spreadsheet Add-in
                              –   Leverage Oracle DB built in
Oracle BI Beans                   analytic and pl/sql functions

Oracle Reports
Oracle BI Enterprise Edition
                 Oracle Business Intelligence Suite
                  Enterprise Edition (OBI-EE) offers
                  the complete spectrum of BI
                  capabilities.

                  Designed for use by anyone
                  Provides intelligence across virtually
                  any data source
                  Based on a proven, modern, web
                  Services-Oriented Architecture
                  Delivers next-generation business
                  intelligence capabilities
Oracle BI Enterprise Edition
Enables Consistency, Security, Reuse, Flexibility

     Presentation Layer
    • User roles, preferences
    • Simplified view
                                Multi-layered Abstraction
    • Logical SQL interface       Separation of physical, logical and
    Semantic Object Layer         presentation layers
    • Dimensions                  Logical modeling builds upon
    • Hierarchies                 complex physical data structures
    • Measures
    • Calculations                Logical model independent of
    • Aggregation Rules           physical data sources, i.e. can be
    • Time Series                 remapped to another data source
        Physical Layer            quickly
    • Map Physical Data
    • Connections
    • Schema
Oracle BI Enterprise Edition
Enables Consistency, Security, Reuse, Flexibility

     Presentation Layer
    • User roles, preferences   Role-based views of the
    • Simplified view
    • Logical SQL interface     information
    Semantic Object Layer
    • Dimensions                Consistent definition of business
    • Hierarchies               measures, metrics, calculations
    • Measures
    • Calculations
    • Aggregation Rules         Model once, deploy anywhere
    • Time Series
        Physical Layer
    • Map Physical Data         Across any data source!!!
    • Connections
    • Schema
Oracle BI Enterprise Edition
                   BI Answers
                     Ad-hoc information exploration
                     Multi-dimensional analysis
                     Works against a logical view of information from
                     multiple data sources in a pure web environment.
                     Easy dashboard and notification creation
                   BI Interactive Dashboard
                     Rich, interactive pure web dashboards
                     Personalized interactive dashboards
                     Guided analytics
                   BI Delivers
                     Alerting engine to capture and distribute
                     notifications via multiple channels in response to
                     pre-defined business events to speed decision
                     making
                     Automated analytic workflows and processes
                     Manage delivery to mobile devices
                   BI Briefing Books
                     Capture a snapshot of an Oracle Dashboard
                     allowing the information to be viewed offline
                     presentation style.
Oracle BI Enterprise Edition
                 BI Disconnected Analytics
                   Provide Answers and Dashboards to users
                   on computers disconnected from the
                   network.
                 BI Office Plug-ins
                   Synchronize information from Answers,
                   Dashboards and Reports to Microsoft Word,
                   Excel and PowerPoint.
                 BI Publisher
                   Scalable reporting tool to generate reports
                   from multiple data sources (delivered as
                   XML) in multiple document formats and to
                   multiple delivery channels.
Oracle BI Enterprise Edition
                  BI Server
                    Highly scalable, highly efficient query and
                    analysis server
                    Efficiently integrates data from multiple
                    relational, unstructured, OLAP and pre-
                    packaged application sources, Oracle and
                    non-Oracle
                    Also incorporates calculations, multiple
                    languages, and complex hierarchies in a
                    single piece of metadata which is both
                    aggregate and fragment aware
                    Enables ease of use for business users while
                    reducing IT involvement.
                    Streamlined server deployment,
                    Unified security
                    Single web-based administration
                    Data Federation and caching are including as
                    part of the core platform
   In Review - Platforms
     Description                   Standard Edition                        Enterprise Edition

Platform                Oracle Centric.                          Separation of:
                                                                      End User BI Tools
                                                                      Business Metadata
                                                                      Data Source

Heterogeneity           Oracle Centric – effort required to      Enterprise BI Platform; Source
                         integrate non-Oracle data sources.        Independent (Oracle and Non-Oracle)
                         (Still Oracle DB Centric for Query      Intelligently Combine Data
                         Submission)                                    - Multiple DW(s), OLAP, and Apps
                                                                        - Historical and Real Time
Disconnected /Off-      No                                       Yes
Line
MS Office Integration   Excel                                    Excel, Word, PowerPoint


Report Distribution     Limited Alerting, Report Distribution,   “BI Delivers” – full support for
                         and Workflow Support                    scheduling and distributing reports
Development             Limited support of open APIs and         Advanced Web Services Integration
Integration              Integration                              Capabilities (SOA/BPEL)
Agenda
 Introduction
 Understanding the Pieces
 Business Intelligence Tools
 – Standard Edition
 – Enterprise Addition
 – In Review - Platforms

 Business Intelligence
 Applications
 –   DBI
 –   Fusion Intelligence
 –   Oracle BI Applications
 –   In Review - Applications
 OBI EE: Delivering Value in the Real World
Daily Business Intelligence (DBI)
                   Out-of-the-Box:
                    – Predefined Roles
                    – Predefined Key Performance Indicators
                      (KPIs)
                    – Drill-Down Reports
                   Embedded EBS Role-based
                   Security
                   Data Synchronization
                    – Summary Tables & Materialized Views
                    – Refresh Daily or As Desired
     Summaries
                   Runs Directly from Transactional
    Transactions
                   System – No Separate Reporting
                   Infrastructure Required
Fusion Intelligence - EBS Edition
                        Leverage Existing DBI Capabilities &
                        Investment

                        Greater Flexibility to meet Reporting
                        Requirements (i.e.adhoc reporting)

                        Greater Extensibility with Developing
                        Custom KPIs

                        Greater Personalization: Add,
                        Rearrange, Hide or Rename
                        Dashboards, Reports, Graphs etc.

        Summaries       Integrate Information from 3rd-party
        Transactions    Data Sources (i.e.unify DBI and Non-
                        DBI information)
Fusion Intelligence - EBS Edition
Financials Intelligence                  Supply Chain Intelligence
   General Ledger                          Order to Revenue
    –   AP Expenses (GL)
    –   AR Revenue (GL)
                                           Order Fulfillment and Shipping
    –   GL Activity                        Manufacturing (Process and Discrete)
    –   Budget                             Inventory (Process and Discrete)
   Accounts Payable
    –   AP Invoices
    –   AP Invoices Aging (Due & Past)   CRM Intelligence
    –   AP Payments Schedule                General Ledger
   Accounts Receivable                      Sales Opportunity
    –   AR Adjustments
    –   AR Payments Schedule                Sales Pipeline
    –   AR Receipts                         Sales Forecasting
    –   AR Invoices
    –   AR Aging Receivables                Service
   Sales Credits                         Human Resources Intelligence
   Compliance                               DBI Workforce Activity and Deployment
Procurement Intelligence                    DBI Compensation Salary Summarization
                                            DBI Leave and Absences
   Procurement Management
                                            HCM EUL Recruitment Pipeline
   Supplier Management
                                            HCM EUL Recruitment Vacancies
Oracle BI Applications



                   Prebuilt role/function based
                     Dashboards, Reports, and Alerts



                   Pre-mapped metadata repository,
                     incorporating best practice metrics and
                     calculations
                   Prebuilt DW Design, extensible to your
                     requirements
                   Prebuilt ETL Adapters for Oracle EBS,
                     PeopleSoft, Siebel, SAP, others
   In Review - Applications
  Description                DBI                    Fusion Intelligence          Oracle BI Applications

Platform        DBI: Integrated reporting       DBI Licensing + OBI EE:         Application Intelligence +
                 tool fully contained on the     Standardize enterprise          OBI EE: Standardize
                 EBS platform, no separate       wide on a single BI             enterprise wide on a
                 tools (licensing) required.     Platform                        single BI Platform
Heterogeneity   EBS Only                        EBS + External Data             Support for data from any
                                                 Sources                         Source (Oracle, DB2, SQL, etc)
                                                                                Support for data from
                                                                                 multiple ERP instances
                                                                                 (SAP, EBS, PS, JDE)

Ad Hoc          None                            Full Ad hoc capabilities        Full Ad hoc capabilities

Extensibility   Limited capabilities            Full capability to customize    Full capability to customize
                                                 metrics and dashboards          metrics, dashboards, and
                                                                                 extend data model
Data Layer      Data resides in transactional   Data resides in transactional   Data resides in separate
                 DB                              DB                              instance
Agenda
 Introduction
 Understanding the Pieces
 Business Intelligence Tools
 – Standard Edition
 – Enterprise Edition
 – In Review - Platforms
 Business Intelligence Applications
 –   DBI
 –   Fusion Intelligence
 –   Oracle BI Applications
 –   In Review - Applications

 OBI EE: Delivering Value in
 the Real World
Delivering Value – a Real World
Example
CLIENT PROFILE                      PAIN POINTS
   Global solutions provider of        Impossible to create a 360 view of
   computer products and services      customers for analysis
   that guarantee continuously
   available processing for            Single reports from Oracle unable
   applications                        to meet the business need

INDUSTRY                               Extensive use of Excel to merge
   Hi-Tech / Communications            data from multiple sources and
                                       present information
SIZE                                   As data increased, uncertainty of
   $ 250M Revenue                      data validity and “True Source” of
   ~1,000 Employees                    data also increased

                                       Abstracting reporting metrics from
ORACLE FOOTPRINT                       the underlying transactional data
  Since late-1990’s, Oracle E-
  Business 10.7
Delivering Value – a Real World
Example
SOLUTION FOOTPRINT                 WHY OBI?
  Built a financial data mart        Reporting capabilities met or
  Secured end user access to a       exceeded all requirement’s
  GUI front-end for easy access      Group sharing by end-user
  to standard reports and ad hoc     Ease of creating Dashboards
  reporting capabilities             Leveraged existing Oracle skill
  Oracle BI components:              sets
   – Oracle Warehouse Builder        Future leveraging of Oracle 11i
     (ETL)                           and Business Process
   – Oracle BI Server                Management
   – Oracle BI Answers
                                     Single Vendor
   – Oracle BI Dashboards            Competitive Pricing
Delivering Value – a Real World
Example
KEY DIFFERENTIATORS
  Immediate comparison of Actual vs. Forecast data in a single report
   – Old method: Several Business Object/Excel iterations spanning hours.
  Immediate fiscal year trend analysis
   – Old method: 10+ hour query processing
  Users have easy to navigate front-end (BI Answers) and easy to
  understand presentation model of the data mart (via BI Server).
  Confidence in the integrity of report data
  IT control of end user access to data through BI Server
  ETL programs easily maintainable through the OWB interface.
Now it’s time for…



         Q&
     QUESTIONS

           A
      ANSWERS

      For more information, call 1.866.611.3282 or visit us on the
                     web at www.zanett.com.
Contact Information
 Erez Azaria
 – Technology Practice Director
 – Phone: 617 869-2374
 – E-Mail: eazaria@whitbreadtech.com
 Sales:
 – E-Mail: sales@dataroad.com

								
To top