Data Analyst · Nagpur, India
Mohammad Ammar
I build end-to-end analytics — from raw SQL queries to Tableau dashboards — around real business problems, and write curriculum-grade SQL content on the side.
Current Focus
Analytics Engineering
SQL · Python · Modeling
Building
NagpurLens
57 localities mapped
Authoring
SQL Handbook
20+ production modules
Seeking
Paid Internship
Data Analyst · Immediate
About
Analytics that survives contact with production — clear questions, defensible queries, and a story a business can act on.
- B.Tech Engineering student in Nagpur — SGPA 8.53 (Sem 1), 7.86 (Sem 2).
- Co-founder, Execution & Lead Data Analyst at Apex Analyticx — a freelance venture delivering data analytics and other services to businesses.
- Building NagpurLens, an open-source urban intelligence platform mapping infrastructure gaps across Nagpur.
- Author of the SQL Engineering Handbook, a 20+ module production-grade SQL curriculum.
- Seeking a paid Data Analyst internship where I can contribute from day one with SQL, Python and data storytelling.
01
Start from the question
Every project begins with a decision someone has to make. If the query doesn't change an action, it doesn't ship.
02
Engineering-grade SQL
CTEs over nested subqueries, indexes over hope, execution plans over guesses. Queries are read more than they're written.
03
Documented like a product
READMEs, schema diagrams, assumptions and limitations. A repo a stranger can run is the minimum bar.
Featured Work
Projects built around questions a business actually asks.
Each repository ships with documentation, assumptions and the query design behind the answer.
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.
NagpurLens
An urban intelligence platform mapping infrastructure gaps and growth signals across 57 Nagpur localities using custom KPIs — density, healthcare access, investment attractiveness.
Multi-collaborator · in progress
Olist Sales Analysis
Which categories and regions drive 80% of revenue across 95K+ orders?
Cohort Retention Analysis
Why do 96%+ of customers never return after their first purchase?
RFM Customer Segmentation
Who are the high-value versus at-risk customers?
Daily Reflection Tree
A deterministic CLI journaling app with 25+ branching nodes across three psychological axes — no LLM at runtime.
Tech Stack
Tools I reach for, and how deep each one goes.
Data & Analytics
SQL Depth
Languages
Tools & Platforms
Open Source
Built in public, committed daily.
Documentation, curriculum and analysis code — all versioned on GitHub.
Contribution activity
Latest commits
Add module 21: query plan reading
sql-engineering-handbook · 2d ago
Score healthcare access KPI per locality
nagpurlens · 5d ago
Refactor revenue CTE, add region rollup
olist-sales-analysis · 1w ago
Fix first-purchase window edge case
cohort-retention · 2w ago
Venture
Apex Analyticx
Co-founder — Execution & Lead Data Analyst
A freelance venture offering multiple services to businesses, including data analytics. I lead execution and own the data analytics function end to end.
Certifications & Externships
HackerRank — SQL (Advanced)
Certification
HackerRank — SQL (Basic)
Certification
Zetheta Algorithms — Data Analyst, Securitisation
Externship · 15 full-time days equivalent · IFRS 9 ECL modeling, DAX, star schema and Python analytics on real auto loan data
B.Tech Engineering, Nagpur
SGPA 8.53 (Sem 1) · 7.86 (Sem 2)
Journey
Where I am, and where this is going.
Now
Data Analyst, shipping in public
Leading execution at Apex Analyticx, authoring the SQL Engineering Handbook, building NagpurLens.
Next
Paid Data Analyst internship
Contributing from day one with SQL, Python and data storytelling inside a real product team.
Future
Analytics Engineer
Warehouse modeling, transformation pipelines and tested, versioned analytics as infrastructure.
Open to a paid Data Analyst internship.
If you're a recruiter — start with the work above. Each project links directly to the repository with full documentation. Email is the fastest way to reach me.