OBIEE 12c Data Modeling Course
4.2 (125 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.
663 students enrolled

OBIEE 12c Data Modeling Course

Data Modeling, RPD, Physical, BMM, and Presentation layer, Logical Dimensions and Hierarchies, Measures, Analysis
4.2 (125 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.
663 students enrolled
Created by Sanjay Singh
Last updated 3/2020
English
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5.5 hours on-demand video
  • 1 article
  • 1 downloadable resource
  • 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
  • What is Business Intelligence and how it helps Organizations in this Information Age.
  • OBIEE 12c Architecture. System Development Life Cycle (SDLC) and Roles and Responsibilities in OBIEE implementation project.
  • Oracle Business Intelligence Enterprise Edition (OBIEE) 12c project development life cycle.
  • Data modeling concepts i.e. Data Denormalization, Dimensional Data Modelling, Kimball and Star Schema Modeling.
  • Installing OBIEE 12C Administration tool.
  • Downloading and Uploading RPD.
  • Reviewing and Modifying Physical Layer, Business Mapping Layers and Presentation Layer.
  • Creating Repository (RPD) from scrath.
  • Creating Physical Layer : Connection Pool, Import Metadata, Alias, Keys and Joins, Snowflake Schema
  • Creating Business Model and Mapping Layer: Star Schema, Logical Table, Logical Column, Logical Table Source, Measures, Utilities
  • Creating Presentation Layer: Subject Area, Presentation Tables and Columns.
  • Creating Measures using existing Logical Columns and Functions.
  • Creating Logical Dimensions, Level Based Hierarchy, Ragged, Skipped Hierarchy. Parent Child Hierarchy.
  • Setting up Content Aggregation and Group By.
  • Creating Analysis with Drill Down feature.
  • Initialization Block and Repository Variable.
  • Time Series Functions.
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

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

From basic concepts about Data Modelling, Denormalization, Star Schema Modelling, Administration Tool, RPD Download, RPD Upload to building each layer -Physical, Business Model and Mapping (BMM), and Presentation Layer- this course covers it all you need to know to become a successful Data Modeler

But that's not all! Along with covering all the steps of Data Modeling 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 Data Model.

This course will be kept up-to-date to ensure you don't miss out on any changes once Data Modelling 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 Data Modeler. 

Pay once, benefit a lifetime! This is an evolving course! OBIEE 12c RPD  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 Data Modeling profession.
  • Current IT professionals who want to switch to OBIEE Data Modeling profession.
  • Experience professionals in non IT sectors who want to switch to OBIEE Data Modeling profession.
  • Project Managers, Operation Managers who want to understand OBIEE Data Modeling.
Course content
Expand all 71 lectures 05:15:24
+ Welcome and Introduction
1 lecture 06:05

Welcome! In this lecture, you will learn about relation between  Data, Information, Business Intelligence, and Analytics.

Preview 06:05
+ OBIEE Development , Architecture, and Data Modeling
4 lectures 26:07

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

Preview 06:47

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

Roles and Responsibilities
07:39

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

Product Life Cycle + Roles
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

OBIEE Architecture
08:33
+ OBIEE VM Installation and Configuration
11 lectures 41:38

Welcome to this section of the course. Here, you will learn about OBIEE Virtual machine and OBIEE Sample App installation. You will also download the build in RPD, modify it , then upload the modified RPD and create analysis.

Preview 01:47

In this lecture you will learn about prerequisites to installing OBIEE Virtual Machine and Sample appliance.

Prerequisites
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 VM Appliance
    2. Import OBIEE 12C VM Appliance
  • OBIEE 12C Sample App Import
    04:49

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

    VM Network Setup
    01:31

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

    Share Folder between VM Box and Host machine
    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 for Oracle.

    Data Direct Driver
    03:27

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

    DSN Setup with VM
    02:40

    In this lecture you will install OBIEE Admin tool.

    OBIEE Admin Tool Download and Configuration
    07:11
    + Data Modeling Concepts
    3 lectures 11:14

    In this lecture you will understand what is data modeler roles and responsibilities in OBIEE implementation project.

    Data Modeler Role
    01:21

    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.

    Preview 03:08
    + Review OBIEE Sample App Data Model
    5 lectures 29:48

    In this lecture you will understand how to download RPD.

    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 Business Model and Mapping layer of RPD.

    Preview 03:56

    In this lecture you will review and modify Presentation Layer in RPD.

    RPD Review and Modification - Presentation Layer
    04:12

    In this lecture you will upload the modified RPD and review the modified data elements in OBIEE12c.

    RPD Upload & Review Changes
    04:43
    + Project#1: RPD Creation and OBIEE Analysis
    12 lectures 44:17

    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 and Import of metadata
    04:39

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

    Alias Creation
    03:21

    In this lecture, you will

    1. Create Keys and Joins among Aliases
    2. Create Snowflake Schema diagram
  • Preview 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
    Create measure and delete unwanted logical objects
    01:52

    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
    Rename Presentation Columns
    03:32

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

    Preview 04:47

    In this lecture you will change the connection pool to biplatform_datasource.

    Connection Pool Change
    01:35

    In this lecture you will

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


  • Upload Sales Analysis RPD
    05:01

    This Quiz will test your knowledge abou OBIEE RPD components.

    Quiz: RPD Creation
    1 question
    + Project#2: 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
    Preview 02:43

    In this lecture you will

    1. Upload the BISAMPLE.rpd in OBIEE 
    2. Use the Subject Area in OBIEE


  • Deploy the RPD
    03:59

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

    OBIEE Analysis with new RPD
    03:19
    + Project#3: Calculation Measures
    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

    In this lecture you will create calculation measure in OBIEE BMM layer using built in function.

    Preview 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
    + Project#4: Logical Dimensions and Level Based Hierarchies
    9 lectures 47:46

    This lecture tells you what will you learn in this section.

    Preview 03:03

    In this lecture, you will understand below concepts

    • Dimensions and Hierarchies
      • Level Based Hierarchy
      • Parent Child Hierarchy
      • Time Series Hierarchy
      • Ragged Hierarchy
      • Unbalanced Hierarchy
    • How to create more than one level based hierarchy within same dimension
    Creating Level Based Hierarchy in OBIEE
    04:41
    1. Create Product Logical Dimension with Level based hierarchy
    2. Associate logical columns to the hierarchy
    3. Assign key, primary key and display columns for hierarchy levels
  • Product Logical Dimension
    07:45

    In this lecture you will

    1. Create Time Logical Dimension with Level based hierarchy
    2. Associate logical columns to the hierarchy
    3. Assign key, primary key and display columns for hierarchy levels


    Time Logical Dimension
    05:17
    1. Create Customer Logical Dimension with Level based hierarchy.
    2. Associate logical columns to the hierarchy.
    3. Assign key, primary key and display columns for hierarchy levels.



    1. Customer Logical Dimension
      07:06
      1. Setup Aggregation Content for Logical Source of D1 Time
      2. Setup Aggregation Content for Logical Source of D2 Product
      3. Setup Aggregation Content for Logical Source of D3 Customer
      4. Setup Aggregation Content for Logical Source of F1 Revenue




      1.  
      2. Setup Aggregation Content
        06:57

        In this lecture you will upload the new RPD to OBIEE.

        Deploy the RPD
        03:59

          In this lecture you will create analysis with fields from Product, Time, Customer dimensions and Revenue Fact table.

        OBIEE Analysis with Logical Dimension
        06:04

        In this lecture you will learn about Ragged, Skipped and Time Structure of Level Based Hierarchy.

        Ragged, Skipped, and Time Structure
        02:54

        This Quiz will test your knowledge about OBIEE Logical Dimensions and Hierarchies.

        Quiz: Logical Dimension and Hierarchies
        3 questions
        + Project#5: Level Based Measures
        3 lectures 13:36

        In this lecture you will

      3.  
        1. Create Revenue Total level based measure based on Product Total Logical Level
        2. Create  Revenue Total measure based on Product Type Total Logical Level
        3. Create Product Level share measure based on above measures
      4. Preview 08:16

        Deploy RPD with Level Based Measure.

        Deploy RPD
        03:59

        In this lecture you will create analysis with Level based measure!

        OBIEE Analysis with Level Based Measures
        01:21