Welcome to my portfolio!

Omar Essa ElBahtieny

About

I am a Data Analyst and Data Operations Lead at Mersal Foundation with strong experience in transforming messy, unstructured data into structured databases that drive decision-making. Skilled in SQL, Excel, Google Sheets, and Power BI, I specialize in building interactive dashboards, automating reports, and cleaning large datasets for actionable insights. I currently lead a data team, ensuring accurate data collection from diverse sources, and deliver advanced analytical reports to both internal leadership and international partners such as UNHCR. My work supports strategic planning by providing data-driven insights and automated solutions. I help businesses make confident, data-driven decisions by turning complex data into clear, actionable insights. With a strong focus on data quality, innovation, and scalable systems, I build solutions that enable smarter decision-making. I am always eager to learn new skills and embrace challenges. I believe that continuous learning is the key to growth, and I strive to expand my knowledge and share it with others. Whether you're here to learn about my work, collaborate, or simply get inspired, I hope you enjoy exploring my journey as much as I’ve enjoyed creating it. Let’s discover the power of data together.!

Data Analyst & Power Bi Develeper.

I’d be happy to connect and explore how I can support your project or business. I specialize in data cleaning, analysis, and dashboard creation, helping organizations uncover insights, track performance, and make smarter decisions with clarity and confidence.

  • Name: Omar Essa Elbahtieny
  • Website: LinkedIn
  • Phone: +20 102 293 0212
  • Location: Maadi, Cairo
  • Experience: 1+ Years in Data Analysis
  • Age: 25
  • Current Role: Data Analyst
  • Email: Omar.Elbahtieny@gmail.com
  • Work Type: Full-time, Freelance, Remote
  • Domains: Healthcare Analytics, Sales Analysis
  • Primary Tools: Excel, Power BI, SQL, Google Sheets

Tools Used Excel, Power BI, Python, Sql

Projects Completed Successfully delivered impactful insights

Team Collaboration Worked seamlessly with cross-functional teams

Years of Experience Hands-on experience in data analysis and reporting

Portfolio

As a Data Analyst, I specialize in uncovering insights and creating impactful visualizations that drive decision-making. Below are examples of my work, including dashboards and projects that showcase my ability to analyze complex datasets and deliver actionable results using tools like Excel, Python, and Power BI. Each project demonstrates my dedication to solving problems with data-driven solutions.

  • All

10 Years Mersal

Retail Sales

Retail Sales

Retail Sales

Retail Sales

Retail Sales

Retail Sales

Cafe Rewards

Bike Sales Dashboard

Supermarket Sales

Employee Report

Sales

Marketing

Sales

Sales, Products&Gender

Sales, Country&City

Sales

Resume

I am a data analyst dedicated to uncovering trends and analyzing data to enhance performance and understand customer needs. I strive to deliver clear insights that empower businesses to make data-driven decisions.

Summary

Omar Essa

Data Analyst with hands-on experience in cleaning, organizing, and analyzing large datasets using Python, Excel, SQL, and Power BI. Skilled in building automated dashboards, creating integrated data models, and transforming unstructured data into actionable insights. Lead data operations at Mersal Foundation and support decisionmaking for fundraising, marketing, and strategic planning

  • Python for Data Analysis
  • Analyzing large Excel datasets to extract meaningful insights
  • Integrating multiple data sources and ensuring real-time data updates
  • Data cleaning and preprocessing using Excel and Python
  • Creating user-friendly reports and clear visualizations for informed decision-making using Power BI
  • Connecting and transforming Excel data into interactive Power BI reports
  • Web scraping and data extraction from online so

Course and Certificates

Data Analysis Course Using Python

In “Data Analysis Internship Program” from Raqameyyah, Oct 2024
  • Introduction to Data Analysis
  • Python Basics for Data Analysis
  • Math & Statistics for Data Analysis (EDA)
  • Libraries: Numpy, Pandas, Matplotlib, Seaborn

DEPI, Egypt's Digital Pioneers Initiative

Ministry of Communications and Information Technology, Oct 2024
  • Python for Data Analysis
  • Excel Advanced

Python Data Analysis Diploma

Udemy, Jun 2024
  • Introduction to Data Science & Analysis
  • Math & Statistics for Data Analysis (EDA)
  • Pandas Basics (Data Analysis)
  • Advanced Pandas | Data Pre-processing (Data Wrangling)
  • Advanced Pandas | Data Importing & Web Scraping

Preparing Youth for Labor Market

