TruTek

Oracle Analytics for Administrators

(Oracle BI EE Analytics)

2-Day Workshop

Give your technical staff that competitive edge with this Oracle (Siebel) Analytics Workshop. This course gives students hands-on experience with setting up the Oracle Analytics end user data access environment. Students will practice administrative tasks using Oracle's Administration Enterprise Edition tool. Students will learn to create the RPD data definition repository and create and manage business areas. Students will learn how to hide the complexity of the data source and provide a user-friendly view of the data for end users.

Topics Covered:

• Introduction to the Analytics Administrator Interface
• Review of the End User interface
• Create/Manage the Data Repository (RFD Files)
• Create Custom Folders
• Create Data Hierarchies
• Maintaining Security and Permissions
• Import and Define various Data Sources
• Creating Joins and Calculated Items
• Creating Data Points

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: Introduction to Oracle Analytics
  • Build a Report
  • Build a Report with a Pivot Table
  • Add a chart to the Report
  • Using Answers
  • Saving Reports
  • Running Reports
• Lesson 2: Prerequisites for Building the Analytics Repository
  • Connecting via ODBC
  • Understand the Analytics Repository Layers and Components
  • Review the Web Components for the Analytics Repository
  • Connecting the end users to the Analytics Repository
• Lesson 3: Building the Physical Layer
  • Including existing application schemas
  • Create the Physical Joins
  • View the Physical Layer Diagram
• Lesson 4: Building the Business Layer
  • Creating a Business Model
  • Map the Physical Layer to the Business Layer
  • Adding Aggregate Columns
  • Adding Calculations
  • Adding Hierarchies/Drill Paths
  • Renaming Items/Folders/Columns
• Lesson 5: Building the Presentation Layer
  • Organizing Folders/Columns
• Lesson 6: Validating and Testing the Analytics Repository
  • Using the Consistency Checker
  • Installing the Analytics Repository into the Web Environment
  • Testing the Analytics Repository using Answers
• Lesson 7: Using Expression Builder
  • Working with Initialization Blocks
  • Working with Session Variables
  • Creating Dynamic Repository Variables
• Lesson 8: Security and Permissions
  • Assigning users to the Repository
  • Managing User Privileges
• Lesson 9: Working with Multiple Data Sources
  • Setting up ODBC to see the Data Sources
  • Adding the Data Sources to the Repository
• Lesson 10: Miscellaneous Topcs
  • Direct Database Access
  • Using Aggregates
  • Setting up Time Series Measures