End-to-end Data Warehousing and Business Intelligence solution for banking operations. Features comprehensive ETL pipelines using SSIS, Star Schema modeling in SQL Server, and OLAP Cube creation with SSAS.
This repository contains an SSIS package that splits employee data from the AdventureWorksDW2017 database into country-specific tables (United States, United Kingdom, Germany, and others). It demonstrates ETL processes using tools like Merge Join, Conditional Split, and OLE DB Destination for efficient data integration.
End-to-end MSBI solution for credit card analytics. Features complex ETL pipelines (SSIS), multi-strategy incremental loading, and SSAS multidimensional cubes for fraud detection and reporting.
Add a description, image, and links to the msbi topic page so that developers can more easily learn about it.
To associate your repository with the msbi topic, visit your repo's landing page and select "manage topics."