Ansh Kansara · Data Analyst · Business Intelligence

SQL · PostgreSQL · Python · Power BI · Business Analytics · Vadodara, Gujarat, India

Data Analyst turning raw data into business decisions.

Specializing in SQL, PostgreSQL, Python, data cleaning, exploratory analysis, and Power BI dashboards. Powered by 1.5 years of professional software development experience at Nilesh IT Solution creating data-driven tools and interactive reporting interfaces.

Explore Analytics Work View All Projects Contact Me →

PostgreSQL & SQLPython (Pandas / NumPy)Power BI & Data VizInteractive Web Products

// POSTGRESQL ANALYTICS ENGINE

LIVE DATASET

Transactions

99,970

Revenue

₹3.37B

Profit Margin

31.41%

sales_analytics_query.sql11 SQL QUERIES

SELECT category, COUNT(*) AS total_orders,
       SUM(revenue) AS total_revenue
FROM sales_transactions GROUP BY category;

100% Validated Analytics Outputs

Explore BI Hub →

// KEY PERFORMANCE INDICATORS & ANALYTICS OUTPUTS100% VALIDATED METRICS

99,970

TRANSACTIONS ANALYZED

30-month PostgreSQL dataset analyzed for profitability, target hit-rates, and rep performance.

01.5+

YEARS EXPERIENCE

Professional experience blending data reporting and SQL integration with software engineering.

31.41%

PROFIT MARGIN ANALYZED

Verified SQL aggregation output across ₹3.37B sales revenue dataset.

35%

DATA FILTER ACCURACY

Optimization achieved through SQL-driven database indexing and data reconciliation.

// FLAGSHIP ANALYTICS PRODUCT

Business Performance Analytics (PostgreSQL & SQL)

Open Interactive BI Hub →

POSTGRESQL CASE STUDY99,970 Transactions · Jan 2024 – Jun 2026

Analyzed 99,970 transaction records across 30 consecutive months. Formulated 11 production SQL queries evaluating revenue drivers (₹3.37B), net profitability (31.41% margin), target hit rates (6.28%), discount margins, and an 80-salesperson performance matrix.

Raw Data→Cleaning→PostgreSQL→SQL Analysis→BI Dashboard→Insights

Launch BI Dashboard & SQL Explorer

NAVIGATION DIRECTORYSelect a Case File