Passionate about turning raw data into meaningful insights. I've worked with real-world datasets spanning retail sales, e-commerce, and business analytics — building dashboards, data models, and end-to-end pipelines.
- 🔭 Currently working on data analysis projects using Python, Power BI, and SQL
- 🌱 Pursuing the IBM Data Analyst Professional Certificate (Coursera)
- 💼 Former Data Analyst Intern Semicolon Codes
- 📫 Reach me at: mohab.ahmed.ntss@gmail.com
Python · Pandas · Streamlit · Plotly
Built a full data pipeline from raw messy data to a live interactive dashboard. Covers 4 datasets (500 customers, 120 products, 3,000 orders, 3,050 payments), applied comprehensive data cleaning, and deployed publicly on Streamlit Cloud.
Excel · Power Pivot · DAX
Analyzed $629.6M in net sales across a star schema model with 5 interrelated tables. Built an interactive Excel dashboard with dynamic slicers, KPI cards, and 4 chart types revealing Electronics as the dominant category (64% of profit).
Power BI · Power Query · DAX
Identified peak sales months and flagged underperforming periods through time series analysis. Delivered geospatial and product-level insights via an interactive Power BI dashboard.
Microsoft SQL Server
Designed and implemented a normalized relational database with 4 tables. Wrote queries using JOINs, aggregations, and GROUP BY to analyze product performance and calculate total revenue.
| Metric | Value |
|---|---|
| 💻 Focus Area | Data Analysis & Visualization |
| 🛠️ Primary Tools | Python · Power BI · SQL · Excel |
| 📁 Projects | 12 end-to-end analysis projects |
| 🎓 Certifications | 3 completed · 1 in progress |
| Certificate | Provider | Date |
|---|---|---|
| Data Analyst in Power BI | DataCamp | Apr 2026 |
| Data Analysis with Excel Power Tools | DataCamp | Jan 2026 |
| Excel Fundamentals | DataCamp | Dec 2025 |
| IBM Data Analyst Professional Certificate | Coursera & IBM | In Progress |
