OBIEE 12c Essential Course
3.9 (69 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
350 students enrolled

OBIEE 12c Essential Course

Exactly what you need to learn to become a successful OBIEE professional
3.9 (69 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
350 students enrolled
Created by Sanjay Singh
Last updated 3/2020
English
English
Current price: $62.99 Original price: $89.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6 hours on-demand video
  • 1 article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Oracle Business Intelligence Enterprise Edition.
  • Please check the curriculum and landing page.
Requirements
  • You should be able to use a PC.
  • You should be able to work on operating systems like Windows.
  • You should know how to use browser and such operating system tools.
Description

Are you looking for an OBIEE course which teaches (concepts plus real life projects) you exactly what you need to know to become an OBIEE professional?

Join the most comprehensive and popular Oracle Business Intelligence Enterprise Edition (OBIEE) 12c Essential Course on Udemy, because now is the time to get started!

From basics of  Business Intelligence, Data Modelling, OBIEE Components (Report, Analysis, Dashboard) Development, Repository(RPD) creation and modification to Advance concepts i.e. Hierarchies, Measures etc.- this course covers it all you need to know to become a successful OBIEE 12c Expert

But that's not all! Along with covering all the steps of OBIEE functions, this course has quizzes and projects, which allow you to practice the things learned throughout the course!

You'll not only learn about the concepts, but also practice each of those concepts through Projects.

And if you do get stuck, you benefit from an extremely fast and friendly support - both via direct messaging or discussion. You have my word!

With more than two decades of IT experience, I have designed this course for students and professionals who wish to master how to develop and support industry standard OBIEE .

This course will be kept up-to-date to ensure you don't miss out on any changes once OBIEE 12c is required in your project!

Why OBIEE?

Oracle Business Intelligence Enterprise Edition is a leading enterprise Business Intelligence and Analysis software. Oracle is completely focused on keeping its lead and capturing market by investing a lot in this tool.

  • Oracle has a lot of customers using it's Oracle ERP application. For these customers OBIEE is first choice for Business Intelligence solution.
  •  Oracle Discoverer is end of life now. All Oracle Discoverer customers are moving to OBIEE.
  • Oracle is enhancing its packaged business intelligence application (BIAPPS) which is developed on OBIEE platform.

If you are looking for a thriving career in business intelligence and analytics, this is the right time to learn OBIEE.

Get a very deep understanding of OBIEE Data Modeling activities

Every new OBIEE version is coming with added features. Success of OBIEE implementation and its performance depends on  OBIEE professionals!

Pay once, benefit a lifetime! This is an evolving course! OBIEE 12c  and later future versions will  be covered in this course.  You won’t lose out on anything! 

Don’t lose any time, gain an edge and start now!

Who this course is for:
  • Students who want to get into OBIEE Profession.
  • Current IT professionals who want to switch to OBIEE implementation and support profession.
  • Experience professionals in non IT sectors who want to switch to OBIEE profession.
  • Project Managers, Operation Managers who want to understand OBIEE.
Course content
Expand all 64 lectures 05:58:46
+ Welcome
1 lecture 07:08

Welcome to this course! 

In this lecture, you will learn about relation between Data, Information, Intelligence, and Analytics and why to learn Oracle Business Intelligence Enterprise Edition (OBIEE).

Preview 07:08
+ OBIEE Implementation
6 lectures 36:01

In this lecture you will learn about product development life cycle in OBIEE implementation project.

Preview 06:48

In this lecture you will understand various roles and responsibilities involved in OBIEE implementation project.

Implementation Project Roles and Responsibilities
07:39

In this lecture you will learn which role performs which function in OBIEE implementation project.

Implementation Team Functions
03:08

In this lecture you will understand OBIEE architecture.

1.Source Databases

2. BI Server Components : System Components, Managed Server

3. OBIEE Repository

4. OBIEE Admin Tool

5. OBIEE Answers

6. OBIEE Catalog

7. OBIEE Agents and other components

Arcthitecture
08:33

In this lecture you will understand how to denormalize data and model in in star schema format.

Data Denormalization
06:45

In this lecture you will understand Star schema and Kimball data modelling.

Kimball Modeling
03:08
+ OBIEE VM and Sample App Installation
9 lectures 32:40

In this lecture you will learn about pre-requisites to installing OBIEE virtual machine and sample appliances.

Prerequisite
00:24

In this lecture you will learn how to install Oracle Virtual Machine.

Oracle VM Download and Installation
03:03

In this lecture you will

  1. Download OBIEE 12c Sample App
  2. Import OBIEE 12C Sample App
OBIEE 12C Sample App Import
04:49

In this lecture you will setup NAT Network and Bridged Adapter between your host and virtual machine.

Host & VM Network Setup
01:31

In this lecture you will learn how to share folder between host and VM box.

Sharing folder between Host Machine and Guest on VM
05:29

In this lecture you will

1. Start OBIEE virtual appliance

2. Start Oracle Database and BI Servers

OBIEE 12c VM Start
07:20

In this lecture you will prepare the tables for importing in data model.

Prepare the tables
03:57

In this lecture you will install Data Direct Driver

Data Direct Driver
03:27

In this lecture you will create Data source name (DSN) with source database.

DSN Setup with VM
02:40
+ OBIEE Repository Review
6 lectures 37:02

In this lecture you will install OBIEE Admin Tool. This tool is required to review, modify and create OBIEE RPD.

Preview 07:12

In this lecture you will download RPD from OBIEE Sample.

RPD Download
07:30

In this lecture you will review the physical layer of RPD.

RPD Review - Physical Layer
09:27

In this lecture you will review the BMM layer of the RPD.

RPD Review- BMM Layer
03:56

In this lecture you will review the presentation layer of sample app RPD.

RPD Review- Presentation layer
04:13

In this lecture you will do small modification to the RPD and upload it to sample app.

RPD Upload
04:44
+ Analysis Development
5 lectures 37:26

In this lecture you will create a simple analysis with two attribute fields and one fact field.

Preview 05:07

This lecture demonstrate implementation of OBIEE filters.

1. Creation of OBIEE filter.

2. Application of OBIEE filter on analysis/reports.

3. Saving OBIEE filter in catalog for future use.

Filters
10:40

In this lecture you will implement OBIEE Selection Step.

Selection Steps
06:39

In this lecture you will learn

  • How to add grand total in an OBIEE report.
  • How to add sub-total in an OBIEE report.
  • How to remove sorting from an OBIEE report field.
  • How to remove an OBIEE report field.
Adding Totals
08:30

In this lecture you will learn formatting of your Analysis. You will specifically learn

  • Format specific cell of your Analysis
  • Format table of Analysis
Formatting
06:30
+ Charts & Visualization
9 lectures 01:20:17

In this lecture you will learn

1. Applying saved filter to OBIEE Analysis

2. Creating OBIEE Graph

3. Navigating through the OBIEE Graph

Preview 09:10

In this lecture, you will

  1. Go through Graph Formatting options.
  2. Enable Zoom and Scroll for horizontal axis.
  3. Change the Legend placement in the graph.
Formatting the Graph
05:57

In this lecture you will learn

  1. OBIEE Pivot Table creation.
  2. Re-order hierarchy column values.
  3. Re-organize the pivot table layout i.e. section,  rows, columns, measures.
  4. Master detail relationship
Pivot Table
08:15

In this lecture, you will 

  1. Add calculated % field to the pivot table.
  2. Create a pivot table based Graph.
Pivot Table Graph
09:13

In this lecture, you will implement OBIEE Performance Tiles.

Performance Tiles
08:58

In this lecture you will learn about and implement OBIEE Trellis.

Trellis
08:19

In this lecture you will

  1. Understand OBIEE Narrative Views.
  2. Format Column
  3. Implement Column Formula
  4. Hide a Column
  5. Implement OBIEE Narrative Views
Narrative Views
16:52

In this lecture, you will

  1. Understand OBIEE Column Selector
  2. Implement OBIEE Column Selector
Column Selector
06:12

In this lecture, you will

  1. Understand OBIEE View Selector.
  2. Implement OBIEE View Selector.
View Selector
07:21
+ Dashboard
9 lectures 56:00

In this lecture you will

1. Understand OBIEE 12c Dashboard

2. Develop OBIEE 12c Dashboard

3. Run and print Dashboard

Preview 08:14

In this lecture you will rename the Dashboard page from previous lecture.

Rename Dashboard Page
02:37

In this lecture you will

1. Enable Dashboard Link

2. Export Dashboard Analysis to Excel

3. Export Dashboard Analysis to PDF

Dashboard Links
04:23

In this lecture you will learn how to modify analyses in dashboard.

Dashboard Analysis Modification
04:29

In this lecture you will 

1. Create new dashboard page.

2. Add analyses to dashboard page

Add new Dashboard Page
05:44

In this lecture you will

  1. Understand Section formatting.
  2. Modify section and place the analyses under the section vertically and then horizontally.
  3. Drop an analysis from the section.
Section Formatting
05:12

In this lecture you will learn

  1. Column Formatting.
  2. Adding and removing columns.
  3. Moving analysis and sections across columns.
  4. Disabling Collapsible feature on section.
Column Formatting
11:42

In this lecture you will give finishing touches to your dashboard and make it complete.

Finishing Touches
04:58

In this lecture you will add a prompt to your dashboard.

Prompts
08:41
+ RPD Creation
11 lectures 42:43

It's time for some real action. You are ready to implement your first project. In this project you are going to create data for a small OBIEE sales analysis. In this project you will learn various concepts like building Physical Layer, Physical Diagram, Aliases, BMM Layer, Calculation Measure, Subject Area, Uploading RPD and creating OBIEE Analysis.

Preview 01:30

In this lecture

  1. Create Repository
  2. Import Metadata
  3. Explore some features
Physical Layer creation
04:39

In this lecture you will create aliases for imported tables in physical layer.

Alias
03:21

In this lecture, you will

  1. Create Keys and Joins among Aliases
  2. Create Snowflake Schema diagram
Keys and Joins
04:20

In this lecture you will create Business Mapping and Model layer. You will

  1. Bring physical aliases to BMM Layer
  2. Review star schema in BMM Layer
BMM Layer Creation
04:37

In this lecture, you will

  1. Change the logical column name manually
  2. Change the logical column name using RPD Utilities 'Change Name Wizard'
Renaming Logical Columns
04:45

In this lecture you will

  1. Delete logical columns from Fact logical table
  2. Create Simple measure by formatting logical columns
Measures
01:53

In this lecture you will

  1. Create Presentation Layer
  2. Bring logical columns to presentation layer
Create Presentation Layer
04:18

In this lecture, you will

  1. Change the presentation column name to different name than the logical column
  2. Change the presentation column name by changing the logical column name
Renaming Presentation Columns
03:32

In this lecture you will perform global consistency check of the RPD.

Global Consistency Check
04:47

In this lecture you will

  1. Upload BISAMPLE.rpd in OBIEE
  2. Use the Subject Area in OBIEE Analysis
Upload RPD
05:01
+ Logical Table Source & Presentation Column/Table Orders
4 lectures 16:49

In this lecture, you will

  1. Rename Logical Table Source
  2. Add more than one Logical Table source to a Logical Table
  3. Make more than one Presentation table from one Logical Table
Add more than one source Logical Table to one Logical Table
06:48

In this lecture, you will

  1. Re-order Presentation Columns
  2. Re-order Presentation Tables
Re-order Presentation Columns and Tables
02:43

In this lecture you will

  1. Upload the BISAMPLE.rpd in OBIEE 
  2. Use the Subject Area in OBIEE
Deploy RPD
03:59

In this lecture you will create Analysis using data elements from new RPD.

OBIEE Analysis with new RPD
03:19
+ Calculation Measure
4 lectures 12:39

In this lecture you will create calculation measure in BMM layer using existing Logical Columns.

Calculation Measure using existing Logical Columns
02:59
Calculation Measure using function
02:33

In this lecture you will deploy the RPD with new calculation measures.

Deploy RPD
03:59

In this lecture you will create analysis using new RPD.

OBIEE Analysis with Calculation Measure
03:08