Obiee 12C Data Modeling Course
Last updated 2/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.57 GB | Duration: 5h 21m
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.
Download linkrapidgator.net:
https://rapidgator.net/file/b0a2b453a5bad2eacd8c1eda4ca96f5c/wnjis.Obiee.12C.Data.Modeling.Course.part1.rar.html
https://rapidgator.net/file/bd01ec10498fa03e8ed7232ee8164640/wnjis.Obiee.12C.Data.Modeling.Course.part2.rar.html
uploadgig.com:
https://uploadgig.com/file/download/B5366c9de2462239/wnjis.Obiee.12C.Data.Modeling.Course.part1.rar
https://uploadgig.com/file/download/3dB6455feFd7abbc/wnjis.Obiee.12C.Data.Modeling.Course.part2.rar
nitroflare.com:
https://nitroflare.com/view/2EEEDEE023F074C/wnjis.Obiee.12C.Data.Modeling.Course.part1.rar
https://nitroflare.com/view/5444F0E296A6E76/wnjis.Obiee.12C.Data.Modeling.Course.part2.rar
1dl.net:
https://1dl.net/0vq6xe1oqgfe/wnjis.Obiee.12C.Data.Modeling.Course.part1.rar.html
https://1dl.net/395bmkfkvwdn/wnjis.Obiee.12C.Data.Modeling.Course.part2.rar.html
Cantinho Satkeys
