We are providing Exclusive Training on OBIEE 11G by Faculty from top MNC’s with highly skilled domain expertise will train & guide you with real time applications and case studies. We also help you in resume preparation and provide job assistance till you get job.
Key features offered:
OBIEE 11G
Case studies
Exercises
Sample applications
Resume preparation and more
Our training features:
You will receive top quality instruction that we are famous for online trainings.
Training from professional experts with Real time project scenarios and real-time examples
Excellent course material will be provided
State-of-the-art lab with required software for practicing
Resume preparation and job assistance
OBIEE 11g Online Training Course Content
|
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 Oracle BI Administration Tool
- Repository Directory
- Repository Files ( Initialization files and log files)
- Informatica Server ETL 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
- 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
Call Us : 08019871850
Mail Us : infoprofessionalonlinetraining@gmail.com |
No comments:
Post a Comment