DAY 1
Oracle BI EE Introduction, Architecture
- An Overview of OBIEE
- Source
- Informatica
- DAC
- Application layer
- Presentation layer
- OBIEE architecture, technology stack components, overview
- Analytics
- Administration (levels of abstraction)
- Physical layer
- Business Model and Mapping layer
- Presentation layer
- Datawarehouse Concepts, Overview
- Dimensions
- Facts
- Measures
- BI Server design: cache, security, high availability options, steps
- Installation and Configuration, Options and Steps
Analysis and Dashboards Overview, Demo
- Analysis, Subject Areas
- Creating Reports
- Creating Graphs, etc
- Populating Dashboards
Oracle BI EE Server Administration - Administering the repository
- Physical Layer
- Business Model and Mapping Layer
- Presentation Layer
- Validating the repository
- Using logs to validate sessions
Oracle BI EE Server Administration - Physical layer
- Calculation measures and logical columns
- Calculation measures using BI Answers
- Creating database connections in Administrator
- Connecting to flat files and other data sources in Administrator
- Development of Physical meta data layer
- Adding joins to Physical meta data layer
- Advanced Administrator techniques
- Physical Repository Design
- Metadata Layer Design
- Importing data sources
- Setting up connection pool properties
- Defining keys and joins
- Creating alias and select tables
Labs - The OBIEE Physical Layer
- Managing physical joins
- Managing data sources
- Working with flat files
- Connecting to non-Oracle databases
DAY 2
Oracle BI EE Server Administration - Business Model and Mapping
- Aggregates
- Time Series Data: Creating Ago and ToDate measures
- Dimension Hierarchies and Level-Based Measures
- Calculations on Fact Tables
- Adding measures to an existing repository
- Delivers Configuration and Interface
- Developing calculations and Dimensional Hierarchies
- Joining different data sources
- Repository Variables
Labs - OBIEE Business Model and Mapping
- Creating a Business Model
- Creating Logical Columns, Logical Joins plus creating Logical Tables and adding to dimensions
- Renaming Business Model Objects
- Deleting Unnecessary Business Model Objects
- Building Dimension Hierarchies
- Working with partitioned data sources
- Creating and managing aggregate tables
- Configuring time based keys
- Defining and using repository variables
Oracle BI EE Server Administration - Presentation Layer
- Building the Presentation layer
- Managing the Oracle BI Presentation Catalog
- Specifying sources for partitioned data
- Using repository variables
- Handling data structure anomalies and difficulties
- Developing Presentation meta data layer
- Organizing the Presentation layer for maximum utilization
Labs - The Presentation Layer
- Creating Presentation layer objects
- Creating a Subject Area
- Using Administrator Logging
Oracle BI EE Server Administration - Advanced Topics
- Oracle BI Security Goals
- Checking repository consistency
- Cache and Catalog Management
- Oracle BI Security Goals
- Scheduler Server
- Server Shutdown / Startup overview
- Log file troubleshooting and reviews
- Customizing the Oracle Business Intelligence User Interface
- Custom Login screen
- Style sheets for views and portal
- Inspecting the query log
- Usage logging
- OBIEE Performance Tuning Concepts
Labs - OBIEE Advanced Topics
- Running and diagnosing Consistency Checks
- Working with Cache
- Creating user and group security
- Configuring Scheduler server and database objects
- Customizing the login screen
- Changing OBIEE's look and feel
- Turning on usage logging
The sessions are being held from 9 am to 5 pm.
|
