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..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..in