Microtech Consultancy & Training Institute |OBIEE




Oracle is the most popular RDBMS. it's created by Oracle Corporation. it's one among the most demanding database management system. it's the most important database technology. Oracle is a collection of data and utilization of SQL queries. Oracle is used in several of the Organization for storing and retrieving the structural data. Oracle helps to learn both SQL additionally as well ad Pl/SQL. SQL Developer, PL/SQL Developer, Toad, etc are some examples of third-party tools that build easier to use database for SQL and PL/SQL work.

We Rated as Best Oracle coaching institute in Tirupati –We Provides 100% Assurance on your Oracle OBIEE coaching & Certification Completion in Tirupati.

Microtech Training Institute is one of the leading Oracle OBIEE coaching Center in Tirupati Offers Job orientating Oracle Courses in Tirupati are taught by experienced Certified Professionals. Get practical exposure on Oracle concepts from this Real time Oracle coaching.

Most of Our Trainers are presently working in TCS, Cognizant, Oracle Corporation, IBM, Accenture, Microsoft etc. Since they're working in Oracle domain they're going to Share all the day to day challenges at add this coaching Session.

    Data Warehouse

    Basics of Data Warehousing

    What is OLTP and OLAP?

    Difference between OLTP and OLAP

    Dimension, Fact, Aggregate tables

    Star Schema, Snowflake schema

    Star Schema vs Snowflake Schema

    What is OBIEE?

    Introduction to OBIEE 11G

    Based on Fusion Middleware 11g Platform

    End-to-End Life Cycle of OBIEE

    Oracle BI Architecture 11g

    Oracle BI Components 11g

    RPD & Catalog Basics

    Repository Basics

    Metadata & Catalog Basics

    Physical, BMM, Presentation layers Overview

    RPD Online Mode and Offline Mode

    Answers, Dashboards, Administration

    Repository & Catalog Deployment

    Start/Stop Weblogic & BI Services

    Create a New Repository

    Import Metadata

    Verify Connection

    Properties of Physical Layer Objects

    Creating Aliases, Physical Keys and Joins

    Creating Business Model

    Properties of BMM Layer Objects

    Examine Logical Joins, Logical Columns, LTS

    Rename Logical Objects Manually

    Rename Logical Objects Using the Rename Wizard

    Delete Unnecessary Logical Objects

    Create Simple Measures

    Creating Presentation Layer Objects

    Properties of Presentation Layer Objects

    Rename Presentation Columns

    Reorder Presentation Columns

    Creating Nested Structure

    Check Global Consistency

    Load the Repository

    Understanding Logging Levels

    Set Up Query Logging

    Validating Query Logging

    Add a New Logical Table Source

    Create Presentation Layer Objects

    Validation of Multiple LTS

    Create a Calculation Measure Derived from Existing Columns

    Create a Calculation Measure Using a Function

    Creating Dimension Hierarchies

    Validating Drill Down feature

    Creating Level Based Measures/p>

    Modelling Aggregate Tables

    Validating Aggregate Navigation

    Creating Ragged & Skipped Level Hierarchy

    Calendar Date/Time Functions

    Conversion Functions

    Display Functions

    Evaluate Functions

    Lookup Functions

    Mathematics Functions

    String Functions

    System Functions

    Time Series Functions

    Understanding Variables

    Creating Session Variables

    Creating Repository Variables

    Creating Initialization Blocks

    Referencing Variables

    Introduction to Analytics

    Creating a Report

    Using Analysis Editor

    Saving Reports

    Formatting & Sorting the Reports

    Creating Filters

    Creating Saved Filters

    Title View

    Table, Pivot View

    Graphs, Gauges


    Narrative View

    Static Text

    Column/View Selector

    Creating Prompts

    Creating Dashboards

    Running a Dynamic Report on a Dashboard

    Working with Presentation Variables

    Creating Dashboard Pages

    Advanced Dashboard Properties

    Creating Union Reports

    Practical Scenarios

    Understanding Action Links

    Navigating to a Report

    Navigating to a Web Page

    Creating KPIs, KPI Watchlist, Scorecards

    Displaying Scorecards on a Dashboard