Oracle OBIEE Queries and Reports for End Users

Request more details:

submit request
This course introduces students to the querying and analytical capabilities of Oracle Analytics (Oracle BI Enterprise Edition) using the web interface. Students will learn to create, modify, run, and refine ad hoc queries. They will learn to view, chart, and analyze multidimensional data. They will also learn to produce individual ad hoc reports.
A working knowledge of Oracle is required.
Topics covered:
Introduction/Analytics Overview
Oracle BIEE and data warehouse overview
Viewing Data
Building Reports
Report Formatting
Querying the Database via Answers
Building and Maintaining Custom Dashboards
Creating web pages/MS Office integration via BI Publisher
Attendees Receive:
Study guide with presentations and relevant white papers
Opportunity to ask the tough Oracle questions
A hands-on opportunity to learn more about Oracle Analytics
Oracle Analytics Overview:
o What is Data Analysis
o What is Oracle Analytics
o Analytics Components
 Web Interface
 Analytics Data Environment
 Analytics Administrative Component
 Analytics End User Component
o Important Terminology
o The Training Environment
Creating Queries:
o Selecting data
o Using Results options
o Working with Pivot Tables
o Adding items to your report
Results Management:
o Saving Reports
o Sharing Reports
o Running Reports
o Renaming Reports
o Deleting Reports
Modify the Display:
o Adding Report Titles
o Formatting Headings
o Formatting Data
o Work with Result Views
Filtering Data/Conditional Formats:
o Add Filters
o Work with Conditional Formats
o Work with Gauges
Calculations / Percentages / Totals:
o Adding calculations
o Work with Totals and Percentages
o Work with Pivot Tables
Variables and Prompts:
o Make reports flexible with user-supplied information
Searching the Data:
o Create/Use Column Selectors
o Create/Use View Selectors
Building Charts:
o Review all charting options
o Build various Charts
o Working with colors and legends
Using Answers:
o Build ad-hoc queries using Answers
o Drill into data using Answers
Creating Dashboards:
o Build interactive Dashboards
o Using Dashboard Prompts
o Using Dashboard Presentation Variables
Working with BI Publisher:
o Creating MS Office documents/web pages easily