Skip to content
View sonimonil's full-sized avatar
🎯
🎯
0 followers · 1 following

Block or report sonimonil

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
sonimonil/README.md

Monil Soni — Power BI Developer · Data Analyst

Typing SVG

Portfolio LinkedIn Email Download CV Open to work Profile views

📊 Impact at a glance

55%

faster dataset refresh
star-schema rebuild

200+

users on one certified dataset
with Row-Level Security

40 → 1

duplicate reports replaced
single source of truth

~20 hrs

manual reporting removed / week
VBA & Excel → Power BI

👨‍💻 About Me

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

🧭 Currently

  • 🔎 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

▶️ Live dashboards — open them in your browser

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)

🛠️ Tech Stack

BI & Visualization

Power BI Tableau Looker Studio

Data & Query

SQL DAX Power Query Python Pandas

Modeling & Ops

Tabular Editor DAX Studio Microsoft Fabric Azure Data Factory Excel Git

📌 Featured Projects

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

📈 GitHub Activity

GitHub Stats

Contribution snake animation

📫 Reach me at sonimonil247@gmail.com — open to Power BI Developer / BI Developer / Data Analyst roles in Vadodara, Ahmedabad, remote, or relocating.

Pinned Loading

  1. Financial-Planning-Analysis Financial-Planning-Analysis Public

    End-to-end FP&A dashboard in Power BI (PBIP format): revenue, discount leakage, COGS and margin across 5 segments, 5 countries and 6 products. Star-schema model, documented DAX, Python validation s…

    Python

  2. Marketing-Analytics Marketing-Analytics Public

    Campaign and channel performance across 2,240 customers: acceptance rates by country, product and channel mix, and two targeting recommendations backed by correlation analysis.

    Jupyter Notebook

  3. Retail-Sales-Analytics Retail-Sales-Analytics Public

    10,000 retail orders (FY2023-24) across 4 regions and 5 categories: 18.2% YoY growth, category margin analysis, and the profit collapse caused by deep discounting. SQL + Python, structured for Powe…

    Python

  4. Sales_Performance Sales_Performance Public

    Q1 vs Q2 FY2026 field-force review for an 8-rep pharma sales team across Gujarat: business up 22.4%, call adherence +8.1pp, doctor coverage 38.7% — reconciled from 15 source reports.

    HTML

  5. FNP-Sales-Analysis FNP-Sales-Analysis Public

    Festival seasonality in Indian gifting retail: 1,000 Ferns N Petals orders showing four months carry 68% of annual revenue, at a 4.3x multiplier. Excel model, Python verification, SVG dashboard.

    HTML

  6. Online_Purchase_Counsumer_Behaviour-E-Commerce- Online_Purchase_Counsumer_Behaviour-E-Commerce- Public

    What drives repurchase intention for 1,000 Indian online shoppers: correlation, ANOVA and regression showing satisfaction and loyalty outweigh price sensitivity. Interactive dashboard + research pa…

    HTML