Technical Training

As part of an all-inclusive Deploying Analytics (Big Data, Business Intelligence, Knowledge Management) or Technical Training Certificate , candidates learn how to harness Oracle to meet specific business needs/objectives and find innovative ways to reach new customers, maximize efficiency/effectiveness, and drive profitable growth.

The 5 hands-on classes described below prepare candidates applying Oracle’s distinctive functional modules to the most widely used database, data management, and business analytics initiatives:

This course provides step-by-step procedures for building and verifying the three layers of an Oracle BI repository. Candidates begin by using the Oracle BI Administration Tool to construct a simple repository to address a fictitious company's business requirements. 

Candidates 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, candidates learn how to build physical and logical joins, simple measures, and calculation measures. Candidates also learn how to validate their work by creating and running analyses, and verifying query results using the query log.

Candidates 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, set up a multi-user development environment, and use Administration Tool wizards and utilities to manage, maintain, and enhance repositories.

Finally, candidates are exposed to more advanced topics, such as implicit fact columns, bridge tables, usage tracking, multilingual environments, write back, and patch merge.

Topics include:

• Use the Oracle BI Administration Tool to build, manage, and maintain an Oracle BI repository
  
• Build a dimensional business model to address business intelligence requirements
  
• Build and execute analyses to test and verify a dimensional business model analyses
  
• Use the Oracle BI Administration Tool to administer Oracle BI Server
  

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, gauges, maps, prompts, embedded content, navigation links, and KPIs on the dashboards. Participants also use Oracle BI Delivers to send real-time, personalized alerts to dashboards and for subscribed users, and are introduced to the use of Oracle Business Intelligence Mobile in accessing BI content on their mobile devices. Participants are introduced to the use of Oracle BI for Microsoft Office to integrate Oracle BI data and views in Microsoft Office presentations and spreadsheets. Participants create KPIs and add KPIs to a dashboard. Finally, they explore the use of Oracle BI Briefing Books.

Topics include:

• Build analyses and dashboards
  
• Build and use views and graphs in analyses
  
• Create and work with KPIs
  
• Create and modify Oracle BI Dashboards
  
• Use Oracle Business Intelligence Mobile to access BI content
  
• Use BI content in Microsoft Office applications
  
• Configure, schedule, and deliver personalized alerts using Oracle BI Delivers

Course Objectives:

• Create and modify Oracle Business Intelligence analyses
  
• Use hierarchical columns in analyses and views
  
• Perform administration tasks related to the development and configuration of dashboards
  
• Build and use views and graphs in analyses
  
• Combine analysis criteria using set operations and execute direct database requests
  
• Perform pre- and post-aggregate filtering using filters, groups, and selections
  
• Add geographical mapping to analyses
  
• Use Oracle Business Intelligence Mobile to view BI content on a mobile device
  
• Create and modify dashboards
  
• Use Oracle BI for Microsoft Office to integrate Oracle BI analysis and dashboard content
  
• Configure Agents using Delivers to get the results of analyses and deliver them to subscribers
  

This Oracle BI: Introduction to End User Tools Course teaches candidates the fundamentals of how to use and take advantage of Oracle Business Intelligence (BI) Enterprise Edition end user tools. This comprehensive and integrated suite of analytic tools is designed to bring greater business visibility and insight, allowing you to have Web-based, self-service access to up-to-the-moment, relevant and actionable intelligence.

By taking this course, candidates will learn how to build simple analyses, integrate analyses into dashboards, build KPIs, build scorecards and deliver content and alerts to other users. Additionally, candidates will learn how to build a BI Publisher report and use MS Office to manipulate the BI analyses. This course is intended for members of a non-technical audience who want to develop a basic understanding of these components, but who are not necessarily part of an implementation team.

Topics include:

• Create analyses to interrogate your data.
  
• Build a dashboard and add objects to the dashboard.
  
• Create a report.
  
• Automate content delivery by using alerts.
  
• Create KPIs and measure results by using those KPIs.
  
• Create a Scorecard.
  

Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements from high-volume, high-performance batch loads, to event-driven integration processes and SOA-enabled data services. Oracle Data Integrator's Extract, Load, Transform (E-LT) architecture leverages disparate RDBMS engines to process and transform the data - the approach that optimizes performance, scalability and lowers overall solution costs.

Topics include:

• Use Oracle Data Integrator to perform transformation of data among various platforms.
  
• Design ODI Mappings, Procedures, and Packages to perform ELT data transformations.
  
• Administer ODI resources and set up security with ODI.
  
• Perform data integration and transformation among various platforms.
  
• Use the ODI graphical interface to define procedures, packages, and ELT jobs.
  
• Set up and maintain a secure, multi-user ODI environment.
  
• Implement Changed Data Capture with ODI.
  
• Use ODI Web services and perform integration of ODI with SOA.
  

Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements from high-volume, high-performance batch loads, to event-driven integration processes and SOA-enabled data services. Oracle Data Integrator's Extract, Load, Transform (E-LT) architecture leverages disparate RDBMS engines to process and transform the data - the approach that optimizes performance, scalability and lowers overall solution costs.

Topics include:

• Improve performance and reduce integration costs across the organization's heterogeneous systems. Centralize data across databases using your new skills to perform data integration, design ODI Mappings, and set up ODI security.
  
• Implement High-Performance Movement and Transformation
  
• How to use Oracle Data Integrator (ODI) 12c to implement high-performance movement and the transformation of data among various platforms.
  
• ODI Graphical User Interface
  
• Use of ODI graphical user interfaces that enable users to access different ODI components and resources that form ODI infrastructure.
  
• ODI Repositories
  
• Using the graphical interfaces, candidates create and manage ODI repositories, which store configuration information about the IT infrastructure, the metadata for all applications, projects, models and other ODI artifacts.
  
• ODI Topology, Models, Mappings, and other objects.
  
• How to create the ODI Topology, organize ODI models and design ODI Mappings, procedures, packages and other objects.