 CIEF ACC1
|
3b2a2555ae
|
Added order refund datetime column to rep order table
|
2024-10-09 03:53:28 +00:00 |
|
|
CIEF ACC1
|
ff552ebd0d
|
renamed to new service type
|
2024-05-13 02:21:08 +00:00 |
|
|
CIEF ACC1
|
49fcb7f6e5
|
Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into build-wallet-cash-flow-analysis
|
2024-05-08 08:24:48 +00:00 |
|
 Yam ZhengLim
|
6cbc293e25
|
Accommodate new service type and update on-time logic
|
2024-04-05 03:14:14 +00:00 |
|
|
CIEF ACC1
|
75910a77fe
|
Added metrics
|
2024-04-03 06:10:11 +00:00 |
|
|
CIEF ACC1
|
5fabf779d9
|
Changed comparison competitor
|
2024-04-01 09:58:59 +00:00 |
|
|
CIEF ACC1
|
1b107599f6
|
updated logic to calculate wallet balance
|
2024-03-22 06:27:27 +00:00 |
|
|
CIEF ACC1
|
0550be2ed3
|
build wallet cash flow analysis
|
2024-03-15 07:15:38 +00:00 |
|
|
CIEF ACC1
|
809763ab80
|
Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into lee_build_exchange_rate_fact
|
2024-03-12 01:08:49 +00:00 |
|
|
CIEF ACC1
|
7acfcad86a
|
Merge branch 'main' into 'lee_build_exchange_rate_fact'
# Conflicts:
# models/marts/warehouse/fct_exchange__transaction_orders.sql
|
2024-03-07 02:11:48 +00:00 |
|
|
CIEF ACC1
|
2bee6b91ef
|
Redefined on-time logic
|
2024-03-07 02:04:48 +00:00 |
|
|
Yam ZhengLim
|
3853e54dcf
|
build exchange rate analysis
|
2024-03-06 02:25:59 +00:00 |
|
|
CIEF ACC1
|
b6b7663bc2
|
build
|
2024-01-12 01:25:25 +00:00 |
|
|
CIEF ACC1
|
20db620d27
|
added is_migrated_company, company_created_datetime, and next_order_datetime variable
|
2023-12-29 10:31:33 +00:00 |
|
|
CIEF ACC1
|
1b60be4522
|
Shipping data model - survival analysis
|
2023-12-29 09:43:22 +00:00 |
|
|
CIEF ACC1
|
a4c4fc83cb
|
Shipping data model - rfm
|
2023-12-29 09:42:53 +00:00 |
|
|
CIEF ACC1
|
cfc1e36d9a
|
Shipping data model - company lists
|
2023-12-29 09:42:08 +00:00 |
|
|
CIEF ACC1
|
4514c35db4
|
Shipping data model - company engagement behavior
|
2023-12-29 09:41:36 +00:00 |
|
|
CIEF ACC1
|
b285a9546d
|
Shipping data model - cohort analysis development
|
2023-12-29 09:40:01 +00:00 |
|
|
CIEF ACC1
|
6c63f37d0c
|
Debug calculation formula to avoid infinity when log(0) is encountered
|
2023-12-29 09:39:15 +00:00 |
|
|
CIEF ACC1
|
21e3ecf9a6
|
Merge branch 'lee_build_rep_frozen_account_incidents' of gitlab.com:cief-data/dbt_cloud into lee_build_rep_frozen_account_incidents
|
2023-12-14 06:00:33 +00:00 |
|
|
CIEF ACC1
|
6ecff261f6
|
Logic fix for is_on_time_delivery
|
2023-12-14 06:00:32 +00:00 |
|
 Yam ZhengLim
