1.
Data warehouse Concepts
- Data warehouse
- Data mart
- Basics of Data Warehousing
- What is OLTP and OLAP?
- Difference between OLTP and OLAP
2.
Dimensional Modeling Overview
- Introduction to Dimensional Modeling
- Dimensional table
- Fact table
- Star schema
- Snowflake schema
- Star schema Vs. Snowflake schem
- Fact Vs. Dimension table
- Types of Dimensions
- Level of Granularity
- Slowly Changing Dimensions( SCD )
- Normalization
- DE normalization
3.
OBIEE Overview
- Introduction to OBIEE 10 G& 11g
- What is Obiee?/td
- Advantages of Obiee
- Components OF Obiee
- Client Components Of Obiee
- Obiee Architecture
- Difference between Obiee 10g and Obiee 11g
4.
Repository Basics
- What is Meta data?
- Perspectives
- Creating a Repository using BI Administration Tool
- Physical, Business Model and Mapping, and presentation layers
- Properties of repository objects
- Online Mode and Offline Mode
5.
Building the Physical Layer of a Repository
- Physical Layer from Relational Data Sources
- Database Objects
- Setting Up and Properties of Connection Pools
- Physical Tables
- Alias Tables
- Defining Physical Foreign Keys and Joins
- Using Database
- Viewing Data in Physical Tables or Columns
- Creating and Editing a Column in a Physical Table
- Primary Key and Foreign Key Relationships
- Complex Joins
- Opaque Views
6. Business Model and Mapping Layer
- Business Model Objects
- Duplicate Business Model and Presentation Catalog
- Creating and Administering Logical Tables
- Creating and Administering Logical Columns
- Creating and Administering Logical Table Sources (Mappings)
- Dimensions and Hierarchical Levels
- Process of Creating and Administering Dimensions
- Unbalanced (Ragged) and Skip-Level Hierarchies
- Parent-Child Hierarchies
- Subject Areas for Logical Stars and Snowflakes
- Level Based Measures
- Time Series Function
- Calculation Measures
7. Presentation Layer
- About the Presentation Layer
- Creating and Customizing the Presentation Layer
- Most-used Functions & Common tasks
- Working with Subject Areas
- Working with Presentation Tables and Columns
- Setting Permissions for Presentation Layer Objects
| 8. Advantages of Caching Cache Manager - Using the Cache Manager
- Monitoring and Managing the Cache
- Working with Subject Areas
- Purging and Maintaining Cache
9. Config Files - NqsConfig
- Nqs Server
- Nqs Query
- Instance Config
10. Variables - Variable
- Repository Variables
- Session Variables
- System and Non System Variables
- Initialization Blocks
11. Security - Data level Security
- Object Level Security
- Users and Groups
12. Types Of Authentication - External Table Authentication
- Database Authentication
- Oracle BI Delivers and Database Authentication
- Oracle BI Server User Authentication
13. Analysis - Types of Views
- Column Properties
- Filters
14. Dashboards - Dashboard Page
- Dashboard Objects
- Actions and Conditions
- Kpi and Scorecard
15. Prompts - Dashboard Prompts
- Column Prompt
16. Using Oracle Business Intelligence Delivers - Buildingalerts
- BuildingAgents
- Introduction to OracleBI Scheduler
- MUDE(Multiuser Development Environment)
- Console
- Enterprise Manager
- Bi Publisher
17. Other Feature we provide - FAQS
- Resume preparation
- Sample resumes
- How to face the interview
- Class notes which is useful for who is trying for job
- Project preparation
| 