Advanced Data Analysis
Move from basic analysis to advanced solutions with advanced SQL, Power BI, DAX and Python, built around real business problems.
- Intermediate
- 40 hours
- Taught in Arabic
What you will learn
Entry requirement: the basics of Excel, SQL and Power BI, or a placement test. 20 sessions, 40 hours.
- Advanced, reusable SQL queries
- A professional data model and advanced DAX measures
- An interactive Power BI report with management KPIs
- Python and pandas notebooks to clean and explore data
- A complete portfolio project with an executive presentation of the results and recommendations
Choose a cohort
No dates are set for this course yet. Join the waitlist and we'll tell you when the next cohort opens.
Course content
7 units · 40 hoursBusiness problem framingSession 1
Turn a management problem into analytical questions.
Advanced SQLSessions 2–4
Subqueries and CTEs for multi-step queries, window functions to rank customers and compute growth and running totals, and query optimization with result checks.
Power Query automation and data modelingSessions 5–6
Reusable ETL with advanced Power Query, fact and dimension tables and the star schema.
DAX and KPI analysisSessions 7–9
Filter context, row context and measures, time intelligence (month and year comparisons, YTD), and contribution, variance and growth rate.
Advanced Power BI reportingSessions 10–12
Dashboards for executives, bookmarks, tooltips and drill-through, performance tuning and an introduction to row-level security (RLS).
Python for data analysisSessions 13–16
Python basics for analysis, preparing data with pandas, exploratory data analysis to find patterns and outliers, statistics and visualization.
Integrated project and storytellingSessions 17–20
Connect SQL, Python and Power BI in one workflow, build a full project on real or realistic data, turn the findings into recommendations, and present and defend it.