Live online · Taught in Arabic

Learn live.
Build with guidance.

Explore upcoming courses with instructor-led sessions, practical work and a clear timetable. Find the cohort that fits your next step.

تعلّم مباشر بالعربي، ومشاريع تبنيها خطوة بخطوة

Choose your live learning path

Upcoming live courses.

One confirmed start date, with more cohort details to follow.

Starts 22 December 2026Live on Zoom · Arabic

AI-Powered
Data Analyst

From spreadsheets to dashboards, databases and AI-assisted analysis, with Mostafa Mohamed.

Programme
22 Dec 2026 – 11 May 2027
Days
Tuesday & Friday
Time
8:00–11:00 PM Makkah / Doha
Live learning
39 sessions · 117 hours
Practice
5 portfolio projects
Cohort fees
Contact us for details
Coming soonFuture live cohort

AI Data Analyst

A future intake. Dates, session times and programme details will be announced here when confirmed.

No start date or booking schedule has been announced for this intake.

Ask about the next intake

22 December 2026 – 11 May 2027

AI-Powered Data Analyst
Live Cohort

A structured programme connecting Excel, Power BI, PostgreSQL and AI. Statistics and storytelling are built into the sessions where you use them.

Enquire about this cohort
39live sessions
117live hours
5portfolio projects
7recorded courses included

Every Tuesday & Friday

Three hours per session, live online via Zoom.

Makkah / Doha8:00–11:00 PM
Cairo7:00–10:00 PM8:00–11:00 PM from 30 April 2027

The timetable is anchored to Makkah time (UTC+3). Cairo changes to daylight-saving time on 30 April 2027 under the current rules. Ramadan timing adjustments, if required, will be communicated in advance.

Who this is for

  • Career changers moving toward data analysis.
  • Professionals working with data and business reports.
  • Graduates developing a practical reporting portfolio.

What’s included

  • 39 instructor-led sessions and guided practice.
  • Five portfolio projects with personal feedback.
  • The recorded track: seven courses and 600+ lessons.
  • Integrated statistics, storytelling and a career session.
  • A certificate of completion.

Prepare before you start

  • A Windows PC, or a Windows virtual machine for Power BI Desktop.
  • Excel 365 or Excel 2021.
  • Power BI Desktop, PostgreSQL and pgAdmin.
  • Allow 4–6 hours a week for homework and recorded lessons.
YOUR INSTRUCTOR

Mostafa Mohamed

17 years of experience in data analysis, data science and machine learning. Master’s in AI for Business. Founder of Data Science Hub.

The learning journey

Your programme at a glance.

Eight phases, from orientation to capstone presentation.
PhaseSessionsDatesFocus / project
Orientation & Analyst Mindset1 session22 Dec 2026Orientation
Excel Fundamentals4 sessions25 Dec 2026 – 5 Jan 2027Excel foundations
Excel for Data Analysis6 sessions8 Jan 2027 – 26 Jan 2027Excel dashboard
Power BI: Beginner to Intermediate11 sessions29 Jan 2027 – 5 Mar 2027Power BI report
Power BI Advanced2 sessions16 Mar 2027 – 19 Mar 2027Power BI report upgrade
SQL with PostgreSQL8 sessions23 Mar 2027 – 16 Apr 2027SQL analysis
AI for Data Analysts4 sessions20 Apr 2027 – 30 Apr 2027AI-assisted dashboard
Capstone & Career3 sessions4 May 2027 – 11 May 2027Capstone & career
Planned Eid al-Fitr break: 9–12 March 2027.

No sessions are scheduled on Tuesday 9 March or Friday 12 March. Ramadan and Eid arrangements are subject to official moon-sighting announcements; any changes will be confirmed in advance.

Session by session

Know what you’ll learn
and when you’ll meet.

Open a phase for every date, topic and practice task. Sessions 15–22 fall in the programme’s expected Ramadan period.

Show session times in

Showing Makkah / Doha times: 8:00–11:00 PM for every session.

Orientation & Analyst Mindset1 session · 22 Dec 2026
Session 18:00–11:00 PMMakkah / Doha

What you’ll learn

The analyst's role and workflow (ask → prepare → analyse → share). Turning business goals into KPIs and questions. Tour of the tools. Setup check: Excel 365 and Power BI Desktop. Cohort rules, projects and grading.

STORYTELLING Start from the business question and the audience

Practice after the session

