Project Milestone 2: KPIs and Datasource

Fact tables:

1. Crime
2. Unemployment

Dimension tables:

1. Category
2. Location
3. Date
4. Subcategory
5. Gender
6. Race

 

Dimensional Model:

 

 

 

ER Diagram DW Project

 

Link to dimensional model: https://drive.google.com/file/d/1jtnju3HwZWp-x9CFMNH1NSCDwRkv_zy3/view?usp=sharing