Analytics, built like a structure

Every dashboard needs
a load-bearing foundation.

DataVedh is an analytics practice run by a civil engineer who now builds with data instead of concrete. Same discipline — a solid foundation, sound structure, honest finish — applied to SQL, Power BI, and the numbers your business runs on.

FIG. 01 — HOW A PROJECT IS BUILT DATAVEDH / PROCESS
FOUNDATION

Data cleaning & validation

Raw exports, messy spreadsheets, duplicate records — sorted, de-duped, and checked before anything gets built on top.

STRUCTURE

SQL analysis & modelling

CTEs, window functions, and joins that answer the actual business question — not just describe the data.

FINISH

Power BI / Tableau dashboards

A finished, load-tested dashboard your team can open Monday morning and actually use.

About

From site drawings to data models.

A 2025 civil engineering graduate from Bihar, now working full-time in data analytics — SQL, Power BI, Python, and Excel. The engineering background isn't a footnote; it's the reason the analysis holds up under scrutiny.

01

Structural thinking

Engineering trains you to check load paths before you trust a structure. Same instinct applied to a churn model or a pricing dashboard.

02

Built for SMEs

No enterprise jargon, no 40-tab workbooks. Dashboards and reports sized for teams that need clear answers, fast.

03

Sector fluency

Particular strength reading construction, infrastructure, and real estate data — domains most analysts have never set foot in.

Services

What gets built.

Dashboard design & build

POWER BI / TABLEAU

KPI dashboards with proper DAX measures — churn, retention, revenue, ops — built to be read in under a minute.

SQL data analysis

MYSQL

Answering specific business questions from raw tables: leakage, cohort behaviour, pricing anomalies, and more.

Excel & MIS reporting

EXCEL

Pivot-table-driven reporting systems for teams that live in spreadsheets and need them to work harder.

Python-based analysis

PANDAS / SCIKIT-LEARN

Exploratory analysis and lightweight predictive models when a spreadsheet isn't enough.

Selected work

Projects, with real numbers.

Customer Churn & Revenue Impact Analysis

SQL · POWER BI · 100K+ RECORDS

₹99M+

Identified a 33% churn rate driving over ₹99M in revenue loss across 100K+ customer records. High-value customers accounted for 86% of total losses — segmented by contract type, tenure, and monthly charges, with a Power BI dashboard tracking churn rate, LTV, and retention KPIs.

View on GitHub →

Revenue Leakage & Pricing Optimization

SQL · POWER BI · FOOD DELIVERY DATASET

₹3.32M

Detected ₹3.32M in revenue leakage (~10% of ₹29.85M total revenue) using reverse pricing logic built in SQL CTEs. Mumbai, Hyderabad, and Chennai flagged as the highest-leakage cities, with an interactive city-level drill-down dashboard.

View on GitHub →

E-commerce Returns & Delivery Analysis

SQL · PYTHON · POWER BI · 1M ROWS

1M

A synthetic 1M-row e-commerce dataset analysed for return drivers and delivery performance — the latest DataVedh project, built end-to-end with a full README and reproducible pipeline.

View on GitHub →

HR Attrition Cost Intelligence

EXCEL · SQL · IBM HR DATASET

HR

Employee attrition cost analysis on the IBM HR dataset — surfacing which departments and roles carry the highest replacement cost, built in Excel and SQL.

View on GitHub →

Have a dataset that needs a foundation?

Free first dashboard sample from your own data — no cost, no obligation. If it's useful, we build from there.