Leetcode Top 50 SQL
LeetCode SQL Solutions repository! This repository contains my solutions to various SQL problems from LeetCode, showcasing advanced SQL skills and techniques.
Smart Watches - Price prediction
Analyzed a dataset of smartwatch prices using Python, performing data cleaning and feature engineering. Conducted exploratory data analysis with visualizations, and applied machine learning models to classify and predict price categories and key features. Evaluated model performance with metrics such as accuracy, mean squared error, and R-squared.
A/B testing on Vungle's new Algorithm
Vungle's A/B testing experiment seeks to determine if the new ad-serving algorithm (Algorithm B) generates higher eRPM, improves Click-Through Rates (CTR), increases conversion rates from impressions to installs, and impacts the fill rate to ensure optimal ad inventory utilization compared to the existing algorithm (Algorithm A)
ProBio - Linear Regression
Conducted a linear regression analysis on ProBio's sales data to evaluate the impact of in-store demos, endcap promotions, and sales representatives on sales. Findings revealed that endcap promotions, sales representatives, and in-store demos significantly boosted sales, with lasting effects from demos. Based on these insights, recommendations were made to continue and optimize the promotional programs for improved sales performance.
Movie Sales & Revenue - Linear Regression
Performed a linear regression analysis on movie data to evaluate the impact of budget, advertising, rating, screens, and sequels on box office revenues. Found that advertising, budget, and sequels significantly boost revenues. Recommended using these insights to optimize future movie marketing strategies for higher box office returns.
MindBook - Logistic Regression
Conducted a logistic regression analysis on MindBook's customer data to evaluate factors influencing purchase decisions for a new book title. Found that amount previously purchased, last purchase time, and specific book categories significantly affect purchasing likelihood. Implemented targeted mailing strategy to enhance campaign profitability, yielding a significantly higher profit compared to random mailing
Car Dealership - Logistic Regression
Performed a logistic regression analysis on a car dealership's marketing campaign data to identify factors influencing customer acquisition. Found that billboard views, coupons, email promotions, and distance from the dealer significantly impact customer conversion. Implemented targeted marketing, achieving a higher conversion rate and increased profitability compared to random mailing.