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.
Phase
Sessions
Dates
Focus / project
Orientation & Analyst Mindset
1 session
22 Dec 2026
Orientation
Excel Fundamentals
4 sessions
25 Dec 2026 – 5 Jan 2027
Excel foundations
Excel for Data Analysis
6 sessions
8 Jan 2027 – 26 Jan 2027
Excel dashboard
Power BI: Beginner to Intermediate
11 sessions
29 Jan 2027 – 5 Mar 2027
Power BI report
Power BI Advanced
2 sessions
16 Mar 2027 – 19 Mar 2027
Power BI report upgrade
SQL with PostgreSQL
8 sessions
23 Mar 2027 – 16 Apr 2027
SQL analysis
AI for Data Analysts
4 sessions
20 Apr 2027 – 30 Apr 2027
AI-assisted dashboard
Capstone & Career
3 sessions
4 May 2027 – 11 May 2027
Capstone & 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.
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.
Text functions (TEXT, LEFT/RIGHT/MID, TRIM, TEXTSPLIT, TEXTJOIN). Date functions (EOMONTH, NETWORKDAYS, DATEDIF). Data validation and drop-downs. Conditional formatting.
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.