OBIEE Developer Online Training
OBIEE Developer Online Training
OBIEE Developer Online Training Course Content :
Overview of Business Analysis
- Introduction to OBIEE
- Importance and features of the tool
Overview of Oracle BI Components
- Gather information to start building Business Model
- Architecture of OBIEE
- Create OBDC Connections
- Importing a data source
- Defining Keys and Joins
- Defining the Repository logical Structure
Measures
- Building simple Fact Measures
- Customizing the presentation Catalog
- Testing the repository
- Checking Consistency
- Importing Additional Product Tables
- Creating Multiple Sources for a logical Table source
- Specifying the Most Economical Source
- Creating Calculation Measures using Logical columns
- Creating Calculation Measures using Physical columns
- Creating Calculation Measures using Calculation Wizard
- Creating Level Based Measures
- Define Share Measure and Rank Measures
Partition
- Types of Partitions
- Modeling a Value Based Partition
- Using Dynamic Repository Variables
- Time Series functions
- Creating Users and Groups
- Assigning permissions to users
Security
- Object Level Security
- Data Level Security
- Setting Query Limits
Cache Management
- Introduction to Cache
- Cache Features
- Modifying Cache Parameters
- Purge the Cache
Report developer
- Introduction to Reports
- Different views
- Dashboard
- Creating and Modifying Reports
- Creating Dashboards
- Dash boards pages
- Working with dash board objects
- Working with filters and prompts
- Guided Navigation Links
- Static
- Dynamic
Introduction to BI Publisher
Data Warehousing Basic Concepts
- Data Warehouse Definition,
- Characteristics of DWH
- OLTP Vs OLAP Databases
Architecture of Date Warehouse
- Process flow In DWH
- Components of Architecture
- Source, Integration Layer, Staging Area, ODS.
- Technical Architecture of Back Room
- Architecture of Front Room
- Infrastructure Metadata
Implementation Methodology
- Kimball Methodology
- Inmon Methodology
- Types of Loads
- First Time Load
- Full Load
- Incremental Load
Data Marts and Star Schema Design
- Definition of Star Schema
- Data Marts Reasons for Construction
- Replacement of Data Mart With Warehouse
- Design process
- Design of Dimension and Facts
- Snow Flake Star Schema
- Summary Tables
- Slowly Changing Dimensions
- Non Additive Facts
- Conformed Dimensions
- Types of OLAP ROLAP, DOLAP, HOLAP, MOLAP
Drop your query
Most Popular Courses
Achieve your career goal with industry recognised learning paths
What my Client's Say?
-
It was a great course over my expectations. I am eager to have another course wıth you as soon as possıble ~ R. Kamand
-
All in all, it was a very constructive and one in a lifetime experience. I'm so glad that I was part of it.~ T. Engin
-
It was the best decision I had ever made in my life. Although it was expensive for me, but I don't regret even for one second. ~ Maruti Malla
-
Thank you for this great course. I learned a lot of things, I met very nice people and I am happy that I had these 6 crazy weeks with you.".~ Najmul Shar A Baig
-
Very nice and friendly tutor and staff. The course was very fruitful, particularly the input sessions during the first half of it.~ Radha Nandyala
-
It was such great experience, though it was really intensive, it was worth doing it! Cant thank enough all team effort esp Mohan! .~ Rohan Kumar
-
The course was really good because it was a practical course.~ M.Radha patel
-
I liked this experience. Good tutor and nice mates. I will always remember it. ~ Jitu Bavaria
