space
Search Courses  in 

Get CourseName COURSE FEES Instantly from BEST Training Institutes!

 

My City

I need details for

 

My Name

My Mobile Number

My Email ID

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

IIHT Bangalore

Mazenet SolutionAMEKS Infotech Ekkattuthangal, Chennai

IIHT Vadapalani Chennai

7 Eleven Arthashastra Chennai

vgit kilpauke learning, e-publishing, technical writting courses

Core Mind Technologies Chennai

Dallas Technologies Bangalore

Peridot Systems Chennai

RIA Institute of Technology Bangalore

Systems Domain Bangalore

JITS Training

HITS computer Education chennai

IICT Chrompet - SAP Training in ChennaiPMP Training in India

Best Oracle PHP Java Training chennaiCareer Innovation Technologies Velachery

HB Services Adyar Training InstituteITBMS chennai Best Training Institute

Training course fee & Discounts

 

 

 

 

   DMCA.com Protection Status