About
Highly motivated Data Analyst with a proven track record in leveraging SQL, Power BI, and Excel to transform complex datasets into actionable insights and interactive dashboards. Expert in data cleaning, transformation, and visualization, consistently delivering solutions that uncover business trends and support data-driven decision-making. Eager to apply advanced analytical and technical skills to solve real-world problems and drive significant business impact within a dynamic organization.
Work
Shoppe Express E-commerce Analysis
|E-commerce Data Analyst / BI Developer
Alexandria, Alexandria, Egypt
→
Summary
Built a comprehensive E-commerce analytics dashboard using Power BI for Shoppe Express, providing a clear view of business health and growth opportunities.
Highlights
Constructed a comprehensive E-commerce analytics dashboard in Power BI, enabling robust tracking of online store performance for Shoppe Express.
Transformed raw sales and customer data into interactive visualizations, enhancing data accessibility and understanding.
Provided a clear, real-time view of business health and growth opportunities, facilitating proactive strategic adjustments.
Empowered stakeholders with actionable insights derived from customer data, optimizing marketing and sales strategies.
Salary Dashboard Analysis
|Data Analyst
Alexandria, Alexandria, Egypt
→
Summary
Designed an interactive salary dashboard using Microsoft Excel to analyze income distribution and trends across categories, supporting dynamic insights and decision-making.
Highlights
Developed an interactive salary dashboard in Microsoft Excel, providing dynamic analysis of income distribution and trends across diverse categories.
Leveraged Pivot Tables, charts, and slicers to create highly interactive visualizations, enhancing user engagement and data exploration.
Improved data visualization strategies to effectively communicate key salary patterns and support informed decision-making.
Enabled stakeholders to easily identify and understand complex salary trends, facilitating strategic HR and compensation planning.
Sales Data Modeling & Reporting
|Data Modeler & Reporting Specialist
Alexandria, Alexandria, Egypt
→
Summary
Built advanced data models and automated reporting processes using Power Pivot and DAX in Excel, significantly improving efficiency and decision-making capabilities.
Highlights
Constructed advanced data models using Power Pivot and DAX in Excel, enhancing data integration and analytical capabilities.
Automated data cleaning processes with Power Query, reducing manual effort and improving data quality for reporting.
Developed comprehensive dashboards to track key performance metrics, enabling real-time performance monitoring and strategic adjustments.
Improved reporting efficiency and supported better decision-making through streamlined data processes and insightful visualizations.
Coffee Shop Sales Analysis
|Data Analyst
Alexandria, Alexandria, Egypt
→
Summary
Developed an Excel-based sales analysis system to identify peak hours and top-selling products, enhancing business decision-making and sales performance.
Highlights
Created an advanced sales analysis system in Excel, accurately identifying peak hours and top-selling products to optimize operations.
Utilized Pivot Tables and Slicers to build interactive reports, providing dynamic data exploration capabilities for stakeholders.
Performed thorough data cleaning to ensure accuracy and reliability of sales data, supporting robust analytical outcomes.
Generated actionable insights that directly improved sales performance and informed strategic business decisions.
Adidas US Sales Analysis
|Data Analyst / BI Developer
Alexandria, Alexandria, Egypt
→
Summary
Led the design and development of a 3-page interactive Power BI dashboard to analyze Adidas US sales performance and trends, providing key insights for strategic decision-making.
Highlights
Designed and implemented a 3-page interactive Power BI dashboard, enabling comprehensive analysis of US sales performance and trends.
Executed robust data cleaning and transformation using Power Query, ensuring data integrity and readiness for advanced analytics.
Developed complex data models with DAX to accurately calculate critical metrics such as revenue and profit, driving informed business strategies.
Identified top-performing products and regions through data-driven insights, contributing to optimized sales and marketing efforts.
Education
Alamein International University
→
Bachelor
Computer Science
Languages
English
Arabic
Certificates
Google Data Analytics Professional Certificate
Issued By
Coursera from Google
Build with AI – Google & ITI (Top 5,000 Developers) Program
Issued By
Google & ITI
Skills
Data Analysis & Business Intelligence
Power BI, DAX, Power Query, Star Schema, Advanced Excel, Pivot Tables, Power Pivot.
Data Visualization
Interactive Dashboards, Data Storytelling, Visual Reporting, Insight Presentation.
SQL (PostgreSQL)
PostgreSQL, ETL Processes, Data Modeling, Normalization, Efficient Queries.
Programming Basics
Python, Java, Data Handling, Logic Building.