Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

OBIEE 12c Essential Course

Name: OBIEE 12c Essential Course
Rating: 4.1 (284 reviews)

Exactly what you need to learn to become a successful OBIEE professional

Created bySanjay Singh

Last updated 11/2022

English

What you'll learn

Oracle Business Intelligence Enterprise Edition.
Please check the curriculum and landing page.

Course content

10 sections • 66 lectures • 6h 3m total length

Introduction7: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).

Product Development Lifecyle6:48
In this lecture you will learn about product development life cycle in OBIEE implementation project.
Implementation Project Roles and Responsibilities7:39
In this lecture you will understand various roles and responsibilities involved in OBIEE implementation project.
Implementation Team Functions3:08
In this lecture you will learn which role performs which function in OBIEE implementation project.
Arcthitecture8:33
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
Data Denormalization6:45
In this lecture you will understand how to denormalize data and model in in star schema format.
Kimball Modeling3:08
In this lecture you will understand Star schema and Kimball data modelling.

Prerequisite0:24
In this lecture you will learn about pre-requisites to installing OBIEE virtual machine and sample appliances.
Oracle VM Download and Installation3:03
In this lecture you will learn how to install Oracle Virtual Machine.
OBIEE VM appliance current status0:05
It seems Oracle is no more providing the VM Appliance for OBIEE. The link provided for the VM appliance might not work.
OBIEE 12C Sample App Import4:49
In this lecture you will

Download OBIEE 12c Sample App
Import OBIEE 12C Sample App
Host & VM Network Setup1:31
In this lecture you will setup NAT Network and Bridged Adapter between your host and virtual machine.
Sharing folder between Host Machine and Guest on VM5:29
In this lecture you will learn how to share folder between host and VM box.
OBIEE 12c VM Start7:20
In this lecture you will

1. Start OBIEE virtual appliance

2. Start Oracle Database and BI Servers
FAQ: Node Manager failure issue resolution4:21
In this lecture, you will learn how to resolve the Node manager failure issues. Please note, this lecture doesn't have a voice.
Prepare the tables3:57
In this lecture you will prepare the tables for importing in data model.
Data Direct Driver3:27
In this lecture you will install Data Direct Driver
DSN Setup with VM2:40
In this lecture you will create Data source name (DSN) with source database.

Admin tool installation7:12
In this lecture you will install OBIEE Admin Tool. This tool is required to review, modify and create OBIEE RPD.
RPD Download7:30
In this lecture you will download RPD from OBIEE Sample.
RPD Review - Physical Layer9:27
In this lecture you will review the physical layer of RPD.
RPD Review- BMM Layer3:56
In this lecture you will review the BMM layer of the RPD.
RPD Review- Presentation layer4:13
In this lecture you will review the presentation layer of sample app RPD.
RPD Upload4:44
In this lecture you will do small modification to the RPD and upload it to sample app.

A Simple Analysis with two fields5:07
In this lecture you will create a simple analysis with two attribute fields and one fact field.
Filters10:40
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.
Selection Steps6:39
In this lecture you will implement OBIEE Selection Step.
Adding Totals8:30
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.
Formatting6: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

Graphs9:10
In this lecture you will learn

1. Applying saved filter to OBIEE Analysis

2. Creating OBIEE Graph

3. Navigating through the OBIEE Graph
Formatting the Graph5:57
In this lecture, you will

Go through Graph Formatting options.
Enable Zoom and Scroll for horizontal axis.
Change the Legend placement in the graph.
Pivot Table8:15
In this lecture you will learn

OBIEE Pivot Table creation.
Re-order hierarchy column values.
Re-organize the pivot table layout i.e. section, rows, columns, measures.
Master detail relationship
Pivot Table Graph9:13
In this lecture, you will

Add calculated % field to the pivot table.
Create a pivot table based Graph.
Performance Tiles8:58
In this lecture, you will implement OBIEE Performance Tiles.
Trellis8:19
In this lecture you will learn about and implement OBIEE Trellis.
Narrative Views16:52
In this lecture you will

Understand OBIEE Narrative Views.
Format Column
Implement Column Formula
Hide a Column
Implement OBIEE Narrative Views
Column Selector6:12
In this lecture, you will

Understand OBIEE Column Selector
Implement OBIEE Column Selector
View Selector7:21
In this lecture, you will

Understand OBIEE View Selector.
Implement OBIEE View Selector.

