Get in Touch
 Duration 21 hours

Course Outline

Introduction to Power BI and Oracle Integration

  • Overview of Oracle database connectivity
  • Linking Power BI to Oracle and other data sources
  • Best practices for secure and efficient connections

Data Analysis, Cleansing, and Management

  • Profiling and interpreting data structures
  • Techniques for data cleansing and normalization
  • Integrating multiple data sources
  • Practical lab: preparing data for reporting

ETL Process with Power Query and Pivot

  • Concepts of ETL
  • Applying Power Query for data transformation
  • Constructing Pivot models for analysis
  • Practical lab: developing an ETL pipeline

Advanced Data Modeling with DAX and M

  • Overview of DAX (Data Analysis Expressions)
  • Frequently used DAX functions for reporting
  • Utilizing M formulas in Power Query
  • Practical lab: applying DAX and M in real-world scenarios

Report Design and Executive Presentations in Power BI

  • Principles of effective dashboard design
  • Custom visuals and interactive elements
  • Crafting executive-level reports
  • Practical lab: building an executive dashboard

Advisory Support for Corporate Needs

  • Allocated time for assistance on actual projects
  • Guidance on developing custom reports and presentations
  • Aligning dashboards with corporate KPIs

Summary and Next Steps

Requirements

  • Fundamental knowledge of databases and SQL
  • Proficiency with Excel or other reporting tools

Audience

  • Data analysts
  • Business intelligence specialists
  • Reporting professionals
  • Corporate decision support teams

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from 3900 € + VAT*

Contact us for an exact quote and to hear our latest promotions

(*The final price may vary depending on the technical specialization of the course, the level of customization, the method of delivery and the number of learners)

Need help picking the right course?
info@nobleprog.pt or +351 30 050 9666

Testimonials (2)

good explanation on each points and provide assignment for practices.

Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop

Greg was very patient and helpful

Chris Havel - Encyclopaedia Britannica
Course - ORACLE SQL Fundamentals

Provisional Upcoming Courses (Contact Us For More Information)

End-to-End Data Analysis and Reporting with Power BI and Oracle Integration

2026-11-30 09:30
21 hours
Mercure Lisboa Almada

End-to-End Data Analysis and Reporting with Power BI and Oracle Integration

2026-12-14 09:30
21 hours
Melia Ria Aveiro

End-to-End Data Analysis and Reporting with Power BI and Oracle Integration

2026-12-28 09:30
21 hours
Hotel Melia Braga

End-to-End Data Analysis and Reporting with Power BI and Oracle Integration

2027-01-11 09:30
21 hours
Eurostars Cascais Hotel

End-to-End Data Analysis and Reporting with Power BI and Oracle Integration

2027-01-25 09:30
21 hours
Hotel Tivoli Coimbra

Related Courses

Oracle Database 19c Administration

 35 Hours
This instructor-led training in Portugal guides intermediate DBAs through Oracle Database 19c SE2 administration. Participants will master installation, security, backup, and performance tuning. It also covers migration strategies from 11g to 19c using practical tools.
Read more...

Oracle Database 19c SE2 Administration Essentials

 49 Hours
This instructor-led training in Portugal focuses on the installation, configuration, and management of Oracle Database 19c SE2. Participants will acquire practical skills in administration, backup, recovery, and migration, ensuring dependable database management and operational efficiency for real-world enterprise workloads.
Read more...

Oracle Database 19c: Administration

 35 Hours

This live, instructor-led training in Portugal (delivered online or on-site) is designed for system administrators seeking to acquire the skills necessary to administer, monitor, and support Oracle databases.

By the conclusion of this training, participants will be capable of:

  • Comprehending the significant feature and architectural updates in Oracle Database.
  • Managing and overseeing Oracle databases.
  • Optimizing the performance of Oracle databases.
Read more...

Oracle Database 19c - Backup and Recovery

 14 Hours

This instructor-led, live training in Portugal (online or onsite) is designed for beginner-level database administrators who wish to manage backup and recovery tasks in Oracle Database 19c.

Upon completion of this training, participants will be able to:

  • Grasp the fundamental concepts of backup and recovery in Oracle Database 19c, including its architecture and various failure modes.
  • Acquire practical experience in configuring backup and recovery settings, such as the RMAN environment and the fast recovery area.
  • Develop hands-on skills in executing diverse backup and recovery operations, including full, incremental, and point-in-time recovery.
  • Learn to leverage Oracle's Flashback technology for efficient database recovery and to manage disaster recovery scenarios.
  • Implement best practices for backup, recovery, and disaster recovery to ensure data availability and reduce downtime in Oracle Database 19c.
Read more...

Oracle Database 19c - Data Guard Administration

 21 Hours

This instructor-led, live training in Portugal (online or onsite) is aimed at intermediate-level database administrators who wish to manage, optimize, and secure Data Guard environments for robust disaster recovery and high availability.

By the end of this training, participants will be able to:

  • Understand the architecture and benefits of Oracle Data Guard for disaster recovery and high availability.
  • Gain hands-on experience in configuring and managing physical and logical standby databases, including Data Guard broker.
  • Develop practical skills in monitoring, troubleshooting, and optimizing Data Guard environments for optimal performance.
  • Learn advanced features such as Active Data Guard, Data Guard with RAC, and securing Data Guard communications.
  • Apply best practices for disaster recovery planning, ensuring data consistency, and automating Data Guard operations.
Read more...

Oracle Database 19c - Install and Upgrade

 7 Hours

This instructor-led, live training in Portugal (online or onsite) is designed for beginner-level database administrators aiming to equip themselves with the necessary skills to manage and optimise their Oracle environments effectively.

Upon completing this training, participants will be capable of:

  • Grasping the core features and architecture of Oracle Database 19c, encompassing system requirements and installation procedures.
  • Acquiring practical expertise in installing Oracle Database 19c and Oracle Grid Infrastructure, including the configuration of network, storage, and security settings.
  • Mastering the full upgrade process for Oracle Database 19c, ranging from pre-upgrade planning to post-upgrade validation.
  • Developing troubleshooting capabilities to address common challenges encountered during installation and upgrade phases.
  • Applying best practices for Oracle Database installation and upgrades to guarantee a seamless and successful deployment.
Read more...

Oracle Database 19c - Multitenant Architecture

 21 Hours

This instructor-led, live training in Portugal (online or on-site) is aimed at intermediate-level database administrators who wish to effectively manage and optimise a multitenant environment.

By the end of this training, participants will be able to:

  • Understand the key components and benefits of Oracle Database 19c's multitenant architecture, including CDBs and PDBs.
  • Gain practical skills in installing, configuring, and managing container databases (CDBs) and pluggable databases (PDBs).
  • Develop proficiency in implementing security measures, backup and recovery strategies, and performance tuning in a multitenant environment.
  • Learn how to manage high availability and disaster recovery in a multitenant architecture, including configuring Data Guard and Oracle RAC.
  • Acquire troubleshooting techniques and best practices for maintaining a secure, efficient, and reliable multitenant database environment.
Read more...

Oracle Database 19c - RAC, ASM, and Grid Infrastructure Administration

 35 Hours

This instructor-led, live training in Portugal (online or on-site) is designed for intermediate-level database administrators looking to manage and optimise complex, high-availability Oracle database environments.

Upon completion of this training, participants will be able to:

  • Gain a thorough understanding of Oracle RAC architecture and Grid Infrastructure, covering installation, configuration, and management.
  • Develop practical skills in managing Automatic Storage Management (ASM), including disk group management, instance tuning, and backup/recovery procedures.
  • Learn advanced RAC performance tuning techniques, disaster recovery configurations, and best practices for achieving high availability.
  • Acquire troubleshooting and diagnostic skills to resolve issues within RAC and Grid Infrastructure environments.
  • Understand the process of patching and upgrading Oracle RAC and Grid Infrastructure while minimising downtime and maintaining system stability.
Read more...

Oracle SQL for Administrators

 21 Hours

This instructor-led, live training in Portugal (online or onsite) is tailored for beginner-level database administrators and developers who want to master SQL for efficiently managing, querying, and manipulating data in Oracle databases for administrative and operational tasks.

Upon completing this training, participants will be able to:

  • Grasp Oracle database architecture, including schemas, users, and sessions.
  • Write and optimize SQL queries for data retrieval, filtering, and manipulation.
  • Utilize joins, subqueries, and set operators to work with multiple tables and complex queries.
  • Perform data aggregation, grouping, and analysis using SQL functions.
  • Manage schema objects such as views, sequences, and indexes to enhance database operations. 
Read more...

Oracle SQL for Developers

 35 Hours

This instructor-led, live training in Portugal (online or onsite) is tailored for intermediate-level developers and database administrators who aim to leverage Oracle SQL to design, manage, and optimize database applications while automating tasks efficiently.

Upon completion of this training, participants will be able to:

  • Grasp Oracle database architecture and manage users, schemas, and permissions.
  • Write optimized SQL queries for data retrieval, manipulation, and analysis.
  • Employ advanced SQL techniques, including joins, subqueries, and hierarchical queries.
  • Design and manage database objects such as tables, indexes, views, and sequences.
Read more...

Oracle Database 19c: Data Warehousing Concepts

 14 Hours
This live, instructor-led training in Portugal guides entry-level data professionals through the data warehousing concepts of Oracle Database 19c. Participants will acquire knowledge of core architecture, data modeling, and fundamental ETL practices to establish a robust analytical foundation for business intelligence.
Read more...

Oracle Database 19c: Data Warehousing Techniques

 21 Hours
This instructor-led training in Portugal covers data warehousing techniques in Oracle Database 19c, including schema design, ETL optimisation, and performance tuning. Participants will acquire hands-on skills to build efficient, scalable analytics solutions for business intelligence and reporting.
Read more...

Oracle Database 19c: SQL Tuning Workshop

 21 Hours
Participate in this instructor-led SQL tuning workshop in Portugal to master performance optimization for Oracle Database 19c. Participants will develop the ability to interpret execution plans, deploy tuning tools like AWR and ADDM, and employ indexing strategies to effectively resolve inefficient queries in practical scenarios.
Read more...

Oracle SQL for beginners

 21 Hours
This Oracle SQL introductory training in Portugal assists in developing fundamental database skills from the basics. Acquire the ability to write queries, manage data, and comprehend relational structures. Ideal for beginners seeking a robust foundation in SQL fundamentals.
Read more...

ORACLE SQL Fundamentals

 14 Hours
This two-day workshop in Portugal provides a foundational introduction to SQL for Oracle and other databases. It explores relational concepts, data retrieval, functions, joins, and advanced queries through practical exercises, empowering participants to develop core database competencies using sample data and free tools.
Read more...

Related Categories

Oracle
Oracle
Power BI
Power BI