Mostafa Hassan El-Sonbaty's Work | ContraWork by Mostafa Hassan El-Sonbaty
Mostafa Hassan El-Sonbaty

Mostafa Hassan El-Sonbaty

Data Analyst turning raw data into clear, actionable insight

New to Contra

Mostafa is building their profile!

Followed by GALLERY L

Cairo, Egypt

WorkAbout

Cairo, Egypt

Cover image for Advanced Automated Analytical Pipeline: Developed an
Advanced Automated Analytical Pipeline: Developed an end-to-end automated analytical pipeline using Python to transition from manual ad-hoc analysis to a scalable, production-ready solution for multinational retail data. Architecture: Engineered a modular, Object-Oriented Programming (OOP) class structure to handle complete ETL workflows, including programmatic data cleaning, duplicate removal, and outlier handling. Optimization: Enhanced system performance by building dynamic memory optimization functions that compressed numeric types and converted redundant objects to categories. Feature Engineering: Engineered strategic business metrics, such as Profit Margins and Shipping Durations, to enrich the dataset for deeper analysis. Automated Reporting: Programmed the pipeline to instantly calculate and output an Executive KPI Report processing nearly 10,000 orders and tracking $2.29M in revenue while simultaneously generating and exporting a suite of advanced EDA visualizations (seasonality trends, correlation matrices, and logistical efficiency charts).
0
31
Cover image for E-Commerce Sales Performance: Designed and developed
E-Commerce Sales Performance: Designed and developed an interactive dashboard to analyze e-commerce sales performance using a Superstore dataset. Key contributions: • Data Preparation: Cleaned and structured raw data in Microsoft Excel (handling missing values, formatting fields) to ensure data integrity. • Data Modeling & DAX: Built dynamic measures in Power BI including Total Revenue, Total Orders, and Average Order Value (AOV). • Visualization: Created clean, interactive visual reports to highlight top-performing regions, category trends, and overall business growth. • UI/UX: Focused on a "Clean Dashboard" design using customized gradients, transparent backgrounds, and strategic layout alignment for clear stakeholder communication.
0
29
Cover image for Corona Marketing Project - Corono
Corona Marketing Project - Corono Ice Cream: This project was created as part of the Management of Marketing course at Helwan University (BIS Department). The goal was to select a real company, analyze its market, and propose a new product that could realistically be launched. We chose Corona Company, a well-known Egyptian chocolate and confectionery brand, and proposed a new ice cream product line named Corono.
0
20