Building Sales Data Mart

intoduction:

In this project, I focus on building a sales data mart for a company by extracting new and updated data from the AdventureWorks2019 (OLTP data) database, creating a star schema and load data to dimensions and fact tables after transforming the data, and finally applying full, incremental, and slow-changing dimension (SCD) loading.

Data Mart: is a subject-oriented database that is often a partitioned segment of an enterprise data warehouse.

Data Source:

using AdventureWorks2014 (OLTP) from microsoft source.

steps:

1. Data Modeling by creating star schema for the data mart:

2. Slowly Changing Dimension (SCD)

3. Full load to fact sales table

4. Increamental load for new records updated to the source database.