E-commerce Growth & Retention Analysis (Indonesia Market)
.svg)
Analyzed a 13M e-commerce dataset to identify a 72% churn rate and a critical 0% retention curve.
6 March 2026About Me
Data Analyst with hands-on experience turning complex datasets into actionable business insights. Skilled in Python, SQL, and Power BI, with a track record of improving campaign performance, predicting customer behavior, and automating workflows. Passionate about leveraging data to drive strategic decisions and measurable business outcomes.
Projects
Telecom Customer Churn Analysis
Analyzed U.S. telecom dataset (26% churn). Identified drivers like contract type and extra charges. Delivered Power BI dashboards highlighting churn patterns.
26 Sep 2025Car Insurance Claim Predictor
Built ML models to predict claims; Decision Tree achieved ~85% accuracy and app deployed with Streamlit for risk assessment.
19 Sep 2025Marketing Campaign Analysis – UK Personal Loans
Cleaned and analyzed 41K+ records from a bank campaign; recommended targeting improvements and script adjustments.
26 Aug 2025Customer Behavior & Sales Probability Modeling
Segmented e-commerce shoppers and built a binomial probability model to estimate purchase likelihood; found promotions improved conversions.
23 Aug 2025Academic Research – Competition Policy & Food Security
Used ARDL econometric analysis to test policy impacts on agricultural productivity and food security in Egypt (1990–2023).
Jan 2025 - Apr 2025Contact & Skills
If you'd like to discuss a project or opportunity, get in touch. I specialize in ETL pipelines, SQL, Python, and dashboarding (Power BI).
Contact
- Email: a.gamal.analytics@gmail.com
- Phone: +20 1550988826
- Location: Maadi, Cairo
- LinkedIn: linkedin.com/in/abdullah-gamal-abdelrahman
Technical Skills
- Python (Pandas, NumPy, Scikit-learn, Seaborn, Matplotlib)
- SQL (Joins, CTEs, Window Functions)
- Power BI (DAX, Power Query, Data Modeling)
- Excel (PivotTables, Power Query, VBA Basics)
- Data Analysis & Machine Learning: Cleaning, Wrangling, EDA, Classification Models, Model Evaluation, Cross-Validation
- Statistics & Econometrics: Hypothesis Testing, Time Series, ARDL Models
- ETL / ELT: Python Data Pipelines
- Data Visualization: Interactive Dashboards & Reports
Experience
Real Estate Marketer at Al-Madaen Real Estate Company | Oct 2021 – May 2025
- Designed and executed Facebook ad campaigns (organic & paid), increasing leads by 50–60% and boosting customer acquisition.
- Optimized targeting and content strategies, resulting in a 65% increase in engagement and higher-quality inquiries.
- Prepared marketing materials and presentations to assist clients in property selection and closing deals.
- Marketed properties, gathered market intelligence, and delivered insights that supported deals and client satisfaction.
Education
Beni-Suef University — Bachelor of Economics (Minor in Statistics), 2025
Certifications
- Data Scientist Associate — DataCamp (Issued Sep 2025)
- Data Analyst in Python — DataCamp (Jul 2025)
- Associate Data Analyst in SQL — DataCamp (June 2025)