Dac Course Content

Overview of Oracle Business Analytics Warehouse

·         Oracle Business Analytics Warehouse Overview

·         Oracle Business Analytics Warehouse Architecture.

·         Oracle Business Analytics Warehouse Architecture Components

DAC Basics

·         Introduction to Dac

·         About the DAC Process Life Cycle

·         Source System Containers

·         Repository Objects

·         User Account Management

·         Extract and Load

Setup View Tabs

·         DAC System Properties Tab

·         Email Recipients Tab

·         Informatica Servers Tab

·         Physical Data Sources Tab

Design Tab

·         Configuration Tags Tab

·         Indices Tab

·         Source System Folders Tab

·         Source System Parameters Tab

·         Subject Areas Tab

·         Tables Tab

·         Task Groups Tab

·         Tasks Tab

Execute View Tabs

·         Current Run Tab

·         Execution Plans Tab

·         Run History Tab

·         Scheduler Tab

Obiee Course Content

OBIEE 11g   , OBIEE 10g , Siebel Analytics ,Obia Dac

Data warehouse Concepts  

·         Data warehouse

·         Data mart

·         Basics of Data Warehousing

·         What is OLTP and OLAP?

·         Difference between OLTP and OLAP

·          

Dimensional Modeling Overview

·         Introduction to Dimensional Modeling

·         Dimensional table

·         Fact table

·         Aggregate table

·         Star schema

·         Snowflake schema

·         Star schema Vs. Snowflake schema

·         Fact Vs. Dimension table

·         Fact Vs. Aggregate Table

·         Types of Facts

·         Types of Fact tables

·         Types of Dimensions

·         Level of Granularity

·         Grain of fact

·         Slowly Changing Dimensions( SCD )

·         Normalization

·         DE normalization

OBIEE Overview

·         Introduction to Siebel Analytics

·         Introduction to OBIEE 10 G

·         What is Obiee?

·         Advantages of Obiee

·         End to End Life Cycle of Obiee

·         Types of Reports

·         Types of Applications

·         Components OF Obiee

·         Client Components Of Obiee

·         Obiee Architecture

·         Difference between Obiee 10g and Siebel Analytics

·         Difference between Obiee 10g

Repository Basics

·         What is Meta data?

·         Creating a Repository using BI Administration Tool

·         Physical, Business Model and Mapping, and presentation layers

·         Properties of repository objects

·         Online Mode and Offline Mode

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

·         Physical Layer Folders

·         Physical Joins

·         Defining Physical Foreign Keys and Joins

·         Using Database

·         Viewing Data in Physical Tables or Columns

·         Creating and Editing a Column in a Physical Table

·         Fragmented Data

·         Primary Key and Foreign Key Relationships

·         Complex Joins

·         Opaque Views

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

·         Display Folders

·         Logical Joins 

·         Level Based Measures

·         Aggregation Navigation

·         Time Series Function

Presentation Layer

·         About the Presentation Layer

·          Creating and Customizing the Presentation Layer

·         Working with Subject Areas

·          Working with Presentation Tables and Columns

·         Working with Presentation Hierarchies and Levels

·         Setting Permissions for Presentation Layer Objects

·          Creating Aliases (Synonyms) for Presentation Layer Objects

·         Controlling Presentation Object Visibility

     Utilities and Wizards

Advantages of Caching Cache Manager

·         Using the Cache Manager

·         Monitoring and Managing the Cache

·         Purging and Maintaining Cache

Config Files 

·         Nqs Config

·         Nqs Server 

·         Nqs Query 

·         Instance Config 

Variables

·         Variable 

·         Repository Variables 

·         Static and Dynamic

·         Session Variables 

·         System and Non System Variables 

·         Initialization Blocks 

·         Row Wise Initialization

Security

·         Data level Security 

·         Object Level Security 

·         Authentication 

·         Authorization

·         Users and Groups

Types Of Authentication 

·         LDAP Authentication

·         External Table Authentication

·         Database Authentication

·         Oracle BI Delivers and Database Authentication 

·         Oracle BI Server User Authentication

Analysis

·         Types of Views

·         Column  Properties

·         Filters

Dashboards

·         Dashboard Page

·         Dashboard Objects

·         Actions and Conditions

·         Kpi and Scorecard

Prompts

:

·         Inline and Dashboard Prompts

·         Column Prompt

·         Image Prompt"

·         Currency Prompt"

·         Variable Prompt

Administering Oracle Business Intelligence Presentation Catalog

•    Maintaining the OracleBI Presentation Catalog
•    Maintaining security
•    Understanding security inheritance

Using Oracle Business Intelligence Delivers

•    Building alerts
•    Building  Agents
•    Introduction to OracleBI Scheduler

MUDE(Multiuser Development Environment)

Catalog manager

Other Feature we provide:

• FAQS
• Realtime Repositories
• Concentration on performance tuning
• Real time scenarios
• Certification guidance
• Resume preparation
• Sample resumes
• Interview & certification FAQS
• How to face the interview
• Class notes which is useful for who is trying for job
• Project preparation