Mohab Ahmed
Data AnalystJunior Data Analyst
Semicolon Codes
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Junior Data Analyst
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Motivated high school student with hands-on internship experience as a Data Analyst at Semicolon Codes, where I contributed to real-world data projects involving data quality assurance, exploratory analysis, and business reporting. Passionate about transforming raw data into meaningful insights that drive informed decisions. Eager to grow and apply my analytical skills in a Junior Data Analyst or Data Analyst Intern role
Ebda'a National School for Technical Sciences
High School · Data Analysis Engineering
N/A – Present
Semicolon Codes
Data Analyst Intern
December 1, 2025 – January 31, 2026
Cairo, Cairo Governorate, Egypt
MB1 Company Sales Analysis
June 16, 2026 – Present
Built a star schema data model connecting 5 interrelated tables (Orders, Products, Customers, Order Details, Calendar) to enable multidimensional analysis Performed data cleaning and transformation including fixing negative prices, handling null values, standardizing date types, and normalizing categorical fields Engineered DAX calculated columns for Revenue, Discount Amount, Net Sales, and Profit — scoped to delivered orders only for analytical accuracy Analyzed $629.6M in net sales and $86.6M total profit, revealing Electronics as the dominant category (64% of profit) and Alexandria as the top city ($30M) Designed an interactive Excel dashboard with dynamic slicers (Date, City, Category), KPI cards, and 4 chart types covering sales trends, product performance, and geographic distribution
View ProjectStore Database – SQL Analysis Project
June 16, 2026 – Present
Designed and implemented a normalized relational database (4 tables: Customers, Products, Orders, OrderDetails) with proper primary and foreign key constraints Wrote SQL queries using JOINs, aggregations, and filters to retrieve customer data, analyze product pricing, and calculate total revenue across transactions Performed product sales performance analysis by aggregating quantities sold per product using GROUP BY and INNER JOIN across multiple tables
View ProjectAdventureWorks Sales & Product Analytics
June 16, 2026 – Present
Imported and modeled multi-table sales data in Power BI, building relationships across products, orders, customers, and time dimensions using a structured data model Cleaned and transformed raw data using Power Query, resolving inconsistencies before analysis Created DAX measures to calculate Revenue, Profit, and Order trends across products, cities, and time periods Identified peak sales months (Jan, May, Jun, Dec) and flagged underperforming periods (Feb, Sep, Nov) through time series analysis to support marketing planning Delivered geospatial and product-level insights, revealing Components and Clothing as top performers and flagging 10 low-profit products for strategic review Designed an interactive Power BI dashboard combining time series, geospatial maps, and profitability charts for executive decision-making
View ProjectShopNile — End-to-End Data Analysis Project
June 16, 2026 – Present
Built a full data pipeline from raw messy data to an interactive dashboard, covering 4 datasets (500 customers, 120 products, 3,000 orders, 3,050 payments) Applied comprehensive data cleaning including deduplication, null handling, outlier capping, type correction, and text normalization across all datasets using Pandas Designed a star schema data model linking Orders as the fact table to Customers, Products, and Payments dimension tables Developed an interactive Streamlit dashboard with Plotly charts covering revenue trends, city performance, top products, and payment method breakdown Deployed the dashboard publicly on Streamlit Cloud, demonstrating end-to-end delivery from raw data to a live, shareable web application
View ProjectData Analyst in Power BI
DataCamp
April 1, 2026 – Present
Data Analysis with Excel Power Tools
DataCamp
January 1, 2026 – Present
Excel Fundamentals
DataCamp
December 1, 2025 – Present
The candidate scored 90% on the 'Application Developer — Microsoft Analytics (Power BI)' test, indicating a strong grasp of Power BI functionalities, including data modeling, DAX, and visualization.
Strengths
Cultural Fit Analysis
The candidate's diverse personal projects, covering Excel, SQL, Power BI, and Python, demonstrate a proactive learning attitude and a broad interest in data analysis tools and methodologies. The internship experience, though short, shows an ability to work in a professional setting. The focus on end-to-end data analysis projects, from raw data to deployed dashboards, indicates a results-oriented mindset. This breadth of skills and project diversity suggests a good cultural fit for a dynamic data team.
Soft Skills & Operational Fit
The candidate's project descriptions highlight strong analytical skills, attention to data integrity, and the ability to present findings clearly through dashboards. The internship experience further demonstrates practical application of these skills in a business context. The candidate appears motivated and eager to apply their skills, which aligns well with a junior data analyst role.
Limitations