Oracle Utilities: Business Intelligence v2.4 Implementation

Course Details
Code D77793GC21
Tuition (USD): $2,790.00 • Classroom (3 days)

This Oracle Utilities: Business Intelligence v2.4 Implementation training introduces you to the major concepts and configuration tasks needed to implement Oracle Business Intelligence for Utilities (OBIU). Explore key business intelligence systems concepts and challenges, along with the solutions incorporated into OBIU that make it unique.

Learn To:

  • Configure OUBI.
  • Apply data warehouse theory.
  • Use Graphical metaphors to display analytic information.
  • Configure the information in the data warehouse.

Benefits to You

Transform your organization's data into intelligence for improved decision making. The knowledge and experience you gain from this course will help you provide time-critical, relevant and accurate insights into your business.

Extract Data from the Source Application

This course teaches you about the OBIU programs used for extracting data from the source application. You'll explore the rules used for loading star schemas in the data warehouse while developing the knowledge to use the system to highlight deviations from target performance. Expert Oracle University instructors will also teach you how to configure the portals and zones used to display the warehouse data.

Skills Gained

  • Understand the OBIU application
  • Describe the basic architecture of OUBI and its underlying applications
  • Identify the OBIEE components
  • Locate and navigate to dashboards and analyses in each of the OBIU analytics
  • Locate and use OBIU-related product documentation
  • Understand the concept of a data warehouse
  • Understand how you can configure the information in the data warehouse
  • Understand and explain the extraction programs and methodologies used in OBIU
  • Load extracted files into a data warehouse
  • Understand flat file structures
  • Manage spatial data
  • Create analyses and add dashboards
  • Customize user-defined fields and measures (UDF and UDM)
  • Modify an extract
  • Apply best practices during an OBIU implementation

Who Can Benefit

  • Business Analysts
  • Business Intelligence Developer
  • Data Modelers
  • Data Warehouse Analyst
  • Developer
  • Functional Implementer
  • Project Manager
  • Reports Developer

Course Details

OBIU Introduction

  • Course components
  • Course conventions

OBIU Overview

  • Prerequisite information
  • Product offerings
  • Product strategy
  • OBIU architecture
  • Extractors and schema
  • Prebuilt analytics
  • Oracle Utilities analytics benefits (CCB, MDM, MWM, WAM, NMS - Outage)

Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Overview

  • Conceptual architecture
  • Self-service reporting
  • OBIEE components
  • Oracle BI Server
  • Analysis process
  • Presentation services

OBIU Dashboards

  • CCB dashboards
  • MDM dashboards
  • MWM dashboards
  • WAM dashboards
  • OMS dashboards

OBIU Architecture

  • Data flow
  • OBIU extractors
  • Oracle Warehouse Builder (OWB)
  • OBIU schema
  • Materialized views
  • Utilities analytics
  • Platform requirements
  • Product documentation explanation

Data Warehouse Fundamentals

  • OLTP to star schema
  • Business intelligence and data warehouse advantages
  • Explanation of Extract, Transform, Load (ETL) process
  • Facts and dimensions
  • Materialized views

OBIU Schema Overview

  • Schema components
  • CCB schema
  • WAM schema
  • OMS schema
  • MDM schema
  • MWM schema
  • Data mapping guide

ETL - Extraction Overview

  • ETL architecture
  • Process components
  • Extractors
  • Flat files
  • Extraction processes for CCB, MDM, MWM, WAM, and NMS - Outage

ETL - Loading Overview

  • Extract files
  • File processor daemon
  • Oracle Warehouse Builder (OWB)
  • External tables
  • File manager
  • Process flows
  • Monitoring load jobs
  • Resubmitting a failed job

ETL Lab

  • Loading files using File Loader
  • Loading files using OWB

OBIU Administration and Spatial Configuration

  • Managing labels
  • Drill-back configuration
  • Spatial configuration
  • Map data management
  • Creating a theme

Creating Analyses and Dashboards Lab

  • Create a table for revenue analysis
  • Adding graphical charts
  • Adding analysis to a dashboard

Product Extension Methods

  • Customizing UDMs and UDFs
  • Extracting UDMs and UDFs
  • Loading UDMs and UDFs
  • Extending the data warehouse schema

User Defined Dimension Lab

  • Changing an UDM for NMS
  • Identify and modify an extract script
  • Use the modified script

Implementation Best Practices

  • Planning
  • Analysis and requirements
  • Design
  • Project scheduling
Course Details
Code D77793GC21
Tuition (USD): $2,790.00 • Classroom (3 days)