Oracle OBIEE Online Training institutes in hyderabad|usa

1
OBIEE Online Training
2
OBIEE

• SUDEEP Technologies is one of the leading
  Training Company involved in providing OBIEE
  ONLINE TRAINING. Our Trainers are expert in
  providing Online Training with real time
  experience.
• OBIEE Concepts
• 1). Data warehousing overview
• Basics of Data Warehousing
• What are OLTP and OLAP?
• Difference between OLTP and OLAP
• Advantages of OLAP
• What is Data Marts and ODS?

3
 OBIEE Overview

• 2). Dimensional Modeling Overview
• Introduction to Dimensional Modeling
• What are Facts and Dimensions?
• Star schema and Snowflake schema

4
Introduction To Business Intelligence

• What is Business Intelligence
• Where BI tools are Used
• Architecture, Components
• Why the Oracle Business Intelligence
• Clients Answers, Delivers, Dashboards and Web
  administration
• Servers- Oracle BI server, Presentation,
  Scheduler server
• Advantages

5
Repository Basics

• What is Business Intelligence
• What is Meta data?
• Creating a Repository using BI Administration
  Tool
• Physical, Business Model and Mapping, and
  presentation layers
• Properties of repository objects

6
 Building Physical Layer of a Repository

• Objects of Physical Layer
• Build physical layer
• DSN for a data sources
• Building business Model mapping layer
• Objects of BMM layer
• Building Business model (creating logical tables,
  columns, joins)
• Creating simple measures

7
Building presentation layer

• Objects of presentation layer
• Properties of the presentation layer
• Build presentation layer
• Testing and validating Repository
• Checking repository consistency
• Checking Global Consistency
• Inspecting Oracle Answers inspecting SQL
• Inspecting log files

8
Adding multiple sources to dimension

• De-normalizing tables structures in database
  design
• Adding multiple sources to existing logical
  tables source
• Adding second table sources

9
Adding calculations to fact

• Calculation measures on the basis of physical and
  logical columns
• Using Calculation wizard
• Creating dimensional hierarchies and level based
  measures
• Creating dimensional hierarchies
• Use level based measures
• Create Rank and Share measures

10
Using aggregation

• Importing Aggregated Tables into Repository
• Modeling aggregate tables to speed processing
• Using partition or fragments
• Identifying reasons to segment data
• Techniques to model partitions
• Value based partitioning

11
Using variables

• Présentation Variables
• Repository variables
• Session variables
• Multiuser Environment (MUD)
• Overview on Multiuser Environment (MUD)
• How to create projects in MUD
• Checkout and check in of projects

12
Modeling time series data

• Types of SCDS
• Using of time series functions
•  
• Modeling extension tables
• Purposes of extension tables
• Modeling extension tables for fact and dimensions

13
Oracle BI Security

• Security at object and data level
• Creating users and User groups
• Assigning permissions to users
• Setting Query limits and timing restrictions
• Authenticating using an external database
• Cache management
• Purge cache and event handling tables
• Making the table cacheable
• Setting of cache in NQSCONFIG.INI file

14
Working With Oracle BI Answer

• Adding Column Filter Prompts in Answers
• Building Business Requests using Answers 
• Adding filters to Business requests Views and
  charts in requests
• Creating Oracle Intelligence Dashboards
• Creating dashboard pages using report requests
• Creating dashboard prompts
• Configuring guided navigation links
• Adding content to dashboard
• Conditional links and conditional section

15
Administering OBI Presentation

• Creating catalog groups, issuing privileges etc
• Using catalog management to maintain web catalog
• Using Oracle BI Delivers
• Configuring delivery devices
• Add delivery profiles
• Build Oracle alerts

16
Overview of Advanced Topics

• BI Applications/ Pre-Built RPO
• ETL Integration using DAC
• BI Publisher

17
Contact Us

• Ph 91 9700042555, 040-65240555
• Address Auto Nagar, Terminal, Krishna Nagar,
• Vijayawada-520007
• Website URL -
• http//www.sudeeptechnologies.com/courses/dataware
  -housing/obiee-online-training/59

18
THANK YOU