TruTek

Oracle Answers for End Users

(Oracle BI EE Analytics)

2-Day Workshop

Give your technical staff that competitive edge with this Oracle (Siebel) Analytics Workshop. 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. The will learn to view, chart, and analyze multidimensional data. They will also learn to product individual ad hoc reports.

Topics Covered:

• Introduction/Analytics Overview
• Viewing Data
• Working with Filters/Totals/Format Results
• Modifying the Display
• Working with Conditions and Parameters
• Working with Exceptions and Calculations
• Working with Pivot Tables
• Working with Variables and Parameters
• Building Charts
• Report Maintenance
• Building and Maintaining Custom Dashboards

Lecture and topics are enhanced with live illustrations and hands-on exercises.

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

Course Outline

• Oracle Analytics Overview
  • What is Data Analysis
  • What is Oracle Analytics
  • Analytics Components
    • Web Interface
    • Analytics Data Environment
    • Analytics Administrative Component
    • Analytics End User Component
  • Important Terminology
  • The Training Environment
• Lesson 1: Creating Queries
  • Selecting data
  • Using Results options
  • Working with Pivot Tables
  • Adding items to your report
• Lesson 2: Results Management
  • Saving Reports
  • Sharing Reports
  • Running Reports
  • Renaming Reports
  • Deleting Reports
• Lesson 3: Modify the Display
  • Adding Report Titles
  • Formatting Headings
  • Formatting Data
  • Work with Result Views
• Lesson 4: Filtering Data/Conditional Formats
  • Add Filters
  • Work with Conditional Formats
  • Work with Gauges
• Lesson 5: Calculations / Percentages / Totals
  • Adding calculations
  • Work with Totals and Percentages
  • Work with Pivot Tables
• Lesson 6: Variables and Prompts
  • Make reports flexible with user-supplied information
• Lesson 7: Searching the Data
  • Create/Use Column Selectors
  • Create/Use View Selectors
• Lesson 8: Building Charts
  • Review all charting options
  • Build various Charts
  • Working with colors and legends
• Lesson 9: Using Answers
  • Build ad-hoc queries using Answers
  • Drill into data using Answers
• Lesson 10: Creating Dashboards
  • Build interactive Dashboards
  • Using Dashboard Prompts
  • Using Dashboard Presentation Variables