OBIEE - Data Warehousing Training

Training/Coaching/Tuition by Big Classes Hyderabad View Contact

Request Info

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

Note: All Training will be on BI Sample Schema.

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

• Viewing 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 & Users:

Answers (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

Oracle Business Intelligence Enterprise Edition (Oracle BI EE) is a comprehensive set of enterprise business intelligence tools and infrastructure, including a scalable and efficient query and analysis server, an ad-hoc query and analysis tool, interactive dashboards, proactive intelligence and alerts, real-time predictive intelligence, and an enterprise reporting engine.
Oracle Business Intelligence online training is designed for every learner to bring greater business visibility and insight to a wide variety of users.
OBIEE training provides a full range of business intelligence capabilities that allow you to:

• Collect up-to-date data from your organization

• Present the data in easy-to-understand formats (such as tables and graphs)

• Deliver data in a timely fashion to the employees in your organization

• These capabilities enable your organization to make better decisions, take informed actions, and implement more-efficient business processes.

OBIEE online training provides a solid foundation on OBIEE 11g step-by-step procedures for building and verifying the three layers of an Oracle BI repository.
Participants will learn to design the Repository, Creating Answers/Analysis Requests, and Interactive Dashboard, Delivers, OBIEE 11g/Fusion Middle ware Security and OBIEE-BI Publisher integration.
Oracle Business Intelligence course is designed for those professionals who are looking for Great career as Consultant in BI Technology.

Trainer Information

• Having 6 Yrs of IT exp

• And 3.5+ yrs of OBIEE and DWH Exp

• Having exp 2yrs as an online trainer for obiee.

• Held up to 80+ batches in past 1yr.

• Worked with future point, Focus Thread, Kennedy International and various pvt projects

Big Classes

BigClasses.com is been into the IT market since a decade. We have started our career 10 years back as a class room training provider. After 5 years in the classroom training, as a part of expansion in 2008, we have moved to online training. We are offering the services globally with local and international standards with real time exposure. Now, after 10 years of expertise in software training, we are one of the best online training service portals of the industry. This shows our standards and commitment towards the software learners.

Since inception of BigClasses.com, it has evolved into a cherished and most reliable retail and Corporate Training Company.

BigClasses.com Training is one training institute where online interactive training is a common experience and many students in the past have learnt, mastered, got certified and landed excellent jobs on their way to their careers. Our training takes place with well-prepared training materials. We provide documentation and the best interview preparation materials for learners.

BigClasses.com has access to a faculty of esteemed and highly qualified consultants to deliver the courses. These instructors are not in any way academics, but rather specialists actively involved in consulting to business in their particular fields. This gives the learners a fuller insight of the needs and as well as knowledge about actual and future trends in the market, and makes the courses extremely practical and relevant.

We don’t just give training and leave you on your own but support you even after you get into the job. We are providing web based online training in major IT Courses, where you can sit at home in front of the system and learn without travel or relocate during the training program. You can practice exercises and real-time projects which are given by our esteemed instructors.

Training is conducted by experienced and certified Instructors. Prestigious clients are included in our Clientele list and 100% Successful placement for excellent candidates.

BigClasses.com Institute is an online provider of IT technologies training products for individual and for corporate groups our training manuals and programs are designed to be used in a self-study or home based training environment. This allows any student the ability to learn at their own pace and on their own schedule.

Self-paced training is a very effective method of training and can be used with any schedule and with no previous experience. Effective results can be achieved in as little as 15 minute blocks of time not hours or days as is common with seminars and schedule courses.

All our materials are available with instant download which means you can get started on your training within minutes. The result is that you can show noticeable improvement in less than a day with our training Bigclasses.com.

Our materials are designed to be used in a self-study or home based environment so anyone can fit this training into any schedule no matter how busy it may be. Self-study also allows an individual the ability to train at their own pace and not have to worry about missing any concepts or being forced to proceed too slow like what might happen in a class or schedule group class.

We are dedicated to providing the very best in Bigclasses.com training while providing quality training at affordable prices. Our goal is to product training that is within the budget of anyone who desires to improve their IT skills.

Corporate Group Training: For companies or large groups who wish to provide quality Customer Service training for their employees, Bigclasses.com online training Institute is proud to announce their Corporate! Under our Corporate Training Program, we offer our Training package at group rates. This course encompassing 6 training modules covering both basic fundamentals and advanced techniques.

Bigclasses.com Training Certificate Program: A complete course in Bigclasses.com Training from Basic fundamentals through advanced skills, this complete course offers a single source for all your requirements and needs. Each module is designed as either a stand lone module or as part of a complete series so the student can target their most pressing needs first for maximum benefit. Upon successful completion of the program and the passing of a short test, a full color Certificate of Completion will be issued to the student.