OBIEE 12c Certification Training

✔ OBIEE Overview
✔ OBIEE Architecture
✔ Clients
✔ OBIEE 11 BI Services
✔ OBIEE Weblogic Admin
✔ OBIEE Repository (rpd)
✔ Data Sources

✔ OBIEE Components
✔ OBIEE Administration Tool
✔ OBIEE Analysis
✔ Intelligence Dashboards
✔ BI Publisher-BI Agents/Actions-KPI/Scorecard
✔ BI Office

✔ Repository Basics
✔ Oracle Business Analysis Warehouse
✔ Weblogic Server
✔ Enterprise Manager
✔ Sample Request Processing
✔ Using the OracleBI Administration Tool
✔ Repository Directory
✔ Repository Files ( Initialization files and log files)
✔ Loading a repository into Oracle BI Server memory
✔ Creating a repository
✔ Connection Pool
✔ Repository Modes ( ONLINE and OFFLINE )
✔ Physical Layer
✔ Business Model & Mapping Layer
✔ Presentation Layer
✔ Presentation Catalogs, Folders and Columns
✔ Error Messages

✔ Building the Physical Layer of a Repository
✔ Defining an ODBC System DSN
✔ Setting up connection pool properties
✔ Importing data sources ( Physical Schema )
✔ Verifying the import
✔ Defining physical keys and joins
✔ Creating alias and select tables

✔ Building the Business Model and Mapping Layer of a Repository
✔ Creating the logical business model
✔ Creating the logical tables, columns, and sources
✔ Defining logical joins
✔ Adding Calculation to a Fact Table
✔ Building measures

✔ Building the Presentation Layer of a Repository
✔ Creating a new Presentation Catalog
✔ Modifying Presentation layer objects
✔ Rename tables
✔ Reorder Table
✔ Testing and Validating a Repository
✔ Checking repository consistency
✔ Defining a repository in the initialization file
✔ Testing a repository using Oracle BI Answers
✔ Adding Multiple Logical Table Sources
✔ Adding multiple logical table sources to a logical table
✔ Specifying logical content
✔ Adding Calculations to a Fact Table
✔ Creating new calculation measures based on existing logical columns
✔ Creating new calculation measures based on physical columns
✔ Creating new calculation measures using the Calculation Wizard
✔ Creating Dimension Hierarchies and Level-Based Measures
✔ Creating dimension hierarchies
✔ Creating level
✔ Based measures

✔ Creating & Using Aggregates
✔ Purpose of aggregate tables in dimensional modeling
✔ Modeling aggregate tables to improve query performance
✔ Testing aggregate navigation
✔ Using Initialization Blocks Repository Variables
✔ Creating Dynamic Repository Variables
✔ Execute Direct Database Requests
✔ Accessing database directly
✔ Creating Time series Measures
✔ Using time comparisons in business analysis
✔ Using Oracle BI time series functions to model time series data
✔ BI Analysis and Dash board & Publisher
✔ Creating and Editing Analysis
✔ Creating Interactive Dashboards using Analysis
✔ Creating query and chart

✔ Working with Filters
✔ Working with Pivot Table
✔ Building Views and Charts in Requests
✔ Creating and Configuring Interactive Dashboards
✔ Creating and Configuring Dashboard Prompts
✔ Configuring Action Links
✔ Creating and understanding KPI, KPI Watchlists, and Scorecards
✔ Oracle BI for MS Office
✔ Sending Alerts Using Delivers
✔ Using Job Manager