obiee developer
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