End-to-End Sales Data Warehouse (Dimensions & Fact Modeling)

Designed a Star Schema Data Model:

Product Dimension

Customer Dimension

Salesman Dimension

Date & Time Dimensions

Developed ETL scripts using SQL:

Data extraction from OLTP systems

Data transformation and cleansing

Data loading into dimension and fact tables

Implemented Fact Table:

Sales Fact with multiple lookups:

Date

Time

Customer

Product

Salesman

Created and managed:

Database backups (.bak)

OLTP & OLAP environments

Applied data integration logic to ensure consistency between transactional and analytical systems