Things I've built.

Multi-page dashboard tracking revenue, GP%, customer trends, salesperson performance, and monthly comparisons with MoM and YoY analysis.

Automated daily GP tracking dashboard connected to ERP data, with threshold alerts and margin trend analysis for management review.

FIFO-based inventory aging dashboard identifying slow-moving stock, near-expiry items, and warehouse utilisation patterns across product categories.

Employee headcount, department distribution, joining/exit trends, and workforce planning metrics for HR leadership review.

Cash flow dashboard integrating POS and Tally data to track bank inflows, outflows, petty cash, and aggregator settlements daily.

Dashboard automating warehouse space allocation and order picking priorities based on real-time demand patterns and current stock levels.

Suite of dashboards tracking software development lifecycle stages, sprint velocity, bug counts, and release timelines for engineering teams.

Comprehensive gross profit workbook with item-level margin analysis, supplier comparisons, and automated summaries from ERP CSV exports.

Maintenance cost tracking and comparison report for company fleet vehicles, with per-km cost analysis and service interval forecasting.

Historical purchasing data analysis identifying cost reduction opportunities across suppliers, with price trend charts and negotiation benchmarks.

Automated invoice workbook that distributes total amounts proportionally across product line items with proper rounding and clean print layout.

Reconciliation workbook matching POS aggregator payouts against bank deposits, flagging discrepancies and commission overcharges automatically.

Query suite calculating monthly profitability by item, customer, and salesperson with margin percentages and revenue contribution rankings.

Query classifying customers as Active, Dormant, or Lost based on purchase recency and frequency — feeds directly into Power BI sales dashboard.

Pareto analysis identifying top revenue-contributing customers and items, with running totals and cumulative percentage calculations using window functions.

Stored procedures extracting, cleaning, and transforming raw ERP data into structured tables ready for Power BI consumption via scheduled refresh.

Python script automating gross profit analysis from ERP CSV exports — data cleaning, margin calculations, supplier aggregations, and Excel report generation.

Python script generating formatted commercial invoice PDFs with proportional amount distribution across product lines using ReportLab.