Education
- • Bachelor’s Degree in Software Engineering
- – Egyptian Chinese University, 2026
Data Analyst
Mohamed Safwat
Python • SQL • Excel • Power BI
Turning data into insights based on Results-driven, detail-oriented Analysis and, hands-on experiencethrough dashboards, business intelligence, and clear storytelling. Transforming data into actionable decisions.
About Me
I don’t just build dashboards — I build decision systems. I specialize in transforming raw, messy data into clean, automated solutions that reduce manual work, improve reporting accuracy, and help businesses make confident, data-driven decisions. My focus is not just visualization, but clarity, performance, and measurable business impact.
Skills
Technical Skills
Power BI • DAX • Power Query • SQL • Excel • Python • Data Modeling
Business Skills
KPI Definition • Business Requirements Gathering • Dashboard Storytelling • Data-Driven Decision Support • Operational Efficiency • Performance Optimization • Financial Analysis • Industry Understanding • Storytelling with Data
Soft Skills
Problem-Solving • Attention to Detail • Communication • Time Management • Adaptability • Presentation Skills • Stakeholder Management
Training and Internships
Data Analysis Trainee, DEPI, 2025 – Present
- • Designed and delivered interactive dashboards integrating multiple data sources, improving reporting clarity and reducing decision-making time.
- • Developed analytical insights that helped identify trends, cost-saving opportunities, and operational inefficiencies.
- • Automated recurring Excel-based reports using Power Query and Power BI, reducing manual workload and minimizing human error.
- • Applied best practices in dashboard design and storytelling to ensure executive-level usability and clarity.
Machine Learning Intern, INSTANT, 2025
- • Applied Machine Learning concepts including supervised and unsupervised learning techniques.
- • Utilized Python libraries such as Pandas, NumPy, Matplotlib, Scikit-learn, and TensorFlow for data preprocessing, model building, and evaluation.
- • Performed web scraping using Python to collect and prepare datasets for ML projects.
- • Conducted data cleaning, feature engineering, and exploratory data analysis to improve model performance.
Offered Services
- Dashboard Development
- Data Modeling & ETL (Extract, Transform, Load)
- DAX Calculations & KPI Setup
- Report Automation
- Data Cleaning & Transformation
- Interactive Visualizations & Insights
- Project Documentation
- MS Office Tasks
- Predictive Analytics
Projects
1/5
HR Analytics Dashboard Suite (Workforce, Attrition, Compensation)
Objective: Developed an HR analytics dashboard suite in Power BI to analyze workforce performance, employee demographics, and attrition trends. The project included cleaning and transforming the dataset, removing irrelevant fields, creating calculated columns, and building DAX measures to support key HR metrics.
Outcome: Delivered three interactive dashboards providing insights into workforce overview, employee attrition patterns, and compensation distribution. The dashboards help HR teams monitor workforce trends, identify potential retention issues, and support more informed, data-driven HR decisions.
1/4
HR Analytics Dashboard Suite (Demographics, Satisfaction & Career)
Objective: Developed a comprehensive HR analytics dashboard suite in Power BI to analyze employee demographics, job satisfaction, workforce performance, and career progression patterns. The project involved cleaning and transforming the dataset, creating calculated columns, and developing DAX measures to support key HR KPIs and workforce insights.
Outcome: Delivered four interactive dashboards that provide clear visibility into workforce demographics, satisfaction levels, attrition trends, and career development patterns. The dashboards enable HR teams to quickly identify employee trends and support more informed, data-driven HR decisions.
Pharmaceuticals Sales Performance Dashboard
Objective: Developed an interactive dashboard to monitor pharmaceutical sales performance, product distribution, and revenue trends across multiple categories and regions.
Outcome: Enabled clear visibility of top-performing products and revenue drivers, improved KPI tracking accuracy, and streamlined performance reporting for faster business insights.
Sales Analytics Dashboard
Objective: Designed a comprehensive sales dashboard to analyze revenue trends, customer behavior, and product performance across different time periods.
Outcome: Improved reporting efficiency through automated calculations and dynamic filtering, allowing stakeholders to quickly identify sales growth patterns and underperforming segments.
.png&w=3840&q=75)
1/2
Financial Transactions Fraud Analysis Dashboard
Objective: Engineered a large-scale data pipeline (SQL + Python + Power BI) to analyze fraud trends across millions of transactions.
Outcome: Reduced raw data inconsistencies through SQL cleaning, automated fraud metric calculations, and delivered executive-ready dashboards highlighting fraud concentration patterns and behavioral risk indicators.
.png&w=3840&q=75)
1/8
Maternal Health Risk Prediction (Machine Learning Project)
Objective: Designed and optimized multiple ML classification models to predict maternal health risk levels using real-world healthcare data.
Outcome: Improved minority-class recall using SMOTE and hyperparameter tuning, delivering a stable model with 87%+ accuracy, strong interpretability, and healthcare-ready insights.
Achievements
- • Awarded NVIDIA Generative AI Training Certificate for participation in advanced AI learning sessions.
- • Earned INSTANT Machine Learning & AI Training Certificate in recognition of successfully completing a hands-on internship focused on real-world ML model development.
Testimonials
“Professional, highly communicative, and delivered a data analysis solution that truly improved my workflow and decision-making!”
“Mohamed demonstrated outstanding problem-solving skills and attention to detail, delivering accurate insights on time and with exceptional quality.”