 CIEF ACC1
|
3b2a2555ae
|
Added order refund datetime column to rep order table
|
2024-10-09 03:53:28 +00:00 |
|
|
CIEF ACC1
|
a00089a40c
|
Fix logic for summing invoice value
|
2024-08-07 09:53:15 +00:00 |
|
|
CIEF ACC1
|
d4ef402cb9
|
replaced model name in yml file
|
2024-07-01 06:56:18 +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
|
9de1c91e50
|
Fixed corrupted stage model
|
2024-04-01 02:20:04 +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
|
05339a85ad
|
Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into build-wallet-cash-flow-analysis
|
2024-03-14 02:24:37 +00:00 |
|
|
CIEF ACC1
|
d1e09ff1a6
|
Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into build-wallet-cash-flow-analysis
|
2024-03-12 07:17:12 +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
|
3c0ced171a
|
Build cash flow analysis
|
2024-03-12 01:08:06 +00:00 |
|
|
Yam ZhengLim
|
1b90eb6eda
|
Changed file name for consistency
|
2024-03-07 09:04:01 +00:00 |
|
|
Yam ZhengLim
|
3341e41e9b
|
change join reference
|
2024-03-07 07:57:01 +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
|
715f51ee35
|
Total order/cost value formula redefined
|
2024-03-07 02:05:22 +00:00 |
|
|
CIEF ACC1
|
2bee6b91ef
|
Redefined on-time logic
|
2024-03-07 02:04:48 +00:00 |
|
|
Yam ZhengLim
|
dd42248cdd
|
build base wallets
|
2024-03-06 03:42:37 +00:00 |
|
|
Yam ZhengLim
|
3853e54dcf
|
build exchange rate analysis
|
2024-03-06 02:25:59 +00:00 |
|
|
Yam ZhengLim
|
57a700cc5d
|
added new status to order
|
2024-03-05 09:50:11 +00:00 |
|
|
CIEF ACC1
|
fde8d9b5c1
|
Merge branch 'lee_build_rep_frozen_account_incidents' into 'main'
Lee build rep frozen account incidents
See merge request cief-data/dbt_cloud!32
|
2024-03-05 09:31:32 +00:00 |
|
|
CIEF ACC1
|
b174496caa
|
Fix total_value_rm formula
|
2024-01-29 09:53:27 +00:00 |
|
|
CIEF ACC1
|
5c000c02fc
|
Fix total_value_rm formula
|
2024-01-29 09:53:16 +00:00 |
|
|
CIEF ACC1
|
b6b7663bc2
|
build
|
2024-01-12 01:25:25 +00:00 |
|
|
CIEF ACC1
|
c959a292d6
|
build
|
2024-01-12 01:25:21 +00:00 |
|
|
CIEF ACC1
|
5297dd0756
|
build
|
2024-01-12 01:25:15 +00:00 |
|
|
CIEF ACC1
|
021cd467dc
|
Added logic to identify migrated_companies
|
2023-12-29 10:32:28 +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
|
2912022f84
|
added next order datetime variable
|
2023-12-29 10:29:37 +00:00 |
|
|
CIEF ACC1
|
5f1a9b361d
|
added is_credit_term_company variable
|
2023-12-29 09:48:22 +00:00 |
|
|
CIEF ACC1
|
c453c6189d
|
added is_credit_term and is_migrated_company variable
|
2023-12-29 09:44:17 +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 |
|
|
CIEF ACC1
|
01fa0f61d6
|
Change status into business naming driven
|
2023-11-22 16:13:47 +00:00 |
|
|
CIEF ACC1
|
8feb447f89
|
1688 cost calculation 0.4% fix
|
2023-11-22 16:11:57 +00:00 |
|
|
CIEF ACC1
|
775cc58358
|
Bank Slip
|
2023-11-22 16:08:39 +00:00 |
|
|
CIEF ACC1
|
436cd7ed92
|
Exclude Internal Purchase
|
2023-11-22 16:07:39 +00:00 |
|