Type
Virtual
Classroom ILT
Skill Level

Available dates
Learning Path
Virtual
Duration
1 Day

TYPE
Virtual
Classroom ILT
LEARNING PATH
SKILL LEVEL

DURATION
AVAILABLE DATES
Introduction:
This five-day Oracle BI 12c: Create Analyses and Dashboards course for Release 12.2.1 provides step-by-step instructions for creating Oracle BI analyses and dashboards in business intelligence applications. You’ll begin by building basic analyses to include in dashboards, with more complexity as the course progresses.
Audience profile:
Application Developers, Business Intelligence Developers, Database Administrators, Forms Developers, J2EE Developers, PL/SQL Developers, System Analysts and Technical Consultants
Course objectives
After completing this course, students will be able to:
- Build and use views and charts in analyses
- Perform pre- and post-aggregate filtering using filters, groups, and selections
- Create mobile applications with Oracle Business Intelligence Mobile App Designer
- Add geographical mapping to analyses
- Use Key Performance Indicators and Scorecards to analyze trends and meet business objectives
- Use BI Mobile to access BI Content
- 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 Analysis Editor
- Perform administration tasks related to the development and configuration of Interactive Dashboards
- Administer analyses and other Oracle BI objects
- Use Oracle Hyperion Smart View for Office to integrate Oracle BI analysis and Interactive Dashboard content into Office documents
- Combine analysis criteria across multiple subject areas and execute direct database queries
Lesson 1: Introduction
This lesson provides a course overview. Lessons: |
|
|
|
|
|
|
|
|
|
Lesson 2: Introduction to Oracle Business Intelligence Enterprise Edition
This lesson provides foundational information to set the context for the remainder of this course. An understanding of the architecture components and the role of Oracle Business Intelligence in the enterprise prepares you to work with the tools included. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 3: Working with Oracle Business Intelligence Analyses
This lesson explores the use of Oracle BI Analysis Editor which enables you to create and edit analyses to explore and interact with information. Lessons: |
|
|
|
|
|
|
|
|
|
Lesson 4: Filtering Data for Analyses
This lesson describes the usage and features of filter within analyses. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
Lesson 5: Selecting and Grouping Data for Analysis
This lesson describes how to implement selections and groupings to limit the data that is returned in the analyses. Lessons: |
|
|
|
|
|
|
|
Lesson 6: Advanced Visualization in Analyses
This lesson describes how to implement advanced views and compound layouts in analyses. Lessons: |
|
|
|
|
|
|
|
|
|
Lesson 7: Showing Results with Pivot Tables
This lesson describes how to create interactive pivot tables within analyses. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
Lesson 8: Working with Additional Views in Analyses
This lesson describes how to use additional views in analyses. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 9: Visualizing Data on Maps
This lesson describes how to add and work with geographical maps. Lessons: |
|
|
|
|
|
Lesson 10: Creating Oracle Business Intelligence Dashboards
This lesson describes the creation and use of dashboards. Lessons: |
|
|
|
|
|
Lesson 11: Configuring Oracle Business Intelligence Dashboards
This lesson describes how to configure custom dashboards. Lessons: |
|
|
|
|
|
Lesson 12: Creating Dashboard Prompts and Variables
This lesson describes the nature of Oracle BI variables and how they can be used to customize analyses. Lessons: |
|
|
|
|
|
Lesson 13: Scorecards and Key Performance Indicators
This lesson describes how to create and manage scorecards. Lessons: |
|
|
|
|
|
|
|
|
|
Lesson 14: Visual Analyzer, BI Ask, and Data Mashup
This lesson describes how to use Visual Analyzer within analyses. Lessons: |
|
|
|
|
|
|
|
Lesson 15: Working with BI Content in Smart View
This lesson describes how to use smart view to create and publish analyses reports to Microsoft Office documents. Lessons: |
|
|
|
|
|
|
|
|
|
Lesson 16: Oracle Business Intelligence Mobile App Designer
This lesson describes how to use Mobile App Designer to create basic mobile apps and pages. Lessons: |
|
|
|
|
|
|
|
Lesson 17: Using Oracle Business Intelligence Delivers
This lesson describes how to add and configure delivery devices. Lessons: |
|
|
|
|
|
|
|
|
|
Lesson 18: Administering the Presentation Catalog
This lesson describes the management processes of roles and privileges within the presentation catalog. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
Lesson 19: Direct Database Analysis
This lesson describes how to create direct database analysis through SQL and XML. Lessons: |
|
|
|
|
|
|
|
Lesson 20: Expressions
This lesson describes how to use SQL aggregate, time series and analytical funtions. Lessons: |
|
|
|
|
|
|
|
|
|
Associated certifications and exam:
This course prepares students to write Exam (None). On successful completion of this course students will receive an Oracle University attendance certificate.

Oracle Overview
Torque IT considers authorised Oracle training to be an integral part of any Oracle Solaris, Oracle Enterprise Linux, Oracle Applications, Java development, or Oracle Database implementation. Oracle authorized training, and associated certification, ensures that you get the most from your technology investment and that you are able to operate above the technology curve.
Our instructor led training provides customers with a hands-on experience to match job role requirements and prepares delegates for Oracle Certification exams. From in-class demonstrations to hands-on-labs, Torque IT’s authorised Oracle instructor led training provides our customers with a comprehensive and dynamic learning experience.
Oracle certifications are universally recognized as demonstrating a high level of expertise and credibility for individuals and the organizations that employ them. Authorised Oracle training and certification is the industry standard for any solution that includes designing, selling, implementing, upgrading, developing and managing Solaris, Java, and Oracle Database solutions.
Torque IT is recognised by Oracle as an Oracle University Training Centre which means that we offer our clients internationally recognised and globally accredited Oracle training and certification. These achievements reflect our commitment to providing our customers with quality skills development, enablement, training, and certification solutions that demonstrate exceptional depth, breadth, and expertise.
Torque is recognised by Oracle, and the industry, as having met rigorous standards for educational competency, service, customer satisfaction and investment in technology that will prepare the next generation of IT industry professionals to exploit Oracle Solutions.