Data Analysis Professional Program (Excel, Power BI, SQL & Python)
A complete data analyst programme covering the full analysis life cycle: business data analysis and dashboards in Excel, business intelligence in Power BI, querying with SQL, and data wrangling and visualisation in Python, finishing with an end-to-end project.
At a glance
- 10 days
- 12 days · Extended capstone
Who it's for
- Data analysts
- Supply chain, sales & finance analysts
- Professionals moving into analytics roles
Learning objectives
- Run the full analysis life cycle from raw data to insight
- Analyse and dashboard data in Excel and Power
- BI
- Query and shape relational data with SQL
- Wrangle, analyse and visualise data in Python (pandas, NumPy, Matplotlib, Seaborn, Plotly)
- Automate Excel tasks with VBA
- Deliver a real-world analytics project
Detailed content
- Preparing data & key metrics
- Relational modelling
- Comparison, trend, ranking, variance, contribution, frequency & correlation analysis
- Interactive dashboards
- Excel VBA & automation
- BI concepts & architecture
- Data warehouse & OLAP
- Power BI data modelling, DAX & reports
- Reports vs dashboards
- Relational databases & SQL Server tools
- SELECT, WHERE, ORDER BY
- Joins, GROUP BY & aggregation
- Sub-queries & views
- Connecting SQL to Power BI/Excel
- Data analysis life cycle
- NumPy & pandas
- Reading/writing CSV, Excel & text files
- Descriptive statistics & EDA
- Data wrangling: filter, sort, group, merge
- Missing data, outliers & duplicates
- Visualisation: Matplotlib, Seaborn, interactive Plotly
- End-to-end analysis of a real dataset
- Presenting findings
Day-by-day agenda
A typical schedule. In-company versions are tailored to your processes, data and timing.
- Business Data Analysis with Excel
- Practical workshop applying the tools to participants' cases
- Business Intelligence & Power BI
- Group project work and coaching
- SQL for Analysts
- Practical workshop applying the tools to participants' cases
- Python for Data Analysis
- Group project work and coaching
- Final Project
- Practical workshop applying the tools to participants' cases
- Case study, action plans and course assessment
Practice, tools and assessment
Hands-on practice
- Hands-on lab on your laptop with a real business data set
- Build a complete dashboard from raw data to one-page report
- Data-cleaning challenge (Power Query / pandas)
- Case studies from Egyptian and Gulf organizations
Tools and templates you keep
- Practice files and solution workbooks
- Formula, DAX and shortcut cheat sheets
- Dashboard design checklist
- Course workbook and slide handouts
How learning is assessed
- Pre- and post-course knowledge check
- Assessment of practical exercises by the trainer
- Action plan reviewed at the end of the course
Built on these standards and bodies of knowledge
- Microsoft PL-300 skills outline (Power BI)
- CRISP-DM data-analysis process
How it is delivered
- Public courses in Cairo, in-company programs and live online training
- Practical exercises, case studies and examples from your sector
- Can also run as Train & Stay in Sharm El Sheikh, Hurghada or Cairo
Part of these career paths
- Data Analytics & Digital Tools · Expert
Frequently asked questions
How long is Data Analysis Professional Program (Excel, Power BI, SQL & Python)?
The program runs 10 days; other formats: 12 days. In-company versions can be adapted to your needs.
Is the course taught in Arabic or English?
Sessions are usually delivered in Arabic with English technical terms and materials. Full English delivery is available for in-company groups.
Can you run it inside our company?
Yes. In-company programs use exercises built on your own processes. Tell us the group size and preferred timing and we will send a proposal.
Will I receive a certificate?
Participants who complete the program and its assessment receive a certificate from The Excellence Center, which can be verified online.
More programs in this field
- Generative AI for ProfessionalsNew
- Advanced Analytics for Business Excellence5 days
- Advanced Excel4 days
- Business Intelligence5 days
- Data Analysis for Digital Marketing5 days
- Data Analysis Using Excel4 days
- Data Analysis Using Excel & Power BI5–6 days
- Data Analysis Using Microsoft Power BI3 days
- Excel for Beginners3 days
Get dates, fees and the full outline.
Tell us whether you are joining as an individual or planning a program for your team.