Skip to content
View ayaelhajjchehade's full-sized avatar
  • Lebanon
  • 02:02 (UTC -12:00)

Block or report ayaelhajjchehade

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
ayaelhajjchehade/README.md

Aya El Hajj Chehade

I am a final-year Management Information Systems student at Lebanese University preparing for a career in data analytics and business intelligence.

I use SQL, Python, Excel, and Power BI to clean data, investigate business questions, and build dashboards that turn raw information into practical recommendations.

I ranked seventh nationwide in the Lebanese Baccalaureate in Economics and Sociology, and I bring the same discipline and attention to detail to my data projects.

Currently seeking: Data Analyst and BI Analyst internships and entry-level roles Location: Lebanon Languages: Arabic and English


Skills

  • Languages: SQL, Python
  • Libraries: pandas, SQLAlchemy
  • Database: MySQL
  • Tools: Excel, Power BI, Jupyter Notebook, Visual Studio Code
  • Excel: Pivot tables, pivot charts, dashboards, XLOOKUP, slicers
  • Power BI: Power Query data cleaning, data modeling, DAX measures, interactive dashboards
  • Analytics: Data cleaning, exploratory data analysis, RFM segmentation, KPI dashboarding, relational data modeling

Featured Projects

An end-to-end analysis of the UCI Online Retail II dataset using MySQL, Python, pandas, and Excel. The project covers data cleaning, sales and returns analysis, customer and product analysis, revenue concentration, country-level trends, and RFM customer segmentation. The results are presented in an interactive Excel dashboard.

Key finding: The analysis identified a 1.76% return rate on £19.66 million in gross sales, resulting in £18.93 million in net revenue.

An interactive Power BI dashboard analyzing global tech layoffs from 2020 to 2026, covering trends over time, industry breakdowns, top companies, and regional comparisons. Cleaning, data modeling, and DAX measures were all built independently within Power BI and Power Query, and the project documents data-quality limitations such as missing values and reporting inconsistencies.

Key finding: The United States accounts for the large majority of recorded layoffs in the dataset, with Retail, Hardware, and Consumer as the hardest-hit industries.

A business-focused Excel dashboard that uses KPI cards, pivot tables, charts, and slicers to analyze employee attrition and help identify where attrition risk is concentrated.

A SQL-based data-cleaning and exploratory-analysis project using hotel booking data. It examines cancellations, booking patterns, pricing, market segments, lead time, and hotel type. This project demonstrates my practical SQL and data-quality work.


Additional Projects


Currently Learning

I recently completed my first Power BI project and am continuing to build on it with more advanced DAX and data modeling techniques.


Contact

Pinned Loading

  1. chinook-data-analysis chinook-data-analysis Public

    SQL + Python analysis of the Chinook music store database revenue trends, top customers/artists/genres, and employee performance, with SQLAlchemy-powered visualizations.

    Jupyter Notebook

  2. hotel-bookings-analysis hotel-bookings-analysis Public

    SQL cleaning and exploratory analysis of 119K+ hotel bookings cancellation patterns, seasonal trends, and City vs Resort hotel comparisons in MySQL.

  3. hr-attrition-analysis hr-attrition-analysis Public

    Excel dashboard analyzing employee attrition patterns using pivot tables, slicers, and interactive charts

  4. layoffs-data-analysis layoffs-data-analysis Public

    Power BI dashboard analyzing global tech layoffs (2020–2026) cleaning and modeling in Power Query, DAX measures, and an interactive dashboard covering trends, industries, companies, and regions.

  5. online-retail-data-analysis online-retail-data-analysis Public

    End-to-end data analytics project on the UCI Online Retail II dataset. Includes SQL data cleaning (MySQL), exploratory analysis and RFM customer segmentation in Python (pandas), and an interactive …

    Jupyter Notebook

  6. sales-data-analysis sales-data-analysis Public

    Python analysis of model vehicle sales data top products, countries, customers, and seasonal trends, visualized with matplotlib and seaborn.

    Jupyter Notebook