🎓 Mechanical Engineering student at Delhi Technological University (DTU)
📊 Aspiring Data Analyst passionate about solving business problems with data.
I build end-to-end analytics projects using SQL, Python, Tableau, and Excel to transform raw data into actionable business insights through data cleaning, analysis, and interactive dashboards.
Languages & Tools
- SQL (MySQL)
- Python (Pandas, NumPy, Matplotlib, Plotly)
- Tableau
- Microsoft Excel
- Git & GitHub
- statistical testing
- Product Analysis
- Web Scrapping
Python • Pandas • Plotly • Excel
- Analysed customer churn using merged subscription, customer, and support datasets.
- Identified 22.63% customer churn and ₹11,005 monthly revenue at risk.
- Found that plan type and customer tenure were stronger churn indicators than support interactions.
Python • SQL • Tableau
- Analysed 7,043 customer records using an end-to-end Python → SQL → Tableau workflow.
- Identified 26.54% churn and ₹1,39,130.85 monthly revenue at risk.
- Used RANK(), LAG(), and running totals to uncover high-risk customer segments.
SQL • Tableau
- Analysed $2.30M in sales with a 12.47% profit margin.
- Built an interactive Tableau dashboard to monitor KPIs.
- Discovered that aggressive discounting reduced profitability despite strong sales.
Python • SQL • Tableau
- Analysed purchasing behaviour of 3,900+ customers.
- Built customer segments using RFM-style analysis.
- Found that customers purchasing without discounts spent more on average, challenging common promotional assumptions.
- Analyzed e-commerce user behavior using Python, MySQL, and Tableau to evaluate engagement, funnel performance, and retention.
- Built view → cart → purchase funnel and identified key user drop-off points and category-level performance.
- Measured conversion rates and D7 retention and translated findings into product recommendations.
- Applied AARRR, RICE, and CIRCLES frameworks to prioritize product improvements and proposed A/B testing for validation.
📧 Email: punitsingh1819@gmail.com
📄 Resume: **
⭐ Thanks for visiting my GitHub! Feel free to explore my projects and connect with me.