AVAILABLE FOR ROLES
GDG Obour Data Lead
ahmedalfeqi.is-a.dev

Transforming Complex Data Into

Hi, I’m Ahmed Alfeqi — a Data Analyst & BI Specialist proficient in Power BI, SQL, Python, and DAX. With a strong background in Competitive Programming (3x ECPC Qualifier), I combine analytical rigor with clean data modeling to deliver enterprise-grade dashboards.

Power BI DAX & Star Schema
SQL & Python Analytics & ETL
ECPC 3x Qualifier
iSchool Coding Instructor
GDG Obour Data Track Lead
Ahmed Alfeqi

Ahmed Alfeqi

VERIFIED

Achievement

3x ECPC Qualifier

Specialization

Power BI & DAX

ABOUT ME

Analytical Rigor Meets Business Strategy

Who I Am

Data Analyst & Collegiate Problem Solver based in Cairo, Egypt

I am a motivated and detail-oriented Data Analyst with a deep passion for unlocking the stories hidden within complex datasets. My journey in technology started with intense competitive programming, mastering C++, Data Structures, and Algorithms, which culminated in qualifying for the prestigious Egyptian Collegiate Programming Contest (ECPC).

This algorithmic foundation gives me a distinctive advantage when architecting Power BI Star Schemas, writing high-performance DAX queries, and cleaning high-cardinality databases with SQL & Python.

Beyond pure analytics, I have honed valuable leadership and communication skills serving as Data Analysis Track Lead at GDG on Campus Obour, as an Instructor Assistant at iSchool, and previously as Head of HR & Technical Coach at CPC, where I mentored dozens of aspiring software engineers and data practitioners.

LOCATION Cairo, Egypt
EDUCATION Obour Institutes (Senior)
LANGUAGES Arabic (Native), English (B1)

Star Schema Data Modeling

Designing normalized dimension tables and fact tables with strict relationship cardinality to avoid bi-directional performance penalties.

Advanced DAX Calculations

Formulating calculated measures, time intelligence (YoY, MoM), dynamic KPIs, and Row-Level Security (RLS) for enterprise governance.

SQL Query Optimization

Crafting robust multi-table joins, subqueries, CTEs, aggregation windows, and data cleaning routines for accurate analytical pipelines.

Algorithmic Problem Solving

ECPC qualification demonstrates sharp critical thinking under time pressure, data structure efficiency, and mathematical deduction.

SKILLS & TECH STACK

Equipped with Industry-Standard Tools

BI & Visualization

Core
Microsoft Power BI Advanced (95%)
Data Modeling & Star Schema Advanced (90%)
DAX (Calculated Columns & Measures) 90%
Advanced Excel (Pivot, Power Query) 88%
RLS Interactive Drill-down KPI Dashboards Power Query ETL

Databases & Code

Technical
SQL (Joins, CTEs, Window Functions) 92%
Python (Pandas, Data Cleaning) 82%
C++ & Algorithmic Programming 88%
Data Structures & Algorithms 90%
MySQL / PostgreSQL Data Pipelines Git / GitHub ETL Processes

Leadership & Mindset

Interpersonal
Complex Problem Solving 95%
Team Leadership & HR Management 92%
Technical Mentorship & Coaching 94%
Executive Communication & Reporting 88%
Recruitment Evaluation Cycles Workshop Facilitation Analytical Thinking
FEATURED DATA PROJECTS

Impact-Driven Business Intelligence

Explore actual enterprise architecture, data modeling strategies, and interactive KPIs built for operational success.

PowerBI_InternetSales_Executive_Dashboard.pbix
Featured BI Project View on GitHub
Retail & E-Commerce Intelligence

Executive Internet Sales Analytics Dashboard

Comprehensive Power BI executive sales suite engineered to track retail transaction performance, customer demographic patterns, product margins, and territorial revenue drivers.

Star Schema Data Model: Integrated fact_InternetSales with normalized dimension tables (dim_Customer, dim_Product, dim_SalesTerritory).
Advanced DAX Calculations: Developed dynamic measures for Total Revenue, Profit Margins, YoY Sales Variance %, and Unit Economics.
AI Decomposition Trees: Implemented AI-powered root-cause visual trees to dissect high-value customer segments and regional profit drivers.
Custom SVG Layouts & UX: Tailored sleek, dark-themed SVG backgrounds and executive card visuals for optimal cognitive readability.
Technologies Used
Power BI Desktop DAX Star Schema Decomposition Trees Power Query ETL

Interactive Analytics Demo

