Docstoc

TCOUG_Ann_PartI

Document Sample
TCOUG_Ann_PartI Powered By Docstoc
					Capture Your Business Data Intelligently


   Ann Kalin - ONYX Training
         • Business Intelligence Reporting
         • Oracle BI Answers
         • Oracle Discoverer

   Dale Lampe - Professional Project Partners
          • SAS
          • Business Objects
          • Cognos

                                                1
Capture Business Data Intelligently


          What is Business Intelligence BI?

   BI helps your organization turn data into useful and
     meaningful information and distributes it to those
     who need it, when they need it, so they can make
     timely and better business decisions.

                                                      2
Capture Business Data Intelligently

        Why BI? Does this sound familiar?

   – Multiple versions of the truth
   – Inability to perform indepth analysis
   – Unable to locate important information
   – Historical values are not being retained
   – Existing BI tools is too difficult to use
   – Inability to comply with government reporting
     requirements
                                                 3
        Dimensional Model

   Access to the business data – reporting purpose

   Not transactional – analysis purpose

   Cube or Star Schema or ROLAP

   Fact Table = business subject

   Dimension table = focus of subject
                                                  4
                 Dimensional Model

                         ORDERS
                          Time key
                          Product key
                          Customer key
                          Sold amount
                          Units sold
                          Cost amount




Time Dimension       Product Dimension   CustomerDimension
 Time key               Product key         Customer key
 Day of week            Description         Customer name
 Month                  Brand               Region
 Quarter                Category            State
 Year                                       Country




                                                            5
        Dimensional Model

   Fact Table
    – Contains measurements
    – Numerical business data
    – Data is additive


   Dimension table
    – Contains attributes
    – Describes the dimension
    – Row header in query



                                6
    What is a Data Warehouse?

   Provides access to business data

   Transactional systems are real time

   Data Warehouse is use for reporting

   Data Warehouse can be relational model

   Data Warehouse can be dimensional




                                             7
       Data Warehouse and OLAP

   Transactional (OLTP) separate from Data Warehouse

   Online Analytical Processing (OLAP) = philosophy

   Relational OLAP (ROLAP) = reality
    – Supports standard SQL
    – Supports foreign keys
    – Supports Referential Integrity
    – Supports open systems




                                                       8
  Data Warehouse and BI Tools

 Business Intelligence   Reporting Tools
     Oracle BI Answers

     Oracle Discoverer

     SAS

     Business Objects

     Cognos




                                      9
Answer Components




                    10
Connecting to Answers




                        11
Navigating BI Answers




                        12
                        Key Terms

   Subject Areas
                                          SUBJECT
    – Business related data                AREA
    – Groups of data
    – Table, view or join

   Folders                               FOLDERS
    – Reports (Query)
    – Fact or Dimension tables
    – Briefing Books (Static)
                                 REPORT   DIMENSION   FACT
    – Filters

                                                        13
                   Key Terms
   BI Presentation Catalog
    – Personal and Shared Requests
    – Personal and Shared filters
    – Interactive Dashboard

   Briefing Books
    – Snapshots of requests
    – Static and reviewed offline
   Dashboard
    – Displays content from request
    – Allows interactive modification for personal use

                                                         14
Browse Saved Request




                       15
Modify Saved Request




                       16
Results View Compound Layout




                               17
                 Results View

   Title view
    – Subtitle and Optional logo
    – Links for help

 Table view – standard row and columns
 Chart or gauge – shows graphic results
 Pivot – can interchange rows and columns
 Filters – shows filter options


                                             18
Pivot Results Window




                       19
Pivot Results Options




                        20
Drilling with Pivot Tables




                             21
Open Query with Filters




                          22
Advanced Tab




               23
Saving a Request




                   24
Help Options




               25
MY Dashboards




                26
MY Dashboards




                27
Interactive Dashboards




                         28
Interactive Dashboards




                         29
Discoverer Components

 Discoverer
  Desktop
                 End User Layer
Administration
  Edition
                     Oracle
  Discoverer        Database
     Plus


  Discoverer
   Viewer
                                  30
Connecting to Discoverer




                           31
Start Discoverer




                   32
              Key Terms
• Business Area   • Folders




                              33
       Discoverer
Opening Existing Workbook




                            34
      Discoverer
Open Existing Workbook




                         35
       Discoverer
Opening Existing Workbook




                            36
Discoverer Drilling




                      37
Discoverer Drilling




                      38
       Discoverer vs. Answers
   Discoverer Advantages
    – Easy to use – been around for a while
    – Adhoc query tool based on Oracle’s standard
          PL/SQL
          Built in SQL functions
          Prebuilt e-Business Suite reports
    – Create custom EULs for non-Oracle databases
    – Can be customized and licensed as a separate suite
    – Integration with other Oracle tools
          Oracle Warehouse Builder
          Oracle OLAP
    – Renamed: Oracle BI Standard Edition
                                                           39
       Discoverer vs. Answers
   Discoverer Limitations
    – Limited to Oracle E-Business, can be extended
      for non-EBS
    – Limited Dashboarding capability via
      Discoverer Portlets
    – Slow processing
    – Requires Java applet – possible security and
      installation issues



                                                     40
       Discoverer vs. Answers
   Oracle OBIEE Advantages
    – Ability to connect to any data source on any platform
    – Ability to merge data from multiple sources
    – Presentation Services (PS)
    – Answers and Dashboards
    – Delivers/ibots
    – BI Publisher
    – OBIEE Administrator
    – Pre-Packaged content (BI Applications)
    – Oracle Warehouse Builder license is included


                                                              41
       Discoverer vs. Answers

   Oracle OBIEE Limitations
    – Expensive
    – Difficult to administer and maintain and use
    – Additional servers and hardware
    – Limited Analytical functions




                                                     42
                       Questions        ?
                             Please contact: Ann Kalin
                            onyx@scc.net 952-443-4694
                              www.onyxtraining.com


                            WEB-BASED CLASSES (1/2 day)
PUBLIC CLASSES (Edina)      Oct 19-22 Introduction - PL/SQL
Nov 2-6 Oracle 10g DBA      Nov 2-6 Advanced PL/SQL
Dec 7-8th Intro to OBIEE    Nov 16-20 Oracle 10g SQL
Dec 9-11th Oracle Answers   Dec 1-4 Oracle SQL Tuning and
Jan 5-8th Discoverer                Performance
                                                       43

				
DOCUMENT INFO