NIKHIL GUPTALet's talkProject archive
Evidence,
not decoration.
A focused collection of business analytics and AI/ML work, with the source, methods, outcomes, and recruiter-ready documentation attached.
Explore the workAll projects
Built to answer real business questions
Every case study below includes working GitHub source and a report you can download, review, or share.
Enterprise data warehouse
ICE Entertainment
Unified disconnected sales and ERP systems into a star-schema warehouse designed to answer board-level questions on revenue, cost, and margin.
50,000+ records · 500 stores · 10 countries
Demand forecasting
EcoMoveUS
Built a regression workflow to forecast bike-rental demand from weather, calendar, and temporal features, supporting fleet and staffing decisions.
Random Forest: R² 0.941 · RMSE 50.24
Decision modelling · LP / ILP / NLP
Investment Portfolio Optimisation
Built three Excel Solver optimisation models — linear, integer, and nonlinear — to construct an ASX equity portfolio under real sector, risk, and allocation constraints.
10 ASX stocks · 5 sectors · 3 optimisation models
Monte Carlo simulation
Alpine Peak Snow Resort
Built a 1,000-trial Monte Carlo simulation to test room-rate and overbooking strategy for a 50-room alpine resort, weighing expected profit against downside risk.
$450/night beats $350/night by +47.9% mean daily profit
Network & transportation modelling
VicGoods Logistics
Built a linear-programming transhipment model to minimise weekly freight cost across a 3-tier network of plants, distribution centres, and retail outlets in Victoria, then stress-tested it against route disruption.
Min weekly freight cost: $6,943 · 5 plants · 2 DCs · 6 outlets
Descriptive analytics & visualisation
GoodNews National Bookstore
Designed an interactive Tableau dashboard for a national bookstore chain, turning raw sales, membership, and financial data into a live, explorable story for decision-makers.
Live interactive Tableau dashboard
Have a role or analytics problem in mind?