Misr El Kheir Foundation and Raya Contact Center, Sep 2023
  • Communication Skills
  • Presentation Skills
  • Basics of Project Management
  • Basics of Marketing
  • Time Management(15 days)

Google Data Analytics Professional Certificate

Coursera, Aug 2023
  • Data Analysis, Creating Case Studies
  • Data Visualization, Data Cleansing
  • Developing a Portfolio, Data Collection
  • Metadata, Data Ethics, Data Aggregation
  • Data Calculations, Software, Presentation
  • Data Integrity, Sample Size Determination
  • Decision-Making, Problem Solving

Relevant Projects

Design and Implementation of a Unified Medical Data Integration & Analytics System at Mersal Charity Foundation

Des, 2025

  • Led the collection, standardization, and cleaning of 10 years of historical data from multiple departments to build a unified and reliable database for the Information Center.
  • Integrated datasets from diverse sources using Excel, SQL, and Power Bi, resolving inconsistencies and improving data accuracy.
  • Designed structured data models ready for in-depth analysis and automated reporting.
  • Developed interactive dashboards and analytical reports using Power BI to support top management with real-time, data-driven insights.
  • Developed interactive dashboards and analytical reports using Power BI to support
  • Contributed to the foundation of a comprehensive information system aimed at enabling strategic planning, performance monitoring, and evidence-based decisionmaking. Tools & Skills: Data Analysis · Data Cleaning · Data Modeling · SQL · Excel · Power BI · Power Query · ETL · Data Quality · BI Reporting · KPI Tracking

RETAIL SUPPLY CHAIN SALES DATASET

Jan, 2025

  • Comprehensive Sales and Returns Analysis
  • I conducted an in-depth analysis of sales, returns, and discounts over a multi-year dataset, identifying key trends, seasonal patterns, and regional performance. I developed actionable strategies to optimize inventory, adjust pricing, and reduce return costs, successfully exceeding profit margin targets. I also designed dashboards and reports to present insights, enabling data-driven decisions that improved sales and operational efficiency.

Company Sales from 2017 to 2020

Nov, 2024

  • Designed three interactive dashboards to analyze and visualize company performance
  • Monthly and quarterly sales and profits over multiple years
  • Customer preferences segmented by gender and top-selling products
  • Branch profitability and sales, including top-performing countries

Maven Cafe Rewards - Offers Completed

Oct, 2024

  • Python code + Report + Presentation + Dashboard + Explanatory Video
  • Identified key customer segments and developed a data-driven strategy for promotional messaging and future targeting
  • Analyzed offer success across demographics and channels, revealing men and age groups 50-70 as the most responsive. Discount offers were most popular, with web, email, mobile, and social channels proving highly effective. Recommended tailoring messages for men, focusing on top offers, and optimizing effective channels.

Make an Interactive Board for Al-Omar Company - Personal Project

Mar, 2023

  • Used Power BI to create a control panel for Al-Omar company data
  • Implemented multiple plans and data visualizations to track net amounts based on imported data
  • Applied filtering to view sales data for each of the three branches

Employee Report - Personal Project

Feb, 2023

  • Designed a professional Power BI control panel for employee data
  • Implemented multiple schemes for decision-makers to view employee information efficiently

Professional Experience

Data Analyst & Data Operations Lead, Mersal Foundation for Charity

