gravity-books-data-warehouse

End-to-end Data Engineering project that transforms a transactional bookstore database into a dimensional Data Warehouse and SSAS OLAP Cube for analytical reporting.

Architecture

Source: OLTP Bookstore Database

ETL: SSIS

Warehouse: SQL Server Star Schema

OLAP: SSAS Multidimensional Cube