Oracle BI 11g R1 Create Analysis and Dashboards 5.0 Training & Placements in Chennai ISQL Global
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 Presentation 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.
- Use Oracle Business Intelligence Mobile to access BI content.
- UseBI content in Microsoft Office applications.
- Configure,schedule and deliver personalized alerts using Oracle BI Delivers.
- Use Oracle BI Briefing Books.
Benefits to YouEnrolling 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 presentations and spreadsheets.
Prerequisites
Audience
- End Users
- Application Developers
- Business Analysts
- Developer
- Technical Consultant
- Functional Implementer
- Business Intelligence Developer
- Technical Administrator
Course Objectives- Build and use views and graphs in analyses
- Combine analysis criteria using set operations and execute direct databaserequests
- Performpre- and post-aggregate filtering using filters, groups, andselections
- Add geographical mapping to analyses
- Use Oracle Business Intelligence Mobile to view BI content on a mobile device
- Create and modify dashboards
- Use Oracle BI for Microsoft Office to integrate Oracle BI analysis anddashboard content
Configure agents using Delivers to get the results of analyses and deliverthem to subscribersCreate and modify Oracle Business Intelligence analysesUsehierarchical columns in analyses and viewsPerformadministration 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 Presentation Catalog- Understandingsecurityinheritance
- Maintaining the Oracle BI Presentation Catalog in the Catalog page
- Settingsystem privileges
- Managingsecurity using roles
- Archivingcatalog items
- OracleBI and catalog security overview
- Settingobject permissions
Limiting and Grouping Data in Analyses- Creatingcalculated items
- Creating,editing, and grouping filters
- Addingprompts 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
- Executingdirect database analyses
- Setting analysis properties
- Combining analysis criteria by using set operations
Working with Views and Graphs in Analyses- Linking master-detail views
- Performingcommon 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
- Buildingcalculations 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
- Publishingdashboard pages
- Creatingpersonal customizations and using other page options
- Creating and editing dashboards
- Exploringdashboard oject properies and options
Configuring Oracle Business Intelligence Dashboards- Types of dashboard content
- Embeddingcontent 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
- Wiringdashboard prompts
Using Oracle Business Intelligence Delivers- Configuring an agent
- Subscribingto an agent
- UsingAnalysis 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
- Configuringdelivery 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- UsingBriefing Books with Oracle BI Delivers
- Downloading and viewing Briefing Books
- Addingcontent to Briefing Books
- Adding a list of Briefing Books to a dashboard
- EditingBriefing Books
- Introduction to Oracle BI Briefing Books