Dashboard Creation8:14
In this lecture you will

1. Understand OBIEE 12c Dashboard

2. Develop OBIEE 12c Dashboard

3. Run and print Dashboard
Rename Dashboard Page2:37
In this lecture you will rename the Dashboard page from previous lecture.
Dashboard Links4:23
In this lecture you will

1. Enable Dashboard Link

2. Export Dashboard Analysis to Excel

3. Export Dashboard Analysis to PDF
Dashboard Analysis Modification4:29
In this lecture you will learn how to modify analyses in dashboard.
Add new Dashboard Page5:44
In this lecture you will

1. Create new dashboard page.

2. Add analyses to dashboard page
Section Formatting5:12
In this lecture you will

Understand Section formatting.
Modify section and place the analyses under the section vertically and then horizontally.
Drop an analysis from the section.
Column Formatting11:42
In this lecture you will learn

Column Formatting.
Adding and removing columns.
Moving analysis and sections across columns.
Disabling Collapsible feature on section.
Finishing Touches4:58
In this lecture you will give finishing touches to your dashboard and make it complete.
Prompts8:41
In this lecture you will add a prompt to your dashboard.

Introduction1:30
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.
Physical Layer creation4:39
In this lecture

Create Repository
Import Metadata
Explore some features
Alias3:21
In this lecture you will create aliases for imported tables in physical layer.
Keys and Joins4:20
In this lecture, you will

Create Keys and Joins among Aliases
Create Snowflake Schema diagram
BMM Layer Creation4:37
In this lecture you will create Business Mapping and Model layer. You will

Bring physical aliases to BMM Layer
Review star schema in BMM Layer
Renaming Logical Columns4:45
In this lecture, you will

Change the logical column name manually
Change the logical column name using RPD Utilities 'Change Name Wizard'
Measures1:53
In this lecture you will

Delete logical columns from Fact logical table
Create Simple measure by formatting logical columns
Create Presentation Layer4:18
In this lecture you will

Create Presentation Layer
Bring logical columns to presentation layer
Renaming Presentation Columns3:32
In this lecture, you will

Change the presentation column name to different name than the logical column
Change the presentation column name by changing the logical column name
Global Consistency Check4:47
In this lecture you will perform global consistency check of the RPD.
Upload RPD5:01
In this lecture you will

Upload BISAMPLE.rpd in OBIEE
Use the Subject Area in OBIEE Analysis

Add more than one source Logical Table to one Logical Table6:48
In this lecture, you will

Rename Logical Table Source
Add more than one Logical Table source to a Logical Table
Make more than one Presentation table from one Logical Table
Re-order Presentation Columns and Tables2:43
In this lecture, you will

Re-order Presentation Columns
Re-order Presentation Tables
Deploy RPD3:59
In this lecture you will

Upload the BISAMPLE.rpd in OBIEE
Use the Subject Area in OBIEE
OBIEE Analysis with new RPD3:19
In this lecture you will create Analysis using data elements from new RPD.

Calculation Measure using existing Logical Columns2:59
In this lecture you will create calculation measure in BMM layer using existing Logical Columns.
Calculation Measure using function2:33
Create a calculation measure using a function by deriving from existing columns, edit the expression to apply rank, and move the Revenue Rank to the presentation table in the RPD.
Deploy RPD3:59
In this lecture you will deploy the RPD with new calculation measures.
OBIEE Analysis with Calculation Measure3:08
In this lecture you will create analysis using new RPD.

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 that teaches (concepts plus real-life projects) 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 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 the market by investing a lot in this tool.

Oracle has a lot of customers using its Oracle ERP application. For these customers, OBIEE is the first choice for a Business Intelligence solution.
Oracle Discoverer is the 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 the 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.

OBIEE 12c Essential Course

What you'll learn

Explore related topics

Course content

Welcome1 lecture • 7min

OBIEE Implementation6 lectures • 36min

OBIEE VM and Sample App Installation11 lectures • 37min

OBIEE Repository Review6 lectures • 37min

Analysis Development5 lectures • 37min

Charts & Visualization9 lectures • 1hr 20min

Dashboard9 lectures • 56min

RPD Creation11 lectures • 43min

Logical Table Source & Presentation Column/Table Orders4 lectures • 17min

Calculation Measure4 lectures • 13min

Requirements

Description

Who this course is for: