You're now visiting the official Saudi
website of GLOMACS International

Power BI: Intermediate Data Analysis Techniques

An Interactive 5-Day Training Course

Power BI: Intermediate Data Analysis Techniques

NASBA
Online Schedule
Date Venue Fees
13 - 17 Apr 2026 Online $ 3,950
10 - 14 Aug 2026 Online $ 3,950

Introduction

This Intermediate Data Analysis Using Power BI training course takes participants beyond the basics. With laptops at hand, participants will develop skills in data modeling, DAX, and advanced data transformations. Each day will include practical, hands-on exercises in Power BI, with a final day dedicated to a preview of advanced techniques, ensuring a seamless progression to the next level.

This GLOMACS training course will highlight:

  • Data modeling fundamentals for Power BI
  • DAX (Data Analysis Expressions) for calculations
  • Advanced data transformation techniques
  • Improved reporting and visualization strategies
  • Skills to optimize data handling for analysis

Objectives

At the end of this Power BI: Intermediate Data Analysis Techniques training course, you will learn to:

  • Build data models effectively
  • Apply DAX functions for deeper analysis
  • Transform data using Power Query
  • Design intermediate-level reports and dashboards
  • Prepare for advanced analytics in Power BI

Training Methodology

The Power BI: Intermediate Data Analysis Techniques training course includes a mix of hands-on practice, case studies, and practical exercises to deepen understanding of Power BI’s intermediate functionalities.

Organisational Impact

The organization will benefit by:

  • Improved reporting and analytical capabilities
  • Enhanced decision-making through dynamic reports
  • Optimized data management processes
  • Strengthening team members' analytical skills
  • More efficient use of data resources
  • Foundation for advanced Power BI skills

Personal Impact

At the end of this Power BI: Intermediate Data Analysis Techniques training course, participants will gain:

  • Confidence in data modeling techniques
  • Proficiency with DAX for analytical needs
  • Skills in intermediate report design
  • Advanced data transformation abilities
  • Insight into efficiency practices
  • Motivation for advanced Power BI training

Who should Attend?

This GLOMACS training course is ideal for professionals with basic Power BI skills who want to enhance their data analysis abilities:

  • Data Analysts
  • Business Data Users
  • Financial Analysts
  • Operations Team Members
  • Professionals working with data insights
Course Outline
Day 1

Deep Dive into Data Modeling

  • Advanced data relationships
  • Normalization and star schema
  • Practical data model building

End-of-Day Exercise: Build a star schema model with imported tables

Day 2

Introduction to DAX for Data Analysis

  • DAX fundamentals
  • Calculated columns and measures
  • Common DAX functions

End-of-Day Exercise: Use DAX to create calculated fields and measures

Day 3

Advanced Data Transformation

  • Data cleaning with Power Query
  • Merging and appending data
  • Creating custom columns

End-of-Day Exercise: Clean and merge a multi-source dataset

Day 4

Building Interactive Reports

  • Intermediate visualization techniques
  • Using bookmarks and buttons
  • Multi-layered reports

End-of-Day Exercise: Build an interactive report with drillthrough pages and bookmarks

Day 5

Preparing for Advanced Analytics with a Sneak Peek

  • Advanced DAX functions introduction
  • Complex data modeling techniques
  • Sneak peek into advanced Power BI: Custom visuals and managing large datasets

End-of-Day Exercise: Apply advanced DAX in a report and experiment with R/Python integration

Certificates
  • On successful completion of this training course, GLOMACS Certificate will be awarded to the delegates.
  • Continuing Professional Education credits (CPE): In accordance with the standards of the National Registry of CPE Sponsors, one CPE credit is granted per 50 minutes of attendance.
Providers

Endorsed Education Provider

NASBA
Options & Brochure
Related Courses
Frequently Asked Question

No. Saudi GLOMACS delivers courses in Saudi Arabia and internationally, including delivery across Europe and Asia. This allows organisations and professionals to access training both locally and abroad.

No. While governance and leadership are part of the portfolio, Saudi GLOMACS delivers training across the entire business and professional lifecycle, including administrative, technical, legal, regulatory, and sector-specific training.

Yes. Saudi GLOMACS designs and delivers bespoke in-house training tailored to organisational objectives, sector requirements, and workforce needs. Training can be delivered in Saudi Arabia or internationally, depending on requirements.

Courses delivered in Saudi Arabia are adapted to reflect local regulatory frameworks, organisational structures, sector conditions, and professional expectations. This ensures training is relevant, practical, and aligned with Saudi workplace realities.

GLOMACS has been delivering professional training for over thirty years, with courses delivered across Europe, the Middle East, Asia, and other international markets.

Saudi GLOMACS combines three decades of global training experience with a clear focus on Saudi market relevance. This allows it to deliver training that is both internationally credible and locally applicable, across a broader range of disciplines than niche or single-focus providers.

Saudi GLOMACS is a Saudi-based professional training provider delivering courses tailored to the Saudi market and applicable internationally. It operates within the global GLOMACS framework and draws on more than three decades of international training experience.

Saudi GLOMACS offers professional training across a wide range of disciplines, including administration, leadership and management, governance and regulation, law, oil and gas, energy, engineering, finance, digital technologies, and sector-specific specialisations.

Training supports professionals across all career stages, from operational roles to specialist and senior responsibilities.

Participants include professionals from public sector, semi-government, and private sector organisations, across a wide range of roles and industries. Attendees range from administrative and operational professionals to technical specialists, managers, and senior decision-makers.

Related Categories