space
Search Courses  in 

Just fill this form to get COURSE FEE details from BEST Training Institutes Instantly !

 

My City

 

I need details for

 

My Name

My Mobile Number

My Email ID

Purpose

Tell us your expectation...

obiee realtime live online,corporate training@apex

 

Apex Online Training
Apex Online Training

 

 

Information

 

 

OBIEE Hands-On Live Online Training,Corporate Training & Interview ,Job Support By IT Professionals


FOR FREE DEMO contact us at:

Email : raj@apex-online-it-training.com

Phone/WhatsApp : +91-(850) 012-2107

USA Number : 214-628-3894

Gtalk : raavi.sriraja@gmail.com

Blog: http://apex-it-online-trainings.blogspot.in



Course Content (we can customize the course curriculum as per your requirements)



OBIEE
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


FOR More Details contact us at:

Email : raj@apex-online-it-training.com

Phone/WhatsApp : +91-(850) 012-2107

USA Number : 214-628-3894

Gtalk : raavi.sriraja@gmail.com

Blog: http://apex-it-online-trainings.blogspot.in

 

Course Information

OBIEE REALTIME LIVE ONLINE TRAINING,CORPORATE TRAINING BY REALTIME EXPERTS | INDIA | USA | UK | CANADA | AUS

 

Contact Information

Address: Apex Online Training,
Hyderabad
, Hyderabad , Ameerpet
PH: 00-91-8500122107 , 00-91-8341056146
Website: www.apex-online-it-training.com
Email: raj@apex-online-it-training.com
Unix Academy Delhi Training

High Technologies Solutions - Delhi,Noida,Gurgaon

Embedded Technosolutions Mumbai

SHRISTI TECHNOLOGY LABS

GRRAS Institute Ahmedabad Jaipur Pune

Sun Infosystems Surat

Indian Institute of Technocrafts, Kolkata

Dallas Technologies Bangalore

Systems Domain Bangalore

IIHT Vadapalani Chennai

HITS computer Education chennai

Peridot Systems Chennai

vgit kilpauke learning, e-publishing, technical writting courses

RIA Institute of Technology Bangalore

Best Oracle PHP Java Training chennaiCareer Innovation Technologies Velachery

JITS Training

Mazenet SolutionAMEKS Infotech Ekkattuthangal, Chennai

7 Eleven Arthashastra Chennai

IIHT Bangalore

Core Mind Technologies Chennai

HB Services Adyar Training InstituteITBMS chennai Best Training Institute

IICT Chrompet - SAP Training in ChennaiPMP Training in India

Training course fee & Discounts

 

 

 

 

   DMCA.com Protection Status