DATA WAREHOUSING AND OBIEE
  • Introduction and Background
  • A Brief History of Oracle Business Intelligence
  • Data Warehouse Concepts
  • Data Warehouse Architectures
  • Logical Design in Data Warehouses
  • Data Warehousing Schemas
  • Data Warehousing Objects
  • Business Intelligence
  • About Oracle Business Intelligence Enterprise Edition 11g
  • An Introduction to Analyses, Dashboards, and Interactive Reporting
  • Oracle Business Intelligence 11g Architecture
DOWNLOAD AND INSTALLATION
  • Instant Client Download and Configuration
  • Installation of Loopback Adapter
  • Installation of Oracle Databases 11g
  • Install Repository Creation Utility (RCU) 11g
  • Install Oracle Business Intelligence Enterprise Edition 11g
  • Post Installation Steps
BUILDING THE METADATA REPOSITORY
  • 0_Module 3 Outline and Introduction
  • Building the Physical Layer of a Repository
  • Building the Business Model and Mapping Layer of a Repository
  • Building the Presentation Layer of a Repository
  • Testing and Validating a Repository
  • Managing Logical Table Sources
  • Creating Calculation Measures
  • Creating Logical Dimensions with Level-Based Hierarchies
  • Creating Level-Based Measures
  • Using Aggregate Persistent Wizard
  • Using Initialization Blocks and Variables
  • Creating Time Series Measures
CREATING ANALYSES AND DASHBOARDS
  • Module 4 Outline and Introduction
  • Beginning the Analytic Process
  • Creating Analyses
  • Formatting Analyses
  • Using Formulas, Filters and Prompts
  • Modifying Views and Adding Pivot Tables
  • Working with Pivot Tables, Gauges, and Master-Detail Linking
  • Building Dashboards
  • Working with Agents
  • Published Reporting - BI Publisher
  • Using Scorecards, KPIs and KPI Watchlists
  • Working With Briefing Books
INTRODUCTION TO SECURITY
  • security
  • Creating Users, Groups and Catalog Permissions
  • Row and Column Level Security
OBIEE In Oracle Linux Environment
  • 1. OBIEE On Oracle Linux Virtual Machine
  • 2. Download OBIEE SampleApp Files
  • 3. Other Required Downloads
  • 4. Installation of Other Required Downloads
  • 5. Installation of Oracle Database 12c
  • 6. Installation of Oracle BI Developer Client Tool
  • 7. Installation of ODBC - Instant Client
  • 8. How to Extract SampleApp OBIEE Downloads
  • 9. Importing the Virtual Appliance
  • 9.2 Starting and Shutting down OBIEE in the VM
  • 9.3 Oracle ODBC Driver Configuration
  • 10. Importing Dump files into Oracle Linux VirtualBox
  • 11. Connecting the Admin Tool to the Oracle Database in Linux
  • 12. How to Deploy the RPD in Linux Environment