Welcome to my portfolio!

Omar ElBahtieny

I'm

About

Hello, I'm Omar, detail-oriented Data Analyst with a strong foundation as a specialist in Python, Excel, and Power BI. I specialize in analyzing large datasets, creating dynamic dashboards, and delivering actionable insights to support data-driven decision-making, 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 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.

  • Name: Omar Essa Elbahtieny
  • Website: LinkedIn
  • Phone: +20 102 293 0212
  • City: Ismailia, Egypt
  • Domain: Sales, Marketing, Business, Logistic, Real Estate, Healthcare
  • Age: 23
  • Degree: Bachelor's
  • Email: Omar.Elbahtieny@gmail.com
  • Freelance: Available

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. If you're looking for someone who combines technical expertise with a genuine passion for data analysis, I'd love to connect and discuss how I can contribute to your team or project!

Tools Used Power BI, Python, Excel

Projects Completed Successfully delivered impactful insights

Team Collaboration Worked seamlessly with cross-functional teams

Hours of Learning Constantly evolving to stay ahead of trends

Portfolio

As a data analyst, I specialize in uncovering insights and creating impactful visualizations that drive decision-making. Below, you'll find examples of my work, including dashboards and projects that demonstrate my ability to analyze complex datasets and deliver actionable results. These showcase my skills in tools like Excel, Python, and Power BI, Each project reflects my dedication to solving problems through data-driven decision-making.

  • All

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

Detail-oriented Data Analyst with a strong foundation as a specialist in Python, Excel, and Power BI. Skilled in analyzing large datasets, web scraping, and creating dynamic dashboards. Dedicated to delivering actionable insights to support data-driven decision-making and drive business success. Proven ability to identify trends, optimize performance, and provide valuable solutions through advanced data analysis techniques.

  • Python for Data Analysis
  • Analyzing large Excel datasets to extract meaningful insights
  • Integrating multiple data sources and ensuring real-time data updates
  • Data cleaning using Python and Excel
  • Creating user-friendly reports with clear visualizations for informed decision-making using Power BI
  • Connecting and transforming data from Excel into reports using advanced DAX formulas and Power Query
  • Designing dynamic, interactive Power BI dashboards that offer clear and actionable visualizations
  • Time-series Analysis
  • Web scraping
  • Linear Algebra
  • Data Entry

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

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

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

  • Proficient in Python
  • Advanced Microsoft Excel
  • Power BI (Interactive Dashboards)
  • Data Pre-processing
  • Numerical Data Manipulation
  • Data Visualization
  • Time-series Analysis
  • Web Scraping
  • Linear Algebra and Statistics

Functional Skills

  • Analytical Skills: Research and interpret data
  • Project Management: Plan and organize processes
  • Data Visualization: Create engaging dashboards
  • Probing Skills: Define problems accurately
  • Problem-Solving: Develop innovative solutions

Soft Skills

  • Collaboration with cross-functional teams
  • Effective communication and storytelling
  • Stakeholder engagement and buy-in
  • Curiosity: Asking deeper questions
  • Intuition: Recognizing patterns and anticipating outcomes

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

Ismailia, Egypt

Call Us

+20 102 293 0212

Email Us

Omar.Elbahtieny@gmail.com