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

The most comprehensive SQL guide from a real-world expert! Learn everything from basics to advanced queries, optimizations, and real-world 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.

Starter project for building an ETL pipeline using SSIS in Visual Studio 2019

Explore my SQL Data Engineering portfolio. See how I use SQL to organize data and create smart solutions for better insights and smoother processes.

This repository contains all the assignments, workshops and mini-projects of course - DAMG7370 Designing Advanced Data Architectures for Business Intelligence

Designed Multi Star schema with 10 Fact & 33 Dimension tables & developed Data Integration Pipeline by ETL workflow to load all tables (380M+ rows) from multiple sources such as CSV, MySQL, MSSQL & PostgreSQL by using Talend. Implemented Data Profiling, Error Handling, Load Statistics, Cleansing and Performance Tuning to address data quality gap…

Using TPC-DI to benchmark MS SQL server using SQL script for extract, transform and load (ETL).

This is a full example of E2E data processing using Microsoft Fabric with some publically available NHS data. Feel free to explore/fork/reuse etc...

Hybrid E-Marketing using Web Page Mining for Website Monetization

🚗 Data engineering scenario for a Car Sales company Achieved Distinction for this module with SQL proficiency

Constructing a contemporary data warehouse that spans multiple databases, with complete ETL pipelines, structured data models, and robust analytics tools.

Building a modern data warehouse including, ETL process, data modeling and analytics

Projeto de BI e engenharia de dados. Criação completa de bancos de dados, ferramentas de busca e visualizações a partir das necessidades de empresa de sucos e bebidas refrescantes.

Project 4: Udacity Nanodegree Program - Data Engineering with Microsoft Azure

Building a modern data warehouse with SQL server, including ETL process, data modeling and analysis

Designed and implemented a complete Data Warehouse solution, defining data architecture, designing multi-layer (Bronze, Silver, Gold) E.T.L. pipelines, and building star schema models in SQL scripts to transform and load data from multiple CRM and ERP systems, with final data visualized using Tableau.

😊️️️️️️ Leetcode database part solutions

Built a scalable data warehouse architecture in SQL Server, featuring well-structured star schemas and automated ETL workflows. The project supports accurate, fast, and insightful reporting through optimized analytical queries, enabling data-driven decision-making.

Building a modern warehouse with SQL Server , including ETL processes , data modeling and analytics.