"I turn messy data into clear business decisions"
- 🔍 Specialized in data cleaning, KPI analysis, and business storytelling
- 💼 Background in Customer Support — I understand business problems deeply
- 📊 Building end-to-end analytics projects using Excel, SQL, Python and Power BI
- 🌱 Currently expanding into Machine Learning and Advanced Analytics
- 📍 Based in Kota, Rajasthan, India
Data Analysis
Database
Visualization
Tools
Predicting term deposit subscriptions using ML
| Metric | Value |
|---|---|
| Dataset | 45,211 customers |
| ML Accuracy | 84.3% |
| AUC Score | 0.916 |
| Top Predictor | Call Duration (50.4%) |
| Segments Found | 6 RFM segments |
Tools: Python • SQL Server • Excel • Power BI
Key Findings:
- 🎯 Champions segment subscribes at 31.6% — 3x overall rate
- 📅 March campaigns convert at 52% — 4x overall average
- ⏱️ Calls over 10 mins convert at 48.4%
- 🏆 Previous campaign success predicts 64.7% conversion
End-to-end supply chain analytics with demand forecasting
| Metric | Value |
|---|---|
| Revenue Analyzed | $55.76M |
| Transactions | 62,884 |
| On-Time Delivery | 47.28% |
| Forecast Horizon | 6 months |
| Avg Daily Forecast | $37,863 |
Tools: Python • SQL Server • Excel • Power BI • Prophet
Key Findings:
- 🚚 Only 47% on-time delivery — critical business issue
- 📈 February is the peak month — Valentine's Day demand
- 🏭 PLANT01 and PLANT03 most cost efficient warehouses
- 💻 Computers drive 34.6% of total revenue
| Project | Domain | Tools |
|---|---|---|
| Swiggy Business Analytics | Food Delivery | SQL Server |
| E-Commerce Relational Analytics | E-Commerce | Python, SQL |
| Stock Showdown Analysis | Finance | Python |
| Covid-19 Data Exploration | Healthcare | SQL Server |
| Nashville Housing Cleaning | Real Estate | SQL Server |
| Data Science Salary Analysis | HR Analytics | Python |
⭐ If you find my projects useful, consider giving them a star!