OBIEE Online Training
Introduction
Learn concepts of self-serve interactive reporting, actionable intelligence and spatial intelligence via map-based visualizations. How to Explore Oracle BI architecture components and physical layer object properties, Building a business model and testing a repository…etc.
Course Content
1.Introduction To OBIEE
- 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?
2.Dimensional Modeling Overview
- Introduction to Dimensional Modeling
- What are Facts and Dimensions?
- Star schema and Snowflake schema
3.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
- ServersOracle BI server
- Presentation
- Scheduler server
4.Server Architecture
- Repository Basics
- What is Meta data?
- Creating a Repository using BI Administration Tool
- Business Model and Mapping and presentation layers
- Properties of repository objects
5.Building Physical Layer Of A Repository
- Objects of Physical Layer
- DSN for a data sources
Build physical layer
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 and SQL
- Inspecting log files (Nqquery.log, NQSserver.log)
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
- Using level based measures
- Creating Rank and Share measures
12.Using Aggregation
- Importing Aggregated Tables into Repository
- Modeling aggregate tables to speed processing
13.Using Variables
- Presentation Variables
- Repository variables
- Session variables
- Initialization Blocks
14.Multi-User Environment (MUD)
- Overview on Multi-user Environment (MUD)
- How to create projects in MUD
- Checkout and check-in of projects
15.Modeling Time Series Data
- Types of SCDS
- Using of time series functions
16.Modeling Extension Tables
- Purposes of extension tables
- Modeling extension tables for fact and dimensions
17.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
18.Cache Management
- Purge cache and event handling tables
- Making the table cache able
- Setting of cache in NQSCONFIG.INI file
19.Oracle BI Presentation Services
- Working with Oracle BI Answers
- Building Business Requests using Answers, Adding filters to Business requests, Adding Column Filter Prompts in
- Answers Views and charts in requests
20.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
21.Administering OBI Presentation Catalogue
- Using catalogue management to maintain web catalogue
- Creating catalogue groups
- Issuing privileges etc
Course Reviews
No Reviews found for this course.
Write a Review