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

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.

Advanced SQL + MySQL for Analytics and Business Intelligence

Antenna Distribution is a project that shows how to run business analysis tools on a set of a data.

Dedicated repository for Microsoft SQL Server code templates and samples.

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 project analyzes sales and shipment data for a US national candy distributor, covering customer orders, product details, factory locations, and regional targets. Using Power BI and a structured data warehouse,

Dedicated repository for Microsoft SQL Server functions and samples.

This project is a Data Warehouse built using SQL, incorporating ETL processes, Data Modeling, and Analytics. It follows the Medallion Architecture (Bronze, Silver, and Gold layers) to ensure efficient data ingestion, transformation, and reporting. The goal is to create a scalable and optimized data pipeline for insightful analytics.

Building a modern data warehouse with sql, including ETL processes, data modelling, and analytics.

This Repository Contains a collection of SQL Scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, part-to-whole anlaysis.

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 implements a Data Warehouse using the Medallion Architecture, ingests data from CSV files into SQL tables, clean them in silver layer and produces STAR schema in Gold Layer. It also provides data marts for customer and products for BI Implementation.

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.

Building an ETL pipeline to prepare source data for visualization, ensuring the data is clean, structured, and ready for accurate and insightful 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.

desc

A curated collection of SQL scripts that demonstrate a variety of fundamental data analytics techniques in a database context. This repository offers practical examples to help you explore, aggregate, filter, and report on data using pure SQL.

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.