SQL Ongoing Post: SQL Problems & Solutions to LeetCode and DataLemur Problems - ‘Medium’ & ‘Hard’ Difficulties
A live document where I demonstrate my solutions to Medium and Hard-ranked SQL problems from LeetCode and DataLemur.
Posts and Projects by Year
2024
Time Series Forecast: Predicting Daily Sales for Walmart
Discover how I used time series-oriented machine learning models to forecast daily sales for Walmart stores, uncovering insights that could reshape retail de...
2022
Python Project: Analysing Customer Purchasing Behaviour in Retail
Defining metrics to capture customer behaviour and understanding the drivers of spend for different segments
Python Project: Evaluating Marketing Campaign and Performing Customer Clustering
An analysis of the effectiveness of a marketing campaign and performance of customer clustering to improve future campaign targeting
A/B Testing Python Project: Testing whether a Smart Ad increases consumer response rates
Using statistical testing to derive causality and validity for business outcomes
SQL & Tableau Project: - Analysing Performance of an E-Commerce Business
SQL queries, dashboards and toystores
SQL & Tableau Project: the Coronavirus Pandemic
Exploring How the Coronavirus Pandemic Has Evolved Over Time
2021
Python End-to-End Machine Learning Project: Using Machine Learning to Minimise Costs of Mental Health Initiatives in the Workplace
Predicting mental health developments in the workplace to more accurately calculate budgets for mental health initiatives
Python End-to-End Machine Learning Project: Improving Government Understanding of Labour Markets via Salary Prediction
Using regression techniques to understand what drives levels of salaries
2020
Python Data Visualisation Post: The Ebb and Flow of A Battle Royale Game in Python
A visualisation project that delves deep into the video game industry
Python Data Cleaning Post: Police Stop and Search Incidents within selected areas in the UK in Python
Clean data is good data
Post: A Tutorial for Natural Language Processing
A Beginner’s Brief Overview of Sentiment Analysis & Text Classification
2019
Python End-to-End Machine Learning Project: Spotify Artist Success (Python)
Predicting Musician Success on Spotify to Inform Pre-emptive Signing Decision for Record Labels
Python End-to-End Machine Learning Group Project: Forecasting Electrical Power Usage Using Time Series (Python)
A group project in which my team and I use time series and supervised learning approaches to forecast electrical power usage for clients