Hi, I'm Malak — a Data Analytics student and freelance data analyst based in Cairo. I transform raw datasets into clean, meaningful insights.
I'm a Data Science student at Canadian International College, specializing in Data Analytics. I enjoy digging into messy datasets, cleaning them up, and surfacing insights that actually matter to the people reading them.
From e-commerce dashboards to flight delay analysis, I've worked with real-world data across multiple domains using Python, Excel, and Power BI. I communicate results clearly — whether the audience is technical or not.
I offer beginner-friendly freelance rates and am open to collaborations, internships, and entry-level opportunities.
Data wrangling, EDA, and visualization using Pandas, NumPy, Matplotlib, and Seaborn.
Advanced formulas, Pivot Tables, Power Query, and dynamic dashboards in Microsoft Excel.
Interactive dashboards, DAX measures, slicers, and visual storytelling for business data.
Querying and managing structured data with MySQL and SQLite.
Handling nulls, duplicates, outliers, and inconsistent formats to prepare clean datasets.
Clear, structured PDF reports and presentations that communicate findings to any audience.
Real datasets, real insights. Each project reflects end-to-end analysis from raw data to final report.
Full sales dashboard tracking total profits (204K+), 6,544 orders, average delivery days, return rate, and profit margin. Includes interactive slicers by product category and region across Egypt.
Power BI dashboard analyzing airline departure delays, on-time arrival/departure rates, worst and best performing airports and airlines. Includes causes-of-delay breakdown (carrier, weather, NAS, security).
Deep-dive pivot analysis breaking down net sales and profit by category (Beauty, Electronics, Fashion, Grocery, Home) and subcategory. Includes brand performance tables and category sales share charts.
KPI dashboard tracking $3M+ total profit, average profit margin (0.43), shipping cost (7.04), and quantity (128K). Includes monthly sales trend, gender and payment method filters, and device type breakdown.
Power BI dashboard analyzing U.S. retail and food sales trends, performance metrics, and category breakdowns. Covers regional comparisons, top-performing segments, and sales growth over time.
Sales performance dashboard for the Central Region built with Excel and Power Query. Includes data cleaning, transformation, KPI tracking, and visual breakdown of sales trends across categories and time periods.
Have a dataset that needs cleaning, a dashboard to build, or a report to write? I'd love to hear about your project. Fill in below and I'll get back to you.
Malak Yousof Ahmed · Data Analyst · Cairo, Egypt