Diploma

Professional Diploma in Data Analysis

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

Built for Anyone Ready to Turn Data into Decisions

This program is designed for beginners and professionals who want practical, job-ready data analysis skills. Through hands-on projects using Excel, SQL, Python, and Power BI, you will learn to clean, analyze, and present data with confidence, and build a portfolio that shows what you can do.

Beginners

Newcomers who want to start a career in data analysis, with no prior experience needed.

Students & Fresh Graduates

Students and recent graduates who want practical skills that help them stand out in the job market.

Working Professionals

Professionals who want to improve their data and reporting skills and make smarter decisions at work.

Hands-On Learners

Learners interested in Excel, SQL, Python, and Power BI who want real projects to strengthen their portfolio.
9,000 EGP
Apply Now
Contact Us
Application Fees (Non-Refundable)
1,500 EGP
Early Bird
8,500 EGP

Have Questions?

Please reach out us for any guidance or assistance.
16453
NUSCE@nu.edu.eg