Skip to content

Installment plans available on all programs

Data Analytics & Business Intelligence Diploma

Build the skills to start your career as a Data Analyst. Learn Excel, Python, SQL, Statistics, Power BI, ETL, Data Modeling, and Tableau while working on practical projects that turn real-world data into actionable business insights.

96 taught hoursLive Online · On CampusNext cohort Sep 13Installments available
Data Analytics & Business Intelligence Diploma — programme artwork
LiveLive OnlineOn Campus

15+

Years of training

ISO 9001

Certified academy

30+

Corporate clients

Choose how you want to learn

Each option has its own schedule and price.

Live Online

Live online, from anywhere

7,500 EGP

Next group starts
Next group: 18 September
Group name
Data Analysis Online 109
Session time
Friday & Saturday · 06:00 – 10:00

On Campus

Maadi

10,500 EGP

Next group starts
Next group: 13 September
Group name
Data Analysis Maadi 73
Session time
Sunday & Tuesday · 08:00 – 11:00
Not sure which? Talk to an advisor
  • Real hands-on projects & portfolio
  • 24/7 ticket support
  • Accredited certificate

Secure payment

You’ll Be Ready To

What you will be able to do after completing Data Analytics & Business Intelligence Diploma.

  • Clean, transform, and prepare raw data for analysis
  • Write SQL queries to extract and analyze business data
  • Build interactive dashboards using Power BI and Tableau
  • Apply statistical techniques to generate meaningful insights
  • Analyze data to support data-driven business decisions
  • Communicate insights clearly through data storytelling
  • Identify trends, patterns, and business opportunities
  • Present data-driven recommendations to stakeholders
96 taught hours12 modulesLive instructor-ledAccredited certificate

You May Pursue Roles Such As

The skills you build here prepare you for roles such as these.

Junior Data Analyst

Data Analyst

Business Intelligence (BI) Analyst

Reporting Analyst

Power BI Developer

Industries that hire these skills

  • Banking & Fintech
  • Retail & E-commerce
  • Healthcare
  • Telecommunications
  • Manufacturing
  • Government
  • Marketing & Media
  • Logistics
  • Technology & Software
  • Insurance
  • Education & EdTech
  • Travel & Hospitality
  • Energy & Utilities
  • Automotive

Roles listed describe the career paths this program prepares you for. They are not a guarantee of employment, and outcomes depend on your own background, portfolio and job search.

Projects that build real skills

3 portfolio projects you build on Data Analytics & Business Intelligence Diploma.

  • Sales Data Analysis

    Take a deliberately messy raw dataset (duplicates, missing values, inconsistent text casing, wrong data types, outliers) and produce a clean analysis-ready file. Document every cleaning decision in the notebook with before/after row counts and a data quality report.

    PandasNumPy
  • sales analysis dashboard

    Build a single-page interactive dashboard from a raw sales . Includes a cleaned data sheet, a calculation layer, dynamic named ranges, pivot charts, slicers and timeline filters, and KPI cards showing totals, growth rate and top performers. Charts must update automatically when filters change.

    Excel
  • Uber Dashboard

    End-to-end project on a single business scenario: raw data cleaned and modeled, SQL queries answering the core business questions, a Power BI dashboard for the operational view and a final presentation with recommendations. Every stage of the diploma appears in one deliverable.

    ExcelSQLPower BI

Technologies you’ll learn

The tools and disciplines this diploma covers, taken live from the academy’s own syllabus.

Excel for Data Analysis
Excel
SQL for Data Analysis
SQL
Python for Data Analysis
Python
Data Manipulation,Data Visualization
Pandas, Matplotlib, Seaborn
Business Intelligence
Power BI
Data Cleaning & Transformation
Power Query, Data Cleaning, Data Transformation
Data Modeling
Data Modeling, Relationships, Star Schema
DAX
DAX, Measures, Calculated Columns
Statistics
Descriptive Statistics, Correlation, Variance, Standard Deviation
Data Visualization
Charts, Dashboards, KPI Visualization
Databases
DBMS, Relational Databases, ERD

