Course content:
Data warehousing overview
• Basics of Data Warehousing
• What is OLTP and OLAP?
• Difference between OLTP and OLAP
• Advantages of OLAP
• What is Data Marts and ODS?
Dimensional Modeling Overview
• Introduction to Dimensional Modeling
• What are Facts and Dimensions?
• Star schema and Snowflake schema
Introduction to Business Intelligence
• What is Business Intelligence
• Where BI tools are Used
• Why the Oracle Business Intelligence
• Advantages
• Architecture, Components
• Clients – Answers, Delivers, Dashboards and Web administration,
• Servers- Oracle BI server, Presentation, Scheduler server
Server Architecture
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
• DSN for a data sources
• Build physical layer
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(Nqquery.log,NQSserver.log)
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 variables
• Presentation Variables
• Repository variables
• Session variables
• Initialization Blocks
Multiuser Environment (MUD)
• Overview on Multiuser Environment (MUD)
• How to create projects in MUD
• Checkout and checkin 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
• Building Busines Requests usiing Answers
• Adding filters to Business requests
• Adding Column Filter Prompts in Answers
• 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
• Using catalog management to maintain web catalog
• Creating catalog groups, issuing privileges etc

  Learning Objectives :

Upcoming Batches