Skip to content

NourTarek201/Datawarehouse-Design---AdventureWorksLT

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Datawarehouse-Design---AdventureWorksLT

This is a Contribution to Complete DataWarehouse Course Project at Faculty of Computers & AI at Cairo University

The data warehouse will model key business processes from the AdventureWorks LT 2022 schema, including Sales Data, Order Information, Customer Data, and Shipping. These processes are essential for performing segmentation, customer analytics, clustering, and more, inspired by retail analytics. This approach supports Sales Simulation training and comprehensive analysis.

Source DB

adventureworks-erd

Star Schema

dimensional mode drawio (3)

PowerBI on Fact Tables

Screenshot_36 Screenshot_37 Screenshot_38 Screenshot_39 Screenshot_40

Used Tools

  • SSIS ETL Visual Studio
  • PowerBI

Authors

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 2

  •  
  •