Hide Notes 

Slide 1: 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
Slide 2: 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
Slide 3: 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
Slide 4: 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    
Slide 5: Dimensional Model ORDERS Time key Product key Customer key Sold amount Units sold Cost amount Time Dimension Time key Day of week Month Quarter Year Product Dimension Product key Description Brand Category CustomerDimension Customer key Customer name Region State Country 5
Slide 6: Dimensional Model  Fact Table – Contains measurements – Numerical business data – Data is additive  Dimension table – Contains attributes – Describes the dimension – Row header in query 6
Slide 7: 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
Slide 8: 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
Slide 9: Data Warehouse and BI Tools  Business  Intelligence Reporting Tools Oracle BI Answers  Oracle Discoverer  SAS  Business Objects  Cognos 9
Slide 10: Answer Components 10
Slide 11: Connecting to Answers 11
Slide 12: Navigating BI Answers 12
Slide 13: Key Terms  Subject Areas – Business related data – Groups of data – Table, view or join SUBJECT AREA  Folders – Reports (Query) – Fact or Dimension tables – Briefing Books (Static) FOLDERS – Filters REPORT DIMENSION FACT 13
Slide 14: 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
Slide 15: Browse Saved Request 15
Slide 16: Modify Saved Request 16
Slide 17: Results View Compound Layout 17
Slide 18: 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
Slide 19: Pivot Results Window 19
Slide 20: Pivot Results Options 20
Slide 21: Drilling with Pivot Tables 21
Slide 22: Open Query with Filters 22
Slide 23: Advanced Tab 23
Slide 24: Saving a Request 24
Slide 25: Help Options 25
Slide 26: MY Dashboards 26
Slide 27: MY Dashboards 27
Slide 28: Interactive Dashboards 28
Slide 29: Interactive Dashboards 29
Slide 30: Discoverer Components Discoverer Desktop Administration Edition Discoverer Plus Discoverer Viewer 30 End User Layer Oracle Database
Slide 31: Connecting to Discoverer 31
Slide 32: Start Discoverer 32
Slide 33: Key Terms • Business Area • Folders 33
Slide 34: Discoverer Opening Existing Workbook 34
Slide 35: Discoverer Open Existing Workbook 35
Slide 36: Discoverer Opening Existing Workbook 36
Slide 37: Discoverer Drilling 37
Slide 38: Discoverer Drilling 38
Slide 39: 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
Slide 40: 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
Slide 41: 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
Slide 42: Discoverer vs. Answers  Oracle OBIEE Limitations – Expensive – Difficult to administer and maintain and use – Additional servers and hardware – Limited Analytical functions 42
Slide 43: Questions ? Please contact: Ann Kalin onyx@scc.net 952-443-4694 www.onyxtraining.com WEB-BASED CLASSES (1/2 day) PUBLIC CLASSES (Edina) Nov 2-6 Oracle 10g DBA Dec 7-8th Intro to OBIEE Dec 9-11th Oracle Answers Jan 5-8th Discoverer Oct 19-22 Introduction - PL/SQL Nov 2-6 Advanced PL/SQL Nov 16-20 Oracle 10g SQL Dec 1-4 Oracle SQL Tuning and Performance 43