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-based EDA project exploring a retail data warehouse. Includes database setup and analysis scripts for data exploration, dimension profiling, date range discovery, measures analysis, magnitude breakdowns and ranking using aggregates and window functions.

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.

SQL Project | PostgreSQL | pgadmin

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.

This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cummulative, 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.

End-to-End Data Cleaning and Preparation on a raw FIFA players dataset using PostgreSQL and pgAdmin 4.

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 repository contains the solutions of the 8 case studies for The 8 Weeks SQL Challenge

This repository provides a comprehensive guide for building production-ready data warehouses using SQL Server. It walks through the complete process of implementing a modern data warehouse using Medallion Architecture (Bronze, Silver, Gold layers) with practical code examples and detailed.

This project demonstrates an end-to-end analytics workflow using Google BigQuery to analyze bike rental data. The project focuses on uncovering insights related to rental demand, revenue trends, seasonality, and user behavior using advanced SQL techniques including aggregations, joins, CTEs, window functions, and KPI calculations.

No description provided.

Developing a modern data warehouse on SQL Server, encompassing ETL workflows, data modeling, and analytical capabilities.

This repository contains SQL queries for the SQL for Data Analysis given by Udacity. The queries include commands to define, select, manipulate, control access, aggregate, and join data and data tables.

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.

This repository contains SQL scripts for analyzing ERP and CRM data from the gold layer of the data warehouse built in PostgreSQL-Data-Warehouse-Project. It covers both exploratory data analysis and advanced analytics techniques like trend analysis, cumulative metrics, performance tracking, data segmentation, and part-to-whole evaluation.

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.

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

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.

A hands-on SQL project simulating data analysis using fact and dimension tables, covering trends over time, cumulative metrics, performance breakdowns, segmentation, and reporting via SQL.

A collection of T-SQL scripts I written throughout my journey as a Data Analyst, Data Engineer, and BI Developer. They demonstrate the use of window functions, calculating dates, dynamic SQL, stored procedures, and other out of the box 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.

Built a Data Model, Implemented Basic to Advanced SQL Queries

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

We analyse GPS fleet data to evaluate driver behavior, detect risky patterns, and identify route anomalies using real world telematics from California. The goal is to have an end-to-end analytics pipeline that will transform raw trip data into actionable insights for fleet safety, operational efficiency, and proactive risk management.

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.