My main activities
are 🧬

This course focuses on installing and using the main functionalities of
Oracle Data Integrator 12c.

This course is focused on creating the OBI 12c repository (modeling source data so that the tool can generate reports).

This course focuses on creating reports (analysis) and dashboards in Oracle Analytics Server.

This course focuses on using Pentaho’s ETL component: Pentaho Data Integration.

This course focuses on the use of Pentaho components to perform data transformation processes, data source modeling, and data visualization using classic reports, on-demand reports, and dashboards.

Data Visualization Fundamentals.

• Analytics and Visualization.
• Types of Analytics: Reporting, Self-Consumption
• Analysis, Information Discovery.
• Data Models for Analytics Tools.

General concepts

• Power BI objects.
• Measures and dimensions.

This course focuses on the analysis part of the Tableau tool.
It provides the knowledge necessary to use data access and analysis tools.

This course focuses on the basic analysis part of the QlikView tool.
It provides the basis for understanding the philosophy of the associative model proposed by QlikView and the objects that allow access to data and visualization in different formats.

This course covers advanced SQL methods with both database functions (views and indexes) and specific syntax (analytics, advanced grouping, hierarchical tables, etc.).
The course uses the Oracle Database relational database.

Course Description

The course is oriented to the creation of queries in SQL language in an Oracle environment (19c).