Open to Business Analyst & BI roles — Bengaluru / Remote

I turn messy operational data into dashboards people actually decide from.

Business Analyst at Adani Enterprises Ltd., building automated Power BI reporting with DAX, Power Query and SQL. Below are three end-to-end analytics projects — cleaning pipeline, SQL model and BI layer — each with the code, the dashboard and the decision it supports.

View the projects Download resume LinkedIn
Dhruvi Vegda, Business Analyst and Power BI developer
Business Analyst · Adani Enterprises Ltd.
  • 0 Power BI dashboards automated
  • 0 Manual reporting time removed
  • 0 Stakeholders served with live KPIs
  • 0 Faster access-request turnaround

Selected work

Three pipelines, end to end

Each project runs the whole way through: a Python cleaning script with real error handling, a PostgreSQL model built on CTEs and window functions, and a Power BI layer with the DAX written out. Every number below comes from the code — nothing is illustrative.

01 Sep 2026

E-Commerce Customer Segmentation — RFM

20% of customers generate 64% of revenue. Retention budget moved from blanket discounting to 866 named accounts.

  • Cleaned 541,909 raw transactions down to 392,692 valid rows in Pandas — duplicates, null customer IDs, cancellations and non-positive lines, each exclusion logged and counted.
  • Scored all 4,338 customers in PostgreSQL with CTEs and NTILE(5) window functions, concatenating a three-digit RFM score and mapping it to 11 business segments.
  • Surfaced 646 lapsing high-value accounts holding £1.03M of historic spend — the highest-ROI win-back list in the base.
  • Pandas
  • PostgreSQL
  • Window functions
  • Power BI
  • DAX
Code Case study (PDF) DAX
02 Jun 2026

SaaS Subscription Funnel & Churn

62% of cancellations happen in the first three months. That makes onboarding the lever, not win-back.

  • Instrumented a four-stage funnel from 66,000 raw event logs, collapsing repeat emits to first touch and voiding out-of-sequence stages that would otherwise inflate every conversion rate.
  • Isolated the single worst leak — 57% of users lost between First Use and Paid Upgrade, at a median of 12 days.
  • Built cohort retention and MRR movement in PostgreSQL using generate_series to expand each customer into active months; monthly MRR churn of 4.2% means ~£196K a year must be replaced before the business grows.
  • Pandas
  • Matplotlib
  • PostgreSQL
  • Cohort analysis
  • DAX
Code Case study (PDF) SQL model
03 Mar 2026

Retail Inventory & Margin Optimization

234 SKUs carrying £1,786 a day of gross margin were about to run dry. 174 of those shortages needed a transfer, not a purchase order.

  • Standardised a 6,220-row warehouse extract carrying four SKU spellings, #N/A costs, negative counts and duplicate rows, then merged it with the product master to derive margin per SKU.
  • Joined stock, 120 days of sales and the warehouse dimension in PostgreSQL to compute daily sales velocity, days of supply and ABC class across 1,200 SKUs in 5 warehouses.
  • Ranked the buying list by margin at risk per day rather than by low stock — so a penny line and the best seller are never treated as the same emergency.
  • Pandas
  • PostgreSQL
  • CTEs
  • ABC analysis
  • Power BI
Code Case study (PDF) SQL model

Research

Rural Gujarat Response to SDG 6

Primary survey of 400+ respondents across 5 villages, analysed in SPSS against 20+ water, sanitation and hygiene KPIs. Findings and recommendations were delivered to the Gandhinagar Municipal Corporation to improve resource accessibility.

  • SPSS
  • Survey design
  • Advanced Excel
  • Stakeholder reporting

Jan – Dec 2023

Experience

Where I've delivered

  1. Business Analyst

    May 2026 — Present

    Adani Enterprises Ltd.

    • Engineered 5+ automated Power BI dashboards with DAX and Power Query, centralising enterprise data, cutting manual reporting time by 15% and giving 20+ stakeholders real-time KPIs.
    • Analysed cross-functional project data in SQL and Excel to surface operational bottlenecks, improving project tracking accuracy.

  2. Business Analyst Intern

    Oct 2025 — Apr 2026

    Adani Enterprises Ltd.

    • Led data analysis for the Hunger Box application rollout, extracting usage metrics in SQL to inform cafeteria capacity planning.
    • Coordinated 3 internal teams through implementation issues, holding 99% uptime across the pilot.

  3. Power Platform Developer

    Jan 2025 — Apr 2025

    Adani Power Ltd.

    • Built and deployed PRAVIX in Power Apps to automate APM access requests, cutting turnaround time by 30%.
    • Configured multi-level approval workflows and automated notifications, with SOPs for operational compliance.

  4. Sales Executive

    Jan 2023 — Feb 2023

    Dabur Ltd.

    • Used historical sales and customer analytics to sharpen retail supermarket interactions and lift consumer engagement.

Toolkit

What I build with

Business Intelligence

  • Power BI
  • DAX
  • Power Query
  • KPI reporting
  • Data visualization
  • Report automation

Data & Databases

  • SQL
  • PostgreSQL
  • MySQL
  • CTEs
  • Window functions
  • ETL
  • Data cleansing
  • Validation

Data Modelling

  • Star schema
  • Fact & dimension design
  • Relationship design
  • Power BI modelling

Programming

  • Python
  • Pandas
  • NumPy
  • Matplotlib
  • Seaborn
  • SPSS

Power Platform

  • Power Apps
  • Power Automate
  • Approval workflows

Analytics & Reporting

  • Advanced Excel
  • Pivot tables
  • Statistical analysis
  • Forecasting
  • Financial analysis

About

Analyst first, dashboard second

I'm a Business Analyst and Power BI developer based in Bengaluru. Most of my work starts the same way: someone has a report that takes hours to produce and still doesn't answer the question. I rebuild the path from raw data to the decision — cleaning and validating the inputs, modelling them in SQL, then publishing something stakeholders can actually use.

What I care about is the part people skip. Whether a null means zero or unknown. Whether a rate is measured against the right denominator. Whether the number on the card would survive someone checking it. The case studies in my projects document those decisions deliberately, because that's the difference between a chart and an analysis.

I hold a PGDM in Big Data Analytics and a BBA (Hons.) in Marketing — which means I'm as comfortable in a stakeholder conversation as in a query editor.

Contact

Let's talk about your reporting

I'm open to Business Analyst, Data Analyst and Power BI roles in Bengaluru or remote. The fastest way to reach me is email — I reply the same day.

dhruvivegda2501@gmail.com
+91 94295 34902 LinkedIn GitHub Resume (PDF)