Training Center

Our trainers have in-depth knowledge of the tools we implement on a daily basis at our customers. Therefor we have ‘field-experience’ and can bring the quality of the courses to a higher level, referring to real customer cases

Oracle BI: Analysis and Dashboards

Course description:

This course provides step-by-step instructions for creating analyses and dashboards, which compose business intelligence applications.
Participants learn how to administer the Oracle BI Presentation Catalog and to build a simple Oracle BI dashboard starting with basic analyses, then adding more complexity as the course progresses. Participants learn to include pivot tables, graphs, prompts, embedded content and navigation links on the dashboards.

Duration:

2 days

Langauge:

English, Dutch

Format:

Instructor-led

Location:

i4BI Trainingcenter (Kontich)

Audience:

End userswho should be able to create ad-hoc analyses

Knowledge required:

Basic analytical capabilities

Topics:

*Introduction to Oracle Business Intelligence Enterprise Edition
– Introduction to Oracle BI
– Architecture overview

*Working with Oracle Business Intelligence Analyses
– Introduction to Oracle BI Analysis Editor
– Oracle BI column types
– Working with analyses in Oracle BI
– Using advanced formatting

*Limiting and Grouping Data in Analyses
– Introduction to filters and selections
– Creating, editing, and grouping filters
– Adding prompts to analyses
– Dynamic filtering
– Using saved analyses as filters
– Creating groups
– Creating calculated items

*Working with Views and Graphs in Analyses
– Introduction to views, graphs, and editors
– Working with views in Compound Layouts
– Creating and editing graphs
– Linking master-detail views
– Performing common view tasks

*Showing Results With Pivot Tables
– Introduction to pivot tables
– Creating, arranging, and formatting a pivot table
– Using hierarchical columns
– Sorting in pivot tables
– Setting aggregation and using totals
– Building calculations and displaying running sums

*Creating Oracle Business Intelligence Dashboards
– Introduction to dashboards and dashboard pages
– Creating and editing dashboards
– Using the Dashboard Builder
– Exploring dashboard object properties and options
– Publishing dashboard pages
– Creating personal customizations and using other page options

*Configuring Oracle Business Intelligence Dashboards
– Types of dashboard content
– Embedding content in dashboards

*Creating Dashboard Prompts and Variables
– Overview of variables
– Introduction to dashboard prompts and prompt types
– Adding a named dashboard prompt to a dashboard
– Creating additional prompt page and setting page preferences
– Variables and prompts
– Adding variable prompts to a dashboard
– Wiring dashboard prompts

Subscription:

*For a customized quote/training, please contact i4BI

Oracle BI: Server Architect

Course description:

This course provides step-by-step procedures for building and verifying the three layers of an Oracle BI repository.

Students begin by using the Oracle BI Administration Tool to construct a simple repository to address a fictitious company’s business requirements. Students import schemas, design and build logical business models, and expose business models to users in the Oracle BI user interface. In the process of constructing the repository, students learn how to build physical and logical joins, simple measures, and calculation measures. Students also learn how to validate their work by creating and running analyses, and verifying query results using the query log.

Students then extend the initial repository and learn how to model more complex business requirements, such as logical dimension hierarchies, multiple logical table sources, aggregate tables, partitions, and time series data. Students also learn how to implement Oracle BI Server security, manage Oracle BI Server cache, and use Administration Tool wizards and utilities to manage, maintain, and enhance repositories. Finally, students are exposed to more advanced topics, such as implicit fact columns, usage tracking, multilingual and write back.

Duration:

– 3 days training
– 4 days training (including installation of the Oracle BI Software)

Language:

English, Dutch

Format:

Instructor-led

Location:

Trainingcenter Kontich

Audience:

BI Developers who will develop and administer the Oracle BI solution

Knowledge Required:

Basics of dimensional modelling, Basics of SQL, basics technical IT

Topics:

*Introduction
– Overview of the Oracle BI 11g Foundation Suite
– OBI EE Architecture

*Oracle BI software & BI methodology
– Installation (4 days training)
– Oracle BI User Interface
– Introduction to Dimensional Modelling

*Oracle BI Repository
– Exploration and basic setup of a repository
– Testing and deploying repository
– Complex repository modelling (= Derived metrics)
– Using multiple sources
– Hierarchies and level based measures
– Advanced repository modelling (= partitioning & time comparison measures)
– Using variables

*Oracle BIServer setup and methodology
– OBI Implementation methodology
– OBI Security
– Cache management and performance tuning

Subscription:

*Plannend Courses: Oak3 Trainingcenter
*For a customized quote/training, please contac i4BI

Oracle BI Publisher: Fundamentals

Course Description:

This course provides step-by-step instructions for creating data models and reports with BI Publisher.

Participants learn how to create layouts for reports and publish the highly formatted reports to a wide range of destinations. Both online editor as Microsoft Word editor will be subject in this training. Participants learn to schedule and manage scheduled jobs, along with bursting reports to other destinations.

Duration:

2 days

Langauge:

English, Dutch

Format:

Instructor-led

Location:

i4BI Training center (Kontich)

Audience:

Key-users with a basic analytical capacities who should be able to create pixel-fine reporting

Knowledge Required:

Basic analytical and query capabilities

Topics:

*Introduction to Oracle BI Publisher
– Overview of BI Publisher architecture, including Oracle BI EE
– Overview Report Components

*Creating data models & reports
– Data models on different sources
– Report creation with online editor
– Report creation with template builder for Word
– Advanced report features like translations, formulas, etc.

*Report output
– Integration between BIP and Oracle BI EE
– Overview of the BI Publisher scheduler
– Viewing and managing Report Jobs & History

Subscription:

* Planned Courses: Oak3 Trainingcenter
* For a customized quote/training, please contact i4BI

Oracle Data Integrator: Fundamentals

Course descpritpion:

This course provides step-by-step instructions for building ODI interfaces, procedures, and packages to perform data movement and transformations.
Additionally training participants learn how to handle advanced data transformations, change data capture and data quality requirements.

Duration:

4 days

Langauge:

English, Dutch

Format:

Instructor-led

Location:

Oak 3 Trainingcenter or onsite.

Audience:

Database administrators, Data warehouse administrators and ETL Developers who are responsible for creating a data integration platform that covers all data integration requirements.

Knowledge required:

– SQL and PL/SQL capabilities
– Database administrator capabilities
– Basic knowledge of data warehouse and ETL concepts

Topics:

° Introduction to Oracle Data Integration
– Overview of ODI Architecture
– Overview of ODI Components

° Basic ODI topics
– Building a simple interface
– Creating Master and Work Repository
– Creating and Managing Topology
– Creating Agents
– Creating Models
– Project and Folders
– Customizing Knowledge Modules
– Variables, Functions, Procedures and Packages
– Workflows and Scenarios

°Advanced ODI topics
– Advanced Interfaces
– Change Data Capture with ODI
– Version, Solution and Migration
– Data Quality and Profiling

Subscription:

*Planned courses: Oak3 Trainingscenter
*For a customized quote/training, please contact i4BI