I turn operational data into clear, auditable decisions through reliable pipelines, dimensional models, and practical business intelligence.
- Building and refining Power BI analytics solutions for sales, HR, and operational reporting, with a focus on actionable KPIs and DAX-driven models.
- Strengthening my analytics engineering toolkit through dbt study notes, dimensional modeling, SQL optimization, and repeatable transformation patterns.
- Developing reliable Python and SQL ETL workflows for API integration, data validation, PostgreSQL warehousing, and decision-ready reporting.
- Supporting aspiring data professionals through technical coaching, reusable BI templates, and code reviews.
I am a data professional based in Damietta, Egypt, focused on building analytics solutions that connect sound data architecture with measurable business outcomes. My work spans Power BI, SQL, Python, ETL automation, data warehousing, and statistical analysis.
I enjoy simplifying complex workflows, improving reporting reliability, and helping aspiring analysts build production-ready technical habits through coaching and code review.
Business intelligence
Build executive-ready Power BI dashboards, KPI models, and DAX measures that support faster decisions.
Data engineering
Design Python/SQL pipelines, REST API integrations, and PostgreSQL warehouses for dependable analytics.
Data modeling
Apply Kimball principles, star schemas, indexing, partitioning, and slowly changing dimensions.
Analytics enablement
Coach data practitioners through reusable templates, technical reviews, and practical BI scenarios.
Featured projects
- DeepClean OS — Streamlit data preparation with Python, Pandas, and scikit-learn.
- B2B Retail Analytics & Churn — Power BI diagnostics, DAX, and star-schema modeling.
- SMART Supply Chain Insights — Statistical analysis and Power BI visualization for operational risk.
- Customer 360 Banking ETL — Warehouse-oriented customer and banking data integration.
- The Data Tea — A practical data-learning and career platform.
My repositories show a consistent path from data ingestion to decision-ready products. The strongest recurring themes are:
- Data platforms and warehousing: Customer 360 banking ETL, National Insurance data warehousing, Global Horizon Bank DWH, Hive SCD Type 2 labs, and Kafka-based pipelines.
- Business intelligence: Power BI solutions for S&OP, regional sales, HR, healthcare, supply chain, customer churn, marketing, and startup expansion.
- Applied analytics: A/B testing, customer segmentation, financial analysis, job-market analysis, global layoffs, and operational KPI storytelling.
- Automation and AI: n8n queue deployments, RAG indexing workflows, NL2SQL, sentiment analysis, job-market roadmap generation, and AI-assisted business workflows.
- Built 10+ interactive Power BI dashboards using dimensional modeling and advanced DAX.
- Reduced reporting refresh cycles from days to under 15 minutes in client analytics workflows.
- Automated ETL processes that removed approximately 40 hours of manual work per client.
- Reduced query execution time by 25% across 10 GB retail datasets through indexing, partitioning, and T-SQL refactoring.
- Conducted 100+ technical code reviews and supported 50+ trainees through reusable BI and analytics templates.
Contribution animation
Visitor analytics
Weekly observations are collected from the GitHub Traffic API and persisted in the repository. Click the chart to view the refresh workflow.
- B.Sc. in Agricultural Sciences, Damietta University, 2024
- DataCamp Data Analyst / Scientist / Engineer Associate and Data Literacy certificates
- Cisco Data Analytics Essentials
- HackerRank SQL and Python certificates
- Training in data warehousing, Apache Airflow, dbt, Excel VBA, cloud data engineering, and AI fluency
I am open to conversations about data analysis, business intelligence, analytics engineering, ETL automation, data warehousing, and technical coaching.