OBIEE Online Training Hyderabad India

Click Here For Course Content.

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?

2). Dimensional Modelling Overview


  • Introduction to Dimensional Modelling
  • What are Facts and Dimensions?
  • Star schema and Snowflake schema

3). 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

4). 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

5). Building Physical Layer of a Repository


  • Objects of Physical Layer
  • Build physical layer
  • DSN for a data sources

6). 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

8). Testing and validating Repository


  • Checking repository consistency
  • Checking Global Consistency
  • Inspecting Oracle Answers inspecting SQL
  • Inspecting log files

9). Adding multiple sources to dimension


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

10). Adding calculations to fact


  • Calculation measures on the basis of physical and logical columns
  • Using Calculation wizard

11). Creating dimensional hierarchies and level based measures


  • Creating dimensional hierarchies
  • Use level based measures
  • Create Rank and Share measures

12). Using aggregation


  • Importing Aggregated Tables into Repository
  • Modeling aggregate tables to speed processing

13). Using partition or fragments


  •  Identifying reasons to segment data
  •  Techniques to model partitions
  •  Value based partitioning

14). Using variables


  • Presentation Variables
  • Repository variables
  • Session variables

15). Multiuser Environment (MUD)


  • Overview on Multiuser Environment (MUD)
  • How to create projects in MUD
  • Checkout and check in of projects

16). Modeling time series data


  • Types of SCDS
  • Using of time series functions

17). Modeling extension tables


  • Purposes of extension tables
  • Modeling extension tables for fact and dimensions

18). 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

19). Cache management


  • Purge cache and event handling tables
  • Making the table cacheable
  • Setting of cache in NQSCONFIG.INI file

20). 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

21). 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

22). Administering OBI Presentation Catalog


  • Creating catalog groups, issuing privileges etc
  • Using catalog management to maintain web catalog

23). Using Oracle BI Delivers


  • Configuring delivery devices
  • Add delivery profiles
  • Build Oracle alerts
  • Create ibots
  • Configuring Oracle scheduler database
  • Configuring of Event poll tables

24). Overview of Advanced Topics


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

Training Enquiry

If you are unable to reach our contact number, Please fill the above Enquiry Form, otherwise send an email to sudeeponlinetraining@gmail.com for quick response.