This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis.

This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis.

This repository features SQL-based analysis on bike rentals and the NFT market. The bike rental project explores customer trends, peak rental times, and revenue insights, while the NFT case study analyzes sales trends, blockchain transactions, and market dynamics. Built using SQL queries for data cleaning, aggregation, and joins in MySQL.

SQL case studies and exercises from my studies at Mate Academy. This repository contains queries for data analysis, transformations, and optimization, covering topics like joins, window functions, and aggregate queries. A learning journey in SQL for data analytics.

This project analyzes e-commerce order fulfillment using Advanced SQL Techniques and Python-based visualization to uncover insights on sales trends, customer segmentation, shipping cost optimization, and payment preferences.

Using complex SQL queries, including PostgreSQL window functions, to answer specific business questions. Notably using multiple named subqueries, views to extract data from a database to address specific problems.

Danny Ma's #8WeekSQLChallenge case study solutions.

This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis

SQL_Notes: Learn SQL concepts through practical application! This repository contains concise notes on key SQL concepts, commands, and techniques, illustrated by solutions to LeetCode SQL challenges and exercises from other sources. Sharpen your SQL skills by understanding the why behind the code!

bunch of SQL Window function query examples

Developed a data processing pipeline to transform Canadian banking data using PySpark on Databricks. The pipeline standardizes, cleans, and enriches raw financial datasets for downstream analytics and reporting.

Built a Data Model, Implemented Basic to Advanced SQL Queries

This repository contains a collection of SQL scripts that demonstrate various analysis techniques, such as change over time, cumulative, performance, data segmentation, part-to-whole analysis.

sql along with a case study

This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis

An Advanced SQL Analytics Project demonstrating end-to-end data analysis using SQL — from EDA and ADA to data transformations and final business reports. Includes two analytical views summarizing Customer and Product performance with insights on revenue, trends, and growth.

MySQL-for data analytics

A structured SQL analysis of Major League Baseball (MLB) data using analytical queries and window functions.

Welcome to the "Spotify Music Analysis - 2023" project! Here, we're exploring a carefully compiled dataset showcasing the standout songs of 2023, as documented by Spotify. This dataset goes beyond the usual song collections, offering a complete look into each track's characteristics, popularity, and visibility across different music platforms.