Business Foundations reading; write 5 business questions for the course dataset

Excel Fundamentals4 sessions · 25 Dec 2026 – 5 Jan 2027
Session 28:00–11:00 PMMakkah / Doha

What you’ll learn

Interface, workbooks and Excel Tables. Data entry and formatting. Formulas, operators and relative/absolute/mixed references. SUM, COUNT, AVERAGE, MIN/MAX, ROUND.

STATISTICS Population vs sample; data types

Practice after the session

Formula drill sheet

Session 38:00–11:00 PMMakkah / Doha

What you’ll learn

Conditional aggregation: SUMIFS, COUNTIFS, AVERAGEIFS. Logical functions: IF, nested IF, IFS, AND/OR/NOT, IFERROR, SWITCH.

Practice after the session

Commission & bonus calculator

Session 48:00–11:00 PMMakkah / Doha

What you’ll learn

Text functions (TEXT, LEFT/RIGHT/MID, TRIM, TEXTSPLIT, TEXTJOIN). Date functions (EOMONTH, NETWORKDAYS, DATEDIF). Data validation and drop-downs. Conditional formatting.

STORYTELLING Highlighting with purpose

Practice after the session

Clean and flag a customer list

Session 58:00–11:00 PMMakkah / Doha

What you’ll learn

XLOOKUP, INDEX/MATCH and two-way lookups. Dynamic arrays: FILTER, SORT, UNIQUE, SEQUENCE. Core charts. Excel Fundamentals quiz.

STORYTELLING Choosing the right chart

Practice after the session

Lookup and chart exercise

Excel for Data Analysis6 sessions · 8 Jan 2027 – 26 Jan 2027
Session 68:00–11:00 PMMakkah / Doha

What you’ll learn

PivotTables in depth: grouping, % of total, running totals, ranks, calculated fields, slicers, timelines and PivotCharts.

STATISTICS Mean, median, mode, standard deviation, percentiles, IQR

Practice after the session

Pivot analysis of the course dataset

Session 78:00–11:00 PMMakkah / Doha

What you’ll learn

Power Query I: importing CSV and Excel files, data types, splitting and merging columns, unpivot, fill down, replace values, refresh.

STATISTICS Data quality: missing values and duplicates

Practice after the session

Clean 3 messy source files

Session 88:00–11:00 PMMakkah / Doha

What you’ll learn

Power Query II: merge and append, folder import, custom and conditional columns, group by. Power Pivot data model and relationships.

STATISTICS Spotting outliers

Practice after the session

Build the Project 1 data model

Session 98:00–11:00 PMMakkah / Doha

What you’ll learn

DAX measures in Power Pivot. What-if analysis: Goal Seek, Scenario Manager, Data Tables. Forecast Sheet. Introduction to recorded macros.

STATISTICS Distributions, histograms, correlation, regression basics

Practice after the session

Forecast and scenario exercise

Session 108:00–11:00 PMMakkah / Doha

What you’ll learn

Dashboard design in Excel: layout grid, KPI cards, slicers across pivots, dynamic titles. Project 1 build lab with 1-to-1 help.

STORYTELLING Dashboard layout and the Big Idea

Practice after the session

Project 1: Excel dashboard

Session 118:00–11:00 PMMakkah / Doha

What you’ll learn

Project 1 presentations and feedback. The bridge from Excel to Power BI.

STORYTELLING The 3-sentence insight: what, so what, now what

Practice after the session

Install and explore Power BI Desktop

Power BI: Beginner to Intermediate11 sessions · 29 Jan 2027 – 5 Mar 2027
Session 128:00–11:00 PMMakkah / Doha

What you’ll learn

Power BI Desktop and Service tour. Getting data from Excel, CSV, folders and the web. Power Query in Power BI.

Practice after the session

Import and clean the course dataset

Session 138:00–11:00 PMMakkah / Doha

What you’ll learn

Advanced Power Query: M basics, parameters, custom functions, query folding, data profiling.

STATISTICS Column profiling and distributions

Practice after the session

Parameterised folder import

Session 148:00–11:00 PMMakkah / Doha

What you’ll learn

Data modeling: fact vs dimension tables, star schema, relationships, cardinality, filter direction.

Practice after the session

Turn a flat table into a star schema

Session 158:00–11:00 PMMakkah / DohaRamadan period

What you’ll learn

Date tables. Calculated columns vs measures. SUM, COUNTROWS, DISTINCTCOUNT, DIVIDE. Your first CALCULATE.

