Courses
Quick Enquiry
Contact Us
- Introduction and Definition
- Sources, Transformations and Targets( Architecture )
- Data Extraction, Data Transformations and Data Loading( Data Acquisition Process)
- Data Warehousing Approaches
- Staging Area, Metadata, Repository and Data Mart
- Differences between OLTP and OLAP( DSS ) Systems
- Operational Data Store( ODS )
- Business Intelligence
- Star Schema Design & Confirmed Dimension, Fact less Fact Table, Types of Facts
- Slowly Changing Dimensions( SCD )
- Clients
- OBI Presentation Services
- OBI Server
- OBI Repository (.rpd)
- Data Sources
- OBI Administration Tool
- OBI Answers
- Intelligence dashboards
- Oracle Business Analysis Warehouse
- DAC and Informatica Server
- Informatica Server ETL
- Sample Request Processing
- Using the OracleBI Administration Tool
- Repository Directory
- Repository Files ( Initialization files and log files)
- Informatica Server ETLLoading a repository into Oracle BI Server memory
- Creating a repository
- Connection Pool
- Repository Modes ( ONLINE and OFFLINE )
- Physical Layer
- Business Model & Mapping Layer
- Presentation Layer
- Presentation Catalogs, Folders and Columns
- Error Messages
- Defining an ODBC System DSN
- Setting up connection pool properties
- Importing data sources ( Physical Schema )
- Verifying the import
- Defining physical keys and joins
- Creating alias and select tables
- Creating the logical business model
- Creating the logical tables, columns, and sources
- Defining logical joins
- Adding Calculation to a Fact Table
- Building measures
- Creating a new Presentation Catalog
- Modifying Presentation layer objects
- Rename tables
- Reorder Table
- Checking repository consistency
- Defining a repository in the initialization file
- Testing a repository using Oracle BI Answers
- Message Severity
- iewing Server Logs
- Defining an ODBC System DSN
- Setting up connection pool properties
- Importing data sources ( Physical Schema )
- Verifying the import
- Defining physical keys and joins
- Creating alias and select tables
- Creating the logical business model
- Creating the logical tables, columns, and sources
- Defining logical joins
- Adding Calculation to a Fact Table
- Building measures
- Creating a new Presentation Catalog
- Modifying Presentation layer objects
- Rename tables
- Reorder Table
- Checking repository consistency
- Defining a repository in the initialization file
- Adding Multiple Logical Table Sources
- Adding multiple logical table sources to a logical table
- Specifying logical content
- Adding multiple logical table sources to a logical table
- Specifying logical content
- Creating new calculation measures based on existing logical columns
- Creating new calculation measures based on physical columns
- Creating new calculation measures using the Calculation Wizard
- Creating dimension hierarchies
- Creating level-based measures
- Purpose of aggregate tables in dimensional modeling
- Modeling aggregate tables to improve query performance
- Testing aggregate navigation
- Accessing database directly
- Using time comparisons in business analysis
- Using Oracle BI time series functions to model time series data
- Creating dimension hierarchies
- Creating level-based measures
- Introduction to Oracle BI Answers
- Working with requests in Oracle BI Answers
- Using advanced formatting
- Creating report Level Hierarchy
- Introduction to filters in Answers
- Adding filter prompts to requests
- Using saved requests as filters
- Introduction to Answers views and charts
- Creating and editing charts
- Performing common view tasks
- Creating a Narrative View
- Creating a column Selector
- Introduction to pivot tables
- Formatting pivot tables
- Setting aggregation rules and building formulas
- Introduction to Interactive Dashboards and pages
- Adding Objects to Dashboard
- Creating Dashboard prompts
- Embedding content in an Interactive Dashboard
OBIEE
OBIEE Online Training
| OBIEE |
| DATAWAREHOUSING CONCEPTS
|
| OBI Overview NEW FEATURES OF OBI OBI ARCHITECTURE |
| OBI COMPONENTS
|
| REPOSITORY BASICS
|
| BUILDING THE PHYSICAL LAYER OF A REPOSITORY
|
| BUILDING THE BUSINESS MODEL AND MAPPING LAYER OF A REPOSITORY
|
| BUILDING THE PRESENTATION LAYER OF A REPOSITORY
|
| TESTING AND VALIDATING A REPOSITORY
|
| BUILDING THE PHYSICAL LAYER OF A REPOSITORY
|
| BUILDING THE BUSINESS MODEL AND MAPPING LAYER OF A REPOSITORY
|
| BUILDING THE PRESENTATION LAYER OF A REPOSITORY
|
| TESTING AND VALIDATING A REPOSITORY
|
| ADDING MULTIPLE LOGICAL TABLE SOURCES
|
| ADDING CALCULATIONS TO A FACT TABLE
|
| CREATING DIMENSION HIERARCHIES AND LEVEL-BASED MEASURES
|
| CREATING & USING AGGREGATES
|
| Using Initialization Blocks Repository Variables CREATING DYNAMIC REPOSITORY VARIABLES EXECUTE DIRECT DATABASE REQUESTS |
| CREATING TIME SERIES MEASURES
|
| CREATING DIMENSION HIERARCHIES AND LEVEL-BASED MEASURES
|
| Providing Security for Groups & UsersANSWERS (REPORTS) WORKING WITH ORACLE BUSINESS INTELLIGENCE ANSWERS |
| FILTERING REQUESTS IN ORACLE BUSINESS INTELLIGENCE ANSWERS
|
| BUILDING VIEWS AND CHARTS IN REQUESTS
|
| SHOWING RESULTS WITH PIVOT TABLES
|
| CREATING ORACLE BUSINESS INTELLIGENCE INTERACTIVE DASHBOARDS
|
