• UPCOMING:
  • 23 and 24-Nov-2019: 2-Days Workshop "Amazon Web Services" at Cavalry Ground Lahore
  • 14-Nov-2019: New Batches "Oracle 12c DBA/Developer and R12 EBS Financials (Cavalry Ground Lahore)
  • 16-Nov-2019: New Batches "Oracle 12c ADF and OBIEE" (Cavalry Ground Lahore)
  • 19-Nov-2019: New Batch "Digital Media Marketing" (Cavalry Ground Lahore)
  • 09-Nov-2019: FREE Orientation "SAP Financial/SCM/ HCM" (Cavalry Ground Lahore)
  • 12-Nov-2019: Free Workshop "AutoCAD" at Johar Town Lahore
  • 16-Nov-2019: FREE Workshop "AutoCAD' (Cavalry Ground)
  • 16-Nov-2019: FREE Orientation "Graphics Designing & Development" (Islamabad Centre)
  • 18-Nov-2019: FREE Orientation "SAP Financial/SCM/ HCM" (Johar Town Lahore)
  • 23-Nov-2019: FREE Workshop "AutoCAD" (Islamabad Centre)
  • 27-Nov-2019: FREE Orientation "SAP Financial/SCM/ HCM" (Islamabad Centre)

Oracle Business Intelligence 11g (Certified Implementation Specialist)

The Oracle Business Intelligence Foundation Suite 11 Certified Implementation Specialist Certification identifies professionals that are skilled in implementing solutions based on Oracle Business Intelligence Suite. The certification covers skills such as: installing OBIEE, building the BI Server metadata repository, building BI dashboards, constructing ad hoc queries, defining security settings and configuring and managing cache files. The exam targets the intermediate-level implementation team member. Up-to-date training and field experience are recommended.

Course Objectives

Oracle Database: Introduction to SQL

  • Identify the major structural components of the Oracle Database 12c
  • Manage objects with data dictionary views
  • Manage schema objects
  • Retrieve row and column data from tables
  • Run data manipulation statements (DML) in Oracle Database 12c
  • Use scalar and correlated sub-queries
  • Utilize views to display data
  • Write SELECT statements that include queries
  • Write multiple-column sub-queries
  • Control database access to specific objects
  • Create reports of aggregated data
  • Create reports of sorted and restricted data
  • Create tables to store data
  • Display data from multiple tables using the ANSI SQL 99 JOIN syntax
  • Employ SQL functions to retrieve customized data 

Oracle BI 11g R1: Create Analyses and Dashboards

  • Introduction to Oracle Business Intelligence Enterprise Edition
  • Working with Oracle Business Intelligence Analyses
  • Filtering Data for Analyses
  • Selecting and Grouping Data in Analyses
  • Adding Views to Analyses
  • Showing Results with Pivot Tables
  • Working with Additional Views in Analyses
  • Visualizing Data: Gauges and Maps
  • Scorecards and Key Performance Indicators
  • Measuring Results with Scorecards and KPIs
  • Creating Oracle Business Intelligence Dashboards
  • Configuring Oracle Business Intelligence Dashboards
  • Creating Dashboard Prompts and Variables
  • Integrating BI Content with MS Office
  • Working with BI Content in Smart View
  • Oracle Business Intelligence Mobile
  • Creating Mobile Applications with Oracle Business Intelligence Mobile App Designer
  • Using Oracle Business Intelligence Delivers
  • Administering the Presentation Catalog
  •  

Oracle BI 11g R1: Build Repositories

  • Apply cache management techniques to maintain and enhance query performance
  • Set up query logging for testing and debugging
  • Set up a multiuser development environment
  • Use the Administration Tool wizards and utilities to manage, maintain, and enhance repositories
  • Enable usage tracking to track queries and database usage, and improve query performance
  • Perform a patch merge in a development-to-production scenario
  • Describe Exalytics machine and the Summary Advisor tool used in the machine
  • Check the model and then model aggregate tables to speed query processing
  • Model partitions and fragments to improve application performance and usability
  • Use variables to streamline administrative tasks and modify metadata content dynamically
  • Use time series functions to support historical time comparison analyses
  • Set up security to authenticate users and assign appropriate permissions and privileges
  • Build the Physical, Business Model and Mapping, and Presentation layers of a repository
  • Build and run analyses to test and validate a repository
  • Build simple and calculated measures for a fact table
  • Create logical dimension hierarchies and level-based measures
  •  
Prerequisite

BA,BCS,MCS,MIT Degree

1
1
 
1
1
Fly-me-a-Trainer is a one of its kind service by Oranet. As per client requirements, Oranet sends expert trainers to corporate locations. With our trainer at your venue, you just need a conference room. The participants will be provided remote access to server at our Data Center.
For any Query or Custom Plan info@oranet.com.pk Lahore: 042-36619618-9 | Islamabad: 051-2806466
Order Summary
asdfsdsdf
Course Oracle Business Intelligence 11g (Certified Implementation Specialist)
Training Mode
Training Type
Training Location
Accomodation
Date
Total




Order Summary
asdfsdsdf
Course Oracle Business Intelligence 11g (Certified Implementation Specialist)
Training Mode
Training Type
Training Location
Accomodation
Training Days
Date
Total