Diploma

Professional Diploma in Data Analysis

Computer Science & AI
Location
Online
Duration
100 Contact Hours - 4 Months

A hands-on diploma covering Excel, SQL, Python, Power BI, statistics, data visualization, and basic Machine Learning. Students work on practical projects and complete a final Python + Power BI project, helping them build the skills needed for entry-level data analysis roles.
 

Contact Hours
Months
Credential

Credential

NU Certificate

Location

Location

Online

Language

Language

English
(Arabic Support)

Program overview

The Data Analysis Diploma is a 100-hour practical training program designed to build strong skills in Excel, SQL, Python, and Power BI.

The diploma covers statistics, data cleaning, visualization, databases, dashboards, web scraping, and introductory Machine Learning. Students also complete hands-on projects and finish with a Python + Power BI final project to apply what they learned to a real data analysis workflow.

What You Will Learn

Data analysis and statistical fundamentals

Python programming and problem solving

Data cleaning and analysis using Pandas

Data visualization and real-world dataset analysis

Excel formulas, Pivot Tables, Power Query, and dashboards

SQL, databases, relationships, joins, and normalization

Power BI, DAX, interactive dashboards, and reporting

Introduction to Machine Learning, including Regression and Clustering

Web scraping and data collection basics

Building end-to-end data analysis projects

Curriculum

Phases

  • Course overview & data analysis concepts
  • Mathematical operations
  • Mean, Median, Mode
  • Variance & Standard Deviation
  • Probability basics

  • Python basics & data types
  • Conditions and loops
  • Lists & functions
  • Problem-solving techniques
  • Data collection concepts
  • Programming revisions

  • Pandas library
  • Sampling techniques
  • Data preprocessing & cleaning
  • Real-world dataset handling
  • Data visualization
  • Web scraping
  • Introduction to Machine Learning: Linear Regression, Clustering

  • Excel formulas
  • Pivot tables
  • Dashboards
  • Data visualization
  • REGEX formulas
  • Power Query

  • Database concepts (ERD & EER)
  • SQL commands (DDL, DML)
  • Relationships
  • Joins & Views
  • Normalization
  • DCL commands

  • Power BI fundamentals
  • Power Query
  • Visualizations
  • DAX functions
  • Interactive dashboards
  • Slicers & reporting design

  • Python problem-solving tasks
  • Python for data analysis Real data case study
  • Full Excel project
  • Database project
  • Power BI dashboard

Who Is This For

who want to start a career in Data Analysis

looking to build practical skills

who want to improve their data and reporting skills

in Excel, SQL, Python, and Power BI

who want hands-on projects to strengthen their portfolio

9,000 EGP
Early Bird
8,500 EGP

Have Questions?