What you’ll learn

12 modules · 62 topics · 96 hours

Understand the role and lifecycle of a data analyst.

What you’ll learn

  • Data Analyst Role & Responsibilities
  • Types of Data
  • Data Lifecycle
  • Data-Driven Decision Making
  • Tools Overview (Excel, Python, SQL, Power BI, Tableau)
  • Data visualization and storytelling with Python (Matplotlib/Seaborn) and Tableau

You’ll build

  • A tools/workflow overview exercise
  • A Python data cleaning and EDA project
  • SQL queries and views for business reporting
  • A Power BI dashboard with a star-schema data model
  • An ETL pipeline using Power Query
  • A Tableau interactive dashboard with calculated fields and filters

Outcome

You'll understand the data analyst role and the tools you'll use throughout the diploma.

Master Excel as a core data analysis tool.

What you’ll learn

  • Data Entry & Formatting
  • Basic Formulas & Functions (SUM, IF, VLOOKUP/XLOOKUP)
  • Data Sorting & Filtering
  • Data Validation
  • Conditional Formatting

You’ll build

  • An Excel formula and validation exercise

Outcome

You'll be able to clean and analyze data confidently in Excel.

Turn Excel data into clear, effective charts and dashboards.

What you’ll learn

  • Chart Types (Bar, Line, Pie, Scatter)
  • Chart Design Principles
  • Dashboard Basics
  • Dynamic & Pivot Charts
  • Visual Best Practices

You’ll build

  • An Excel dashboard with dynamic and pivot charts

Outcome

You'll be able to build clear, effective Excel dashboards.

Clean, transform and analyze data programmatically with Python.

What you’ll learn

  • NumPy & Pandas DataFrames
  • Data Importing (CSV, Excel, JSON)
  • Data Cleaning & Missing Values
  • Data Transformation
  • Data Filtering, Merging & Joining

You’ll build

  • A Python data cleaning project

Outcome

You'll be able to clean and prepare data programmatically with Pandas.

Visualize and explore data using Python's plotting libraries.

What you’ll learn

  • Matplotlib
  • Seaborn
  • Plot Types
  • Data Exploration
  • Storytelling with Data

You’ll build

  • A Python EDA and visualization project

Outcome

You'll be able to explore and visualize data using Matplotlib and Seaborn.

Query and analyze relational data with SQL.

What you’ll learn

  • SELECT, WHERE, ORDER BY
  • Aggregations (COUNT, SUM, AVG)
  • GROUP BY & HAVING
  • JOINs
  • Subqueries and Views

You’ll build

  • A SQL business reporting project

Outcome

You'll be able to write SQL queries for real business reporting needs.

Apply statistics to support data-driven decisions.

What you’ll learn

  • Descriptive Stats
  • Distributions
  • Variability & Shape
  • Probability Theory
  • Hypothesis Testing

You’ll build

  • A hypothesis testing exercise on a real dataset

Outcome

You'll be able to apply statistical thinking to real data problems.

Build interactive business intelligence reports with Power BI.

What you’ll learn

  • Data Importing & Modeling
  • Relationships
  • DAX Basics
  • Measures & Calculated Columns
  • Reports & Dashboards

You’ll build

  • A Power BI report with measures and relationships

Outcome

You'll be able to build interactive Power BI reports from raw data.

Extract, transform and load data using Power Query.

What you’ll learn

  • Data Extraction
  • Power Query
  • Data Transformation & Cleaning
  • Data Refresh
  • Automation Basics

You’ll build

  • A Power Query ETL pipeline

Outcome

You'll be able to build ETL pipelines using Power Query.

Design efficient, well-structured data models.

What you’ll learn

  • Star Schema
  • Snowflake Schema
  • Fact & Dimension Tables
  • Cardinality & Cross Filtering
  • Performance Optimization

You’ll build

  • A star-schema data model project

Outcome

You'll be able to design efficient, high-performing data models.

Turn data models into compelling, interactive dashboards.

What you’ll learn

  • Visualization Types
  • Dashboard Design
  • Drill Down & Drill Through
  • Filters & Slicers
  • KPI Visualization

