Duration
5 days
Overview
This Oracle BI 11g R1: Analyses, Dashboards & Repositories Bootcamp training teaches you how to create analyses and dashboards, which compose business intelligence applications. Working with expert Oracle University instructors, 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:
- Configure, schedule, and deliver personalized alerts using Oracle BI Delivers.
- Build a dimensional business model to address business intelligence requirements.
- Build and execute analyses to test and verify a dimensional business model analyses.
- Build analyses and dashboards.
- Build and use views and graphs in analyses.
- Create and modify Oracle BI Dashboards.
Include pivot tables, graphs, gauges, maps, prompts, embedded content, navigation links and KPIs on the dashboards.
- Use Oracle BI Delivers to send real-time, personalized alerts to dashboards and subscribed users.
- Use Oracle Business Intelligence Mobile to access BI content on mobile devices.
Benefits to You
This course also teaches you how to build and verify the three layers of an Oracle BI repository. You'll use the Oracle BI Administration Tool to construct a simple repository to address a fictitious company's business requirements. Enrolling in this course will help you develop import schemas, design and build logical business models and expose business models to users in the Oracle BI user interface. While constructing the repository, you'll also learn how to build physical and logical joins, simple measures and calculation measures.
Target Audience
- Administrator
- Analyst
- Architect
- Developer
- Implementer
Course Objectives
- Add geographical mapping to analyses
- Create and modify Oracle Business Intelligence analyses and dashboards
- Perform administration tasks related to the development and configuration of dashboards
- Build and use views and graphs in analyses
- Perform pre- and post-aggregate filtering using filters, groups, and selections
- Use Oracle Business Intelligence Mobile to view BI content on a mobile device
- Configure Agents using Delivers to get the results of analyses and deliver them to subscribers
- 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
- Set up security to authenticate users and assign appropriate permissions and privileges
- Apply cache management techniques to maintain and enhance query performance
Course Topics
- Working with Oracle Business Intelligence Analyses
- Administering the Presentation Catalog
- Limiting and Grouping Data in Analyses
- Working with Views and Graphs in Analyses
- Visualizing Data: Gauges, Maps, and Mobile,Showing Results With Pivot Tables
- Creating and Configuring Oracle Business Intelligence Dashboards
- Creating Dashboard Prompts and Variables
- Repository Basics
- Building the Physical Layer of a Repository
- Building the Business Model and Mapping Layer of a Repository
- Building the Presentation Layer of a Repository
- Managing Logical Table Sources
- Adding Calculations to a Fact
- Working with Logical Dimensions
- Using Aggregates
- Using Partitions and Fragments
- Using Repository Variables
- Security
- Cache Management
- Multiuser Development
Programme scope, delivery arrangements and suitability are confirmed during enquiry.