Blog
Thoughts on software engineering, web development, and technology trends. Sharing insights from building scalable applications.
Building an Order Fulfilment Database for an E-Commerce Platform
A deep dive into designing an Amazon-inspired relational database from scratch covering schema design, normalisation, warehouse-to-postcode routing, serialised inventory modelling, and the SQL queries that tie it all together.
All Posts
2 postsHotel Booking Cancellation Prediction — EDA & Machine Learning
Applying exploratory data analysis and four classification models — Logistic Regression, Decision Tree, Random Forest, and KNN — to predict whether a hotel reservation will be cancelled, using a real-world dataset of 36,275 bookings.
Sales Forecasting with Python — Random Forest on UK Retail Data
A complete end-to-end sales forecasting pipeline built on a real UK online retail dataset of 1M+ transactions. Covers data cleaning, exploratory analysis, feature engineering with lag variables and seasonal flags, and a Random Forest model that predicts next month's revenue.