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


Popular Posts