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

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.

11g: Data Warehousing Fundamentals

Learn the basic concepts of a data warehouse and study the issues involved in planning, designing, building, populating, and maintaining a successful data warehouse. Learn to improve performance or manageability in a data warehouse using various Oracle Database features.

11g: 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.

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

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...

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.

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 BI 11gR1: Create Analyses & Dashboards

Step-by-step instructions for creating analyses and dashboards, which compose business intelligence apps. Administer the Oracle BI (OBIEE) Presentation Catalog and to build a simple OBIEE dashboard

Oracle BI 11gR1: Build Repositories

Provides step-by-step procedures for building and verifying the three layers of an Oracle BI (OBIEE) repository.

Introduction to Big Data

This Introduction to Big Data training introduces you to Big Data and Oracle's Big Data solution. Expert Oracle University instructors will help you explore Oracle Big Data Appliance and Oracle Big Data Connectors.

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

Oracle Database 11g: Data Mining Techniques NEW

In this course, students review the basic concepts of data mining and learn how to leverage the predictive analytical power of the Oracle Database Data Mining option by using Oracle Data Miner 11g Release 2.

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.