obiee developer

Upload: tanuj-gautam

Post on 10-Oct-2015

42 views

Category:

Documents


0 download

DESCRIPTION

o.k.

TRANSCRIPT

  • Address: B-125, Sector -2, Noida 201301, India

    Mob: 9810306956/8130778822/8130778881

    Board: 0120-2540300/400

    E-mail: [email protected]

    Software Development & Education Center

    ENTERPRISE EDITION

    OBIEE Developer

  • Oracle University | Contact Us: Local: 1800 103 4775 Intl: +91 80 4108 4709

    Oracle Database: Introduction to SQL

    Duration: 5 Days

    What you will learnThis course helps you write subqueries, combine multiple queries into a single query using SET operators and reportaggregated data using group functions. Learn this and more through hands-on exercises.

    Learn To:

    Understand the basic concepts of relational databases ensure refined code by developers.Create reports of sorted and restricted data.Run data manipulation statements (DML).Control database access to specific objects.Manage schema objects.Manage objects with data dictionary views.Retrieve row and column data from tables. Control privileges at the object and system level.Create indexes and constraints; alter existing schema objects.Create and query external tables.

    Learn Advanced Features of SQLIn order to query and manipulate data within the database, use the dictionary views to retrieve metadata and createreports about their schema objects, you'll learn to understand the advanced features of SQL. Some of the date-timefunctions available in the Oracle Database are also covered. This course also discusses how to use the regularexpression support in SQL.

    Development ToolsIn this course, the main development tool used is Oracle SQL Developer. SQL*Plus is available as an optionaldevelopment tool. This is appropriate for a 10g and 11g audience. There are minor changes between 10g and 11gfeatures in SQL.

    This course is a combination of Oracle Database: SQL Fundamentals I and Oracle Database: SQL Fundamentals IIcourses.

    AudienceApplication DevelopersBusiness AnalystsData Warehouse AdministratorDeveloperForms DeveloperPL/SQL Developer

    Copyright 2012, Oracle. All rights reserved. Page 1

  • System Analysts

    Related Training

    Required Prerequisites

    Familiarity with data processing concepts and techniques

    Data processing

    Course ObjectivesDisplay data from multiple tables using the ANSI SQL 99 JOIN syntax.

    Identify the major structural components of the Oracle Database 11g.

    Create reports of aggregated data.

    Write SELECT statements that include queries.

    Retrieve row and column data from tables.

    Run data manipulation statements (DML) in Oracle Database 11g.

    Create tables to store data.

    Utilize views to display data.

    Control database access to specific objects.

    Manage schema objects.

    Manage objects with data dictionary views.

    Write multiple-column sub-queries.

    Employ SQL functions to retrieve customized data.

    Use scalar and correlated sub-queries.

    Use the regular expression support in SQL.

    Create reports of sorted and restricted data.

    Course Topics

    Introduction to Oracle Database List the features of Oracle Database 11gDiscuss the basic design, theoretical, and physical aspects of a relational database

    Copyright 2012, Oracle. All rights reserved. Page 2

  • Categorize the different types of SQL statementsDescribe the data set used by the courseLog on to the database using SQL Developer environmentSave queries to files and use script files in SQL Developer

    Retrieve Data using the SQL SELECT StatementList the capabilities of SQL SELECT statementsGenerate a report of data from the output of a basic SELECT statementSelect All ColumnsSelect Specific ColumnsUse Column Heading DefaultsUse Arithmetic OperatorsUnderstand Operator PrecedenceLearn the DESCRIBE command to display the table structure

    Learn to Restrict and Sort DataWrite queries that contain a WHERE clause to limit the output retrievedList the comparison operators and logical operators that are used in a WHERE clauseDescribe the rules of precedence for comparison and logical operatorsUse character string literals in the WHERE clauseWrite queries that contain an ORDER BY clause to sort the output of a SELECT statementSort output in descending and ascending order

    Usage of Single-Row Functions to Customize OutputDescribe the differences between single row and multiple row functionsManipulate strings with character function in the SELECT and WHERE clausesManipulate numbers with the ROUND, TRUNC, and MOD functionsPerform arithmetic with date dataManipulate dates with the DATE functions

    Invoke Conversion Functions and Conditional ExpressionsDescribe implicit and explicit data type conversionUse the TO_CHAR, TO_NUMBER, and TO_DATE conversion functionsNest multiple functionsApply the NVL, NULLIF, and COALESCE functions to dataUse conditional IF THEN ELSE logic in a SELECT statement

    Aggregate Data Using the Group FunctionsUse the aggregation functions to produce meaningful reportsDivide the retrieved data in groups by using the GROUP BY clauseExclude groups of data by using the HAVING clause

    Display Data From Multiple Tables Using JoinsWrite SELECT statements to access data from more than one tableView data that generally does not meet a join condition by using outer joinsJoin a table to itself by using a self join

    Use Sub-queries to Solve QueriesDescribe the types of problem that sub-queries can solveDefine sub-queriesList the types of sub-queriesWrite single-row and multiple-row sub-queries

    Copyright 2012, Oracle. All rights reserved. Page 3

  • The SET OperatorsDescribe the SET operatorsUse a SET operator to combine multiple queries into a single queryControl the order of rows returned

    Data Manipulation StatementsDescribe each DML statementInsert rows into a tableChange rows in a table by the UPDATE statementDelete rows from a table with the DELETE statementSave and discard changes with the COMMIT and ROLLBACK statementsExplain read consistency

    Use of DDL Statements to Create and Manage TablesCategorize the main database objectsReview the table structureList the data types available for columnsCreate a simple tableDecipher how constraints can be created at table creationDescribe how schema objects work

    Other Schema ObjectsCreate a simple and complex viewRetrieve data from viewsCreate, maintain, and use sequencesCreate and maintain indexesCreate private and public synonyms

    Control User AccessDifferentiate system privileges from object privilegesCreate Users Grant System PrivilegesCreate and Grant Privileges to a RoleChange Your PasswordGrant Object PrivilegesHow to pass on privileges? Revoke Object Privileges

    Management of Schema ObjectsAdd, Modify, and Drop a ColumnAdd, Drop, and Defer a ConstraintHow to enable and Disable a Constraint?Create and Remove IndexesCreate a Function-Based IndexPerform Flashback OperationsCreate an External Table by Using ORACLE_LOADER and by Using ORACLE_DATAPUMPQuery External Tables

    Manage Objects with Data Dictionary ViewsExplain the data dictionaryUse the Dictionary ViewsUSER_OBJECTS and ALL_OBJECTS Views

    Copyright 2012, Oracle. All rights reserved. Page 4

  • Table and Column InformationQuery the dictionary views for constraint informationQuery the dictionary views for view, sequence, index and synonym informationAdd a comment to a table Query the dictionary views for comment information

    Manipulate Large Data SetsUse Subqueries to Manipulate DataRetrieve Data Using a Subquery as SourceInsert Using a Subquery as a TargetUsage of the WITH CHECK OPTION Keyword on DML StatementsList the types of Multitable INSERT StatementsUse Multitable INSERT StatementsMerge rows in a tableTrack Changes in Data over a period of time

    Data Management in different Time ZonesTime ZonesCURRENT_DATE, CURRENT_TIMESTAMP, and LOCALTIMESTAMPCompare Date and Time in a Sessions Time ZoneDBTIMEZONE and SESSIONTIMEZONEDifference between DATE and TIMESTAMPINTERVAL Data TypesUse EXTRACT, TZ_OFFSET and FROM_TZInvoke TO_TIMESTAMP,TO_YMINTERVAL and TO_DSINTERVAL

    Retrieve Data Using Sub-queriesMultiple-Column SubqueriesPairwise and Nonpairwise ComparisonScalar Subquery ExpressionsSolve problems with Correlated SubqueriesUpdate and Delete Rows Using Correlated SubqueriesThe EXISTS and NOT EXISTS operatorsInvoke the WITH clauseThe Recursive WITH clause

    Regular Expression SupportUse the Regular Expressions Functions and Conditions in SQLUse Meta Characters with Regular ExpressionsPerform a Basic Search using the REGEXP_LIKE functionFind patterns using the REGEXP_INSTR functionExtract Substrings using the REGEXP_SUBSTR functionReplace Patterns Using the REGEXP_REPLACE functionUsage of Sub-Expressions with Regular Expression SupportImplement the REGEXP_COUNT function

    Copyright 2012, Oracle. All rights reserved. Page 5

  • Oracle University | Contact Us: Local: 1800 103 4775 Intl: +91 80 4108 4709

    Oracle BI 11g R1: Create Analyses and Dashboards NEW

    Duration: 4 Days

    What you will learnThis course provides step-by-step instructions for creating Oracle BI analyses and dashboards in business intelligenceapplications. You'll begin by building basic analyses to include in dashboards, with more complexity as the courseprogresses.

    Learn To:

    Build analyses and dashboards.Build and use views and graphs in analyses.Create and work with KPIs and scorecards.Create and modify Oracle BI dashboards.Administer objects in the Presentation Services Catalog.Use Oracle Business Intelligence Mobile to access BI content.Include pivot tables, graphs, gauges, maps, prompts, embedded content, navigation links, key performance indicators(KPIs) & scorecards on the dashboards.Use Oracle BI Delivers to send real-time, personalized alerts to dashboards and subscribed users.Use Oracle BI Mobile to access BI content on mobile devices.

    You'll also learn to use Oracle BI for Microsoft Office to integrate Oracle BI data and views in presentations andspreadsheets. Explore the use of Oracle BI Briefing Books and BI Composer, while learning to administer objects in theOracle BI Presentation Catalog.

    This course concludes with a case study where step-by-step instructions for building analyses and dashboards arescaled back. This allows you to practice the skills acquired in previous lessons. An appendix is included that covers thearchitecture and benefits of Oracle Exalytics BI Machine.

    AudienceApplication DevelopersBusiness AnalystsBusiness Intelligence DeveloperDeveloperEnd UsersFunctional ImplementerTechnical AdministratorTechnical Consultant

    Course Objectives

    Copyright 2012, Oracle. All rights reserved. Page 1

  • Combine analysis criteria across multiple subject areas and execute direct database queries

    Perform pre- and post-aggregate filtering using filters, groups, and selections

    Build and use views and charts in analyses

    Create analyses using Essbase data sources

    Add geographical mapping to analyses

    Use BI Mobile to access BI Content

    Use Key Performance Indicators and Scorecards to analyze trends and meet business objectives

    Create and modify Interactive Dashboards

    Use hierarchical columns in analyses and views

    Create guided navigation links within Interactive Dashboards

    Use Delivers to configure Agents to get the results of analyses and deliver them to subscribers

    Create and modify Oracle Business Intelligence analyses using Analyses Editor

    Perform administration tasks related to the development and configuration of Interactive Dashboards

    Administer analyses and other Oracle BI objects

    Use Oracle BI for Microsoft Office to integrate Oracle BI analysis and Interactive Dashboard content into Office

    documents

    Use BI Composer

    Course Topics

    Introducing Oracle Business Intelligence Enterprise EditionIntroduction to Oracle BIArchitecture overview

    Working with Oracle Business Intelligence AnalysesIntroduction to Oracle BI Analysis EditorOracle BI column typesWorking with analyses in Oracle BIUsing advanced formatting

    Administering the Presentation CatalogOracle BI and catalog security overviewManaging security using rolesUnderstanding security inheritance Setting object permissions

    Copyright 2012, Oracle. All rights reserved. Page 2

  • Setting system privilegesArchiving catalog items

    Limiting and Grouping Data in AnalysesIntroduction to filters and selectionsCreating, editing, and grouping filtersAdding prompts to analysesDynamic filtering Using saved analyses as filtersCreating groupsCreating calculated itemsCreating selection steps

    Oracle Business Intelligence Analyses: Advanced FeaturesSetting analysis propertiesCombining analysis criteria by using set operationsExecuting direct database analysesEditing logical SQL generated by an analysisCreating a link to a saved analysisCreating an Excel Web Query file

    Working with Views and Graphs in AnalysesIntroduction to views, graphs, and editorsWorking with views in Compound LayoutsCreating and editing graphsLinking master-detail viewsPerforming common view tasks

    Visualizing Data: Gauges, Maps, and MobileWorking with Gauge views Creating and editing Map viewsWorking with and searching content in BI Mobile

    Measuring Results with Key Performance IndicatorsCreating KPIs, setting trending, dimensionality, and thresholdsCreating a KPI WatchlistChanging Dimensionality for a KPI Watchlist event

    Showing Results With Pivot TablesCreating, arranging, and formatting a pivot tableUsing hierarchical columnsSorting in pivot tablesSetting aggregation and using totalsShowing an item's relative valueBuilding calculations and displaying running sums

    Creating Oracle Business Intelligence DashboardsCreating and editing dashboardsUsing the Dashboard BuilderExploring dashboard object properties and optionsPublishing dashboard pagesCreating personal customizations and using other page options

    Copyright 2012, Oracle. All rights reserved. Page 3

  • Configuring Oracle Business Intelligence DashboardsExploring types of dashboard contentEmbedding content in dashboards

    Creating Dashboard Prompts and VariablesUnderstanding variablesAdding a named dashboard prompt to a dashboardAdding a hidden named dashboard prompt to a dashboardCreating additional prompt page and setting page preferencesAdding variable prompts to a dashboard

    Using Oracle Business Intelligence DeliversConfiguring delivery devices and adding delivery profilesAdding an Alert Section to a dashboardConfiguring an AgentUsing Analysis and KPI conditions to deliver content with AgentsSubscribing to an Agent

    Integrating Analyses with MS OfficeWorking with Oracle BI content in Microsoft Office applications

    Working with Oracle Business Intelligence Briefing BooksAdding content to Briefing BooksEditing Briefing BooksDownloading and viewing Briefing BooksAdding a list of Briefing Books to a dashboardUsing Briefing Books with Oracle BI Delivers

    ScorecardingIdentifying the objects and components of Oracle Scorecard and Strategy ManagementCreating a scorecardEditing a scorecard

    Copyright 2012, Oracle. All rights reserved. Page 4

  • Oracle University | Contact Us: Local: 1800 103 4775 Intl: +91 80 4108 4709

    Oracle BI 11g R1: Build Repositories

    Duration: 5 Days

    What you will learnThis course teaches you step-by-step procedures to build and verify the three layers of an Oracle BI repository. You'llbegin by using the Oracle BI Administration Tool to construct a simple repository to address a fictitious company'sbusiness requirements.

    Learn To:

    Build and execute analyses to test and verify a dimensional business model.Use the Oracle BI Adminstration Tool to administer Oracle BI Server.Use the Oracle BI Administration Tool to build, manage and maintain an Oracle BI repository.Build a dimensional business model to address business intelligence requirements.Validate your work by creating and running analyses, and verifying query results using the query log.

    Build Logical Business Models

    This course will teach you how to import schemas, design and build logical business models and expose businessmodels to users in the Oracle BI user interface. While constructing the repository, you'll learn how to build physical andlogical joins, simple measures and calculation measures.

    Logical Dimension Hierarchies

    You'll then extend the initial repository and learn how to model more complex business requirements, such as logicaldimension hierarchies, multiple logical table sources, aggregate tables, partitions and time series data.

    Oracle BI Server Security

    This course will teach you how to implement Oracle BI Server security and manage the Oracle BI Server cache. Learnhow to set up a multi-user development environment and use Administration Tool wizards and utilities to manage,maintain and enhance repositories.

    Advanced Course Topics

    Finally, explore more advanced topics, like implicit fact columns, bridge tables, usage tracking, multilingualenvironments, write back and patch merge. An appendix is included, which covers architecture and the benefits of theOracle Exalytics BI Machine.

    AudienceApplication Developers

    Copyright 2012, Oracle. All rights reserved. Page 1

  • Business AnalystsBusiness Intelligence DeveloperData ModelersData Warehouse AdministratorData Warehouse AnalystData Warehouse DeveloperReports Developer

    Related Training

    Suggested PrerequisitesBasic SQL

    Data warehouse design

    Database design

    Dimensional modeling

    Oracle BI 11g R1: Create Analyses and Dashboards

    Oracle BI 11g R1: Create Analyses and Dashboards NEW

    Course ObjectivesSet 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

    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

    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 Administration Tool wizards and utilities to manage, maintain, and enchance repositories

    Copyright 2012, Oracle. All rights reserved. Page 2

  • Enable usage tracking to track queries and database usage, and improve query performance

    Perform a patch merge in a development-to-production scenario

    Course Topics

    Repository BasicsExploring Oracle BI architecture componentsExploring a repository's structure, features, and functionsUsing the Oracle BI Administration ToolCreating a repositoryLoading a repository into Oracle BI Server memory

    Building the Physical Layer of a Repository Importing data sourcesSetting up connection pool propertiesDefining keys and joinsExamining physical layer object propertiesCreating alias tables

    Building the Business Model and Mapping Layer of a RepositoryBuilding a business modelBuilding logical tables, columns, and sourcesDefining logical joinsBuilding measuresExamining business model object properties

    Building the Presentation Layer of a RepositoryExploring Presentation layer objectsCreating Presentation layer objectsModifying Presentation layer objectsExamining Presentation layer object properties

    Testing and Validating a RepositoryChecking repository consistencyTurning on loggingDefining a repository in the initialization fileExecuting analyses to test a repositoryInspecting the query log

    Managing Logical Table SourcesAdding multiple logical table sources to a logical tableSpecifying logical content

    Adding Calculations to a FactCreating new calculation measures based on existing logical columnsCreating new calculation measures based on physical columnsCreating new calculation measures using the Calculation WizardCreating measures using functions

    Copyright 2012, Oracle. All rights reserved. Page 3

  • Working with Logical DimensionsCreating logical dimension hierarchiesCreating level-based measuresCreating share measuresCreating dimension-specific aggregation rulesCreating presentation hierarchiesCreating parent-child hierarchiesUsing calculated members

    Using AggregatesModeling aggregate tables to improve query performanceSetting the number of elements in a hierarchyTesting aggregate navigationUsing the Aggregate Persistence Wizard

    Using Partitions and FragmentsExploring partition typesModeling partitions in an Oracle BI repositoryUsing the Calculation Wizard to create derived measures

    Using Repository VariablesCreating session variablesCreating repository variablesCreating initialization blocksUsing the Variable ManagerUsing dynamic repository variables as filters

    Modeling Time Series DataUsing time comparisons in business analysisUsing Oracle BI time series functions to model time series data

    Modeling Many-to-Many RelationshipsUsing bridge tables to resolve many-to-many relationships between dimension tables and fact tables

    Setting an Implicit Fact ColumnAdding fact columns automatically to dimension-only queriesEnsuring the expected results for dimension-only queriesSelecting a predetermined fact table source Specifying a default join path between dimension tables

    Importing Metadata from Multidimensional Data SourcesImporting a multidimensional data source into a repositoryIncorporating horizontal federation into a business modelIncorporating vertical federation into a business modelAdding Essbase measures to a relational modelDisplaying data from multidimensional sources in Oracle BI analyses and dashboards

    SecurityExploring Oracle BI default security settingsCreating users and groupsCreating application rolesSetting up object permissions

    Copyright 2012, Oracle. All rights reserved. Page 4

  • Setting row-level security (data filters)Setting query limits and timing restrictions

    Cache ManagementRestricting tables as non-cacheableUsing Cache ManagerInspecting cache reportsPurging cache entriesModifying cache parameters and optionsSeeding the cache

    Enabling Usage TrackingSetting up the sample usage tracking repositoryTracking and storing Oracle BI Server usage at the detailed query levelUsing usage tracking statistics to optimize query performance and aggregation strategiesAnalyzing usage results using Oracle BI Answers and other reporting tools

    Multiuser DevelopmentSetting up a multiuser development environmentDeveloping a repository using multiple developersTracking development project history

    Performing a Patch MergeComparing repositoriesEqualizing objectsCreating a patchApplying a patchMaking merge decisions

    Copyright 2012, Oracle. All rights reserved. Page 5

  • Oracle University | Contact Us: Local: 1800 103 4775 Intl: +91 80 4108 4709

    Oracle Endeca Information Discovery 2.3: Getting Started

    Duration: 3 Days

    What you will learnThis is a three-day course for data architects, application developers, and business analysts. It encompasses anintroduction to the concepts of Oracle Endeca Information Discovery data exploration and ingest, as well as hands-oninteraction in developing an Oracle Endeca Information Discovery sample business application using Integrator andStudio.

    Throughout the class you will learn about the core concepts specific to the Oracle Endeca Information Discovery productline. You will spend time getting introduced to Oracle Endeca Information Discovery becoming acquainted withIntegrator which configures your data and Studio that drives your application's user experience and encouragessuccessful end-user discovery. You will become familiar with the Oracle Endeca Information Discovery sample businessapplication assets and work with its data to build out your own Oracle Endeca Information Discovery analysisapplication.

    Through the hands-on lessons in the class, you will learn the details of how to work with and load different data in thecontext of your sample application. You will start with ingesting data using the Integrator. You will then build a basicresults page, using search, breadcrumbs, guided navigation and data explorer components in Studio. Next you areintroduced to the concepts of data modeling and joining data and how it can enhance your guided navigationexperience. The next portion of the class covers the process of adding a search interface through the Integrator, thenverifying its function and behavior through the search box component in your sample application. You will continue toenhance your guided navigation through creating attribute groups in Studio. Next, you will work with Integrator to createprecedence rules, then verify your results with your guided navigation component in Studio. In the next phase of theclass you will cover advanced topics such as Oracle Endeca Information Discovery deployment features, data ingestand modeling, text enrichment, and security. In the last phase of the class, you will be introduced to buildingvisualizations with charts, metric bars, alerts, results table and tag cloud Studio components. Through class labs, youwill be guided in building Endeca Query Language (EQL) statements and configuring Studio components to successfullydeliver the necessary enhancements to build your sample application.

    AudienceApplication DevelopersArchitectBusiness Analysts

    Related Training

    Required Prerequisites

    Familiarity with search and navigation conceptsWindows OS experience

    Copyright 2012, Oracle. All rights reserved. Page 1

  • Course ObjectivesLoad data and configuration using IntegratorManipulate data in an Integrator graphAccess Studio components, add them to a sample application and configure various preferences in themConfigure Guided NavigationConfigure and enhance search through features such as search interfacesUnderstand the aspects of data modeling using Oracle Endeca Information DiscoveryCreate enhanced visualizations by writing a variety of Endeca Query Language (EQL) statements in StudioCreate views in View Manager to use to configure chart components in Studio

    Course Topics

    Oracle Endeca Information Discovery Core ConceptsIntroduction to Oracle Endeca Information DiscoveryData IngestCapabilities: OverviewStudio: OverviewData Exploration in an Oracle Endeca Information Discovery Application

    Basic Data DesignProject Basics with Oracle Endeca Information DiscoveryWorking with StudioData Modeling and Joining Data

    Search and Navigation Configuration EnhancementsIntroduction to SearchEnhancing Navigation

    Advanced TopicsData Ingest and Modeling: OverviewText Enrichment in Oracle Endeca Information DiscoveryOracle Endeca Information Discovery Deployment FeaturesSecurity

    Configuring Enhanced VisualizationsIntroduction to the Endeca Query LanguageCreating and Using Views

    Next Steps for Enablement

    Copyright 2012, Oracle. All rights reserved. Page 2

  • Oracle University | Contact Us: Local: 1800 103 4775 Intl: +91 80 4108 4709

    Oracle BI 11g: New Features and Exalytics Coming Soon

    Duration: 1 Day

    What you will learnThis course teaches you about the BI Machine, its benefits, components, and architecture. You learn about theenhancements in Oracle BI EE and Oracle BI Publisher. You also learn about Oracle Summary Adviser (a componentdesigned to help you improve performance), BI Composer (an easy to use wizard for creating analyses), andenhancements in BI Mobile.Learn To:Describe Oracle Exalytics In-Memory MachineUse the Favorites menu, install BI Clients and use additional Selection Steps in Analyses Create Trellis graphs and use new dashboard prompts properties in Oracle BI EECreate a BI Publisher report by using the new Create Report wizard, use dashboard prompt properties, edit scheduledjobs, and create a scheduled job by using a triggerCreate an analysis by using BI ComposerDescribe the new features in ScorecardDescribe the touch gestures and options in BI MobileRun and use the Summary Adviser to improve performance

    AudienceAdministratorApplication DevelopersBusiness AnalystsBusiness Intelligence DeveloperDeveloperImplementation ConsultantReports DeveloperTechnical Consultant

    Related Training

    Required Prerequisites

    Knowledge of BI PublisherKnowledge of OBIEEOracle BI 11g R1: Create Analyses and DashboardsOracle BI Publisher 11g R1: Fundamentals

    Suggested PrerequisitesOracle BI 11g R1: Build Repositories

    Course ObjectivesDescribe and use enhancements to Oracle BI EECreate an analysis by using BI Composer

    Copyright 2012, Oracle. All rights reserved. Page 1

  • Describe and use Summary AdvisorUnderstand enhancements to Enterprise ManagerDescribe Oracle Exalytics In-Memory MachineDescribe enhancements for BI MobileDescribe and use enhancements in BI Publisher

    Course Topics

    Exploring Extreme Analytics with the BI MachineOracle Exalytics In-Memory Machine OverviewWhy Use Oracle Exalytics In-Memory Machine?Examining Oracle Exalytics TopologyOracle Analytics In-Memory ArchitectureOracle WebLogic Server, BI Foundation, and Fusion MiddlewareTimesTen and "Essbase on Exalytics"Techniques for leveraging In-Memory DatabasesBenefits of Exalytics

    Enhancing Oracle BI Enterprise EditionOracle BI EE housekeeping changes (My Account, Favorites menu, BI Client Installer, Search)Right-click Interaction MenusExamining the Selection Steps viewEnhancing Selections - Family Relationships (Siblings of, Leaves of)

    Enhancing BI Views and PromptsCreating Simple Trellis graphsCreating Advanced Trellis graphsOptional Apply and Reset buttonsAuto-complete functionalityOptions for Reset ButtonsEdit and Copy linksVertical or horizontal layout for Prompts

    Enhancing Oracle BI PublisherAdding and managing FavoritesCreating a report by using the Create Report WizardExamining Parameter and LOV enhancements (configuring radio buttons and checkboxes, Apply button)Examining the enhancements to Report ViewerParameter Search optionExploring Scheduled Jobs enhancements (editing a job, using a trigger)

    BI Composer, Scorecard, and BI MobileCreating an analysis by using BI ComposerUsing additional right-click Menu options in ScorecardsSetting targets in KPINew Home screen in iPadsConfiguring BI MobileWorking with Tables, Pivot tables, Graphs, and Maps Views in BI MobileWorking with Prompts in BI MobileWorking with BI Content Options in BI Mobile

    Copyright 2012, Oracle. All rights reserved. Page 2

  • Working with BI ToolsNesting Presentation Layer folders and controlling object visibilityChecking modeling problems with Model CheckerDescribing Summary AdvisorSetting up Summary AdvisorExploring the Summary Advisor WizardReviewing Enhancements to Enterprise ManagerDemonstration on Summary Advisor

    Copyright 2012, Oracle. All rights reserved. Page 3

    Front Page.pdfIntroduction to SQL.pdfCreate Analyses and Dashboards.pdfBuild Repositories.pdfOracle Endeca Information Discovery 2.3 - Getting Started.pdfOracle BI 11g - New Features and Exalytics.pdf