George Ayad

I'm George.

Data Analyst

Transforming complex datasets into actionable insights.

My Services

Data Cleaning and Preparation

I clean and prepare raw data to ensure it is accurate, consistent, and ready for analysis. This includes handling missing values, removing duplicates, and transforming data into a usable format.

Data Visualization and Dashboard Creation

I create interactive and visually appealing dashboards using tools like Tableau, Power BI, and Python libraries (e.g., Matplotlib, Seaborn) to help stakeholders understand data insights at a glance.

Reporting and Insights Delivery

I deliver actionable insights through detailed reports and presentations, tailored to the needs of stakeholders. My reports are clear, concise, and focused on driving decision-making.

SQL Database Querying and Optimization

I write efficient SQL queries to extract, manipulate, and analyze data from relational databases. I also optimize database performance for faster query execution.

Machine Learning Model Development

I design and implement machine learning models to solve complex business problems. This includes data preprocessing, feature engineering, model selection, and evaluation using Python libraries like Scikit-learn and TensorFlow.

Data Pipeline Automation

I automate data pipelines to streamline data collection, transformation, and loading processes. Using tools like Apache Airflow and Python, I ensure data flows seamlessly from source to destination.

George Ayad
About Me

As a recent Data Analyst and a self-proclaimed data enthusiast with an insatiable passion for "data-driven decisions", I deeply understand the transformative impact that data analysis can have on any business's performance. As I continue to hone my skills and mindset, I'm dedicated to unleashing the full potential of data in driving business success.

My Background
2019 High School Score: 90% 2023 Bachelor's Degree Future University 2024 Master's Degree Helwan University 2025 Thesis Completion Software Engineering
2019 High School Score: 90% 2023 Bachelor's Degree Future University 2024 Master's Degree Helwan University 2025 Thesis Completion Software Engineering
Skills & Tools

Programming Languages

MySQL icon

MySQL

Python icon

Python

Data Analytic Tools

Excel icon

Excel

Pandas icon

Google Sheets

Jupyter Notebook icon

Jupyter Notebook

Jupyter Notebook icon

Visual Studio Code

Data Visualization

PowerBI icon

PowerBI

Tableau icon

Tableau

PowerBI icon

Docker

Additonal

Tableau icon

Github

PowerBI icon

Figma

Portfolio

Some previous projects, but I am eager to take on more.

Tech Filter
  • Excel
  • Power BI
  • Tableau
  • Google Sheets
  • SQL
  • Python
Drug Sales Analysis Dashboard

UK Railway

Power BI, SQL, Excel, Tableau, Python

A complete end-to-end project for data cleaning, modeling, analysis, and forecasting in the UK railway sector This project was developed as part of the Digital Egypt Pioneers Initiative (DEPI) under the Google Data Analytics Specialist Track.

GitHub Power BI Tableau
Drug Sales Analysis Dashboard

Drug Analysis

Power BI

Designed Power BI dashboards analyzing drug transactions, revenue, and profit metrics.

GitHub Power BI
Healthcare Patient Flow Analysis Dashboard

Healthcare Patient Flow Analysis

Power BI

Analyzed appointment data to optimize scheduling and resource allocation in a hospital environment.

GitHub Power BI
Transportation Analysis Dashboard

Transportation Analysis

Power BI

Built dashboards for tracking peak hours, riders, and key business indicators.

GitHub Power BI
Bike Analysis Dashboard

Bike Analysis

Excel

Created an interactive dashboard for sales managers to monitor team performance.

GitHub
Sales Dynamic Analysis Dashboard

Sales Dynamic Analysis

Power BI, SQL

Analyzed sales data to identify trends and optimize performance.

GitHub Power BI
Bank Loan Analysis Dashboard

Bank Loan Analysis

Excel, Power BI, SQL

Built dashboards for tracking loan metrics, reducing delinquency rates by 15%.

GitHub
HR Analysis Dashboard

HR Analysis

Excel, Tableau, Power BI, SQL

Analyzed HR data to improve employee performance and retention.

GitHub Tableau
Gaming Agency Progress Tracker

Gaming Agency Progress Tracker

Google Sheets

Tracked and analyzed progress for a gaming agency using Google Sheets.

GitHub
typing

Contact Me

Wanna say a friendly hello? Reach out & let’s build something together!



Β© Last Update: 15/1/2024 Made by George Ayad.