Facebook X-twitter Linkedin Instagram
Menu Close
Close
Get in Touch

Power BI Training in Middle East

About Excel Prodigy

Power BI Training Across the Middle East for Corporate Teams

One training partner for every GCC office. Consistent, instructor-led Power BI programmes delivered on-site or via live virtual classroom — for teams across the UAE, Saudi Arabia, Qatar, Oman, Bahrain and Kuwait.
Request a Regional Training Proposal
See Countries We Cover

0+

Years training corporate & government teams

0+

Corporate Training Programs Delivered

0+

Professionals certified

0%

Participant satisfaction rate
Clients We Serve

Delivering excellence worldwide

6
BBi
centurion
lime concepts
shipstar
STS
wefreight
yokogawa
Sealead
volta shipping
yamaha
wabco
medtronic
vestas
unicharm
tata-sky
sterling
pwc
pfizer
olam
murugappa
mothercare
34
33
32
31
30
29
28
26
25
23
22
20
18
17
16
15
14
13
7
6
Course Outline

Power Bi Training

Introduction
  • Introduction to Self-Service BI
  • Standard Business Intelligence Process
  • Introduction Power BI Desktop & Workflow
  • Power BI Architecture & Power BI Services
  • Excel Vs Power BI Desktop & Advantage
  • Power BI Components: Power Pivot, Power Query, Power Map, Power View, Q&A
  • Report Canvas, Visualizations, Filters & Fields Pane
  • Power BI User Interface: Report View, Data (Tables) View, Relationship (Model) View
  • Connect and Load data from CSV, Excel & Web

Part 1

  • Exploring Report View & Understanding Chart Elements
  • Adding Chart to the Canvass
  • Inserting basic Charts/Visuals and Creating Simple Report
  • Cluster Column Chart, Cluster Bar Char, TreeMap
  • Line Chart, Pie Chart, Donut Chart, Funnel Chart, CARD Visual
  • Table Vs Matrix
  • Essential Formatting: Text Size, Legends, Values, Title
  • Inserting Text Box, Shapes & Images
  • Slicers: Vertical List Vs. Horizontal Tiles
  • Tooltip - On hover Text
  • Sort Visuals by Values/Fields
  • Focus Mode, Explore & Export Data

Part 1

  • Exploring Power Query Editor
  • Importing Data
  • Preparing/Transforming Data for Power BI Dashboard
  • Promoting First Row as Headers
  • Renaming the Table and Column Names
  • Remove Unwanted and Empty Columns
  • Remove Top Rows, Blank Rows, Errors, Duplicate Rows
  • Split Column by Delimiter, Characters, Positions
  • Choosing the right Data Types - Whole Number, Date, Text
  • Replacing Values and Column Formatting: Clean, Trim, Change Case
  • Fill Blank Data with Above or Below Text
  • Filtering Data, Removing, Reordering and Merging Columns
  • Applied Steps - Its Usage & Revert Options
  • Overview of M-Query Language

Power Pivot

  • Introduction to Data Model
  • Data Tables (FACT Tables) Vs Lookup Tables (Dimension Tables)
  • Active & Inactive Relationship
  • "Snowflake" Schemas Vs Star Schemas
  • Understanding Relationship Cardinality
  • One to Many, One to One, Many to Many

Part 2

  • Creating Custom Column from Examples (Excel Flash Fill)
  • Working with Conditional Columns
  • Transpose Data (Rows to Columns)
  • Unpivot Columns to convert unstructured data set to columnar table
  • Grouping & Binning
  • Merge Queries Vs Append Queries
  • Merge Queries - Joins
  • Left Outer, Right Outer, Inner Join, Full Outer Join, Left Anti, Right Anti
  • Append Queries
  • From Different Sheets, From Csv Files, From Excel Files, From Folder
  • Creating Dimension Table using M-Query Language
  • Enable Data load, Enable Data Refresh, Close and Apply

Part 1

  • What is DAX?
  • Creating Simple Calculated Column & Calculated Measure
  • Implicit Measure Vs Explicit Measure
  • Calculated Columns Vs DAX Measure
  • DAX - Calculated Columns
  • RELATED, FORMAT, DATEVALUE, DAY, MONTH, YEAR
  • DAX - Calculated Measures
  • SUM, COUNT, MAX, MIN
  • COUNTROWS, DIVIDE
  • DISTINCT COUNT
  • DAX - Calculated Tables
  • CALENDARAUTO, CALENDAR, DATE

