← Workshop profile
عربي

Ahmed Mahmoud Swid

Hands-on workshops in Business Analysis & Dashboard Design — Power BI

Summary

Business & Data Analyst at Riyadh Municipality with over five years of practice. Has delivered hands-on business-analysis and Power BI dashboard workshops to more than 150 Municipality staff, totalling over 360 hours, and authored their material: purpose-built practice data, printed handbooks and a glossary. PMI CAPM certified.

Training areas

Power BI DesktopPower Query — ETLData modelling — star schemaDAXFilter contextTime intelligenceDashboard designKPI developmentPower BI Service & publishingRow-level securityData cleaning & qualityExecutive reporting

Workshop record

Riyadh Municipality

5+ years
  • ●“Business Analysis with Power BI” workshop for West sector staff — five days, 11–15 January 2026, four and a half hours daily.
  • ●A week-long Power BI workshop for North sector staff, covered by the Municipality’s internal channel.
  • ●An official business analysis and dashboard course for South sector staff.
  • ●Trained and mentored more than 150 staff in data analysis, reporting and dashboard building.
  • ●Hands-on throughout: every participant works on their own machine, and the programme closes with a closing project they present themselves.

Workshop tracks

Four progressive tracks · Arabic, with English terminology

  • Track 1 — From mess to a clean table — import, clean, combine and automate refresh with Power Query. Output: a file that refreshes in one click.
  • Track 2 — The model — dimensional modelling and relationships, date table and hierarchies, measures versus calculated columns in DAX.
  • Track 3 — The heart of the tool — filter context as a full session and a mandatory gate, then CALCULATE and its family, and time intelligence.
  • Track 4 — Presentation and delivery — visual choice, interaction and navigation, then publishing, governance, RLS and the closing project.

Prepared material

  • ●Curriculum plan and language standard — 7 pages
  • ●Part One: Introduction to Power BI — 22 pages
  • ●Part Two: Your first complete report — 23 pages
  • ●An agreed Arabic–English glossary for the curriculum
  • ●Six training data files, each with one deliberate defect
  • ●A pre-publish checklist handed to every participant

Qualifications

  • CAPM — Certified Associate in Project Management

    Project Management Institute (PMI) · No. 4183768 · 2025–2028

  • Complete Guide to Power BI for Data Analysts

    Microsoft Press · LinkedIn Learning

  • Learning Power BI Desktop

    LinkedIn Learning

Languages

  • ArabicNative
  • EnglishGood

How it runs

No slide gets read aloud · Mistakes are made on purpose, then diagnosed · “Why” before “how” · English term, Arabic meaning · Filter context is a mandatory gate.

Practical background

What is taught comes from live practice: a Business & Data Analyst at Riyadh Municipality who built a 34-screen platform running SAR 179.3M of maintenance contracts.