Business Intelligence & Analytics Hub
Select an analytics project below to inspect interactive PostgreSQL dashboards, SQL explorers, data quality audits, and strategic executive recommendations.
Business Performance Analytics
An end-to-end sales and profitability intelligence project analyzing 99,970 sales transactions across 30 months (Jan 2024 – Jun 2026). Demonstrates data cleaning in Python, relational modeling in PostgreSQL, advanced SQL query execution, transaction target hit-rate analysis, and interactive executive reporting.
public.sales_transactions (30 Months)8-Stage Analytical Architecture
Click any stage in the flow below to inspect tools, validation steps, and analytical transformations.
99,970 multi-channel retail sales records spanning 2024-01-01 to 2026-06-30.
Contains transaction ID, dates, customer segments, product categories, unit prices, discounts, sales targets, and payment channels.
Data Cleaning & Preprocessing Log
Comprehensive audit log documenting cleaning steps, category standardization, and payment channel string normalization.
Interactive SQL Analysis Notebook (11 Queries)
Select any query from the sidebar below to inspect the exact SQL code, business questions, and verified output tables.
Aggregates the entire sales_transactions dataset of 99,970 rows to establish primary executive KPIs.
SELECT
COUNT(*) AS total_transactions,
SUM(quantity) AS total_quantity,
SUM(revenue) AS total_revenue,
SUM(profit) AS total_profit,
ROUND(
SUM(profit) / NULLIF(SUM(revenue), 0) * 100,
2
) AS profit_margin_pct,
ROUND(AVG(revenue), 2) AS average_order_value
FROM sales_transactions;| total_transactions | total_quantity | total_revenue | total_profit | profit_margin_pct | average_order_value |
|---|---|---|---|---|---|
| 99970 | 339217 | ₹3,368,329,417.33 | ₹1,057,911,296.07 | 31.41% | ₹33,693.40 |
Key Business Findings & Data Insights
Executive summary derived directly from the PostgreSQL 99,970 transaction analysis.
Electronics Leads Overall Revenue Generation
Electronics represents the single largest revenue stream at ₹1.35B with a strong 33.38% profit margin, outperforming all other product categories.
Office Supplies Achieves Highest Profit Margin
Despite generating lower gross revenue (₹158.4M), Office Supplies maintains the portfolio's highest margin efficiency at 35.24%.
Low Transaction Target Hit Rate Across High Targets
Only 6,278 of 99,970 transactions hit assigned target thresholds. Higher sales targets (₹300K) see hit rates fall to 1.94%.
Profit Margin Degrades Rapidly at Higher Discount Bands
Profit margins drop from 34.70% for transactions with <5% discount to 19.96% for transactions with >20% discount.
West Region Dominates Revenue; South Holds Margin Lead
West territory leads in sales volume (28,782 orders), while South territory delivers the highest regional profit margin at 31.56%.
Strategic Business Recommendations
5 concrete, data-backed operational actions for management derived directly from analytical findings.
Re-align Transaction Sales Target Structures
Overall transaction-level target hit rate is only 6.28%, dropping to 1.94% at the ₹300K target level.
Unrealistically high transaction targets create disincentives. Restructuring targets around historical median order values (₹33.7K) will improve achievement and morale.
Enforce Governance on High Discount Bands
Margins erode by nearly 15 percentage points (from 34.70% to 19.96%) when discounts cross 20%.
Uncontrolled discounting directly damages profitability without generating proportional volume increases.
Protect and Expand High-Margin Office Supplies
Office Supplies maintains a market-leading 35.24% margin but represents only 4.7% of total revenue.
Increasing basket penetration of high-margin accessories and supplies boosts net portfolio profit margin with minimal inventory risk.
Scale High-Value Electronics Inventory & Marketing
Electronics drives ₹1.35B in revenue with strong 33.38% margins.
Electronics is the primary revenue engine. Ensuring high product availability for top items like P-0218 maximizes top-line growth.
Coach Salespeople in High Sales / Low Efficiency Category
20 salespeople generate high gross revenue but remain below average profit margins due to aggressive discount usage.
Coaching high-volume reps to reduce average discount by 3% will unlock millions in bottom-line margin expansion.