|
42202ccea1
|
Merge branch 'main' into 'lee_build_rep_frozen_account_incidents'
# Conflicts:
# models/marts/reporting/rep_exchange__daily_orders.sql
Yam add order_created_week_number, order_created_month_day_number etc... from dim_dates to enhance order_created_datetime column
|
2023-12-10 06:56:45 +00:00 |
|
|
CIEF ACC1
|
eea798478c
|
fix service_type
|
2023-12-01 01:37:57 +00:00 |
|
|
CIEF ACC1
|
68908bf57c
|
Enhance company detail only
|
2023-11-22 16:26:31 +00:00 |
|
|
CIEF ACC1
|
eefb32db93
|
Change status into business driven naming
|
2023-11-22 16:25:16 +00:00 |
|
|
Yam ZhengLim
|
0f5f6665ec
|
Add order_created_dates
|
2023-10-23 16:57:28 +00:00 |
|
|
CIEF ACC1
|
d59b6908ef
|
Merge branch 'main' into 'lee_build_int_get_latest_cost'
# Conflicts:
# models/marts/reporting/rep_exchange__daily_orders.sql
|
2023-10-10 06:55:55 +00:00 |
|
|
CIEF ACC1
|
9206cfa02e
|
Added Model
|
2023-10-10 05:23:11 +00:00 |
|
|
CIEF ACC1
|
5d9f357837
|
Add Business Term status
|
2023-10-10 05:23:03 +00:00 |
|
|
CIEF ACC1
|
c27858b932
|
Added Model
|
2023-10-10 05:22:45 +00:00 |
|
|
Yam ZhengLim
|
656d584da9
|
order lifetime value compute
|
2023-10-03 06:36:22 +00:00 |
|
|
CIEF ACC1
|
2ec4184064
|
debug estimated_order_delivery_datetime_customer_expectation to include existing time
|
2023-08-25 08:12:51 +00:00 |
|
|
CIEF ACC1
|
159c5c82a8
|
replaced fct transaction orders
|
2023-08-24 04:33:02 +00:00 |
|
|
CIEF ACC1
|
c5aff88531
|
changed name to fct_transaction_orders
|
2023-08-23 09:01:52 +00:00 |
|
|
CIEF ACC1
|
eee76d9a82
|
changed name to fct_transaction_orders
|
2023-08-23 09:01:43 +00:00 |
|
|
CIEF ACC1
|
d99072a27c
|
changed name to fct_transaction_orders
|
2023-08-23 09:01:33 +00:00 |
|
|
CIEF ACC1
|
e32bddd3c9
|
changed name to fct_transaction_orders
|
2023-08-23 09:01:22 +00:00 |
|
|
CIEF ACC1
|
9f0b206350
|
changed name to fct_transaction_orders
|
2023-08-23 09:01:03 +00:00 |
|
|
CIEF ACC1
|
8abc7b4e34
|
replaced new fct orders table
|
2023-08-23 08:14:20 +00:00 |
|
|
CIEF ACC1
|
9b3cdc7140
|
replaced new fct orders table
|
2023-08-23 08:14:09 +00:00 |
|
|
CIEF ACC1
|
3824bbe56d
|
replaced new fct orders table
|
2023-08-23 08:13:57 +00:00 |
|
|
CIEF ACC1
|
991db604ff
|
replaced new fct orders table
|
2023-08-23 08:13:47 +00:00 |
|
|
CIEF ACC1
|
2a90f2cef2
|
replaced new fct orders table
|
2023-08-23 08:13:30 +00:00 |
|
|
Yam ZhengLim
|
52173653c0
|
Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into compile_company_dimension_for_dedupe
|
2023-08-08 03:10:52 +00:00 |
|
|
Yam ZhengLim
|
4679a4693c
|
debug next_order_created_datetime
|
2023-08-08 03:10:39 +00:00 |
|
 CIEF DataTeam
|
9b9b694210
|
Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into YAM_rep_shipping_company_purchase_frequency
|
2023-08-02 12:17:57 +00:00 |
|
|
CIEF DataTeam
|
f426376997
|
Remove Super high usage
|
2023-08-02 12:17:43 +00:00 |
|
|
Yam ZhengLim
|
cf6bc44baa
|
Merge branch 'compile_company_dimension_for_dedupe' into 'main'
Sales lead activation model
See merge request cief-data/dbt_cloud!17
|
2023-08-02 04:14:07 +00:00 |
|
|
Yam ZhengLim
|
4eb48eb070
|
sales exchange lead activations
|
2023-08-02 04:12:39 +00:00 |
|