A comprehensive guide to building a modern data warehouse with SQL Server, including ETL processes, data modeling, and analytics.

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.

collection of SQL - Tableau integration projects for Data Analytics and Business Intelligence

🚀 A curated collection of SQL mini challenges designed to strengthen your database querying skills. This repository includes weekly exercises focused on real-world scenarios, ideal for beginners and intermediate learners aiming to master SQL through hands-on practice.

Zomato Data Exploration and Analysis with SQL (SQL SERVER)

This is an Analysis to optimise inventory managemnt for FitCapacity company by analyzing sales and inventory data using SQL and PowerBI

Data Analyst Portfolio Project 1 - SQL and PowerBI - Cleaning and analysing the AdventureWorks dataset with SQL, then visualizing it with PowerBI

SQL for Data Analysis using PostgresSQL - analyzing Parch&Posey fictional company

Aprender scripts de consulta e manipulação de dados no Azure SQL

SQL data analysis project from basic statistics like median, min, max, avg,etc to percentile, correlation or linear regression

Building a modern data warehouse with Microsoft SQL Server, including ETL processes with Bronze Layer, Silver Layer and the Gold Layer, data modeling and as well as analytics.

In this repository you will find SQL queries of multi-difficulty levels that can applied on to large datasets for various business requirements.

This repository contains SQL problems from HackerRank, DataLemur and other challenges. Contains solutions to improve skills in database querying, optimization, and data manipulation.

Advanced SQL analytics project extending prior EDA work. Includes change-over-time, cumulative trends, performance benchmarking, segmentation, part-to-whole analysis, and customer/product analytical reporting using window functions and real-world data warehouse logic.

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.

A PowerBI dashboard to explore the raw sales data for an online retailer of bicycles and bicycle components in order to obtain insights into its sales performance, customers, and products.

Data Analysis case studies on various databases using SQL . Demonstrating proficiency in solving diverse business problems. Projects cover sales, orders, products, finance, healthcare and other sectors, and highlight my ability to analyze complex datasets through SQL queries, data manipulation, and visualization techniques.

Design and Implementation of a data warehouse on the "Northwind" database.

This repository contains intermediate to complex sql queries which explains sql concepts. This repository can be helpful when writing queries with complex concepts and can be considered for reference. (Most queries have DDL and DML command within for practise)

This is a project that shows my ability to query data from Adventure Works database Using SQL, thereafter using PowerBI to import , analyze and visualise.