Lead the data team and supervise data entry personnel to ensure timely and accurate data collection from diverse sources.

  • Built structured databases from highly unstructured data sources, including administrative reports, incomplete legacy files, external systems, and healthcare centers.
  • Consolidated and cleaned data from 4 departments and more than 100+ heterogeneous files, transforming messy and inconsistent datasets into a single highquality database used for analytics and reporting.
  • Developed and maintained automated dashboards and monthly performance reports using Power BI and Excel.
  • Delivered analytical reports to internal leadership and external partners, supporting funding decisions, operational planning, and impact tracking.
  • • Provided insights to social media and fundraising teams, enabling data-driven advertising strategies and campaign performance optimization.
  • Esablished data documentation standards and contributed to the long-term development of Mersal’s internal data infrastructure

    • Skills

    Equipped with a strong technical and analytical skill set, I excel at turning data into valuable insights, My diverse expertise spans data analysis, problem-solving, and effective collaboration to drive business success.

    Technical Skills

    • Python (Pandas, NumPy, Matplotlib, Seaborn), automation scripts, data transformation
    • SQL (Microsoft SQL Server), querying, cleaning, and transforming structured data
    • Power BI (Power Query, DAX basics, dashboard design, KPI tracking)
    • Microsoft Excel & Google Sheets (advanced formulas, dashboards, data validation)
    • ETL Operations (Extract, Transform, Load)
    • Data Modeling & Database Management (relational databases)
    • Web Scraping using Python (requests, BeautifulSoup, APIs)
    • Statistics & Linear Algebra fundamentals

    Data Skills

    • Data Cleaning & Data Wrangling
    • Exploratory Data Analysis (EDA)
    • Data Quality Management & Data Validation
    • Data Preparation & Data Transformation
    • Data Aggregation & Calculations
    • Reporting & Insights Generation
    • Performance Analysis & KPI Tracking

    Soft Skills

    • Team Collaboration: Leading and coordinating with data teams and departments
    • Effective Communication: Presenting findings clearly to both technical and non-technical audiences
    • Critical Thinking: Challenging assumptions and making data-driven decisions
    • Curiosity & Intuition: Exploring beyond surface-level trends for deeper insights
    • Adaptability: Managing unstructured and incomplete data under tight deadlines
    • Problem Solving & Analytical Skills & Attention to Detail & Data-Driven Decision Making\

    Business Intelligence Skills

    • Data Visualization
    • BI Reporting & Dashboard Creation
    • Real-time reporting & interactive dashboards
    • Business Intelligence (BI) concepts
    • Cross-departmental reporting workflows

    Services

    I offer data analysis services, including cleaning and organizing large datasets, identifying trends and insights, and creating interactive dashboards using tools like Power BI and Excel. My goal is to help businesses make data-driven decisions with clarity and confidence.

    Python for Analysis

    Using Python, I analyze and clean datasets, automate tasks, and generate insights using libraries like Pandas and Matplotlib.

    Power BI Reports

    I design user-friendly Power BI reports, presenting data clearly to support informed decision-making.

    Excel Analysis

    I process large Excel datasets, apply advanced formulas, and create charts to highlight key trends and insights.

    Data Cleaning

    I clean and organize data using Python and Excel, ensuring accuracy by handling duplicates, missing values, and errors.

    Interactive Dashboards

    I build real-time Power BI dashboards with advanced DAX and Power Query, providing actionable and dynamic insights.

    Data Integration

    I combine data from multiple sources, ensuring consistency and enabling seamless updates for unified reporting.

    Testimonials

    hroughout my journey, I have completed several specialized courses that have helped enhance my skills and increase my ability to analyze and present data effectively. These certifications provided me with advanced techniques in data processing, statistical analysis, and extracting insights from data, enabling me to deliver high-quality results in all my projects, Each course has been a significant step in developing my expertise, providing me with the necessary tools and methodologies to tackle complex data challenges and make data-driven decisions that add value to any organization.

    Google Data Analytics Professional Certificate: (Online Course) Coursera.org. (156 total hours) Aug, 2023. "Data Analysis, Data Cleaning, Data Viz, Data Aggregation, Data Integrity, Problem Solving"

    Google Data Analytics

    Coursera.org

    Python Data Analysis Diploma: (Online Course) Udemy (41 total hours). "Intro to Data, Math & Statistics (EDA), Python Numpy & Pandas (Data Importing & Web Scraping, Data Pre-processing, Time-series), Matplotlib & Seaborn, Real-life Projects & Case-studies."

    Python Data Analysis Diploma

    Udemy

    DEPI: (Interactive course) Online and physical (For 4 Months). Technical: Python & Excel, Soft Skills, Freelancer, English. Ministry of Communications and Information Technology.

    DEPI Initiative

    Ministry of Communications and Information Technology

    PYTHON DATA ANALYSIS COURSE: (Interactive course) (For 6 Months) Oct, 2024. With Engineer Mustafa Othman in "Data Analysis Internship Program" from Raqameyyah Company. "Introduction to Data Analysis, Python Basics for Data Analysis, Math & Statistics for Data Analysis (EDA), Libraries: Numpy, Pandas, Matplotlib, Seaborn."

    Python Data Analysis Course

    Raqameyyah Company

    Preparing Youth for Labor Market, Misr El Kheir Foundation and Raya Contact Center Sep, 2023. Content: "Communication Skills, Presentation Skills, Basics of Project Management, Basics of Marketing, Time Management". (15 days)

    Preparing Youth for Labor Market

    Misr El Kheir Foundation & Raya Contact Center

    Contact

    I’m always excited to connect and collaborate—feel free to reach out and let’s create something amazing together!

    Address

    Maadi, Cairo

    Call Us

    +20 102 293 0212

    Email Us

    Omar.Elbahtieny@gmail.com