Price Prediction Regression Algorithm using xGBoost
Streamlit | ML | XGBoost | Maps API
In this project, I implemented a price estimation algorithm using an XGBoost model trained on a year's worth of historical data.
The app provides users with accurate estimates for trip fares and ride durations based user inputs such as start and end locations, membership type, and desired bike type.
Integrated OpenAI ChatGPT-4.0 model to generate detailed route descriptions based on start and end stations.
Explore the application below!
Mapping Ottawa Neighbourhoods into Six Distinct Safety Profiles
Python | K-Means | Machine Learning
A K-Means analysis of 104 Ottawa neighbourhoods across 348,000 incidents (2018–2025), revealing a city split between quiet residential communities and a concentrated band of high-crime urban areas — with Centretown forming a statistical cluster of one.
Canada: Gas Price Research Analysis from 1990 - 2024
Python| Tableau | MySQL | Excel
This research project examines the changes in gas prices across Canada from 1990 to 2024, using monthly data from self-service filling stations
provided by Statistics Canada. It focuses on price fluctuations across different provinces, uncovering insights on key metrics such as year-over-year changes, average costs, and seasonal price variations.
Ottawa: Auto Theft Analysis
SQL | Python
This project analysis over 7,000 car thefts recorded by the Ottawa Police Service (OPS) from 2018-2013, uncovering patterns in theft occurrences and analyze key trends, such as year-on-year changes,
recovery rates, financial loss amount, and geographical analysis to identify high-risk areas in Ottawa, providing insights and recommendations to stakeholders to improve security measures and recovery rates.
Ottawa: Bike Thefts Analysis
Tableau
An interactive dashboard visualizing bike theft patterns across Ottawa neighbourhoods, highlighting high-risk areas and seasonal trends.
Marketing and Customer Insights Analysis
Tableau | SQL
This project analyzes data for an e-commerce company specializing in the sale of popular electronic products to
uncover critical insights covering sales, marketing expenditures, customer insights, and product offerings across 310 products in 10 business lines,
that will enhance OxiN’s marketing strategies and provide data-driven recommendations
Database Design: A Sports League Booking and Automation System
SQL
A comprehensive database to automate various processes for a sports league including creating new leagues, handling team signups, managing field rentals and payments, updating user records and processing cancellations.
Through this project, I aim to demonstrate my ability to handle end-to-end database development, including requirements gathering, table creation, data relationships, automation, and user privilege management.
An End-to-End Monthly Revenue KPI Dashboard
Tableau
An end-to-end dashboard that tracks and provides stakeholders with detailed insights on company KPIs — revenue generated, total trips, and ride details such as duration, revenue, and start/end time station.
Customer Insights Analysis for a Bike Company - Part 1
Python | KMeans | Tableau
This project analyzes the annual sale data for a bike rental company, with over 5 million records to extract insights and provide actionable
recommendations to drive customer and revenue growth, optimize targeted marketing, maximize product performance and improve operational efficiency.
Sales Performance Overview
Python | SQL | Tableau
Analyzing product sales records for a retail company to identify sales trends and performance by product category and customer region.
