Data warehouse end-to-end scenario. Focuses on data warehousing, from data acquisition to data consumption on the Microsoft Fabric platform.

This Data Warehouse project is built on a Medallion Architecture design to manage and process information from CRM and ERP systems.

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.

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.

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

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

Building a Mordern Data Warehouse with SQL Server, Including ETL Processes, Data Modeling and Analytics

A PowerShell query launcher for SQL Server Data Warehouse

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.

Continuação do repósitorio Data_WareHouse_ETL_1

global terrorism - data warehouse project + analysis

Hurtownia danych oparta o Microsoft SQL Server, Analysis Services, Integration Services oraz Power BI gromadząca dane o rozprzestrzenianiu się koronawirusa na świecie.

Criação de um modelo de dados de uma Data Warehouse usando ETL com Integration Services.

Hurtownia danych do analiz sprzedaży w salonach samochodowych określonej marki.