OBIEE 12c Certification Training

Viswa Online Trainings is one of the world’s leading online IT training providers. We deliver a comprehensive catalog of courses and online training for freshers and working professionals to help them achieve their career goals and experience our best services.

4627 Reviews 4.9
4.7/5

Learners : 1080

Duration :  30 Days

About Course

Our OBIEE 12c is a unique platform that enables customers to uncover new insights and make faster, more informed business decisions by offering agile visual analytics and self-service discovery together with best-in-class enterprise analytics. Instant mobile, highly interactive dashboards, powerful operational reporting, just-in-time alerts, content and metadata search, strategy management, native access to Big Data sources, sophisticated in-memory computing, and streamlined systems management combine to make Oracle BI 12c a comprehensive solution that reduces the total cost of ownership and increases return on investment for the entire organization.

OBIEE Training Course Syllabus

Module 1

✔ OBIEE Overview
✔ OBIEE Architecture
✔ Clients
✔ OBIEE 11 BI Services
✔ OBIEE Weblogic Admin
✔ OBIEE Repository (rpd)
✔ Data Sources

Module 2

✔ OBIEE Components
✔ OBIEE Administration Tool
✔ OBIEE Analysis
✔ Intelligence Dashboards
✔ BI Publisher-BI Agents/Actions-KPI/Scorecard
✔ BI Office

Module 3

✔ Repository Basics
✔ Oracle Business Analysis Warehouse
✔ Weblogic Server
✔ Enterprise Manager
✔ Sample Request Processing
✔ Using the OracleBI Administration Tool
✔ Repository Directory
✔ Repository Files ( Initialization files and log files)
✔ Loading 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

Module 4

✔ 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

Module 5

✔ 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

Module 6

✔ 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
✔ 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

Module 7

✔ 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
✔ BI Analysis and Dash board & Publisher
✔ Creating and Editing Analysis
✔ Creating Interactive Dashboards using Analysis
✔ Creating query and chart

Module 8

✔ Working with Filters
✔ Working with Pivot Table
✔ Building Views and Charts in Requests
✔ Creating and Configuring Interactive Dashboards
✔ Creating and Configuring Dashboard Prompts
✔ Configuring Action Links
✔ Creating and understanding KPI, KPI Watchlists, and Scorecards
✔ Oracle BI for MS Office
✔ Sending Alerts Using Delivers
✔ Using Job Manager

Live Instructor Based Training With Software
Lifetime access and 24×7 support
Certification Oriented content
Hands-On complete Real-time training
Get a certificate on course completion
Flexible Schedules
Live Recorded Videos Access
Study Material Provided

OBIEE Training - Upcoming Batches

Coming Soon....

8 AM IST

Weekday

Coming Soon

AM IST

Weekday

Coming Soon

8 AM IST

Weekend

Coming Soon

AM IST

Weekend

Don't find suitable time ?

CHOOSE YOUR OWN COMFORTABLE LEARNING EXPERIENCE

Live Virtual Training

  • Schedule your sessions at your comfortable timings.
  • Instructor-led training, Real-time projects
  • Certification Guidance.
Preferred

Self-Paced Learning

  • Complete set of live-online training sessions recorded videos.
  • Learn technology at your own pace.
  • Get access for lifetime.

Corporate Training

  • Learn As A Full Day Schedule With Discussions, Exercises,
  • Practical Use Cases
  • Design Your Own Syllabus Based
For Business

OBIEE Online Training FAQ'S

Compare OBIEE & Tableau

CriteriaOBIEETableau
Ease of useNeeds trained developersEmpowers end users
Data visualizationAverageExcellent
Enterprise ReportingEasy to deploy and manageMuch harder

Our Page: VISWA Online Trainings

 

Explain the Architecture of OBIEE 11g and function of each components?

OBIEE Comprises Presentation Services, Oracle BI Server: The user constructs SQL and passes it to the Analytic Engine and then the Oracle BI (Analytic Engine) describes the physical SQL to the Data sources and recovers the data back to the Engine and presents it to the presentation Services.

How we can extract sql from OBIEE for reports?

  • Change the request and click Advanced in that you get XML code and also the actual SQL.
  • In the catalog, Manager clicks Tools-Create Report. In the Create Report Window –> Click Request SQL and save the SQL to the physical path in your PC.
  • Enable Log level to 2 in the OBIEE 11g Administration Tool from Manage-> Security and enable the log level to 2 by clicking properties for the user, then go to the NQ Query.log in BI_HOME/OracleBI/Server/Logs. You will find the SQL for that User.
    d. By clicking Administration->Manage sessions-> view SQL.

How can you sort in Reports in OBIEE 11g?

Click on modify and then click on sort (order by icon) on the relevant column in the criteria pane.

How we can do different types of narrative Reports in OBIEE?

By clicking modify request and Narrative View and by giving @1 for the first column result and @2 for the 2nd column and so on and we can also give a heading for No Results by clicking the Narrative view.

Reviews

vishal meda
vishal meda
2023-04-15
They give trainings properly and trainers are well versed with them where i recommend to all viswa trainings are good!!
Ntr fan
Ntr fan
2023-04-01
I just finished sap bods training in Hyderabad. Excellent course and curriculum 100% doubt clarification sessions. Thanks Chaitanya
Shiva Krishna
Shiva Krishna
2023-04-01
I recently completed informatica online training with Chaitanya. Course was built by excellent trainer. And process of learning was streamlined. Thanks
Mohammad ali syed
Mohammad ali syed
2023-03-27
It was great and smooth understandable training. You can learn lots.
Govinda Bhatia
Govinda Bhatia
2023-03-19
Not recommended as there will be no server access working to do practical after training. Also there will be no fix for the same. So it's wastage of money. If server access not at all working then no meaning to provide server access. Also it not working for single day properly. Need to followup daily but in response you told will fix that sir at home once he will back will fix. After he came back again it's not working and not able to fix for single day also Every time new excuse it's wastage of money.
M Leela mohan
M Leela mohan
2023-03-15
I took SQL Server and MSBI Online training with Murali Krishna. I must say the course content was highly qualitative and the trainer covered all concepts. Overall it was a good experience with VISWA Online Trainings.
HARIKRISHNA BANDLA
HARIKRISHNA BANDLA
2023-03-13
Attended live Virtual training for IoT Trainer was very good. He had excellent knowledge of IoT and was very good at explaining concepts in detail.…
Lakshmi Lakshmi
Lakshmi Lakshmi
2023-01-18
Best sap commerce cloud and Spartacus training institute in india. He provides a great mix of listening, speaking, and practical learning activities and a very safe, supportive learning environment. He maintains a friendly relationship with the students during class. He not only teaches but also monitors our practice status on daily basis.
Ch Chandranath
Ch Chandranath
2023-01-18
I have undergone Oracle Tuning training. I can proudly say that this is one of the best training institutes available in the market. The way Mr. Kumar teaches the concepts and makes them understandable is very commendable and unique. Even a novice can clearly understand the concepts clearly after attending his classes.

Quick Links