Part 2

  • Working with Multi-row Card
  • Visualizing Data with Multiple Fields
  • Stacked Bar, 100% Stacked Column
  • Area Chart, Stacked Area, Combo Chart
  • Line & Cluster Column
  • Line & Stacked Column
  • Secondary Axis Chart
  • Scatter (Bubble) Chart
  • Visualizing Time Series Data
  • Multi-Line Chart, Ribbon Chart, Waterfall Chart
  • Visualizing Geospatial Data with Maps, Point Map, Fill Map
  • Showing Key metrics with Cards, KPI Visuals & Gauge Chart
  • Applying Condition Formatting, Data Color, Color Scale, Rules, By Field Values
  • Table Formatting, Background & Font Color, Data Bar, Icon Set
  • Working with different Level of Filters, Report Level, Page Level, Visual Level, Top N
  • Analytics Tab, Adding Target Line, Average, Median & Percentile Line
  • Q&A - Ask Question (Natural Language), Hierarchies, Timeline Slicer

Part 2

  • Creating Table for Measure (Measure Table)
  • DAX - ADVANCED
  • SUMX, COUNTX, AVERAGEX
  • CALCULATE, IF ELSE IF, SWITCH, AND, OR, NOT, FILTER
  • ALL, HASONEVALUE, SAMEPERIODLASTYEAR
  • PARALLELPERIOD, DATEADD, DATEDIFF
  • Understanding "xVelocity in-memory Analytical Engine" - Vertipaq
  • Different Modes of Connection
  • Live Connection, Imported (Cashed)
  • DirectQuery, Get Data from, Csv, Excel
  • Access, SQL Server, Web, ERP, CRM, Cloud Services
  • Update & Refreshing Dataset
  • Changing Data Source

Part 3

  • Configuring Data for Q&A
  • Adding Trendline & Forecasting
  • Editing Power BI Report Interaction
  • Adding and Updating Bookmarks
  • Inserting Buttons
  • Using Selection Panes to Control Visibility
  • Synchronize Slicer Across Pages
  • Displaying Report Page in Tooltips
  • Importing Custom Visual from Marketplace
  • Using Custom Visuals
  • Creating Customized Color Themes and Templates
  • Mobile Layout & Desktop Layout
  • Publish Report from Power Desktop
  • Understanding Dashboards, Tiles, Reports, Datasets, workbooks
  • Creating Dashboard
  • Pinning Tiles to Dashboard
  • Sharing Reports & Dashboards
  • Publish Reports to Web
  • Print or Save as PDF
  • Exporting to Powerpoint
  • Refreshing Data Sets
  • Workspace and Apps (Power BI Pro)
  • Row Level Security (Power BI Pro)

Countries We Cover

United Arab Emirates

Saudi Arabia

Qatar

Oman

Bahrain

Kuwait

How can we help you?

Drop Email For Corporate Training Across International or Call
Contact Us
Call Us

Why One Regional Partner

  • One curriculum and one quality standard, delivered consistently across every GCC office
  • Flexible on-site or live-virtual delivery for teams that can’t all be in one room
  • Trainers experienced across UAE, Saudi Arabia, Qatar and wider GCC markets
  • Volume and multi-location pricing for regional training rollouts

Industries We Serve

Oil & Gas

Banking & Finance

Retail & FMCG

Logistics & Supply Chain

Healthcare

Government & Public Sector

Your questions answered

Frequently asked questions

Yes. We deliver on-site and live virtual Power BI training across Saudi Arabia, Qatar, Oman, Bahrain and Kuwait, in addition to the UAE.
Yes, live virtual sessions are scheduled to overlap working hours across the GCC, with recordings shared where needed.
Both use the same curriculum and trainer-led format; on-site suits single-location teams, live virtual suits multi-country teams.
Yes — a coordinated multi-country rollout managed through a single point of contact at your regional HQ.
Yes, regional bookings qualify for volume-based pricing — share your office count and headcount for a consolidated proposal.