Certificate Verification
Data Analysis - Full Roadmap (120H)
Issued on 20 Sept 2026
✓ Verified
Official TechTrek record
Certificate Summary
Student Name
Abdullah Mohamed Mohamed Mahmoud Elgondakly
- Certificate ID
- CERT_000672
- Verification Status
- Verified
- Certificate
- Data Analysis - Full Roadmap (120H)
- Issue Date
- 20 Sept 2026
Academic Information
- University
- Alexandria National University
- College
- Computer Science
- University Student ID
- 2305388
- Track
- Data Analysis & Business Intelligence
- Credit Hours
- 120 H
- Delivery Mode
- Hybrid
Learning Roadmap
Curriculum topics are displayed from the Roadmap snapshot stored on this certificate.
Level 1 - Module 1: Statistics & Excel Fundamentals
- Intro to Data Analysis Concepts
- Basic Statistics (Mean, Median, Mode)
- Advanced Statistics (Variance, SD, Correlation)
- Advanced Excel Functions (VLOOKUP, INDEX, MATCH)
- Conditional Logic (IF, SUMIFS, COUNTIFS)
- PivotTables & Pivot Charts
Level 1 - Module 2: Data Cleaning & Excel Mastery
- Intro to Power Query (Import & Clean)
- Handling Duplicates, Nulls & Errors
- Advanced Power Query Transformations
- Data Type Conversion & Calculated Columns
- Full Data Analysis Cycle in Excel
- Complete Excel Capstone Project
Level 1 - Module 3: SQL & Databases
- Intro to Databases & PostgreSQL
- SQL Basics (SELECT, WHERE, GROUP BY)
- Intermediate SQL (Joins & Subqueries)
- Advanced SQL (Window Functions, CTEs)
- Data Pipelines Concepts
- End- to- End SQL Project
Level 1 - Module 4: Power BI & DAX Mastery
- Intro to Power BI Interface & Workspace
- Data Modeling in Power BI
- Essential DAX (SUMX, CALCULATE, RELATED)
- Advanced DAX (FILTER, RANKX, VAR)
- Power BI Visualizations (Charts, Cards, Slicers)
- Interactive Dashboards Building
Level 2 - Module 5: Tableau & Integration
- Intro to Tableau Interface & Basics
- Visualizations & Calculated Fields
- Interactive Filters & Superstore Dataset
- Tableau Dashboard Design (Kaggle Data)
- Final Capstone (Excel + Power BI + Tableau)
Level 2 - Module 6: Python Programming & EDA
- Python Basics & Data Structures
- NumPy for Numerical Computing
- Pandas for Data Manipulation
- Data Visualization (Matplotlib & Seaborn)
- Exploratory Data Analysis (EDA)
- Python Data Cleaning Mini- Project
Level 2 - Module 7: Machine Learning Foundation
- Intro to ML & Scikit- Learn Setup
- Linear & Logistic Regression
- Classification vs. Regression
- Decision Trees & Random Forest
- Model Evaluation Metrics
- Foundational ML Project
Level 2 - Module 8: Career Prep & Final Presentations
- GitHub Portfolio Setup
- Resume & CV Writing for Data Roles
- Mock Interviews (Technical & HR)
- Final Capstone Presentation
Completed Tasks
✓Python Fundamentals – Data Structures, Loops & Conditions
✓Pandas Data Manipulation, Grouping & Sales Analysis
✓End-to-End Machine Learning – EDA, Preprocessing & Model Building
✓Excel Data Cleaning & Sales Analysis
✓Sweet Delight Chocolates – Excel Sales Analysis
✓Dashboard in Power Bi
✓Data cleaning
✓HR Dashboard
✓Power Bi
✓Search about MTD PMTD YTD PYTD MOM YOY