You’ll build

  • An interactive KPI dashboard in Power BI

Outcome

You'll be able to design interactive, decision-ready Power BI dashboards.

Build visual analytics and dashboards using Tableau.

What you’ll learn

  • Data Connections & Preparation
  • Worksheets & Dashboards
  • Calculated Fields & Parameters
  • Filters
  • Story Points
  • Tableau Publishing

You’ll build

  • A Tableau interactive dashboard (Capstone)

Outcome

You'll be able to build and publish interactive Tableau dashboards.

Curriculum is updated regularly to match market demand.

Prerequisites & who can start

What you need to start

  • Personal laptop
  • Basic computer skills
  • Basic knowledge of Microsoft Excel
  • Basic understanding of mathematics
  • Basic problem-solving skills

Who is this program for?

Built for people like you

  • Fresh Graduates who want to start a career in Data Analytics.
  • Beginners in Technology who want to enter the data field without prior professional experience.
  • Career Changers looking to transition into a high-demand data career.
  • Junior Data Analysts who want to strengthen their technical and analytical skills.
  • Business & Operations Professionals who want to make better decisions using data.
  • Professionals Working with Excel who want to move into advanced analytics and Business Intelligence.
  • Developers & Technical Professionals who want to expand into data analysis and BI.
  • Freelancers who want to offer data analysis, dashboard, and reporting services to clients.

Upcoming cohorts

Pick a start date and reserve your place.

18Sep

Starts Fri, 18 Sep 2026

in 11 Days

Group Data Analysis Online 109

7,500 EGP
06:00 PM10:00 PM Online (live)
FridaySaturday

Choose the Learning Experience That Fits You

Every option is live instructor-led, with the same projects, assessments and accredited certificate. Pick the format that fits your schedule.

The three ways to study this program, compared
FeatureOnline Live CohortOn Campus Live Cohort
Start DateFixedFixed
DeliveryLive OnlineLive On Campus
ScheduleFixed Weekly ScheduleFixed Weekly Schedule
Learning Hours9696
Mentor SupportLive InstructorLive Instructor
ProjectsIncludedIncluded
AssessmentsIncludedIncluded
CertificateIncludedIncluded
Ideal ForStudents who prefer a structured weekly scheduleLearners who enjoy face-to-face classroom interaction

Swipe the table to compare all three.

Start dates, times and prices for this program are in the enrollment card above.

Everything you need to succeed

What is included with every AMIT program, whichever format you choose.

Live Mentor Sessions

Learn directly from industry experts through interactive workshops, coaching, and Q&A.

Portfolio Projects

Build real-world solutions that demonstrate your practical skills.

Milestone Assessments

Reinforce your knowledge and unlock the next stage of your learning journey.

Expert Support

Receive guidance from mentors whenever you need help.

Learning Community

Connect, collaborate, and learn alongside other learners.

Progress Tracking

Monitor your milestones and stay on track toward graduation.

Certificate

Earn your diploma after successfully completing all program requirements.

Career Readiness

Prepare your portfolio and strengthen your confidence to apply your new skills professionally.

Frequently asked questions

Personal laptop Basic computer skills Basic knowledge of Microsoft Excel Basic understanding of mathematics Basic problem-solving skills

Data Analytics & Business Intelligence Diploma is 96 taught hours across 12 modules, delivered live by an instructor. The exact calendar length depends on the cohort you pick — see the start dates above for each schedule.

Both. This programme runs live online from anywhere and on campus at Maadi, Nasr City, Dokki Workspace. Every format is live instructor-led with the same projects, assessments and accredited certificate.

Live Online starts at 7,500 EGP, On Campus starts at 10,500 EGP. Installment plans are available — the options are shown at checkout.

Yes — an accredited certificate on successful completion of all program requirements. AMIT is ISO 9001:2015 certified and an ITIDA member, and its programs are accredited by the Egyptian Engineers Syndicate and the Applied Professionals Syndicate.

Recognized & accredited

Licensed by the Ministry of Communications & Information Technology

