Welcome to my portfolio!
Omar Essa ElBahtieny
About
Data doesn’t drive decisions on its own… but the right analysis can change the direction of an entire organization. I’m a Data Analyst and Data Operations Lead at Mersal Foundation, specializing in transforming messy, unstructured data into scalable systems that support real business decisions. I don’t just analyze data… I solve problems like: Lack of visibility in performance Fragmented data across multiple sources Slow, manual reporting processes By leveraging SQL, Excel, Python, Google Sheets, and Power BI, I build structured databases, automate workflows, and design interactive dashboards that turn complexity into clarity. One of my key achievements was leading the transformation of 100+ fragmented files into a unified, enterprise-ready database—reducing reporting time by 75% and enabling faster, more accurate decision-making. I currently lead a data team, ensuring high-quality data collection and delivering advanced analytical reports to internal leadership and international partners such as UNHCR, supporting strategic planning with reliable, data-driven insights. What sets me apart is my approach: I start with understanding the business and defining the right KPIs before building any dashboard—so every number tells a story, and every insight drives action. I’m passionate about data quality, innovation, and building scalable systems that empower organizations to make smarter decisions. I’m always learning, always improving, and always looking for new challenges where I can create real impact. Let’s connect and explore how data can drive better decisions.!
Data Analyst & Power BI Developer.
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.5+ Years
- Age: 25
- Current Role: Data Analyst
- Current Employer: Mersal Foundation
- Email: Omar.Elbahtieny@gmail.com
- Work Type: Full-time, Freelance, Remote
- Industries: Healthcare • Charity • Business Intelligence
- Primary Tools: Excel, Power BI, SQL, Google Sheets
- Data Skills: Data Cleaning • ETL • Data Modeling • DAX • Power Query
- Dashboard Expertise: Executive Dashboards • KPI Tracking • Interactive Reports
- Reporting: Executive Reports • Performance Analysis • Decision Support
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.
Professional Moments
A glimpse into my professional journey, work environment, and achievements.
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 decision-making 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 sources
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
Dec, 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.
- Contributed to the foundation of a comprehensive information system aimed at enabling strategic planning, performance monitoring, and evidence-based decision-making. 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
Supported the coordination of the data team and supervised data entry activities, ensuring timely and accurate data collection from multiple sources.
- Supported the coordination of a 6-member data team, improving data collection, quality assurance, and reporting workflows. Collaborated with my manager to implement data governance and documentation standards, contributing to the development of a scalable and reliable internal data infrastructure.
- Developed a centralized database by consolidating 100+ heterogeneous files across four departments using Excel and Python. The unified data foundation improved data consistency and reduced report generation time from weeks to under two hours, enabling faster and more reliable reporting.
- Slashed monthly reporting cycle by 75% — from 3–4 days to 1 day — by automating reporting workflows in Excel and Power BI, shifting from manual department-based data collection to direct extraction from a centralized structured source.
- Eliminated reporting duplication and improved data accuracy by redesigning case tracking with new unique case level IDs — replacing imprecise family-level aggregation using Excel, producing audit-ready datasets trusted by top management for strategic decisions.
- Produced Excel and Power BI analytical reports consumed by top management, PR, and 3+ operational departments — directly informing executive decision-making, external publications, and cross-departmental operational planning.
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, and 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
Throughout 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
Feel free to reach out for collaborations, opportunities, or any inquiries.
Address
Maadi, Cairo, Egypt
Phone
+20 102 293 0212
Omar.Elbahtieny@gmail.com
linkedin.com/in/omar-elbahtieny
GitHub
github.com/OmarElbahtieny