MetroCar Project

Analyzed user funnel to boost first-ride completions. Optimized marketing across iOS, Android, and web. Targeted marketing by age group. Recommended surge pricing and simplified payments.

chinook-sql-analytics

Performed SQL analysis on the Chinook database to identify managers with 2+ direct reports, calculate 2024 MPEG-4 video revenue, count distinct playlists for classical composers, and find customers with increasing yearly spending. Aimed to enhance management insights, revenue tracking, and customer

SQL_Flight_Analytics

This repository contains SQL queries for analyzing flight data. It includes counting flights during work weeks and weekends, identifying users with notable hotel discounts, finding the airport with the most services, and ranking airports by service percentage. These solutions offer insights into fli

Nike_Statewise_Performance_Analysis

This project features SQL queries to analyze Nike's customer and order data by state for quarterly reviews. It identifies unique states, corrects data inconsistencies, and calculates total and categorized order completions. It also evaluates total revenue, returned items, and return rates to aid str