Hi
I'm
Data Analyst
"Data tells the story, I help you read it."
About Me
I'm a Data Analyst with a background in Decision Support & Operations Research from the Faculty of Computers and Artificial Intelligence, Cairo University. I work with data to uncover patterns, measure performance, and turn raw information into clear insights that support better business decisions.
I have hands-on experience working with real business data across different projects and companies. At Almia Chem, I worked with ERP data to analyze sales and purchasing activities, track sales representatives' performance against targets, and build recurring reports and dashboards using Excel and Power BI. I also worked with Reef Group on Power BI reporting, validating measures and KPI logic within a Microsoft Fabric semantic model.
My technical toolkit includes Power BI, SQL, Excel, Python, and Microsoft Fabric, with experience in data cleaning, analysis, data modeling, KPI development, dashboard building, and extracting actionable insights from business data.
Beyond analysis, I enjoy sharing knowledge and working with others. I've worked as a Data Analysis Instructor at Flashat and led the Data Analysis Committee at Star Union, where I taught Excel and Power BI, mentored members, and supported data-focused projects.
I'm interested in solving real business problems through data and building analytical solutions that are clear, practical, and useful for decision-making.
Work Experience
Data Analyst
Reef Group (Cosmetics) · Remote · Part-time
- Rewired two Sales Reports to connect them to a new semantic model, ensuring correct data relationships and reporting logic.
- Reviewed and validated approximately 36 report pages to ensure consistency across KPIs, measures, and calculations.
- Performed data validation and quality checks to ensure reliability and accuracy of reporting outputs.
Data Analyst
Almia Chem · Full-time
- Analyzed data from the company's ERP system to support reporting and generate actionable business insights.
- Prepared daily, weekly, and monthly reports using Excel and Power BI to track KPIs and sales trends.
- Analyzed sales data and monitored sales representatives' performance against targets.
- Tracked company expenses, purchases, and returns to ensure data accuracy and consistency.
- Supported data-driven decision-making through interactive dashboards and clear visual analysis.
Projects
A collection of dashboards and analyses where raw data became a decision — built in Power BI, Excel, and SQL.
Medical Sales Performance Dashboard
A dynamic dashboard to track sales performance and target achievement, featuring a Galaxy Schema data model.
Adventure Works | Internet Sales Analysis
A multi-page dashboard analyzing two years of sales data against budgets, identifying market trends, and informing business strategy.
HR Analysis Dashboard
An interactive dashboard analyzing workforce data to understand demographics, identify attrition trends, and support retention strategies.
Sales Analysis Dashboard (Excel)
An interactive dashboard built entirely in Excel to analyze over 256M in revenue, identifying sales trends, top products, and high-performing outlets.
Udemy Courses Performance Analysis
An interactive dashboard analyzing Udemy's course data to provide insights on revenue, student engagement, and performance optimization for creators and managers.
CallSentier Analysis & Automation
A smart customer support solution that combines real-time translation, sentiment analysis, workflow automation, and interactive dashboard reporting to monitor customer interactions and agent performance.
Education
Cairo University
Faculty of Computers & Artificial Intelligence
Major: Decision Support & Operations Research
Volunteering
Head of Data Analysis Committee
Star Union · Education
- Leading the Data Analysis Committee, setting the direction for projects and learning initiatives.
- Mentoring members and guiding them through hands-on data analysis projects to build practical skills.
- Analyzing Star Union's internal data to generate insights that support better organizational decisions.
Academic Member – Data Analysis Instructor
Flashat · Education
- Conducted online sessions teaching Data Analysis using Excel to students from various backgrounds.
- Covered the main stages of data analysis: data cleaning, exploratory analysis, and visualization.
- Provided hands-on explanations of Pivot Tables, basic DAX, ETL concepts, data modeling, and dashboard creation.
My Skills
Technical Skills
- Data Analysis & Business Intelligence (BI)
- Data Visualization (Power BI)
- SQL & Database Design
- Python (Pandas)
- Advanced Excel (Power Query, DAX)
- Data Modeling (Star & Galaxy Schema)
- ETL Processes & Data Cleaning
Soft Skills
- Analytical Thinking
- Problem-Solving
- Communication
- Teamwork
- Attention to Detail
- Storytelling with Data
Tools & Technologies
Power BI
SQL
Python
Excel
n8n
FabricCertifications
Associate Data Analyst in SQL
DataCamp
The Data Analyst Diploma
Dataskool
Database Fundamentals
Mahara-Tech
SQL Fundamentals
DataCamp
SQL (Intermediate)
HackerRank
AI Agents BootCamp
Cairo UniversityGet In Touch
I'm currently seeking new opportunities and am excited to connect. Whether you have a question, a project idea, or just want to say hello — feel free to reach out!