Courses for Oracle BI, ODI & Data Warehousing

All Oracle University Business Intelligence (OBIEE), Data Warehousing & ODI courses  are delivered at Deloitte NZ. If the course you need is not showing Please enquire - Course Enquiry

Enhanced Visual Analysis with Data Visualization

Learn to use Data Visualization to easily create visualizations and explore your data through intuitive drag and drop gestures. Quickly upload data from a variety of sources, like spreadsheets, CSV files, Fusion Applications and database, to your system and model it in a few easy steps. Use the Oracle Analytics Cloud Home page to perform analyses & dashboards tasks

OBIEE 12c: Create Analyses & Dashboards

Provides step-by-step instructions for creating Oracle BI analyses and dashboards in business intelligence applications. You'll begin by building basic analyses to include in dashboards, with more complexity as the course progresses.

OBIEE 12c: Build Repositories

Teaches you how to build and verify the three layers of an Oracle Business Intelligence (BI) repository, step-by-step. Our expert Oracle University instructor will begin by teaching you how to use the Oracle BI Administration Tool to construct a simple repository.

Oracle BI 12c: New Features for Administrators

Instructions & step-by-step procedures for the new features of Oracle BI 12c, with emphasis on sys admin features & changes. Overview of the BI 12c new features, BI sys admin tasks, installation steps, the logical architecture, & the tools used to complete system admin tasks. Learn to upgrade from Oracle BI 11g to BI 12c...

BI Publisher 12c R1: Fundamentals

BI Publisher 12c provides best of breed capabilities for scheduling and bursting reports. By investing in this course, you'll learn how to schedule and manage scheduled jobs, along with bursting reports to other destinations

Predictive Analytics using Oracle Data Mining

In this course, students review the basic concepts of data mining and learn how leverage the predictive analytical power of Oracle Data Mining, a component of the Oracle Advanced Analytics option

18c Data Warehousing Concepts

Explains the evolution of Data Management systems, the business drive behind Data Warehousing and Business Intelligence, and the related concepts and terminology.

12c: Analytic SQL for Data Warehousing

12c: Analytic SQL for DW teaches how to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data & exclude branches from the tree structure. Learn to use regular expressions & sub-expressions to search for, match & replace strings.

Administer a Data Warehouse

Learn about Oracle’s Database partitioning architecture and how to identify the benefits of partitioning in addition to using parallel operations to reduce response time for data-intensive operations. Extract, transform, and load data into an Oracle database warehouse.

Business Intelligence on Oracle Cloud

Provides step-by-step instructions for creating analyses and dashboards using Oracle Business Intelligence Cloud Service. You’ll learn how to load data, model data, build and modify analyses and dashboards, while configuring Business Intelligence Cloud Service on mobile.

Oracle Data Integrator (ODI) 12c: New Features

This ODI workshop details the new features and techniques of using 12c ODI for implementing high-performance movement.

Oracle Data Integrator (ODI) 12c: Integration & Admin

Learn how ODI covers all data integration requirements from high-volume, high-perf batch loads, to event-driven integration processes & SOA-enabled data services. ODI's Extract, Load, Transform (E-LT) architecture leverages disparate RDBMS engines to process & transform the data - approach that optimizes performance, scalability & lowers overall solution costs.

Oracle Data Integrator (ODI) 12c: Advanced Integration & Dev

Covers advanced techniques for using Oracle Data Integrator 12c (ODI). Learn how to implement high-performance movement and transformation of data among various platforms.

Oracle Big Data Fundamentals

Increase your Big Data technology portfolio by learning to use a wide range of big data acquisition, processing, integration, and analysis techniques. Learn about Oracle’s engineered systems for Big Data. Analysis options include Oracle Big Data SQL, Oracle Data Mining, Oracle R Enterprise, and Oracle Big Data Discovery.

Oracle Big Data Essentials NEW

This Oracle Big Data Essentials training deep dives into using the Oracle Big Data Solution. Through hands-on, interactive instruction and exercises, you'll develop the skills to acquire, organize, analyze and make key decisions based on the big data.

GoldenGate 12c: Fundamentals for Oracle

Focuses on Oracle-to-Oracle database replication. Expert Oracle University instructors will deep dive into the Oracle GoldenGate architecture, walking you through various product features.

GoldenGate 12c: Advanced Configuration for Oracle

Enrolling in this Oracle GoldenGate 12c training will help you develop your installation and configuration skills. By interacting with top Oracle instructors, you'll be able to ask questions as you learn to solidify your understanding.

GoldenGate 12c Troubleshooting & Tuning

Teaches how to gather & examine evidence; you’ll learn to solve case problems, diagnose their cause and find methods of resolution. Each of these practices challenges you to diagnose and troubleshoot the issue using GoldenGate software

Oracle Enterprise Data Quality: Profile, Audit & Operate

Import and analyse a new set of data. Learn about ODQ's user interface and how to use its profiling tools to delve into data and quickly identify inconsistencies, missing data and other problems. Audit the profiled data and also to export the data.... and more

Oracle Enterprise Data Quality: Match and Parse

Configure match processors to find and optionally merge exact and similar (fuzzy) matching records. Create sophisticated match rule hierarchies, configure merge options and review match results. Deals about the different match processors that are available, including those in the Customer Data Extension Pack... and more

Data Warehouse Database Design

Students are presented with the basic concepts, fundamental issues, & techniques for the design of a data warehouse or data mart.

Oracle BI 11gR1: Create Analyses & Dashboards for End Users

Step-by-step instructions for creating Oracle BI analyses & dashboards in business intelligence applications. Build basic analyses to include in dashboards, with more complexity as the course progresses.

Oracle BI Applications 11g: Implementation using ODI

Implementation Using ODI training provides step-by-step procedures for installing, configuring, managing, and customizing Oracle Business Intelligence Applications and Oracle Business Intelligence Warehouse. It begins by exploring Oracle BI Applications components and architecture.