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
This repository contains a real example of an Extract, Transform, Load (ETL) process using SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), and AdventureWorks2012 data. The objective is to load data into our LightAdventureDW data warehouse.
Medallion-architecture fleet analytics on Microsoft Fabric: ingestion from SSMS staging, cleansing & enrichment via Dataflow Gen2, storage as Delta tables in Lakehouse, curation through Fabric Warehouse & semantic model, and interactive Power BI dashboards.
Modern data warehouse in SQL Server with GTFS data from Buenos Aires buses and exploratory analysis using Jupyter Notebook, built to facilitate data analysis and to provide clear insights on bus attributes
This repository contains the design and implementation of a retail Data Warehouse project for DWBI coursework. The solution integrates multiple data sources, builds a star schema, and implements ETL workflows to populate and maintain dimensional and fact tables.
Structured SQL patterns for data engineering: incremental loads, CDC logic, validation queries, foreign key dependency checks, SCD Type 2, MERGE/UPSERT, and data quality tests.
Hurtownia danych oparta o Microsoft SQL Server, Analysis Services, Integration Services oraz Power BI gromadząca dane o rozprzestrzenianiu się koronawirusa na świecie.
This project demonstrates the end-to-end process of building a Data Warehouse using SQL Server and Azure Data Studio. It covers data ingestion, transformation, modeling, schema design, and BI reporting.