Data Analyst with less than a year in Data Analysis & Visualization
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Data-driven professional with hands-on experience in managing, cleaning, and analyzing structured datasets to drive informed decision-making. Skilled in Excel, performance tracking, and data control processes, with a strong ability to transform raw data into actionable business insights. Currently mastering advanced data visualization, dashboard creation, and data modeling using Power Pivot and Pivot Tables. Passionate about identifying operational patterns, improving efficiency, and supporting business outcomes through clear, impact-driven reporting.
Cairo University
Bachelor of Specific Education · Music
N/A – Present
Marketing Analytics Project
June 1, 2026 – June 1, 2026
Built a comprehensive analytics solution to optimize marketing spend and regional performance. Managed the full data lifecycle, including Data Cleaning and Normalization via Power Query. Architected data using Star Schema modeling and developed dynamic DAX measures to visualize key insights and improve decision-making.
IMDb Movie Analytics Project
June 1, 2026 – June 1, 2026
Developed a comprehensive dashboard to visualize movie trends, ratings, and viewership distribution. Managed the full data lifecycle, including Data Cleaning and Normalization via Power Query to ensure data integrity. Architected data using Star Schema modeling and implemented complex DAX measures to analyze performance metrics across different decades and movie classifications.
Bank Customer Churn Analysis Project
June 1, 2026 – June 1, 2026
Developed a comprehensive dashboard to analyze customer churn behavior and identify key retention drivers. Managed the full data lifecycle, including Data Cleaning and Normalization to ensure data accuracy and integrity. Built a structured data model and utilized advanced Excel functions and interactive tools to visualize key performance metrics such as churn rates, spending patterns, and customer activity levels.
Sales & Shipping Analytics Project
June 1, 2026 – June 1, 2026
Developed an interactive dashboard to monitor total sales, order quantities, and shipping costs. Streamlined data preparation by performing comprehensive Data Cleaning and Normalization to optimize the dataset for accurate analysis. Built a structured data model and utilized advanced Excel tools to visualize key performance metrics such as profit margins and regional sales distribution.
Adidas Sales & Customer Insights Performance
June 1, 2026 – June 1, 2026
Developed an interactive, multi-page Power BI dashboard to analyze retail performance, tracking 7M EGP in Revenue and 4M EGP in Profit across 214K+ orders. Applied data normalization techniques to eliminate redundancy and structured an optimized Star Schema data model for high-performance querying. Utilized advanced DAX to calculate dynamic profit margins, monthly trends, and product performance metrics. Visualized critical customer demographics and distribution channel performance (Franchise vs. Retail) to enhance strategic decision-making. Designed a clean user interface with a custom navigation home page and global slicers for seamless interactivity.
Superstore Sales & Performance Dashboard
June 1, 2026 – June 1, 2026
Developed an interactive dashboard tracking $2.30M in Sales and $286.40K in Profit across 9,994 orders. Performed Data Cleaning and transformation in Power Query to ensure data integrity and quality. Applied Data Normalization to build an optimized Star Schema model for efficient querying. Utilized advanced DAX to analyze operational KPIs across shipping modes, regions, and categories. Designed a clean UI with interactive slicers and a Decomposition Tree for deep-dive analysis.
HR & Salary Analytics Dashboard
June 1, 2026 – June 1, 2026
Developed an interactive workforce dashboard in Excel tracking a Total Salary of 1.31M and employee metrics across multiple departments. Utilized Power Query for Data Cleaning, transformation, and structuring the raw HR dataset. Applied Data Normalization principles to build an optimized data model using Power Pivot. Created dynamic calculations and insights using Pivot Tables and advanced Excel functions to analyze salary distributions, average performance, and experience by location. Designed a comprehensive visual interface with interactive Slicers for deep-dive workforce analysis.
Excel, Power Bi Data Analysis Diploma
Growth level Academy
June 1, 2026 – Present
Cultural Fit Analysis
The candidate's project portfolio demonstrates a strong initiative for self-learning and practical application, which aligns well with a proactive and growth-oriented culture. The diversity of projects (marketing, movies, banking, sales, HR) indicates adaptability and a broad interest in applying data analysis across different business contexts. The focus on creating impact-driven reports suggests a results-oriented mindset. The lack of professional experience means cultural fit is primarily assessed through personal projects and certifications.
Soft Skills & Operational Fit
The candidate's resume highlights soft skills such as Problem Solving, Analytical Thinking, Attention to Detail, Communication Skills, Teamwork, and Time Management. These are crucial for a Data Analyst role, indicating a good operational fit for collaborative and detail-oriented tasks. The project descriptions demonstrate a structured approach to problem-solving and a focus on delivering actionable insights.