OBIEE - Data WareHouse Course

Training/Coaching/Tuition by Sudeep Technologies Hyderabad View Contact

Request Info

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?

Dimensional Modelling Overview

• Introduction to Dimensional Modelling

• What are Facts and Dimensions?

• Star schema and Snowflake schema

Introduction to Business Intelligence

• What is Business Intelligence

• Where BI tools are Used

• Architecture, Components

• Why the Oracle Business Intelligence

• Servers- Oracle BI server, Presentation, Scheduler server

• Advantages

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

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

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

Adding multiple sources to dimension

• De-normalizing tables structures in database design

• Adding multiple sources to existing logical tables source

• Adding second table sources

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

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

Using variables

• Presentation 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

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

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

Working with Oracle BI Answers

• 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

Administering OBI Presentation Catalog

• 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

• Create ibots

• Configuring Oracle scheduler database

• Configuring of Event poll tables

Overview of Advanced Topics

• BI Applications/ Pre-Built RPO

• ETL Integration using DAC

• BI Publisher

Sudeep Technologies

SUDEEP TECHNOLOGIES was established with an aspect of providing comprehensive end to end training on various computer software IT courses. Our team consists of high end professionals with vast real time experience who trains you on all courses to bridge the gap between industry and academic graduates.

we provide cost effective training for needy learners with utmost care and guidance according to the demand of job market. Faculty, technically sound in high end technologies will teach you with quality principles and deliver the methodology of easy learning which gets you updated to the current trend. Sudeep Technologies, with dedication provides you the best learning concepts which puts you front in this competitive software world as a successful one.

Our faculty are enough skilled to explore the complicated concepts and explains you in a well descriptive manner.As the pace of technological enhancements is getting faster day by day there is indispensable part of imparting advance concepts to the learners to meet the demand which is the cause for emerge of SUDEEP TECHNOLOGIES.

We are ideal for beginners and an added advantage to the professionals to enhance their skills as we deals in depth with the advance concepts of the courses and also provide implementation-real time concepts. SUDEEP TECHNOLOGIES, renders one to one online training for students in state-of-the-art technology platforms in India or abroad.we save your time and money by avoiding expensive travel through online training. With the latest in collaborative technology, top instructors, cutting-edge curriculum we provide an exciting combination of traditional content and interactive learning and also materials with rich information that shouldn’t make any difference to the class room training.

Personalized online training sessions can be held comfortable to the student ease.without any hesitation, we offer you a100% student satisfaction online program.If you have any queries please contact us through e-mail id or phone or fill the enquiry form with the necessary details.