You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This project analyzes historical transaction data from Walmart stores using advanced SQL queries to uncover insights related to sales performance, customer behavior, and operational efficiency. By leveraging SQL techniques, the project covers various aspects such as branch performance, product profitability, customer segmentation, and sales trends.
Ejercicios prácticos de SQL intermedio con MySQL 8+: SELECT avanzado, JOINs, Agregaciones, CTEs, Subconsultas y Window Functions. Incluye soluciones y esquema de base de datos lista para usar.
This project demonstrates end-to-end data analysis of an online bookstore using SQL. It covers data modeling, importing CSV files into PostgreSQL, and writing queries for business intelligence insights. The project showcases skills in SQL querying, joins, aggregation, window functions, and real-world data problem-solving.
This repository, NorthWind Customer Churn Analysis, leverages the NorthWind database and MySQL to analyze customer churn patterns. It identifies trends, predicts at-risk customers, and provides actionable insights to improve customer retention.
Advanced SQL for Data Analytics. A collection of problem-solving solutions covering complex Joins, Window Functions, CTEs, and Query Optimization. Includes real-world interview questions, schema design, and dataset analysis for MySQL and PostgreSQL
These Projects have SQL real-world data analysis with Netflix and Zomato datasets.Worked with complex queries utilizing JOINs, aggregation functions, GROUP BY, subqueries, CTEs, and window functions. Analyzed popular content, cuisine preferences, revenue metrics, and operational performance.
SQL-based operational analytics project built on a logistics transportation dataset hosted on Supabase. The project applies advanced PostgreSQL techniques to derive insights on fleet performance, route economics, operational risk, and demand trends.
Engineered a BI framework to drive growth and operational efficiency. Segmented 90+ customers for churn mitigation, audited logistical ROI to optimize shipping costs, and automated margin protection for discontinued inventory. Delivered actionable KPIs for sales attribution and revenue forecasting using 830+ order records.
MySQL projects on GitHub showcase a wide range of applications, sample databases, and learning resources designed to help developers understand SQL, relational modeling, and backend integration. Many repositories feature sample databases such as the well-known test_db, which contains realistic employee records.