Obiee 12C Data Modeling Course

Data Modeling, RPD, Physical, BMM, and Presentation layer, Logical Dimensions and Hierarchies, Measures, Analysis

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 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 activitiesEvery 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!

Overview

Section 1: Welcome and Introduction

Lecture 1 Introduction

Section 2: OBIEE Development , Architecture, and Data Modeling

Lecture 2 Product Development Lifecycle

Lecture 3 Roles and Responsibilities

Lecture 4 Product Life Cycle + Roles

Lecture 5 OBIEE Architecture

Section 3: OBIEE VM Installation and Configuration

Lecture 6 OBIEE Virtual Appliance Introduction

Lecture 7 Prerequisites

Lecture 8 Oracle VM Download and Installation

Lecture 9 OBIEE 12C Sample App Import

Lecture 10 FAQ : Problems during VM import

Lecture 11 VM Network Setup

Lecture 12 Share Folder between VM Box and Host machine

Lecture 13 OBIEE 12c VM Start

Lecture 14 FAQ: Node Manager not starting Issue resolution

Lecture 15 Prepare the tables

Lecture 16 Data Direct Driver

Lecture 17 DSN Setup with VM

Lecture 18 OBIEE Admin Tool Download and Configuration

Section 4: Data Modeling Concepts

Lecture 19 Data Modeler Role

Lecture 20 Data Denormalization

Lecture 21 Kimball and Star Schema Modelling

Section 5: Review OBIEE Sample App Data Model

Lecture 22 RPD Download

Lecture 23 RPD Review -Physical Layer

Lecture 24 RPD Review- Business Model and Mapping Layer

Lecture 25 RPD Review and Modification - Presentation Layer

Lecture 26 RPD Upload & Review Changes

Section 6: Project#1: RPD Creation and OBIEE Analysis

Lecture 27 Project#1 Introduction

Lecture 28 Physical Layer and Import of metadata

Lecture 29 Alias Creation

Lecture 30 FAQ: Why Alias?

Lecture 31 Keys and Joins creation

Lecture 32 BMM Layer creation

Lecture 33 Renaming Logical Columns

Lecture 34 Create measure and delete unwanted logical objects

Lecture 35 Create Presentation Layer

Lecture 36 Rename Presentation Columns

Lecture 37 Global Consistency Check

Lecture 38 Connection Pool Change

Lecture 39 Upload Sales Analysis RPD

Section 7: Project#2: Logical Table Source & Presentation Column/Table Orders

Lecture 40 Add more than one source Logical Table to one Logical Table

Lecture 41 Re-order Presentation Columns and Tables

Lecture 42 Deploy the RPD

Lecture 43 OBIEE Analysis with new RPD

Section 8: Project#3: Calculation Measures

Lecture 44 Calculation Measure using existing Logical Columns

Lecture 45 Calculation Measure using Function

Lecture 46 Deploy RPD

Lecture 47 OBIEE Analysis with Calculation Measure

Section 9: Project#4: Logical Dimensions and Level Based Hierarchies

Lecture 48 Logical Dimension and Hierarchy- Section Introduction

Lecture 49 Creating Level Based Hierarchy in OBIEE

Lecture 50 Product Logical Dimension

Lecture 51 Time Logical Dimension

Lecture 52 Customer Logical Dimension

Lecture 53 Setup Aggregation Content

Lecture 54 Deploy the RPD

Lecture 55 OBIEE Analysis with Logical Dimension

Lecture 56 Ragged, Skipped, and Time Structure

Section 10: Project#5: Level Based Measures

Lecture 57 Level Based Measures

Lecture 58 Deploy RPD

Lecture 59 OBIEE Analysis with Level Based Measures

Section 11: Project#6: Parent Child Hierarchies

Lecture 60 Import tables with Parent Child Hierarchies

Lecture 61 Physical Diagram

Lecture 62 Logical Table and Logical Columns

Lecture 63 Logical Join

Lecture 64 Logical Dimension

Lecture 65 Presentation Layer

Lecture 66 OBIEE Analysis with Parent Child Hierarchy

Section 12: Project#7: Ragged & Skipped Hierarchy

Lecture 67 Physical Layer

Lecture 68 BMM Layer

Lecture 69 Ragged & Skipped Hierarchy- Presentation Layer

Lecture 70 Ragged & Skipped Hierarchy- Analysis

Section 13: Project#8: Initialization Block

Lecture 71 Initialization Block Creation

Lecture 72 Repository Variable

Lecture 73 Analysis

Section 14: Time Series Function

Lecture 74 Time Series Function

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.