| faster dataset refresh star-schema rebuild |
users on one certified dataset with Row-Level Security |
duplicate reports replaced single source of truth |
manual reporting removed / week VBA & Excel → Power BI |
I'm a Power BI Developer with 5+ years of experience in Business Intelligence & Analytics, turning messy, multi-source data into dashboards that leadership teams actually use to make decisions.
- 🔭 Building enterprise-grade BI solutions at SMART MIND — previously at PhysicsWallah
- 📊 I design star-schema data models, complex DAX measures, and automated ETL pipelines
- ⚡ My work has cut manual reporting effort by up to 60% and dashboard refresh times by ~55%
- 🔐 Hands-on with Row-Level Security (RLS), Power BI Service, and governed report distribution to 200+ users
- 🎓 MBA in Business Analytics · Based in Vadodara, India
- 💬 Ask me about Power BI, DAX, Power Query, SQL, and dashboard design
- 🔎 Open to Power BI Developer · BI Developer · Data Analyst roles
- 📍 Vadodara / Ahmedabad · open to relocation and remote
- ⏳ 30-day notice (negotiable)
- 🌱 Going deeper into Microsoft Fabric — lakehouses, dataflows and Direct Lake
| What you can do | |
|---|---|
| Sales Team Performance | Slice 6,939 call records by quarter, rep, doctor grade, territory and month |
| FNP Festival Seasonality | 1,000 gifting orders — see the four months that carry 68% of the year |
| E-Commerce Consumer Behaviour | 1,000 respondents, correlation and regression results (simulated data) |
BI & Visualization
Data & Query
Modeling & Ops
| Project | The finding | Tools |
|---|---|---|
| 💰 Financial Planning & Analysis | Enterprise sells below cost — COGS at 103% of net sales. Built in PBIP format, so the model is diffable in Git | Power BI, DAX, Python |
| 📈 Sales Team Performance | 8-rep field force, Q1 → Q2: business +22.4%, call adherence +8.1pp, reconciled from 15 source reports | Excel, BI reporting |
| 🏏 T20 World Cup Analytics | Web-scraped player data modelled into batting & bowling facts, custom DAX measures and a data-driven best-XI selection | Power BI, DAX, Python |
| 🎁 FNP Festival Sales | Four festival months carry 68% of annual revenue, at a 4.3× multiplier over quiet months | Excel, Python, SVG |
| 🛍️ Retail Sales Analytics | Profit per order collapses from ₹270 to ₹7 as discounts deepen; 18.2% YoY growth underneath | SQL, Python, Pandas |
| 🛒 Online Purchase Behaviour | Satisfaction and loyalty drive repurchase intention far more than price — tested with ANOVA and regression | Statistics, dashboards |
| 📣 Marketing Analytics | Latest campaign hit >60% acceptance in Mexico; web and store outperform every other channel | Python, Power BI |
📫 Reach me at sonimonil247@gmail.com — open to Power BI Developer / BI Developer / Data Analyst roles in Vadodara, Ahmedabad, remote, or relocating.