STATISTICS Ratios, rates and the average-of-averages trap

Practice after the session

10 base measures

Session 168:00–11:00 PMMakkah / DohaRamadan period

What you’ll learn

Filter context: CALCULATE, ALL, REMOVEFILTERS, ALLEXCEPT, FILTER, KEEPFILTERS.

Practice after the session

DAX filter-context exercises

Session 178:00–11:00 PMMakkah / DohaRamadan period

What you’ll learn

Iterators (SUMX, AVERAGEX). Time intelligence: YTD/QTD/MTD, SAMEPERIODLASTYEAR, DATEADD, YoY %, rolling periods.

STATISTICS Trend, seasonality and moving averages

Practice after the session

Time-intelligence measure set

Session 188:00–11:00 PMMakkah / DohaRamadan period

What you’ll learn

Visuals and interactivity: drill-down, drill-through, tooltip pages, bookmarks, field parameters, conditional formatting.

STORYTELLING Decluttering and colour with purpose

Practice after the session

Rebuild a cluttered report

Session 198:00–11:00 PMMakkah / DohaRamadan period

What you’ll learn

Report design: layout, navigation, themes, mobile layout. Analytics pane, histograms and box plots.

STATISTICS + STORYTELLING Box plots and outliers; report narrative

Practice after the session

Wireframe for Project 2

Session 208:00–11:00 PMMakkah / DohaRamadan period

What you’ll learn

Power BI Service: workspaces, publishing, apps, sharing, scheduled refresh, gateway, subscriptions and alerts.

Practice after the session

Publish your report

Session 218:00–11:00 PMMakkah / DohaRamadan period

What you’ll learn

Project 2 build lab with 1-to-1 help and a peer-review checklist.

Practice after the session

Project 2: Power BI report

Session 228:00–11:00 PMMakkah / DohaRamadan period

What you’ll learn

Project 2 presentations and feedback.

STORYTELLING The executive walkthrough

Practice after the session

Catch up on recorded lessons

Power BI Advanced2 sessions · 16 Mar 2027 – 19 Mar 2027
Session 238:00–11:00 PMMakkah / Doha

What you’ll learn

Advanced DAX: variables, context transition, virtual tables, RANKX, TOPN. Overview of calculation groups and performance tools.

STATISTICS Pareto (80/20) analysis

Practice after the session

Add ranking and Pareto to Project 2

Session 248:00–11:00 PMMakkah / Doha

What you’ll learn

Row-level security, static and dynamic (USERPRINCIPALNAME, security tables). Object-level security. Governance and deployment basics.

Practice after the session

Project 2 upgrade; install PostgreSQL + pgAdmin

SQL with PostgreSQL8 sessions · 23 Mar 2027 – 16 Apr 2027
Session 258:00–11:00 PMMakkah / Doha

What you’ll learn

Relational databases and pgAdmin; loading the course dataset. SELECT, WHERE, ORDER BY, LIMIT, DISTINCT, LIKE / IN / BETWEEN.

Practice after the session

20 basic queries

Session 268:00–11:00 PMMakkah / Doha

What you’ll learn

GROUP BY and HAVING. CASE WHEN. COALESCE and NULLIF. Date functions: DATE_TRUNC, EXTRACT, intervals.

STATISTICS Descriptive statistics in SQL

Practice after the session

KPI queries

Session 278:00–11:00 PMMakkah / Doha

What you’ll learn

JOINs: inner, left, right, full, self and anti-joins. UNION, INTERSECT, EXCEPT.

Practice after the session

Multi-table business questions

Session 288:00–11:00 PMMakkah / Doha

What you’ll learn

Database design: data types, keys, constraints, normalisation. CREATE, INSERT, UPDATE. Views.

Practice after the session

Design a small schema

Session 298:00–11:00 PMMakkah / Doha

What you’ll learn

Subqueries (scalar, IN, EXISTS, correlated) and CTEs. Building funnel and cohort analyses.

Practice after the session

Funnel analysis

Session 308:00–11:00 PMMakkah / Doha

What you’ll learn

Window functions: ROW_NUMBER, RANK, DENSE_RANK, LAG/LEAD, running totals, moving averages, NTILE.

STATISTICS Growth rates and rolling metrics

Practice after the session

Window-function set; start Project 3

Session 318:00–11:00 PMMakkah / Doha

What you’ll learn

