Recreate Fact and Dimension

[dion-ricky]

Relationship	Priority	Est. Time
...	High	5 days

---

Fact and dimension model is all wrong because I want to do it quickly. So, before continuing with the analysis fix the warehouse first. Steps are:

1. Identify dimensions
2. Identify facts
3. Create Migration + ETL for dimension table
4. Create Migration + ETL for fact table

Todo:

• [x] #24
• [x] #29
• [x] #30
• [x] #31
• [x] #32

[dion-ricky]

Fact order:

• time DONE
• date DONE
• product + (category) DONE
• seller_location
• customer_location
• seller (omit location) DONE
• customer (omit location) DONE
• order_status (only status) DONE

[dion-ricky]

Location dimension:

• add lat long from ext_latlong_kabko
• add pdrb from ext_pdrb
• add state population from ext_state_population