IT / Data Warehousing / Oracle / Oracle 19c / Oracle BI Discoverer / Analyzing Relational and OLAP Data

Oracle 19c - Oracle BI Discoverer / Analyzing Relational and OLAP Data

Details

ID 2757914
Classroom 2 days
Webinar 4 days
Method Presentation with examples and hands-on labs.
Prequisite Oracle SQL, PL / SQL
Audience Business Intelligence Developer

Services:

  • Lunch / Catering
  • Assistance for hotel / travel bookings
  • Comelio certificate
  • Flexible: Free cancellation up until 10 days before the training

Summary

Oracle Business Intelligence Discoverer is an intuitive ad-hoc query, reporting, analysis and Web publishing tool set that gives business users immediate access to information in databases. Oracle BI Discoverer enables business users at all levels of the organization to make faster and more informed business decisions. Using any standard Web browser, you have secure and immediate access to data from both relational and multidimensional data sources. The Oracle BI Spreadsheet Add-In enables end users to display and navigate Oracle OLAP data from within Excel. Users can treat the Oracle OLAP data as regular Excel data. Using a wizard-driven interface, users can select data from Oracle OLAP simply by choosing from a list of values or by creating advanced selections, such as those based on exceptions, top/bottom analysis, or hierarchies.

Training Dates

  • 2020-Nov-09 - Nov-12
  • 2021-Jan-18 - Jan-21
  • 2021-Mar-29 - Apr-01
  • 2021-Jun-07 - Jun-10

650 EUR +VAT

Location | Enrollment


Agenda

Simple Reports

Workbook and Worksheets - Queries - Tables and Cross-Tabs - Page Elements (Header and Footer, Title, Formatting Columns, Graphics) - Sorting and Grouping of Results - Aggregations

Diagrams

Types of Diagrams - Reports and Diagrams

Complex Techniques

Conditions and Conditional Formatting - OLAP Operations: Pivoting, Drilling, and Slicing/Dicing - Static and Dynamic Parameters - Calculations - Advanced Analysis

Administration of Reports

Scheduling Manager - Running Reports in Batch Mode - Managing Workbooks, Publishing and Exporting Reports

Trainer

Marco Skulschus (born in Germany in 1978) studied economics in Wuppertal (Germany) and Paris (France) and wrote his master´s thesis about semantic data modeling. He started working as a lecturer and consultant in 2002.

Publications
  • Oracle PL/SQL ISBN 978-3-939701-40-8
  • Oracle SQL ISBN 978-3-939701-41-5
  • Oracle PL/SQL - Objektrelationale Techniken ISBN 978-3-939701-42-2
  • Oracle, PL/SQL und XML ISBN 978-3-939701-49-1
Projects

He works as an IT-consultant and project manager. He developed various Business Intelligence systems for industry clients and the public sector. For several years now, he is responsible for a BI-team in India which is mainly involved in BI and OLAP projects, reporting systems as well as statistical analysis and Data Mining. He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.

Research

He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.