Corporate training in the Gulf, London, Europe & Asia since 2015
Enquire now
AF-035

Power BI: Data Visualization and Dashboards

Intensive 5-day course · English, Arabic & European languages

Data analysts, business professionals and finance staff will learn to build interactive dashboards and automate reporting on this five-day Power BI course. Using Power Query and Power BI Desktop, delegates transform data from external sources into visual reports. The course also covers DAX measures, data models and relationships between tables.

Classroom

Public courses in our cities

  • 19–23 Oct 2026Manama£3,080 + VAT
  • 2–6 Nov 2026Dubai£4,200 + VAT
  • 16–20 Nov 2026Kuala Lumpur£1,800 + VAT
  • 7–11 Dec 2026Kuala Lumpur£1,800 + VAT
  • 21–25 Dec 2026Riyadh£4,200 + VAT
  • 11–15 Jan 2027Barcelona£3,080 + VAT
Show 23 more dates
  • 25–29 Jan 2027Cairo£2,280 + VAT
  • 8–12 Feb 2027Frankfurt£2,600 + VAT
  • 22–26 Feb 2027Jeddah£4,200 + VAT
  • 1–5 Mar 2027Rome£3,400 + VAT
  • 15–19 Mar 2027Singapore£4,200 + VAT
  • 5–9 Apr 2027Muscat£3,080 + VAT
  • 19–23 Apr 2027Kuala Lumpur£1,800 + VAT
  • 3–7 May 2027Kuala Lumpur£1,800 + VAT
  • 17–21 May 2027Casablanca£2,280 + VAT
  • 14–18 Jun 2027Barcelona£3,080 + VAT
  • 28 Jun – 2 Jul 2027Manama£3,080 + VAT
  • 12–16 Jul 2027Frankfurt£2,600 + VAT
  • 26–30 Jul 2027Amman£3,400 + VAT
  • 2–6 Aug 2027Rome£3,400 + VAT
  • 16–20 Aug 2027Madrid£3,400 + VAT
  • 6–10 Sep 2027Berlin£3,400 + VAT
  • 20–24 Sep 2027Kuala Lumpur£1,800 + VAT
  • 4–8 Oct 2027Kuala Lumpur£1,800 + VAT
  • 18–22 Oct 2027Milan£3,400 + VAT
  • 8–12 Nov 2027Barcelona£3,080 + VAT
  • 22–26 Nov 2027Malaga£3,080 + VAT
  • 13–17 Dec 2027Frankfurt£2,600 + VAT
  • 27–31 Dec 2027Sarajevo£3,400 + VAT

Group discount: 2 delegates 20% · 3 delegates 35% · 5 or more delegates 50%

Can't make these dates? We can run this course for your team on dates that suit you. Ask for custom dates · In-house options

Online (live)

With a trainer, on dates to suit your team

This course can be taught live online by a trainer, in English, Arabic or any European language, for one person or a whole team.

£1,850 + VAT

Group discount: 2 delegates 20% · 3 delegates 35% · 5 or more delegates 50%

Special requests

Tailor this course

Pick what you want changed and we’ll come back with a proposal and price.

Special request

What would you like to change? (pick any)
or

Course overview

Organisations hold data in a wide variety of formats. Spreadsheets, CSV files, web sources and shared folders each present their own preparation problems. Converting these into clear, consistent dashboards is a task that eats time when done manually, and the results are often out of date before they reach anyone who needs them.

This course teaches delegates to connect to external data sources and automate preparation using Power Query. Sessions cover filtering, sorting, pivoting and adding conditional columns. Work then moves into Power BI Desktop, where delegates build report views and apply a full range of visual types, from basic charts to matrix visuals, slicers, timelines, cards, maps, tooltips, drill-through functions and bookmarks.

The course is delivered as a live online programme with instructor interaction, slides, collaborative exercises and assessed activities. From module four, delegates work on data models, establishing relationships between tables and managing explicit and implicit measures. The course closes with DAX formulas, including CALCULATE, RELATED and iterative functions such as SUMX, COUNTX and AVERAGEX.

Course objectives

By the end of the course, delegates will be able to:

  1. Explain the capabilities and features of Power BI
  2. Use Power Query to extract, transform and edit data from multiple file types
  3. Build dynamic dashboards and data visuals in Power BI Desktop
  4. Establish relationships between tables to create well-structured data models
  5. Automate data reporting processes and dashboard updates

Target competencies

  • Creating dashboards
  • Reporting, analysing and visualising data
  • Using Power BI Desktop
  • Applying Power Query

Who should attend

This course suits:

  • Business, data and research analysts
  • Finance, marketing and sales professionals
  • HR and IT professionals
  • Administrative staff and supervisors
  • General business professionals

Training methodology

  • Live online sessions with instructor interaction via video and audio.
  • Collaborative exercises and group discussions.
  • Practical assessments, activities and case studies.

Course modules

  1. Module 1

    Getting data with Power Query

    • Extracting data from Excel
    • Connecting to CSV and TXT files
    • Pulling data from the web
    • Getting data from a folder
  2. Module 2

    Transforming data

    • Unpivoting and pivoting tables
    • Filtering datasets
    • Sorting information
    • Removing and adding columns
    • Creating conditional columns
  3. Module 3

    Visualising data in Power BI

    • The Power BI report view
    • Working with visuals
    • Working with fields
    • Building basic charts
    • Applying formatting options
    • Using filtering tools
    • Creating matrix visuals
    • Adding timelines and slicers
    • Using cards and Q&A features
    • Building maps
    • Applying tooltips
    • Using drill-through functions
    • Working with bookmarks
  4. Module 4

    Data models and DAX measures

    • Managing implicit and explicit measures
    • Building relationships between data tables
    • Using RELATED and CALCULATE functions
    • Applying iterative functions (SUMX, COUNTX, AVERAGEX)

Certificate

Every delegate who completes the course receives an ARUK Training Certificate of Attendance.

Frequently asked questions

How do I register?

Choose a date and city in the schedule and press Register, or send us an enquiry. Our team confirms your place and sends an invoice.

Are fees shown with VAT?

Fees are shown per delegate and exclude VAT, which is added to the invoice where applicable.

Can this course be delivered for our team only?

Yes. Any ARUK course can be delivered in-house at your premises, in a meeting room we book for you, or 1-to-1.

Is this course available online?

Yes. We run it live online with a trainer, on dates that suit your team, for £1,850 + VAT per delegate.

Is there a group discount?

Yes. 20% for 2 delegates, 35% for 3 delegates and 50% for 5 or more delegates on the same course.

Can the course be delivered in Arabic or another language?

Yes. Our courses can be delivered in English, Arabic or any European language, by a trainer who teaches in that language. Mention your preferred language when you register or enquire.

What certificate will I receive?

An ARUK Training Certificate of Attendance.

Related courses

Register

Key booking terms (read before you register)
  • The full fee is paid in advance, before the course starts.
  • Cancel in writing 30 or more days before the start date (45 for in-house) for a refund. Later than that, the full fee is payable.
  • No refund for non-attendance or partial attendance.
  • Places are for the named delegate only; another person cannot attend instead.
  • Moving to another date or city is only possible if ARUK agrees in writing.
  • Travel, accommodation and visas are your responsibility. A refused visa does not change the cancellation terms.

booking terms and conditions

Get a quotation