Home Training Data Analytics using Excel, Power BI and AI

Data analytics program

Data Analytics using Excel, Power BI and AI

From Raw Data to Decision-Ready Insights

Five modules and an integrated capstone that take professionals from raw data to decision-ready insight, with AI as a co-pilot at every stage and every AI output validated by the analyst.

  • Dates: 21 Nov – 19 Dec 2026
  • Duration: 9 sessions · 40 hours
  • Format: Sat on-site · Mon online
  • Location: El Maadi + live online
Register your seat All programs
Instructional hours
40 h
Modules + capstone
5
Dedicated AI
3 h
Business cases, start to finish
5+

Every Saturday on-site at Orillia, El Maadi (10:00 AM – 4:00 PM · 6 h). Every Monday live online (7:00 – 10:00 PM · 3 h).

The Orillia Analytics Journey

From raw data to decision-ready insights

Prepare reliable, refreshable data. Model it, measure it and find what it says. Turn findings into recommendations, then communicate, monitor and follow through. New: AI as a co-pilot at every stage, and every AI output validated by the analyst.

  1. 1Data
  2. 2Insight
  3. 3Decision
  4. 4Action
Data Analytics using Excel, Power BI and AI
21 Nov – 19 Dec 2026
Who it is for

Designed for professionals who report and decide

Business & data analysts

Reports others rely on

Managers who own KPIs

Answers, not just numbers

Finance & FP&A

Budget vs. actual, margin

HR & L&D

Headcount, turnover, training

Sales & commercial

Revenue, pipeline, product mix

Operations & CX

SLA, quality, CSAT

Prerequisites

  • Working Excel: tables, basic formulas, charts
  • No Power BI, DAX or coding experience needed
  • Windows laptop (Power BI Desktop is Windows-only)
  • Stable internet and webcam for any online sessions
Learning Outcomes

What participants will be able to do

  1. Translate

    Business questions into KPIs

  2. Prepare

    Refreshable, multi-source data

  3. Model

    Star schema with a date table

  4. Measure

    KPI, variance and time-intelligence DAX

  5. Design

    Executive-ready dashboards

  6. Augment

    Use AI in all data analytics processes

  7. Deploy

    Publish, share, secure, refresh

  8. Recommend

    Evidence-based business decisions

Curriculum Architecture

Five modules, one learning journey

Each module answers a business question and produces an output that feeds the next.

A · Excel

Data Analytics & Excel

Business question
What is happening, and can we trust the data?
Output
KPI Framework & Excel Dashboard
Focus

KPIs · PivotTables · dashboards

  • KPI thinking and data quality checks
  • Excel tables, formulas, PivotTables and PivotCharts
  • Trend, variance, budget vs. actual
  • Slicers, timelines; one-page Excel dashboard
Challenge

The Management Report Is Wrong

  • Output: KPI framework and Excel dashboard
  • Feeds Module B
Program Schedule

Starting Saturday, 21 November 2026

Saturdays on-site at Orillia, El Maadi (10:00 AM – 4:00 PM) and Mondays live online (7:00 – 10:00 PM). 9 sessions, 40 hours, 21 Nov – 19 Dec 2026.

Register your seat

  1. S1 · Module A: Data Analytics & Excel

    10:00 AM – 4:00 PM On-site · El Maadi

  2. S2 · Module A: Excel Dashboard

    7:00 – 10:00 PM Live online

  3. S3 · Module B: Data Preparation & Automation

    10:00 AM – 4:00 PM On-site · El Maadi

  4. S4 · Module B: Refreshable Workflow

    7:00 – 10:00 PM Live online

  5. S5 · Module C: Data Modeling

    10:00 AM – 4:00 PM On-site · El Maadi

  6. S6 · Module C: DAX & Analysis

    7:00 – 10:00 PM Live online

  7. S7 · Module D: Power BI Dashboards & Service

    10:00 AM – 4:00 PM On-site · El Maadi

  8. S8 · Module E: AI-Augmented Analytics

    7:00 – 10:00 PM Live online

  9. S9 · Integrated Capstone Presentation

    10:00 AM – 2:00 PM On-site · El Maadi
New in this program

AI as a co-pilot at every stage

Participants use AI to draft, explain and debug, then prove every answer. Each AI output is validated by the analyst before it reaches a decision.

  1. Measure Factory

    AI drafts 5 KPI measures; each checked against a known total

  2. Debug Clinic

    Fix broken measures and explain why they failed

  3. Why Did Returns Rise?

    AI visuals find drivers; measures confirm them

  4. The AI Audit

    Catch errors in an AI-written insight summary

Takeaways & Business Value

What participants leave with

  1. KPI framework
  2. Excel dashboard
  3. Power Query workflow
  4. Data model & DAX measures
  5. Power BI report
  6. AI prompt & validation log
  7. Insight summary
  8. Capstone presentation

Intended business value

  • Less manual, repetitive reporting
  • Data managers can trust
  • Faster, evidence-based decisions
  • AI used productively, and safely
  • Skills applied to real work problems
Meet Your Trainer

Learn from a Data & BI Leader

Mahmoud Serag

Mahmoud Serag

Corporate BI Trainer & Consultant

Credentials

  • Microsoft Certified (MCITP & MOS)
  • Certified Instructional Designer
  • Udacity Data Analyst Nanodegree
  • Train-the-Trainer (TOT) Certified

For 17 years, Mahmoud Serag has been turning data into decisions for teams across MENA. He has trained 3,000+ professionals at 80+ organizations, from the National Bank of Egypt, QNB and Paymob to Chevron, Dell and Saudi German Hospital, and built live dashboards for WHO, Tharwat and Raya CX. He leads the Power BI Developer track at Egypt's national DEPI initiative. In the room, he pairs Power BI, DAX and AI-analytics mastery with instructional design, so skills stick long after the workshop.

Years turning data into decisions for MENA's leading organizations
17
Professionals trained across 80+ organizations, 60+ of them enterprises
3,000+
Average satisfaction rating across his training programs
4.8/5

What he brings to this program

  • Power BI & DAX
  • Excel & Power Query
  • AI-Powered Analytics
  • Dashboard & KPI Design
  • SQL & Statistics
  • Tableau & Data Viz
Training Halls
Where you will learn

Orillia training halls, El Maadi

Saturday sessions and the capstone run face to face in our training halls in El Maadi. Monday sessions are live online.

See the training halls
Registration

Reserve your place

Send your details below and our team will get back to you to confirm your place.

  • Dates21 Nov – 19 Dec 2026
  • Duration9 sessions · 40 hours
  • FormatSat on-site · Mon online
  • LocationEl Maadi + live online

Questions? Call 0120 133 0888 or email info@orilliaeg.com.

Register your seat

Register your interest and our team will confirm your seat. No payment required online.

Data Analytics using Excel, Power BI and AI · 21 Nov – 19 Dec 2026

Request sent

Thank you! Our team will contact you shortly to confirm your registration.

Your email app should now open with your request ready to send. If nothing opened, copy the message and email it to us at info@orilliaeg.com

From raw data to decision-ready insight, with AI as your co-pilot.

Want this program delivered for your team only? We can run it in-house or at Orillia, tailored to your people.

Register your seat Bring This Program to Your Team