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

Power BI Training in Dubai

About Excel Prodigy

Power BI Training in Dubai for Corporate Teams

Turn static spreadsheets into interactive, real-time dashboards. Corporate Power BI training for finance, sales and operations teams across Dubai — built on your own business data.
Request a Regional Training Proposal
See the Difference

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 Curriculum

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)
Duration: 16 hours across 2 days | Batch size: 8–15 participants

Where We Train Across Dubai

On-site Power BI training for the districts where Dubai’s finance, data and analytics teams work.

DIFC & Downtown

Business Bay

Dubai Internet City & Barsha Heights

Abvanced Excel Training

Who Should Attend

BI analysts and reporting executives moving beyond Excel

Finance managers building rolling P&L, cash flow and budget dashboards

Sales operations teams tracking pipeline, targets and conversion

Marketing analytics teams reporting on campaign performance

IT & reporting teams responsible for company-wide dashboard standards

How can we help you?

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

Why Corporates Choose Us

  • Dashboards built around your company’s actual KPIs, not sample datasets
  • On-site delivery at your Dubai office — no travel disruption for your team
  • Trainers with hands-on corporate BI implementation experience
  • Post-training support while your team builds its first live dashboards

Industries We Serve

Finance & Banking

Retail & FMCG

Real Estate & Construction

Logistics & Supply Chain

Healthcare

Government & Public Sector

Your questions answered

Frequently asked questions

A working knowledge of Excel (formulas, PivotTables) is recommended. No prior Power BI experience is required.
Power BI Desktop (free to install); a Power BI Service licence is only needed later, for publishing dashboards company-wide.
Yes, where data-sharing policies allow, we build exercises around your actual sales, finance or operations data.

The core programme runs 16 hours over 2 days; advanced modules can be added for teams that need them.

Yes, on-site delivery is our standard model, including free zones such as DIFC, DMCC and JLT.