Analysis of synthetic hospital patient data (2011–2022) using SQL to explore admissions, readmissions, length of stay, procedure coverage, and costs. Designed to demonstrate data querying, aggregation, and insights for healthcare operations.
Collection of solved exercises for Oracle Database, including SQL queries, DDL, DML, joins, subqueries, and practice problems.
🦠 Covid Data Cleaning 🧹 on SSMS (SQL Server 19.2) | 🍕 Pizza Sales Data Cleaning 🧹 on SSMS (SQL Server 20.0) | 🏦 Bank Loan Data Analysis & Cleaning 📊
Interactive Power BI dashboard analyzing credit card portfolio performance, including spend, revenue, growth, and delinquency KPIs (2025). Insights generated to support business decisions.
A/B test analysis for Maven Fuzzy Factory comparing bounce rates between the original homepage (/home) and a new landing page (/lander-1). Using SQL to filter traffic, calculate bounce rates, and verify statistical significance with 95% confidence intervals. Includes business recommendations and next steps for implementation.
ostgreSQL database analysis project solving community council queries using advanced SQL techniques including JOINs, aggregations, and window functions
SQL + Power BI analysis of 300K PhonePe transactions (₹3.47B) — found Loans drove ₹2.53B in revenue while Server Errors were the leading cause behind the 4% of failed payments.
Collection of SQL query solutions for LeetCode challenges.
Demo for Spring Boot Kafka Streams prove of concepts Stateful operations.
Food delivery platform database in MySQL — schema design, seed data, and progressively complex practice queries (joins, subqueries)
This Library Management System project demonstrates how a real-world library can manage books, members, and borrow transactions efficiently using SQL.
A PostgreSQL-based Book Store Management System that manages books, customers, and orders with data analysis through SQL queries
End-to-end Power BI dashboard project analyzing loan applications, borrower demographics, credit scores, loan amounts, default rates, YOY trends, and financial risk metrics to generate lending insights.
End-to-end banking analytics — PostgreSQL Star Schema, AML fraud detection & customer wealth segmentation using CTEs and Window Functions
Advanced SQL analysis of user interactions, influencer trends, and geographic engagement drivers to derive business growth insights.
To associate your repository with the joins-aggregation topic, visit your repo's landing page and select "manage topics."