Corporate training in the Gulf, London, Europe & Asia since 2015
Enquire now
IT-016

Microsoft Power BI: Data Analysis & AI Dashboards

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

Business analysts and data professionals study advanced analytics and AI features in Microsoft Power BI over five days. Delegates load and transform data before building interactive dashboards for reporting business performance. Practical work covers DAX calculations and forecasting to support strategic decisions.

Classroom

Public courses in our cities

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

Data preparation supports reporting in Power BI. During this five-day course, delegates study advanced analytics and AI integration to understand how dashboards reveal business performance and identify opportunities or challenges that need attention. Forecasting and pattern identification help explain the factors behind business outcomes.

Delegates learn to clean and transform business data using Power Query Editor. The syllabus covers Data Analysis Expressions (DAX) for custom calculations. Practical sessions show delegates how to design interactive dashboards that use AI-driven visuals to identify hidden patterns.

Automated forecasting supports interactive dashboards with data available in real time. Publishing sessions cover secure sharing in Power BI Service and integration with Microsoft Teams and SharePoint. The final project applies these features to a dashboard that presents business insights.

Course objectives

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

  1. Connect, clean, and transform raw business data using Power BI
  2. Create dynamic dashboards and reports for detailed data analysis
  3. Apply artificial intelligence and machine learning capabilities
  4. Use advanced data modelling and visualisation for data storytelling
  5. Apply AI analytics to identify trends, forecasts and hidden patterns

Who should attend

This course suits:

  • Business analysts, data professionals and managers exploring Power BI and AI
  • Executives and decision-makers developing their understanding of data dashboards
  • Finance, marketing, sales and operations professionals integrating AI analytics into reporting

Training methodology

  • Interactive lectures and structured group discussions
  • Practical work building data models and custom dashboards
  • Hands-on exercises loading data for analysis

Daily agenda

  1. Day 1

    Fundamentals of Power BI and data loading

    • Navigating the Power BI interface and core functionalities
    • Connecting to databases, cloud systems, and Excel
    • Loading, cleaning and transforming data in Power Query Editor
    • Hands-on session setting up and loading business data
  2. Day 2

    Data modelling and DAX for analysis

    • Structuring data models in Power BI for efficient reporting
    • Using Data Analysis Expressions (DAX) for custom measures
    • Creating calculated columns and detailed mathematical formulas
    • Practical work building a data model with DAX
  3. Day 3

    Designing dashboards for data analysis

    • Core principles of effective business data visualisation
    • Building dynamic dashboards using charts, KPIs, and tables
    • Adding drill-throughs, tooltips, and interactive slicers
    • Best practices for clear and concise data storytelling
    • Hands-on session designing a functional data analysis dashboard
  4. Day 4

    Integrating AI and machine learning

    • Q&A visual, AI visuals and Cognitive Services in Power BI
    • Analysing outcome factors using the Key Influencers visual
    • Running AI-driven data clustering and segmentation
    • Applying forecasting models and time-series analysis techniques
    • Creating AI visuals that reveal patterns and insights in data
  5. Day 5

    Advanced reporting and publishing

    • Integrating dashboards with Microsoft Teams and SharePoint
    • Publishing and sharing dashboards securely in Power BI Service
    • Dashboard performance optimisation and mobile access
    • Final project building an AI-powered insights dashboard
    • Review of the course and Q&A

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