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 professional Oracle University instructors, you’ll learn how to administer the OBI Presentation Catalog and build a simple Oracle Business Intelligence 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 Business Intelligence Delivers to send real-time, personalized alerts to dashboards and subscribed users.
- Use Oracle Business Intelligence Mobile to access BI content on mobile devices.
Course Objective
-
Module 1: Working with Oracle Business Intelligence Analyses
-
Module 2: Administering the Presentation Catalog
- Lesson 1: Maintaining the Oracle BI Presentation Catalog in the Catalog page
- Lesson 2: Oracle BI and catalog security overview
- Lesson 3: Managing security using roles
- Lesson 4: Understanding security inheritance
- Lesson 5: Setting object permissions
- Lesson 6: Setting system privileges
- Lesson 7: Archiving catalog items
-
Module 3: Limiting and Grouping Data in Analyses
- Lesson 1: Introduction to filters and selections
- Lesson 2: Creating, editing, and grouping filters
- Lesson 3: Adding prompts to analyses
- Lesson 4: Dynamic filtering
- Lesson 5: Using saved analyses as filters
- Lesson 6: Creating groups
- Lesson 7: Creating calculated items
- Lesson 8: Creating selection steps
-
Module 4: Working with Views and Graphs in Analyses
-
Module 5: Visualizing
- Lesson 1: Introduction to Gauge views
- Lesson 2: Working with Gauge views
- Lesson 3: Introduction to Map views and their components
- Lesson 4: Creating and editing Map views
- Lesson 5: Introduction to Oracle Business Intelligence Mobile
- Lesson 4: Creating and editing Map views
- Lesson 6: Working with and searching content in BI Mobile
-
Module 6: Showing Results With Pivot Tables
- Lesson 1: Introduction to pivot tables
- Lesson 2: Creating, arranging, and formatting a pivot table
- Lesson 3: Using hierarchical columns
- Lesson 4: Sorting in pivot tables
- Lesson 5: Setting aggregation and using totals
- Lesson 6: Showing an item’s relative value
- Lesson 7: Building calculations and displaying running sums
-
Module 7: Creating and Configuring Oracle Business Intelligence Dashboards
-
Module 8: Creating Dashboard Prompts and Variables
- Lesson 1: Introduction to dashboard prompts and prompt types
- Lesson 2: Adding a named dashboard prompt to a dashboard
- Lesson 3: Adding a hidden named dashboard prompt to a dashboard
- Lesson 4: Creating additional prompt page and setting page preferences
- Lesson 5: Variables and prompts
- Lesson 6: Adding variable prompts to a dashboard
- Lesson 7: Wiring dashboard prompts
- Lesson 7: Wiring dashboard prompts
-
Module 9: Repository Basics
-
Module 10: Building the Physical Layer of a Repository
-
Module 11: Building the Business Model and Mapping Layer of a Repository
-
Module 12: Building the Presentation Layer of a Repository
-
Module 13: Managing Logical Table Sources
-
Module 14: Adding Calculations to a Fact
-
Module 15: Working with Logical Dimensions
- Lesson 1: Creating logical dimension hierarchies
- Lesson 2: Creating level-based measures
- Lesson 3: Creating share measures
- Lesson 4: Creating dimension-specific aggregation rules
- Lesson 5: Creating presentation hierarchies
- Lesson 6: Creating parent-child hierarchies
- Lesson 7: Using calculated members
-
Module 16: Using Aggregates
-
Module 17: Using Partitions and Fragments
-
Module 18: Using Repository Variables
-
Module 19: Security
-
Module 20: Cache Management
-
Module 21: Multiuser Development
0.00 average based on 0 ratings