Indexes, EXPLAIN, roles and permissions. Connecting Power BI to PostgreSQL (Import vs DirectQuery).

STATISTICS A/B testing, significance, confidence intervals

Practice after the session

Project 3: SQL analysis

Session 328:00–11:00 PMMakkah / Doha

What you’ll learn

Project 3 presentations and query review.

STORYTELLING The one-page insight memo

Practice after the session

Finalise the Project 3 memo

AI for Data Analysts4 sessions · 20 Apr 2027 – 30 Apr 2027
Session 338:00–11:00 PMMakkah / Doha

What you’ll learn

AI for analysts: how LLMs work, prompting for analysis, AI in Excel (Copilot, Claude), verifying AI output, data privacy.

Practice after the session

AI-assisted Excel task with a verification log

Session 348:00–11:00 PMMakkah / Doha

What you’ll learn

AI for data cleaning and exploratory analysis: automated profiling, AI-suggested hypotheses, and how to check them.

STATISTICS Sanity-checking AI statistics

Practice after the session

AI exploratory report and the errors found

Session 358:00–11:00 PMMakkah / Doha

What you’ll learn

AI for SQL and DAX: text-to-SQL, reviewing and optimising queries, generating and reviewing DAX, Copilot in Power BI.

Practice after the session

Fix 5 wrong AI answers

Session 368:00–11:00 PMMakkah / Doha

What you’ll learn

AI agents for Power BI with MCP: what MCP is, Power BI MCP servers, Claude dashboard walkthrough, governance.

STORYTELLING Telling the story with AI, and what not to delegate

Practice after the session

Project 4: AI-assisted dashboard

Capstone & Career3 sessions · 4 May 2027 – 11 May 2027
Session 378:00–11:00 PMMakkah / Doha

What you’ll learn

Project 4 show-and-tell. Capstone kickoff: choosing a domain and business question, sourcing data. 1-to-1 scoping.

Practice after the session

Project 5: capstone

Session 388:00–11:00 PMMakkah / Doha

What you’ll learn

Career session: CV, LinkedIn and portfolio. Technical mock interviews (SQL + Power BI). Capstone clinic.

STORYTELLING Stakeholder presentation rehearsal

Practice after the session

Project 5: capstone

Session 398:00–11:00 PMMakkah / Doha

What you’ll learn

Capstone presentations (7 minutes + Q&A). Graduation and certificates. What to learn next.

STORYTELLING Final presentation

Practice after the session

—

Build as you learn

Five projects for your portfolio.

Excel dashboard

Clean a sales file with Power Query, analyse it with PivotTables and present a one-page dashboard.

Power BI report

Create a star-schema model, DAX measures and a three-page report. Upgrade it with advanced DAX and row-level security.

SQL analysis

Answer business questions in PostgreSQL and write a one-page insight memo for management.

AI-assisted dashboard

Extend a Power BI report with Claude and MCP, documenting what the AI got right and what you corrected.

Capstone

Connect a business question, SQL and Power BI in a chosen domain, then present your work and answer questions.

Before you join

A few practical answers.

What is the difference between live and recorded learning?

The live cohort follows the dated Tuesday/Friday schedule above, with guided work and feedback. The seven-course recorded track supports self-study between sessions and covers additional depth.

What time will I attend from Cairo?

Sessions are fixed at 8:00–11:00 PM Makkah/Doha time. That is 7:00–10:00 PM Cairo time until 29 April 2027, then 8:00–11:00 PM from 30 April under the current daylight-saving rules. Choose Cairo in the timetable to see each session’s local time.

What happens during Ramadan and Eid?

The supplied programme marks sessions 15–22 as Ramadan sessions and plans a break on 9 and 12 March. Timing changes and any adjustments following official moon sightings will be communicated in advance.

How much self-study should I allow?

Plan for 4–6 hours a week for homework and recorded lessons in addition to the live sessions. Your own study needs may vary.

How do I enrol and what are the fees?

Use the enquiry button to contact Data Science Hub by WhatsApp, or email info@datasciencehub.cloud. We will confirm live-cohort pricing, availability and booking details. The recorded-course price is not presented as the live-cohort fee.

Are the other live courses scheduled?

Only the dated cohort on this page has an announced programme. The coming-soon intake does not yet have confirmed dates or session times.

Your next live learning step

Ask about the December cohort.

Share your goals and confirm the fees and booking details before enrolling.