Hi, I'm Mohammad Ammar 👋 — an aspiring Data Analyst from Nagpur, India.
I build end-to-end analytics work — from raw SQL queries to Tableau dashboards — focused on real business problems, and I write curriculum-grade SQL content on the side. Currently seeking a paid Data Analyst internship where I can contribute immediately with SQL, Python, and data storytelling.
🌐 Website: theammarngp-makes.github.io
📧 Email: theammarngp@gmail.com
- HackerRank — SQL (Advanced)
- HackerRank — SQL (Basic)
Co-founder — Execution & Lead Data Analyst at Apex Analyticx, a freelance venture offering multiple services including data analytics for businesses.
| Project | What it answers | Stack |
|---|---|---|
| SQL Engineering Handbook | A 20+ module, production-quality knowledge base covering advanced SQL, performance tuning, data modeling, and real-world query design, with a full resource library and community health docs | SQL MySQL Git GitHub |
| NagpurLens (open-source, in progress) | An urban intelligence platform mapping infrastructure gaps and growth signals across 57 Nagpur localities using custom KPIs (density, healthcare access, investment attractiveness) | MySQL FastAPI Streamlit Python |
| Olist Sales Analysis | Which categories & regions drive 80% of revenue across 95K+ orders? | SQL Python Pandas Tableau |
| E-commerce Cohort Retention Analysis | Why do 96%+ customers never return after their first purchase? | SQL Python Tableau |
| RFM Customer Segmentation | Who are the high-value vs. at-risk customers? | SQL Python Pandas Tableau |
| Daily Reflection Tree | A deterministic CLI journaling app with 25+ branching nodes across three psychological axes — no LLM at runtime | Python FastAPI JSON |
NagpurLens is a multi-collaborator, in-progress project — link will be added once the repo is public-ready.
If you're a recruiter — start with the project table above. Each project links directly to the repo with full documentation.