GLP-1 Weight-Loss Calculator
Excel · Clinical Data Modeling · Dosing Equations
Built a GLP-1 weight-loss calculator in Excel, modeling clinical dosing equations for a repeat client.
#OPEN TO WORK
Alaa Salah
Junior Data Analyst
I turn raw, messy data into dashboards and reports people actually use. Open to junior data analyst and applied AI roles, plus freelance Power BI & Excel projects.
Certifications
Five Microsoft and AWS certifications in data analytics, cloud and AI.
- 5
- certifications passed
Hover over or tap a badge to see the full certification name
Featured work
Client work, team projects and individual bootcamp projects — dashboards, machine learning and AI applications.
- 3
- freelance client projects
- 6
- group projects
- 15
- individual bootcamp projects
BASIRA: Customer Feedback Intelligence
XLM-R · Aspect-Based Sentiment Analysis · NLP · Multilingual
A customer feedback intelligence platform turning unstructured reviews into business decisions. A 4-layer architecture (data → NLP/AI → analytics → business) runs 3 complementary models — explicit aspect extraction, implicit category detection, and sentiment/type classification — on a multilingual XLM-R encoder.
TechUni Intelligence Hub
SQL Server · Python (EDA) · Orange ML · Power BI · Netlify
Full-stack university data system: designed a 12-table SQL Server schema (ERD, views, queries), ran Python EDA and Orange ML workflows, and shipped both a Power BI dashboard and a live web dashboard on Netlify.
ReviewIQ AI Frontend
React · TypeScript · Vite · Material UI · Recharts
AI-powered customer review intelligence platform with a dashboard for aspect analysis, branch performance, trend analysis, and AI-generated recommendations.
Body Performance ML Pipeline
Python · Scikit-learn · Pandas · NumPy · Matplotlib · Seaborn · Google Colab
Full ML pipeline on 13,393 body-performance records — medical-grade cleaning, EDA, feature engineering, and 5 models compared for classification and regression. Best results: SVM classifier (70.4% accuracy) and MLP regressor (R² = 0.80).
Grape Leaf Disease Classification System
TensorFlow/Keras · ResNet50 · EfficientNetB7 · Transfer Learning
Transfer-learning image classifier detecting Black Rot, ESCA, and Leaf Blight in grape leaves, with a full preprocessing and evaluation pipeline.
Defective Chips Detection System
PyTorch · EfficientNet-B0 · Computer Vision
Image classification system using EfficientNet-B0 and PyTorch to automatically detect defective vs. non-defective chips for quality inspection.
Tableau Dashboard — Data Visualization
Tableau · Data Visualization · Data Analysis
Business data was scattered across multiple sources, making it difficult to track key metrics and spot trends at a glance. Built an interactive Tableau dashboard consolidating key metrics into clear, visual insights for faster decision-making.
University Student Analytics Dashboard
Power BI · DAX · Data Modeling
University needed a consolidated view of student enrollment, demographics, and academic performance across 8 departments. Built a Power BI dashboard tracking 5,000 students by department, program, gender, and academic status, with enrollment trends from 2020–2024 and average age/GPA KPIs for at-a-glance monitoring.
GTX Sales Dashboard — Sales Analytics
Power BI · DAX · Data Modeling
Sales team needed a unified view of KPIs across sectors, products, managers, and agents. Built an interactive Power BI dashboard tracking sector performance, product waterfall, manager breakdown, and top sales agents.
Sales Dashboard — Multi-Year Analysis
Power BI · DAX · Data Modeling
Management needed to compare sales performance across multiple years with flexible filtering. Designed a multi-year sales dashboard with month and year slicers showing $85.26M total, broken down by region, product, and agent.
Sales by Office Location — Geographic Analysis
Power BI · DAX · Maps · Data Modeling
Leadership lacked visibility into how each office contributed to overall sales across 15 countries. Created a multi-page geographic dashboard with flag slicers, country timeline, and drill-through by location.
GTX Sales Dashboard — Multi-Page Report
Power BI · Treemap · Waterfall · DAX
Stakeholders needed a structured multi-page report covering sales from different angles. Developed a multi-page Power BI report with treemap, waterfall, and donut charts across product, month, agent, and region views.
GTX Sales Dashboard — Green Theme
Power BI · Map Visual · Key Influencers · DAX
Client requested a branded green-theme dashboard with map, decomposition tree, and key influencers. Delivered a polished green-branded dashboard with sales by map, decomposition, key influencers, and manager breakdown showing $20.94M total.
Global Sales Analytics — Europe Market
Power BI · DAX · Data Modeling
The European team needed a dedicated view of sales by category, ship mode, and segment across 2011–2014. Built a dark-themed Europe market dashboard showing $5.49M total with gauge, donut, bar, and stream charts.
GTX Sales Dashboard — Full Dataset
Power BI · DAX · Data Modeling
The company needed a complete view of $85.26M in sales across sectors, products, managers, and 30+ agents. Created a full-dataset dashboard with sector area chart, product waterfall, manager donut, and full agent bar chart.
Restaurant Sales — Food & Beverage
Power BI · DAX · Food & Beverage
A restaurant needed to identify top-selling items and understand revenue distribution across food categories. Built a food and beverage dashboard showing $159.22K total sales, top 7 items, and category breakdown.
Sales Analytics Dashboard — Excel
Excel · Pivot Tables · Charts · Conditional Formatting
Raw sales data was unstructured and inconsistent, making it difficult to identify revenue trends. Cleaned and modeled the dataset into a pivot-based interactive dashboard highlighting revenue metrics by country, segment, category, and region.
Revenue by Region — Global Revenue Map
Power BI · Bing Maps · DAX · Data Modeling
The business needed a geographic breakdown of revenue across Asia, Europe, and North America. Built a global revenue map with product analysis and payment method distribution.
AI Market RAG
Python · LlamaIndex · ChromaDB · Streamlit
Retrieval-Augmented Generation pipeline for semantic search over Stanford's AI Index Report 2025, wrapped in an interactive Streamlit app.
Smart Sheets Email Automation
n8n · Google Sheets · LLM · Gmail
n8n workflow triggered on new Google Sheets rows, processing data through an LLM chain and auto-sending results via Gmail.
PDF Knowledge Base Chatbot
n8n · Google Gemini · Supabase · RAG
n8n RAG chatbot watching a Google Drive folder, chunking PDFs, embedding with Google Gemini, and storing vectors in Supabase for real-time Q&A.
Training
A 9-month Digilians diploma with the Egyptian Military Academy and the Ministry of Communications & IT, followed by an internship at Sadat Academy.
- 9 months
- diploma and data bootcamp
- 2 months
- internship
- 20+
- datasets analyzed
9-Month Diploma — Applied AI & Data Analysis Track
Digilians · Egyptian Military Academy · Ministry of Communications & IT
Intensive data bootcamp: analyzed 20+ datasets with Python and SQL, built Power BI and Tableau dashboards, and developed machine learning and Generative AI (RAG, LangChain) solutions.
Digital Transformation & AI Intern
Sadat Academy for Management Sciences
Group project: Smart Digital Library & Paperless Academy — digitizing the library with OCR and digital workflows.
Skills
Tools and methods I work with, grouped by area.
BI & visualization
- Power BI
- DAX
- Power Query
- Tableau
- Excel
- Data Visualization
Data & programming
- SQL
- Python
- SPSS
- Microsoft Fabric
AI & machine learning
- Machine Learning
- Generative AI
- RAG
- LangChain
- Prompt Engineering
Contact me
Hiring for a data role or have a project in mind? Send me a message and I'll reply by email.
- Open to full-time roles and freelance projects
- Based in Cairo, Egypt
- Or connect on LinkedIn
- Or send me an email
- Save my contact card
- Or message me on WhatsApp