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
Examples of SQL scripts. Includes templates for admin (SQL server) and data cleaning, as well as scripts designed for creating a mock database, illustrating triggers, common table expressions, analysis, and ETL.
The aim of this analysis was to extract valuable insights and answer a variety of questions related to the history, participation, and performance of nations and athletes in the Olympic Games. This project demonstrates my proficiency in Data Analysis, SQL Querying using advance functions like CTE, Joins, CASE, Pivot.
End-to-end SQL Data Warehouse project implementing the Medallion Architecture (Bronze–Silver–Gold) using T-SQL. Covers data ingestion, cleansing, transformation, and modeling.
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.
Microsoft SQL Server es un sistema de gestión de bases de datos relacionales (RDBMS) que admite una amplia variedad de aplicaciones de procesamiento de transacciones, inteligencia empresarial y análisis en entornos informáticos corporativos.
Comprehensive SQL analytics project that transforms raw data into actionable insights using advanced SQL techniques (CTEs, window functions, aggregates) for in-depth reporting and analysis.
End-to-end SQL Data Warehouse project implementing Medallion Architecture and Star Schema. Engineered automated ETL pipelines for data integration. Beyond engineering, I performed advanced SQL analysis using CTEs & Window Functions to uncover key business insights. Demonstrates mastery in data modeling, SQL Server, and analytical problem-solving.
The aim of this analysis was to extract valuable insights and answer a variety of questions related to the history, participation, and performance of nations and athletes in the Olympic Games. This project demonstrates my proficiency in Data Analysis, SQL Querying using advance functions like CTE, Joins, CASE, Pivot.
Publishing all latest matches, scores, goalscorers, assist makers and cards during the 2020-21 Premier League season. All SQL commands include, top scorers, which stadium has the most goals and many more.
This project cleans and prepares a layoffs dataset using SQL by removing duplicates, standardizing text, handling null/blank values, and dropping unnecessary columns. The result is a consistent, high-quality dataset ready for reporting, analysis, and visualization.