ISO 9001:2015 logo

ISO 9001:2015

ITIDA logo

ITIDA

Cisco Networking Academy logo

Cisco Networking Academy

Egyptian Engineers Syndicate logo

Egyptian Engineers Syndicate

Applied Professionals Syndicate logo

Applied Professionals Syndicate

Graduates of this program

In their own words

Taken from their own LinkedIn posts. 3 stories from Data Analytics & Business Intelligence Diploma graduates.

  • LinkedIn story

    11/2025
    I developed a professional Employee Analytics Dashboard using Microsoft Excel, designed to deliver clear insights into workforce structure, salary distribution, and performance indicators. Key Highlights: Executive KPIs for annual salary, monthly salary, headcount, and performance ratings…

    Abdelrahman Mohsen

    Data Analytics & Business Intelligence Diploma

    Post
  • LinkedIn story

    07/2026
    Over the past few months, I dedicated myself to learning new analytical skills and I'm proud to share that I have successfully completed the Data Analysis Diploma at AMIT Learning, achieving a 98% grade. Throughout this journey, I gained hands-on experience with: • SQL • Python • Excel • Power…

    Abdelrahman sultan

    Data Analytics & Business Intelligence Diploma

    Post
  • LinkedIn story

    02/2026
    I am thrilled to share that I have successfully completed the Business Intelligence Diploma with Creativa Innovation Hub - Menofia, sponsored by the Ministry of Communications and Information Technology (MCIT), Egypt, TIEC, and Information Technology Industry Development Agency, ITIDA…

    Abdulrahman said

    Data Analytics & Business Intelligence Diploma

    Post
Watch and read all graduate stories
On camera

Data Analytics & Business Intelligence Diploma students, on film

Filmed interviews and project walk-throughs from students on this programme.

  • Graduate story

    Ayaat

    Data Analytics & Business Intelligence Diploma

  • Graduate story

    Mohamed Moustafa Azmy

    Data Analytics & Business Intelligence Diploma

  • Graduate story

    Kermina Henaan

    Data Analytics & Business Intelligence Diploma

  • Graduate story

    Mina Waheed

    Data Analytics & Business Intelligence Diploma

  • Graduate story

    Mohamed Ali

    Data Analytics & Business Intelligence Diploma

  • Graduate story

    Michel Wael

    Data Analytics & Business Intelligence Diploma

  • Graduate story

    Islam Khaled

    Data Analytics & Business Intelligence Diploma

  • Graduate story

    Shehab Essam

    Data Analytics & Business Intelligence Diploma

  • Graduate story

    Bassant Salah

    Data Analytics & Business Intelligence Diploma

Flexible Payment Options

Invest in your future with payment solutions designed to fit your budget.

Instant online payments

  • Visa
  • Mastercard
  • Meeza card
  • Meeza mobile wallet

Card or mobile wallet — paid immediately, enrollment confirmed on the spot.

Buy now, pay later

  • ValU
  • Aman
  • Contact
  • Souhoola
  • Bank installments

Split the fee over installments with a provider or your bank.

Offline payment options

InstaPay and bank transfer — instructions are shown during checkout.

  • Secure payments
  • Flexible installments
  • Instant enrollment
Keep exploring

Related programs

  • CourseAI & Data

    AI for Human Resources

    Starting from
    2,900 EGP
  • CourseAI & Data

    AI for Marketing

    Starting from
    2,900 EGP
  • CourseAI & Data

    AI for Finance

    2,900 EGP
Career consultation

Not Sure Which Program Is Right for You?

Get Free Career Guidance from an AMIT Advisor

Tell us about your goals, interests, and experience. Our education advisors will recommend the program that best fits your career ambitions and answer your questions — completely free.

  • Free, no-pressure career guidance
  • Advisors help hundreds of students every month
  • Typically replies within one business day

Book a free consultation

By submitting, you agree to be contacted by AMIT about programs. We respect your privacy.

Ready to build your future?

Join the students who have developed practical technology skills through live instructor-led training and real-world projects.

From7,500 EGP2 ways to learn