Oracle BI 11g R1 Create Analysis and Dashboards 5.0 Training & Placements in Chennai SQL STAR

Oracle BI 11g R1: Create Analyses and Dashboards

(The Course materials and Course Completion Certificates are directly delivered from Oracle University to those seeking for Foreign Opportunity)

(Government of India Approved Education Center)

This Oracle BI 11g R1: Create Analyses and Dashboards Self-Study Course teaches you how to use tools and components of the Business Intelligence Foundation Suite. Information is presented in a simple and easy-to-understand manner.
This Oracle BI 11g R1: Create Analyses and Dashboards Self-Study Course provides step-by-step instructions for creating analyses and dashboards, which compose business intelligence applications. You'll learn how to administer the Oracle BI Present ation Catalog and build a simple Oracle BI dashboard starting with basic analyses, adding more complexity as the course progresses.
Learn To:

• Buildanalyses and dashboards.
• Buildand use views and graphs in analyses.
• Create analyses using Essbase data sources.
• Create and work with KPIs.
• Create and modify Oracle BI Dashboards.
• UseOracle Business Intelligence Mobile to access BI content.
• UseBI content in Microsoft Office applications.
• Configure,schedule and deliver personalized alerts using Oracle BI Delivers.
• UseOracle BI Briefing Books.

Benefits to You
Enrolling in this course will also teach you how to include pivot tables, graphs, gauges, maps, prompts, embedded content, navigation links and KPIs on the dashboards. You'll also be introduced to using Oracle BI for Microsoft Office to integrate Oracle BI data and views in Microsoft Office present ations and spreadsheets.
Prerequisites
Audience

• EndUsers
• Application Developers
• BusinessAnalysts
• Developer
• Technical Consultant
• FunctionalImplementer
• BusinessIntelligence Developer
• Technical Administrator

Course Objectives

• Buildand use views and graphs in analyses
• Combineanalysis criteria using set operations and execute direct databaserequests
• Performpre- and post-aggregate filtering using filters, groups, andselections
• Addgeographical mapping to analyses
• UseOracle Business Intelligence Mobile to view BI content on a mobiledevice
• Create and modify dashboards
• UseOracle BI for Microsoft Office to integrate Oracle BI analysis anddashboard content
• Configureagents using Delivers to get the results of analyses and deliverthem to subscribers
• Create and modify Oracle Business Intelligence analyses
• Usehierarchical columns in analyses and views
• Performadministration tasks related to the development and configurationof dashboards

Course Topics
Introduction to Oracle Business Intelligence Enterprise Edition

• Introduction to Oracle BI
• Architectureoverview

Working with Oracle Business Intelligence Analyses

• Working with analyses in Oracle BI
• Introduction to Oracle BI Analysis Editor
• OracleBI column types
• Using advanced formatting

Administering the Present ation Catalog

• Understandingsecurity inheritance
• Maintaining the Oracle BI Present ation Catalog in the Catalog page
• Settingsystem privileges
• Managingsecurity using roles
• Archiving catalog items
• OracleBI and catalog security overview
• Setting object permissions

Limiting and Grouping Data in Analyses

• Creating calculated items
• Creating,editing, and grouping filters
• Adding prompts to analyses
• Creatingselection steps
• Creatinggroups
• Dynamicfiltering
• Introduction to filters and selections
• Usingsaved analyses as filters

Oracle Business Intelligence Analyses: Advanced Features

• Creating an Excel Web Query file
• Editinglogical SQL generated by an analysis
• Creating a link to a saved analysis
• Executing direct database analyses
• Setting analysis properties
• Combining analysis criteria by using set operations

Working with Views and Graphs in Analyses

• Linkingmaster-detail views
• Performing common view tasks
• Creating and editing graphs
• Working with views in Compound Layouts
• Introduction to views, graphs, and editors

Visualizing Data: Gauges, Maps, and Mobile

• Working with and searching content in BI Mobile
• Introduction to Map views and their components
• Introduction to Gauge views
• Working with Gauge views
• Creating and editing Map views
• Introduction to Oracle Business Intelligence Mobile

Measuring Results with Key Performance Indicators

• Changing Dimensionality for a KPI Watchlist event
• CreatingKPIs, setting trending, dimensionality, and thresholds
• Introduction to KPI Watchlists
• Introduction to KPIs
• Creating a KPI Watchlist

Showing Results With Pivot Tables

• Using hierarchical columns
• Sorting in pivot tables
• Setting aggregation and using totals
• Creating,arranging, and formatting a pivot table
• Introduction to pivot tables
• Building calculations and displaying running sums
• Showing an item's relative value

Creating Oracle Business Intelligence Dashboards

• Using the Dashboard Builder
• Introduction to dashboards and dashboard pages
• Publishing dashboard pages
• Creating personal customizations and using other page options
• Creating and editing dashboards
• Exploring dashboard oject properies and options

Configuring Oracle Business Intelligence Dashboards

• Types of dashboard content
• Embedding content in dashboards

Creating Dashboard Prompts and Variables

• Introduction to dashboard prompts and prompt types
• Adding a hidden named dashboard prompt to a dashboard
• Creating additional prompt page and setting page preferences
• Adding a named dashboard prompt to a dashboard
• Variablesand prompts
• Addingvariable prompts to a dashboard
• Overview of variables
• Wiring dashboard prompts

Using Oracle Business Intelligence Delivers

• Configuring an agent
• Subscribing to an agent
• Using Analysis and KPI conditions to deliver content with agents
• Introduction to Oracle BI Delivers
• Introduction to alerts
• Adding an Alert Section to a dashboard
• Overview of agents
• Configuring delivery devices and adding delivery profiles

Integrating Analyses with MS Office

• Working with Oracle BI content in Microsoft Office applications
• Introduction to Oracle BI Office Add-in

Working with Oracle Business Intelligence Briefing Books

• Using Briefing Books with Oracle BI Delivers
• Downloading and viewing Briefing Books
• Adding content to Briefing Books
• Adding a list of Briefing Books to a dashboard
• Editing Briefing Books
• Introduction to Oracle BI Briefing Books