Click tabs to toggle between metrics

Total Revenue

$3.42M

+18.4% YoY
Avg Profit Margin

24.6%

+3.2% vs target
Sales Volume

60.3K

Online Orders
Return on Sales

41.2%

Gross Efficiency
Star Schema: 1 Fact, 3 Dimensions Live Repo: PowerBI-Sales-Analysis-Dashboard
Cairo Weather Data Pipeline & Analytics Banner
VIDEO DEMO • 1m 24s
Watch on YouTube 1080p
Meteorological BI GitHub

Cairo Weather & Climate Analytics Dashboard

An interactive Power BI meteorological analytics dashboard built on multi-year historical weather data for Cairo, Egypt. Analyzes micro-climate trends, temperature variances, and atmospheric dynamics.

  • Temperature Dynamics: Tracks daily highs/lows, mean temperature, and apparent "feels-like" heat index correlations.
  • Atmospheric Factors: Statistical modeling of precipitation probability, relative humidity distributions, and cloud cover %.
  • Wind & Pressure Correlation: Visualizes wind speed gusts against barometric sea-level pressure.
  • Custom Power BI Theme: Designed structured JSON themes & SVG visuals for modern visual analytics presentation.
Power BI Desktop Time-Series DAX Power Query ETL Custom Theme JSON
GitHub Repo
SWVL Business Intelligence & Analytics Banner
VIDEO DEMO • 2m 04s
Watch on YouTube 1080p
Mobility Operations GitHub

SWVL Operational & Financial Dashboard

Enterprise Power BI dashboard analyzing SWVL operational metrics, ride volume efficiency, customer booking patterns, and macro-financial variables across regional markets.

  • Star Schema Modeling: Fact Orders connected to Dim Customer, Dim Region, Dim Route, and Dim Calendar.
  • DAX Measures: Tracking Total Revenue, YoY Growth %, Net Profit Margin, and Seat Utilization.
  • Row-Level Security (RLS): Dynamic regional data governance for localized operational management.
  • Drill-Down Analytics: Weekend vs. Weekday demand curves and territorial tax/currency impact.
Power BI Desktop Row-Level Security Star Schema Advanced DAX
View Repo
CAREER & LEADERSHIP

Work Experience & Community Impact

2026 – Present • Leadership

Data Analysis Track Lead

Google Developer Groups on Campus (GDG) • Obour Institutes

  • Curriculum Leadership: Design and orchestrate the complete technical roadmap for the Data Analysis track, providing structured learning paths for student developers.
  • Hands-on Workshops: Conduct intensive, interactive sessions covering Excel, Power BI, SQL, and Python for data analytics.
  • Cohort Mentorship: Guide student cohorts through end-to-end data pipeline challenges, real-world case studies, and portfolio building.
Jun 2026 – Present

Coding & Tech Instructor (Part-Time)

iSchool • Cairo, Egypt (On-site)

  • Assist Lead Instructors in delivering interactive computer science, coding, and programming sessions for students.
  • Guide students through hands-on technical exercises, troubleshooting errors, and explaining core programming logic.
  • Evaluate student assignments and projects, providing constructive, structured feedback to optimize their learning curves.
2024 – 2025

Technical Coach & Head of HR

Competitive Programming Community (CPC) • Cairo

  • Technical Coaching: Mentored and trained students in C++, Data Structures, and Algorithms, significantly improving their logical reasoning.
  • HR Leadership: Directed the HR department by managing end-to-end recruitment, member evaluations, and facilitating soft-skills development.
  • Key Milestone: Successfully qualified for the prestigious Egyptian Collegiate Programming Contest (ECPC).
2026 – Present • Leadership

Data Analysis Track Leader

GDG on Campus Obour • Google Developer Groups

  • Direct the Data Analysis curriculum and learning track for university students across Obour Institutes.
  • Mentor members through hands-on technical workshops covering SQL querying, Power BI dashboards, and Python analytics.
  • Organize collaborative hackathons, real-world case study deep-dives, and technical training sessions.
CREDENTIALS & HONORS

Verified Certifications & Academic Background

Click any certificate to inspect the full-resolution verified document, credentials, and curriculum details.

HIGHER EDUCATION Senior / 4th Year Expected: 2027

Bachelor’s Degree in Management, Computers & Information Systems

Higher Obour Institute for Management, Computers and Information Systems • Cairo, Egypt

Foundational studies in quantitative analytics, computer science architectures, relational database management systems, and discrete mathematics. Represented Obour Institutes across three consecutive years in the Egyptian Collegiate Programming Contest (ECPC).

