Oracle Business Intelligence

PDF OPEN FILE AS PDF DOCUMENT 

Course Benefits:

  • Course One:
      • Describe the fundamental business intelligence term and concepts
      • Navigate the BI dashboard
      • Identify and describe the major components of Oracle BI architecture
      • Use the BI Admin tool to view the repository
      • Explain the three layers of the BI repository
      • Use the BI Answer tool to view the dashboard and report definition
      • Understand the typical BI apps development project lifecycle
  • Course Two:
      • Use the Oracle BI Administration Tool to build, manage, and maintain an Oracle BI repository
      • Build a dimensional business model to address business intelligence requirements
      • Build and execute analyses to test and verify a dimensional business model analyses
      • Use the Oracle BI Administration Tool to administer Oracle BI Server
  • Course Three:
      • Create and modify the analytics request using Oracle Bi Answer
      • Create and modify the analytics dashboards
      • Create guided navigation links within the dashboard


Who Should Attend:

  • BI Apps Developer
  • BI Architect
  • Business Analyst
  • Application Administrator
  • Database Administrator
  • Project Manager


About the Instructor:

  • 15 year experience in enterprise business application  development
  • 5 year in developing prepackaged BI Apps
  • Various roles in the application development, including application engineer, application architect, solution architect, product manager, and development manager


Course Dates: 80 hours – 20 sessions (pls call for details)


Course Content:

  • Course 1: Oracle BI Overview
      • Introduction
      • Oracle BI Overview
      • Exploring the BI Dashboard and Report User Interface
      • Oracle BI Architecture
      • Oracle BI Admin Tool
      • Oracle BI Repository
      • Oracle BI Application Overview
      • BI Project Lifecycle
  • Course 2: Use BI Admin Tool and Create Repository
      • Repository Overview
      • BI EE Admin Tool
      • Physical Layer
      • Business Model and Mapping
      • Importing Metadata
      • Presentation Layer
      • Testing and Validating Repository
      • Manage Logic Table Source
      • Create Metrics
      • Create Dimension Hierarchy
      • Create Level based Attributes
      • Logical Dimension with Parent-child Hierarchy
      • Ragged and Skip Level Hierarchy
      • Setting an Implicit Fact Column
      • Using Aggregate
      • Using Partitions and Fragments
      • Using Variables
      • Data Security Basic
      • Modeling Time dimension
      • Using Time Hierarchy
      • Using Time Series functions
      • Localizing Oracle BI Metadata
      • Localizing Oracle BI Data
      • Cache Management
      • Enabling Usage Tracking
      • Setting up an Multiuser Development
  • Course 3: Use BI Answer and Create Dashboard and Reports
      • BI Answer - User Interface
      • Create a query
      • Using Formulas and Filter
      • Create Views and Charts
      • Creating Pivot Tables
      • Create Dashboard
      • Using Prompts
      • Session Variables
      • Create Guided Navigation
      • Dashboard design best practice
      • Create iBot