Scribd Logo
Upload

Welcome to Scribd!

  • 391 views

    Obiee 12c Course Content

    Uploaded by

    Khaled Mohammed
    This document outlines the topics covered in a training course on Oracle Business Intelligence Enterprise Edition (OBIEE) 12C/11G. The training will cover key concepts like data warehousing, OBIEE administration, presentation services, dashboards, delivers, and more. It will also cover tools like Informatica and BI Publisher. The training is 75 hours over 45 days and will be project-oriented with both classroom and online options.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Obiee 12c Course Content

    Uploaded by

    Khaled Mohammed
    391 views6 pages
    This document outlines the topics covered in a training course on Oracle Business Intelligence Enterprise Edition (OBIEE) 12C/11G. The training will cover key concepts like data warehousing, OBIEE administration, presentation services, dashboards, delivers, and more. It will also cover tools like Informatica and BI Publisher. The training is 75 hours over 45 days and will be project-oriented with both classroom and online options.

    Original Description:

    Obiee 12c Course Content

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document outlines the topics covered in a training course on Oracle Business Intelligence Enterprise Edition (OBIEE) 12C/11G. The training will cover key concepts like data warehousing, OBIEE administration, presentation services, dashboards, delivers, and more. It will also cover tools like Informatica and BI Publisher. The training is 75 hours over 45 days and will be project-oriented with both classroom and online options.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    391 views6 pages

    Obiee 12c Course Content

    Uploaded by

    Khaled Mohammed
    This document outlines the topics covered in a training course on Oracle Business Intelligence Enterprise Edition (OBIEE) 12C/11G. The training will cover key concepts like data warehousing, OBIEE administration, presentation services, dashboards, delivers, and more. It will also cover tools like Informatica and BI Publisher. The training is 75 hours over 45 days and will be project-oriented with both classroom and online options.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 6

    Oracle Business Intelligence Enterprise Edition (OBIEE 12C/ 11G)

    1) 1) DW CONCEPTS 7) 7) OBIA 7964


    2) 2)OBIEE 12C 8) 8) LIVE PROJECTS
    3) 3)OBIEE 11G 9) 9) CHAPTER WISE PPTs
    4) 4)BI PUBLISHER 12C 1 10) CHAPTER WISE HANDSONS
    5) 5)INFORMATICA 1 11) CHAPTER WISE RECORDINGS
    6) 6)DAC
    v Course Duration : 75 Hrs (45 Days)
    v Training Mode : Class Room / On Line
    v Training Methodology : Real-time Project Oriented.

    Data Warehouse concepts


    1. What is Data
    2. Types of Data
    3. Types of Databases
    4. What is Data Warehouse?
    5. Data Warehouse Architecture
    6. Difference between OLTP Vs OLAP
    7. Types of Columns
    8. Types of Tables
    9. What is schema and types of Schemas
    10. Difference between Star and Snow Flake Schemas
    OBIEE 12C

    OBIEE Introduction :

    1. Why Oracle BI ?
    2. What is Oracle BI?
    3. History of Oracle BI
    4. Oracle BI architecture 12C Vs 11G
    5. Oracle BI components 12C Vs 11G

    OBIEE 12C Practitioner Level

    Administration

    1. Repository Basics
    2. Building the Physical Layer of a Repository
    3. Building the BMM Layer of a Repository
    4. Building the Presentation Layer of a Repository
    5. Testing Repository
    6. Working with Multiple Logical Table Sources
    7. Adding Calculations to Fact Table

    8. Creating Dimensional Hierarchies& Level based measures


    OBIEE 12C Lerner Level
    Presentation Services or Analytics
    1. Introduction to Presentation Services
    2. What is Web Catalog & Instanceconfig.xml
    3. Difference between Shared Folders & My Folders
    Answers
    RR ITEC.COM #209,Nilagiri Block,Adithya Enclave,Ameerpet @8374899166,8790998182 1
    Answers

    1. Working with OBI Answers


    2. OBI Column Properties
    3. Style ,Column Format ,Data Format , Conditional Format ,Intraction and Write
    Back
    4. Hide Column
    5. Edit Formulas / Report level Calculations
    6. Filters
    7. Column ,image and Variable Prompts
    8. Sorting of Columns
    9. OBI 17 Views
    10. Combining With Similar Request
    11. Direct Database Requests

    Dashboards

    1. Creating Oracle Business Intelligence Interactive Dashboards


    2. Working With Dashboard Objects
    3. Column , Section ,Link or Image ,Embedded Content ,Text, Folder, Action Link
    ,Action Link Menu ,Alert Section
    4. Hiding or showing Section Dynamically based on condition
    5. Working With Dashboard Prompts
    6. Column ,Image and Variable Dashboard Prompts
    7. Presentation Variables
    8. Request Variable

    Delivers

    1. Introduction to Oracle BI Delivers


    2. Oracle BI Deliveries Tables
    3. Configuring delivery devices
    4. Adding delivery profiles
    5. Developing Agents
    6. Building Alerts
    7. Creating Agents Based on Time
    8. Creating Agents Based on Time and Condition
    9. Creating Chain of Agents

    Job Manager
    1. Monitoring Agents
    Oracle BI for Microsoft Office
    1. Introduction to Oracle BI for Microsoft Office
    2. Installation of Oracle BI for MS Office
    3. Accessing OBI reports in MS Excel
    4. Accessing OBI Reports in MS Power Point
    Catalog Manager
    1. Deploying Dev to test or test to prod
    2. Deploying in Offline or Online Mode
    3. Catalog Back Up and Restore
    4. Providing Permissions
    5. 5. Documentation of Web Catalog
    RR ITEC.COM #209,Nilagiri Block,Adithya Enclave,Ameerpet @8374899166,8790998182
    OBIEE 12C Specialist Level

    1. Using Aggregate Tables


    2. Using Partitions and Fragments
    1. Value Based
    2. Fact Based
    3. Level Based
    3. Variables
    1. Static Repository
    2. Dynamic Repository
    3. Repository Initialization Blocks
    4. System Session
    5. Non System Session
    6. Session Initialization Blocks
    7. Row Wise Initialization Blocks
    8. Presentation Variables
    9. Request Variables
    4. Time Series Functions
    1. AGO
    2. TODATE
    3. PERIODROLLING
    5. Configuring Many To Many Relationships
    1. Bridge Table
    2. Helper Table

    6. Deploying Oracle Bi application to multiple countries


    1. Localizing Oracle BI Metadata
    2. Localizing Oracle BI Data
    7. Setting Implicit Fact Column
    8. Third Party Reporting Tool Integration
    9. Creating Repositories From Multi dimensional Data Sources
    10. Security
    1. Authentication
    1. LDAP
    2. External Table
    2. Authorization
    1. Object Level
    1. RPD
    2. Web Catalog
    2. Data / Row Level
    11. Administering Usage Tracking
    12. Multi-User Development Environment (MUDE)
    13. Utilities
    14. Cache Management
    15. Optimizing Query Performance
    16. Cluster Servers
    17. Alias ,Circular Joins & Opaque Views or Select Tables

    OBIEE 12C Advanced Level


    1. Introduction about EM, CONSOLE, ANALYTICS, XMLPSERVER..etc
    2. Parent Child Hierarchies
    3. Unbalanced Hierarchies
    1. Ragged Hierarchies
    2. Skipped Hierarchies
    4. Hierarchical Columns and Selection Steps
    5. Action Links
    6. Creating Simple Action Links
    7. Creating Advanced Action Links
    8. Master Detail Reports
    9. Creating KPI
    10. Creating KPI Watch List
    11. Creating Scorecards
    12. Assign ID columns to descriptive columns
    13. Using Lookup Table
    14. Horizontal Federation
    15. Vertical Federation
    16. Combined Horizontal & Vertical Federation
    OBIEE 12c Data Visualization
    1. Creating Your First Visual Analyzer Project
    2. Data Mashups
    3. BI Ask
    4. Visual Analyzer and the Web Catalog

    Deployment
    1. Moving RPD and Web Catalog from Development server to Testing Server
    2. Moving RPD and Web Catalog from Testing Server to Production Server

    Migration
    1. Under Standing Pre Migration Process
    2. Understanding Upgrade Assistant Wizard
    3. Migrating from OBIEE 10G to OBIEE 11G
    4. Under Standing Post Migration Process

    BI Publisher 12C
    1. Introduction to BI Publisher or XML publisher
    2. Integrating database
    3. Integrating Oracle BI Presentation server
    4. Integrating Oracle BI Discoverer
    5. Configuring BIP Scheduler
    6. Installing Oracle BI Publisher Desktop
    7. Develop BI Publisher Templates Directly From Data Base
    8. Working with Parameters and List Of Values (LOVs)
    9. Develop BI Publisher Templates using OBI Answer Request
    10. Develop BI Publisher Templates using OBI Subject Areas
    11. Develop BI Publisher Templates using XML file
    12. Scheduling BI Publisher templates
    13. Deployment of BIP reports
    14. Integrating BIP reports in OBIEE dashboard

    Informatica 9.6
    1. INFORMATICA 9 Introduction
    2. INFORMATICA 9 Installation
    3. Server Installation
    4. Client Installation
    5. Informatica Administration Console
    6. Repository Manager
    7. Configuring RRITEC Database
    1. Configuring source database
    2. Configuring Target database

    8. Hands on 01_Source_Target_Import
    1. Exercise 1: Import a Source Schema
    2. Exercise 2: Import a Target Schema
    9. Hands on 02_Creating_mapping
    1. Exercise 1: Create a Mapping
    10. Hands on 03: Creating Workflow
    1. Exercise 1: Create a Workflow
    2. Exercise 2: Create source and target database connections
    3. Exercise 3: Create a Task and Run the Workflow
    4. Exercise 4: Monitor the Workflow
    11. Hands on 04: Flat file Filter
    1. Exercise 1: Import Source and Target
    2. Exercise 2: Create the Mapping
    3. Exercise 3: Create and Run the Workflow
    DAC 11G
    1. DAC Installation
    2. Configuring DAC
    3. Configuring Source & Target Data Base
    4. Configuring Informatica repository Service
    5. Configuring Informatica Integration Service
    6. Creating Container
    7. Configuring Informatica Physical Folder
    8. Creating Informatica Logical Folder
    9. Mapping Informatica Physical and Logical Folders
    10. Creating Task Phases
    11. Creating primary source
    12. Creating Target source
    13. Creating Tasks
    14. Creating Task Group
    15. Creating Subject Areas
    16. Creating Execution Plans
    17. Understanding Execution Plan Parameters
    18. Scheduling Execution Plans
    19. Deployment
    1. Export
    2. Import
    20. Creating OBAW Data Model

    OBIA 7964
    1. Oracle Business Intelligence Application Overview
    2. Oracle Business Intelligence Application Overview and Architecture
    3. Oracle Business Analytics Warehouse Content
    4. Installing the OBIA
    5. Deploying Informatica Repository
    1. Understanding the ETL Process
    2. Exploring SDE , SIL and PLP Mappings
    3. Assigning Integration server
    4. Changing source and target database connections
    6. Deploying DAC
    1. Importing DAC repository
    2. Copying container
    3. configuring database and Informatica connections
    7. Deploying OBAW
    1. Creating OBAW data Model
    2. Understanding types of OBAW tables
    8. Loading OBAW database
    9. Customizing the Oracle Business Analytics Warehouse
    10. Deploying RPD of OBIA
    11. Deploying Web Catalog of OBIA
    12. Understanding pre defined reports and Dashboards
    13. Types of Analytics
    1. CRM Analytics
    2. ERP Analytics
    3. Industrial Analytics
    14. Human Resource Analytics
    15. Sales Analytics
    16. Faineance Analytics
    Live Projects:
    1. Gathering Requirement
    2. Understanding& Analyzing Requirement
    3. Developing Business Specification Document
    4. Developing High Level Design Document
    5. Developing Low level Design Document
    6. Following Unique Coding Standards
    7. HR analytics
    8. Finance Analytics
    9. Sales Analytics

    You might also like