obiee online training 100 real time Apex Online IT Trainings

OBIEE realtime online training, job & interview support, corporate training | Apex Online IT Trainings

OBIEE course makes you a professional in building the applications by leveraging capabilities of Building Physical Layer Of A Repository, Testing And validating Repository, Oracle bi Presentation Services, Server design and etc. This course conjointly includes the way to produce Dimensional Hierarchies And Level based mostly Measures and the way to add Multiple Sources To Dimension.

FOR FREE DEMO contact :
Email : [email protected]
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : [email protected]
Blog: https://best-online-it-training-institute.blogspot.com/
Webs
ite: www.apex-online-it-trainings.com

Obiee Interview queries and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments are going to be provided

OBIEE COURSE course of study

(the course content may be modified as per your requirements):

DATAWAREHOUSING CONCEPTS
Introduction and Definition
Sources, Transformations and Targets( Architecture )
Data Extraction, Data Transformations and Data Loading( Data Acquisition Process)
Data Warehousing Approaches
Staging Area, Metadata, Repository and Data Mart
Differences between OLTP and OLAP( DSS ) Systems
Operational Data Store( ODS )
Business Intelligence
Star Schema Design & Confirmed Dimension, Fact less Fact Table, Types of Facts
Slowly Changing Dimensions( SCD )

OBI Overview

NEW FEATURES OF OBI

OBI ARCHITECTURE
Clients
OBI Presentation Services
OBI Server
OBI Repository (.rpd)
Data Sources

OBI COMPONENTS
OBI Administration Tool
OBI Answers
Intelligence dashboards

REPOSITORY BASICS
Oracle Business Analysis Warehouse
DAC and Informatica Server
Informatica Server ETL
Sample Request Processing
Using the OracleBI Administration Tool
Repository Directory
Repository Files ( Initialization files and log files)
Informatica Server ETLLoading 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
Message Severity
iewing Server Logs

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
Adding Multiple Logical Table Sources
Adding multiple logical table sources to a logical table
Specifying logical content

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

CREATING DIMENSION HIERARCHIES AND LEVEL-BASED MEASURES
Creating dimension hierarchies
Creating level-based measures

Providing Security for Groups & UsersANSWERS (REPORTS)
WORKING WITH ORACLE BUSINESS INTELLIGENCE ANSWERS
Introduction to Oracle BI Answers
Working with requests in Oracle BI Answers
Using advanced formatting
Creating report Level Hierarchy

FILTERING REQUESTS IN ORACLE BUSINESS INTELLIGENCE ANSWERS
Introduction to filters in Answers
Adding filter prompts to requests
Using saved requests as filters

BUILDING VIEWS AND CHARTS IN REQUESTS
Introduction to Answers views and charts
Creating and editing charts
Performing common view tasks
Creating a Narrative View
Creating a column Selector

SHOWING RESULTS WITH PIVOT TABLES
Introduction to pivot tables
Formatting pivot tables
Setting aggregation rules and building formulas

CREATING ORACLE BUSINESS INTELLIGENCE INTERACTIVE DASHBOARDS
Introduction to Interactive Dashboards and pages
Adding Objects to Dashboard
Creating Dashboard prompts
Embedding content in an Interactive Dashboard