Building an End-to-End Data Warehouse & BI Pipeline with SSIS, SSAS, and Power BI

As part of my Data Warehousing and Business Intelligence module at SLIIT, I built an end-to-end BI solution using SQL Server, SSIS, SSAS, Excel, and Power BI.

The goal of this project was to transform raw sales data from CSV and TXT files into a structured data warehouse that supports analytical reporting and business insights.

This project helped me understand how modern BI systems process raw data into dashboards and decision-making reports using ETL pipelines, OLAP cubes, and visualization tools.