Summary

Detail-oriented Data Analyst with expertise in SQL, Excel, Power BI, and Python, dedicated to translating complex datasets into clear, impactful insights. Skilled in data visualization, simplifying technical findings for diverse audiences, and uncovering hidden patterns beyond raw numbers. Adept at storytelling with data, crafting compelling narratives that drive informed decision-making. Experienced in designing interactive dashboards, conducting training sessions, and collaborating across teams to enhance data-driven strategies. Passionate about delivering actionable insights that bridge the gap between data and decision-makers.

Experiences
May 2025 – present | Cairo, Egypt
  • Develop forecasting models using Python (Pandas, Statsmodels) to predict, enabling proactive planning and optimized scheduling.
  • Collaborate with the finance team to analyze and manage monthly budgets and financial statements, ensuring data accuracy and supporting cost-reduction initiatives.
  • Design dynamic dashboards in Power BI to track KPIs.
  • Automated financial and operational reporting workflows using Power BI and Python.
  • Provided data-driven recommendations that improved budget allocation and enhanced visibility for senior management.
  • CLS Digital Egypt Pioneers Initiative (DEPI), Data Analytics Instructor
    December 2025 – Present | Cairo, Egypt
  • Delivered training on data analytics fundamentals, data-driven decision-making, and Excel-based visualizations for DEPI participants.​
  • Taught Power BI end-to-end: data extraction, Power Query cleaning, data modeling, DAX, and interactive dashboard/​report development.​
  • Introduced Azure data services, Tableau visualization, and data governance concepts, and supervised capstone projects using real-world datasets.​
  • October 2025 – Present | Cairo, Egypt
  • Delivered advanced Excel training on Power Query, Power Pivot, and DAX language for data modeling.
  • Conducted Power BI sessions covering DAX time intelligence, calculated columns, and performance optimization techniques.
  • Mentored students in complex data modeling, relationship management, and Microsoft Power BI certification preparation.
  • Provided supplementary training on SQL for data analysis, Python data manipulation with Pandas, and Power Automate workflow automation.
  • NeuroTech⁠, Part time Data Analysis Instructor
    December 2024 – October 2025 | Cairo, Egypt
  • Taught key data analysis tools and techniques, including Python, statistics, SQL, Power BI, and Excel, to students in the diploma.
  • Designed and delivered instructional materials for each module, ensuring a deep understanding of both theoretical concepts and practical applications.
  • Guided students in building real-world projects, focusing on data collection, cleaning, and visualization to develop their skills.
  • Provided one-on-one mentoring and support to students, helping them apply data science methods to solve real-world challenges.
  • Developed assessment materials and graded assignments to track students' progress and mastery of the course content.
  • Collective Routes, Part time Data Analyst
    April 2023 – April 2025 | Giza, Egypt
  • Conducted quantitative data analysis for research projects at Collective Routes, utilizing Excel and Power BI.
  • Analyzed research data to generate statistical reports and extract valuable insights.
  • Designed interactive dashboards using Power BI to visually communicate research findings effectively.
  • Provided training sessions on Power BI usage, empowering researchers to analyze and present data proficiently.
  • DADRI Data Research Institute
    Senior Data Analyst and Researcher
    January 2019 – October 2022 | Giza, Egypt
  • Managed 19 social dataset projects utilizing Excel and Power BI to collect and analyze over 10,000 data points, resulting in accurate information indicators and forecasts.
  • Established and oversaw the "Modern Egypt program," which launched databases for modern Egypt's social history.
  • Led and trained a team of 3 members, increasing their technical capabilities and improving project efficiency by 15%.
  • Conducted multiple workshops on advanced Excel skills, dataset building, and analysis, resulting in a 50% increase in participants' data analysis abilities.
  • Junior Data Analyst and Researcher
    September 2017 – December 2018 | Giza, Egypt
  • Analyzed 5 social dataset projects using Excel and Power BI with 95% accuracy, totaling 5,000 data points.
  • Conducted exploratory studies and literature reviews to support project objectives.
  • Authored and prepared 20+ technical, research, and evaluation papers and reports, achieving an average rating of 4.5 out of 5 from project stakeholders.
  • Technical Skills
    Python
    Tableau
    Data Analytics
    N8N
    SQL
    Microsoft Excel
    Data Cleansing
    Power Automate
    SQL Server (SSIS) (SSAS) (SSRS)
    Microsoft Power Query
    Data Visualisation
    Power BI & Dax Language
    Data Modeling
    Exploratory Data Analysis
    Top Projects

    This Power BI project provides an interactive analysis of Adventure Works business performance, covering sales, profit, returns, products, pricing, and customer insights. It includes executive KPIs, trend analysis, what-if scenarios, drillthrough pages, and Q&A features to support deeper exploration

    Al Amreyah Cement Budget Analysis Report⁠, Power Bi, Excel, Power Query

    This Power BI project provides an interactive financial analysis of Al Amreyah Cement, covering revenue, expenses, profitability, budget variance, balance sheet position, liquidity, and working capital. It is designed to support financial diagnosis and highlight performance gaps.

    AB-Testing and SQL Analysis with Python⁠, Python, Jupyter notebook, Pandas, Numpy, Matplotlib, Seaborn
    December 2024

    Python project for A/​B testing analysis using Pandas, SQL, and statistical testing to compare CTR performance between test and control groups.

    This project addresses the water crisis in Maji Ndogo through comprehensive SQL analysis. Leveraging data-driven solutions, it aims to understand water access issues, assess water quality, and propose strategies for improvement.

    This project presents a complete SQL-based business analysis using the AdventureWorks database. It answers 15 key business questions covering sales performance, customer behavior, product insights, inventory analysis, and geographic performance.

    Forecasting Website Traffic - Case Study⁠, Python, Pandas, Numpy, Matplotlib, seaborn, Statsmodels, Plotly

    This project develops a time series forecasting model to predict website traffic for TheCleverProgrammer.com⁠. The analysis covers visitor data from June 2021 to June 2022, with the goal of understanding traffic patterns and building accurate predictions for future periods.

    Diamond Price Analysis and Forecasting⁠, Python, Pandas, Numpy, Matplotlib, seaborn, Scikit-learn, Plotly

    This project focuses on analyzing diamond prices based on their characteristics (carat, cut, color, clarity, etc.) and building a predictive model to estimate diamond prices.

    The project aimed to analyze employee survey data using Microsoft Excel. The dataset included responses from employees across different departments, with varying levels of agreement/​disagreement on several statements. The goal was to import, clean, analyze, and visualize the data to derive meaningful insights regarding employee satisfaction and areas for improvement within the organization.

    Diabetes Prediction Model using Regression⁠, Python, Regression, Jupyter Notebook

    This project aims to develop a predictive model to determine whether a patient has diabetes based on certain diagnostic measurements. The dataset used for this analysis is originally from the National Institute of Diabetes and Digestive and Kidney Diseases. The objective is to diagnostically predict whether a patient has diabetes using various medical predictor variables.

    This project centers around a movie database containing comprehensive information about movies, including details such as titles, release dates, actors, genres, awards, and more.

    Courses & Certificates
    Data Science program⁠, ExploreAI & ALX Academy
    May 2023 – August 2024

    The ALX Data Science Program is a rigorous, hands-on course that taught me strong data analysis and data science skills. I gained proficiency in Python, SQL, and machine learning techniques such as regression and classification. I also developed expertise in data visualization using Matplotlib and Seaborn, enabling me to turn complex datasets into actionable insights. I completed real-world projects on data wrangling, cleaning, and statistical analysis during the program. I applied data science methodologies to solve business problems and provide data-driven insights, enhancing my ability to analyze large datasets and present findings.

    Data Science & Machine Learning Certificate⁠, Microsoft Student Club EELU
    October 2024 – February 2025

    Completed a 5-month intensive program covering key data science tools and concepts including Python fundamentals, NumPy, Pandas, Matplotlib, Power BI, and machine learning basics. The program emphasized hands-on learning, version control (Git/​GitHub), and real-world projects to build digital and analytical skills relevant to the job market. Developed a strong foundation in data analysis and applied these skills in community and academic contexts.

    Data Visualization in Power BI, DataCamp

    Currently mastering audience-centric Power BI visualizations for clear and relevant insights. Developing skills in emotional connection through ongoing exploration of concise dashboard elements like bar charts and small multiples. Actively exploring and implementing cognitive load reduction techniques in Power BI for enhanced data communication.

    Introduction to Python Programming. Introduction to Data Analysis using Anaconda and Python data analysis packages. Data Wrangling, Clean data using Python and Pandas, and data visualization using Python.

    Ask questions and answer them using data. Calculate key business metrics in financial analysis and interpret the values. Forecast financial metrics using scenario analysis, Digital Freelancing and the used platforms "globally and in the Arab world", and build an identity to work as a freelancer.

    Intro to Descriptive Statistics, Udacity

    Intro to Research Methods. Create and interpret histograms, bar charts, and frequency plots. Central Tendency, Variability, Standardizing, Normal Distribution, Sampling Distributions.

    Education
    Bachelor's degree, Faculty of Commerce and Business Administration, Helwan University
    May 2019 | Cairo, Egypt