Mariam Hanafy
Data Analyst
"Data tells the story, I help you read it."
About Me
I've always been drawn to the stories hidden inside data — because behind every number, there's a decision waiting to be made. As a senior Computer Science student at Cairo University (FCAI), I've spent the past few years turning that curiosity into real skills: building dashboards in Power BI, writing SQL queries, and transforming raw, messy data into insights that actually matter.
I've had the chance to apply this in a real work environment at Almia Chem, where I analyzed ERP data, tracked sales performance, and built reports that supported day-to-day business decisions. Beyond the technical side, I genuinely enjoy sharing knowledge — which is why I've worked as a Data Analysis Instructor at Flashat, and currently lead the Data Analysis Committee at Star Union, mentoring members and driving data projects within the organization.
I'm always looking for opportunities to grow, take on new challenges, and work on projects where data can solve real problems and drive smarter decisions.
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
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!