Oracle Business Intelligence Applications – OBIA Training
Oracle Business Intelligence Applications (OBIA) is a pre-built business intelligence solution that delivers intelligence across an organization, empowering users at all levels from front line operational users to senior management with key information that maximizes effectiveness. These solutions allow organizations to rapidly deploy business intelligence throughout their organization without the traditional cost and time associated with defining, designing and developing a custom data warehouse, ETL, metadata, reports and dashboards.
The Oracle Business Intelligence Applications – OBIA training is meticulously crafted by a highly seasoned industry professional with over 10+ years of expertise in the domain.
In This Module We Will Learn :
ORACLE BUSINESS INTELLIGENCE APPLICATIONS OVERVIEW
- Oracle BI Applications components
- Business areas supported in Oracle BI Applications
- Oracle BI Applications Architecture
ORACLE BI APPLICATIONS COMPONENTS OVERVIEW
- Oracle BI Applications architecture overview
- Oracle BI Applications product lifecycle overview
- Oracle Business Analytics Warehouse Content
PRE-BUILT STAR SCHEMAS IN ORACLE BUSINESS ANALYTICS WAREHOUSE
- Oracle Business Analytics Warehouse naming conventions
- Overview of Oracle Business Analytics Warehouse tables
- System columns in Oracle Business Analytics Warehouse tables
- Installing Oracle Business Intelligence Applications
PREINSTALLATION AND DEPLOYMENT REQUIREMENTS
- Installing Oracle BI Applications prerequisites
- Installing Oracle BI Applications
- Performing post-installation system set up tasks
- Understanding the ETL Process
ETL PHASES AND PROCESSING OVERVIEW
- Using ODI Studio to explore prebuilt ETL metadata
- Full ETL and incremental ETL
- Change capture
- ETL versus ELT
- Functional Configuration for Oracle BI Applications
FUNCTIONAL CONFIGURATION OVERVIEW
- Terminology related to Oracle BI Applications configuration
- Configuration Manager overview
- Functional Setup Manager overview
- Creating an implementation project
- Assigning configuration tasks to developers
- Administering and Maintaining Functional Configuration Data
FUNCTIONAL CONFIGURATION DATA OVERVIEW
- Administering and maintaining domains and domain mappings
- Editing domain members
- Administering and maintaining data load parameters
- Administering and maintaining reporting parameters
- Managing Load Plans
DEFINING, GENERATING, EXECUTING, AND MONITORING LOAD PLANS
- Troubleshooting and restarting load plans
- Managing load plan parameters
- Customizing the Oracle Business Analytics Warehouse
ADDING COLUMNS TO EXISTING TABLES IN THE OBAW
- Creating custom ETL mappings for a category 1 customization
- Enabling versioning for a category 1 customization
- Generating DDL scripts for a category 1 customization
- Creating and executing a load plan for a category 1 customization
- Building a Category 2 Customization
CUSTOMIZATION TYPES AND SCENARIOS OVERVIEW
- Overview of category1 and category 2 customizations
- Impact of patches on customizations
- Applying an update strategy
- Building a Category 1 Customization
TOOLS USED TO MANAGE ORACLE BI APPLICATIONS SECURITY
- Oracle BI Applications security levels
- Exploring default security settings for Oracle BI Applications
- Exploring ODI security
OPTIMIZING PERFORMANCE OVERVIEW
- Managing Performance
- Performance tuning recommendations
ADDING A NEW DIMENSION TABLE TO THE OBAW
- Creating custom ETL mappings for a category 2 customization
- Enabling versioning for a category 2 customization
- Generating DDL scripts for a category 2 customization
- Creating and executing a load plan for a category 2 customization
- Oracle BI Applications Security
Course Content
Similar Courses:
Oracle Process Cloud Service (PCS) Training
The Oracle Process Cloud Service (OPCS) training consists of a set of 9 modules and…
Oracle Database Developer – SQL and PL/SQL Training
With over 5+ years of specialized expertise in the sector, our training instructor has meticulously…
Basics of Oracle Data Modelling Training
With over 5+ years of specialized expertise in the sector, our training instructor has meticulously…
Oracle Transactional Business Intelligence (OTBI) Training
The Oracle Transactional Business Intelligence (OTBI) course/training is meticulously crafted by a highly seasoned industry…