Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
OBIEE 12c Data Modeling Course
Rating: 4.0 out of 5(518 ratings)
2,954 students

OBIEE 12c Data Modeling Course

Data Modeling, RPD, Physical, BMM, and Presentation layer, Logical Dimensions and Hierarchies, Measures, Analysis
Created bySanjay Singh
Last updated 11/2022
English

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.

Course content

14 sections • 75 lectures • 5h 20m total length

  • Introduction6:05

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

  • FAQ : Problems during VM import0:18

    In this lecture you will understand, how to remedy any problem you are encountering during VM import.

  • VM Network Setup1:31

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

  • Share Folder between VM Box and Host machine5: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 not starting 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 for Oracle.

  • DSN Setup with VM2:40

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

  • OBIEE Admin Tool Download and Configuration7:11

    In this lecture you will install OBIEE Admin tool.

  • BMM Layer creation4:37

    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


  • Renaming Logical Columns4:45

    In this lecture, you will

    1. Change the logical column name manually
    2. Change the logical column name using RPD Utilities 'Change Name Wizard'
  • Create measure and delete unwanted logical objects1:52

    In this lecture you will

    1. Delete logical columns from Fact logical table
    2. Create Simple measure by formatting logical columns
  • Create Presentation Layer4:18

    In this lecture you will

    1. Create Presentation Layer
    2. Bring logical columns to presentation layer
  • Rename Presentation Columns3:32

    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
  • Global Consistency Check4:47

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

  • Connection Pool Change1:35

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

  • Upload Sales Analysis RPD5:01

    In this lecture you will

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


  • Quiz: RPD Creation

  • OBIEE Analysis with new RPD3:19

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

  • Time Logical Dimension5:17

    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


  • Customer Logical Dimension7:06
    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.



    3. Setup Aggregation Content6:57
      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




      3.  
      4. Deploy the RPD3:59

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

      5. OBIEE Analysis with Logical Dimension6:04

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

      6. Ragged, Skipped, and Time Structure2:54

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

      7. Quiz: Logical Dimension and Hierarchies

      8. Deploy RPD3:59

        Deploy RPD with Level Based Measure.

      9. OBIEE Analysis with Level Based Measures1:21

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

        10. Requirements

        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 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 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 Business Intelligence solutions.

        •  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. The 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.

        Report abuse