ACADEMIC STATUS Senior (4th Year)
Data Engineering Camp Certificate
Inspect Full Size
DATA ENGINEERING
Issued: 29 Apr 2026 Verified Completion

Data Engineering Camp

Alaa Essam & Ibrahim El Nwasany

Practical training program covering scalable data infrastructure, ETL pipeline architecture, SQL for Data Engineering, and Data Warehousing concepts.

Data Pipelines ETL SQL Warehousing
EraaSoft 100-Hour Data Analyst Diploma
Inspect Full Size
ERAASOFT • 100H DIPLOMA
Completed: 28 Jan 2026 EraaSoft Accredited

100-Hour Data Analyst Professional Diploma

EraaSoft Academy • Certified Diploma

Successfully completed a 100-hour comprehensive professional Data Analyst diploma with EraaSoft, gaining solid hands-on experience in Excel, Power BI, SQL, and Python.

Excel Power BI SQL Python
PDF
IBM SkillsBuild Data Fundamentals Certificate
Inspect Full Size
IBM SKILLSBUILD
Issued: 29 Sep 2026 Credly Verified

Data Fundamentals

IBM-SkillsBuild • Credly Badge

Demonstrated core competencies in big data concepts, data management architectures, and analytical workflows. Verified by IBM SkillsBuild on Credly.

Data Fundamentals Big Data IBM SkillsBuild Credly
iSchool Certificate of Completion
Inspect Full Size
ISCHOOL • TUTOR
Completed: 15 Oct 2026 2026 Intake

Dedicated & Talented Tutor

iSchool • Aya Elnaggar (Head of Education)

Awarded for successfully completing the 2026 Intake as a dedicated programming tutor, contributing to raising the next generation of tech leaders. Accredited by STEM, IAIDL, kidSAFE, and Education Alliance Finland.

STEM Accredited IAIDL kidSAFE Computer Science
NASA Space Apps Challenge Certificate
Inspect Full Size
GLOBAL HACKATHON
Nov 14–15, 2026 NASA International

Galactic Problem Solver

2026 NASA Space Apps Challenge • Marc Kuchner

Presented for outstanding participation and technical collaborative efforts in addressing critical scientific challenges we face on Earth and in space.

NASA Space Science Planetary Data
2026 ICPC ECPC Qualifications Certificate
Inspect Full Size
ICPC ECPC 2026
13 Aug 2026 168th Place

ECPC 2026 Qualifications

Higher Obour Institute • Day 2 Contest

Awarded One-hundred Sixty-eighth Place in the official Egyptian Collegiate Programming Contest (ECPC) Qualifications, solving complex algorithmic challenges.

ICPC Foundation C++ Algorithms
2025 ICPC ECPC Qualifications Certificate
Inspect Full Size
ICPC ECPC 2025
02 Aug 2025 122nd Place

ECPC 2025 Qualifications

Higher Obour Institute • Day 3 Contest

Awarded One-hundred Twenty-second Place in the official Egyptian Collegiate Programming Contest (ECPC) Qualifications, demonstrating speed and mathematical precision.

ICPC Foundation Data Structures Competitive Math
2024 ICPC ECPC Qualifications Certificate
Inspect Full Size
ICPC ECPC 2024
23 Jul 2024 174th Place

ECPC 2024 Qualifications

Higher Obour Institute • Day 4 Contest

Awarded One-hundred Seventy-fourth Place in the 2024 ICPC ECPC Qualifications, marking my collegiate debut in high-stakes competitive programming.

ICPC Foundation Algorithms Problem Solving
Coach Academy Problem Solving Certificate
Inspect Full Size
PROBLEM SOLVING L2
Issued: 2025 Coach Academy

Problem Solving Level 2

Coach Mohamed Abdel Wahab (FCIH Head Coach)

Advanced problem-solving methodologies, graph algorithms, dynamic programming paradigms, and time/space complexity optimization.

C++ Algorithms Dynamic Prog
PDF
GET IN TOUCH

Let’s Build High-Impact Data Solutions Together.

Whether you are looking for an ambitious Data Analyst for your team, need a custom Power BI Dashboard, or want to collaborate on analytical projects, feel free to reach out anytime!

Direct Email ahmed.alfeeqi@gmail.com
Phone & WhatsApp +20 109 717 5629
Based in Cairo, Egypt (Available for On-site & Remote)

Send a Direct Message

Fills into your default mail client or connects via WhatsApp instantly.