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

12c: Analytic SQL for Data Warehousing NEW

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

Oracle's strategic enterprise reporting & publishing solution enables you to extract data from multiple data sources, create layouts for report data, & publish the highly formatted reports to a wide range of 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...

Oracle BI 12c: Create Analyses & Dashboards ED 1 NEW

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.

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

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

Oracle Big Data Fundamentals Ed 1

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

Data Integration and ETL with Oracle Warehouse Builder (OWB) NEW

Participants learn to load data by executing the mappings or the process flows, use Oracle Warehouse Builder 11g, Release 2 features to manage metadata changes, debug mappings, backup metadata, manage security, and tune the ETL mappings for better performance. Integration of Warehouse Builder with OBI EE, along with the Warehouse Builder architecture and configuration are discussed.

Data Integration and ETL with Oracle Warehouse Builder: Part 1

This Data Integration and ETL with Oracle Warehouse Builder: Part 1 training teaches you how to load data by executing the mappings or the process flows. Explore the integration of Warehouse Builder with OBI EE, along with the Warehouse Builder architecture and configuration.

BI Discoverer: Analyze Relational & OLAP Data (for End Users)

Learn the querying &analytical capabilities of Oracle BI Discoverer Plus 11g. Learn how to use Disco Plus to query, report & analyze corporate data & to perform ad hoc analysis against relational data sources...

BI Discoverer Administrator 11g: Develop an EUL

Oracle BI Discoverer Administrator is a component used by Discoverer managers (business or data administrators) to create, maintain, and administer data in the End User Layer, and to define how users interact with that data.

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.