data-dwh-dbt-project

counterweight/data-dwh-dbt-project

Fork 0

Commit graph

696ac24e35 updated monthly_aggregated_metrics_history_by_deal Joaquin Ossa 2025-01-30 17:18:08 +01:00
1e37d04f72 Update rule for metric depends on invoicing Joaquin Ossa 2025-01-30 16:51:35 +01:00
7ada9de3a1 Added comments Joaquin Ossa 2025-01-30 16:34:27 +01:00
40c8e20e70 Addressed comments Joaquin Ossa 2025-01-30 16:30:03 +01:00
bb9dea8ed6 Removed changes for cutoff date Joaquin Ossa 2025-01-30 16:18:29 +01:00
396d19b549 changed exclusion rule for metrics depending on invoicing Joaquin Ossa 2025-01-30 15:43:53 +01:00
142b5a526f MRR change Joaquin Ossa 2025-01-30 15:15:34 +01:00
a208541e04 Merged PR 4224: Rework accounting aggregations for Financial Reporting Oriol Roqué Paniagua 2025-01-30 10:28:49 +00:00
491cf2743e Merged PR 4223: Cleaned first time booked for deals Joaquin Ossa 2025-01-30 09:23:31 +00:00
fe317ac17a Cleaned first time booked for deals Joaquin Ossa 2025-01-30 10:16:29 +01:00
62cecf52f0 Merged PR 4202: New expected MRR metric Joaquin Ossa 2025-01-29 16:07:42 +00:00
63b1eac81f Addressed comments Joaquin Ossa 2025-01-29 15:44:07 +01:00
a48f6d0f59 Fixed dumb auto formatting Joaquin Ossa 2025-01-29 12:09:52 +01:00
c0da375223 Update Joaquin Ossa 2025-01-29 11:20:12 +01:00
26898322e7 wip fixing deals from hubspot Joaquin Ossa 2025-01-29 10:05:41 +01:00
cf024f7b71 wip Joaquin Ossa 2025-01-28 16:47:44 +01:00
cea7cdb34d Removed first_time_booked_deals metric Joaquin Ossa 2025-01-28 12:53:44 +01:00
88e86ea9ed Added schema Joaquin Ossa 2025-01-28 12:41:03 +01:00
8bd5851235 created new model to get all mrr metrics Joaquin Ossa 2025-01-28 12:26:53 +01:00
39de8617b7 New expected MRR metric Joaquin Ossa 2025-01-27 18:26:19 +01:00
6dcfe03b30 Merged PR 4215: Fixes Oriol Roqué Paniagua 2025-01-29 12:46:53 +00:00
4ed59ffd15 Merged PR 4198: Update Onboarding MRR and Deal Lifecycle Joaquin Ossa 2025-01-27 14:10:44 +00:00
d7f454b326 Removed deal lifecycle First-Booked Joaquin Ossa 2025-01-27 14:55:53 +01:00
5186cd2cac Renamed Onboarding MRR per New Account Joaquin Ossa 2025-01-27 12:40:52 +01:00
952e861bad Merged PR 4171: Capped new ratios Joaquin Ossa 2025-01-24 13:59:59 +00:00
e63a093991 Added ratios to deal models Joaquin Ossa 2025-01-24 14:47:41 +01:00
720185f235 Fixed macro Joaquin Ossa 2025-01-24 14:17:29 +01:00
e4d19b85e8 Capped new ratios Joaquin Ossa 2025-01-24 11:36:22 +01:00
0df6d07c20 Merged PR 4166: New KPI rates for Main KPIs Joaquin Ossa 2025-01-24 08:11:45 +00:00
f7bacc2310 changed names Joaquin Ossa 2025-01-24 08:30:05 +01:00
49a10fe249 New KPI rates for Main KPIs Joaquin Ossa 2025-01-23 17:14:36 +01:00
d5f36c14df Merged PR 4154: update exposures Joaquin Ossa 2025-01-23 08:50:56 +00:00
463de78b1e update exposures Joaquin Ossa 2025-01-23 08:50:13 +01:00
707950a6db Merged PR 4143: Ensure order in financial aggregations Oriol Roqué Paniagua 2025-01-22 09:38:18 +00:00
49269b8288 Merged PR 4141: Add OSS Sales accounts to the respective Guest Revenue service aggregation Oriol Roqué Paniagua 2025-01-21 17:13:46 +00:00
437460065e Merged PR 4138: Adds Account Code Name in reporting Oriol Roqué Paniagua 2025-01-21 16:37:16 +00:00
ddc806583c Merged PR 4130: Propagate aggregations to xero sales reporting Oriol Roqué Paniagua 2025-01-21 13:22:36 +00:00
a99b7f29a7 Merged PR 4126: cih monthly fee to reporting Joaquin Ossa 2025-01-21 11:40:27 +00:00
f8cf824c06 cih monthly fee to reporting Joaquin Ossa 2025-01-21 12:37:50 +01:00
5394066959 Merged PR 4124: Adds dedicated start date for KPIs Oriol Roqué Paniagua 2025-01-21 11:18:16 +00:00
6141af1eff Merged PR 4076: CIH fees Joaquin Ossa 2025-01-21 09:27:21 +00:00
c02eda9d71 Merged PR 4121: PMS in new dash reporting Joaquin Ossa 2025-01-21 09:27:08 +00:00
89f7db1997 back to created date Joaquin Ossa 2025-01-21 10:18:46 +01:00
e71cde0d63 PMS in new dash reporting Joaquin Ossa 2025-01-21 10:12:46 +01:00
90967fd34e Merged PR 4117: Added PMS info Joaquin Ossa 2025-01-21 08:07:22 +00:00
1865bafd19 Merged PR 4118: New Dash services Invoiced Revenue Oriol Roqué Paniagua 2025-01-20 16:23:20 +00:00
e007b85d87 Addressed comments Joaquin Ossa 2025-01-20 17:18:39 +01:00
15e0993b36 changed exchange rate date to first of the next month from created date Joaquin Ossa 2025-01-20 16:51:57 +01:00
8898a2d150 modified host/deal logic Joaquin Ossa 2025-01-20 16:35:43 +01:00
1a692a044b fixed join Joaquin Ossa 2025-01-20 15:23:53 +01:00
d12a7233c9 Merged PR 4104: Refactor Invoiced Revenue from Account Code + New Revenue Streams Oriol Roqué Paniagua 2025-01-20 14:18:05 +00:00
31e4feb593 Added fees in gbp Joaquin Ossa 2025-01-20 15:14:57 +01:00
5c71791f10 Added PMS info Joaquin Ossa 2025-01-20 14:26:37 +01:00
151bb46182 Merged PR 4107: First version of accounting aggregations Oriol Roqué Paniagua 2025-01-19 12:20:19 +00:00
06bdb81cfe Merged PR 4106: Avoids duplicates in athena verification with fees after price changes Oriol Roqué Paniagua 2025-01-19 10:07:39 +00:00
873402fd8e Merged PR 4105: Fixes exclusion of MRR after name change Oriol Roqué Paniagua 2025-01-19 09:37:07 +00:00
3f3b99cdf6 Merged PR 4102: Athena price update Pablo Martín 2025-01-17 16:34:29 +00:00
53f9c1e08f Merged PR 4097: Small name change Joaquin Ossa 2025-01-17 10:54:11 +00:00
51326865d8 Small name change Joaquin Ossa 2025-01-17 11:45:48 +01:00
e28ea25e47 Merged PR 4087: Added expected_mrr Joaquin Ossa 2025-01-17 08:47:14 +00:00
394d2e7672 excluding current and previous month for expected mrr Joaquin Ossa 2025-01-17 08:29:58 +01:00
6d5b15f062 Added expected_mrr to int_mtd_aggregated_metrics Joaquin Ossa 2025-01-16 15:32:32 +01:00
bf0cddcb4d wip2 Joaquin Ossa 2025-01-16 14:45:26 +01:00
7213a34d1c wip Joaquin Ossa 2025-01-16 14:19:49 +01:00
ee1bd1976a Merged PR 4086: Changed to cube instead of rollup Joaquin Ossa 2025-01-16 13:45:06 +00:00
f3201b3c77 changed to cube instead of rollup Joaquin Ossa 2025-01-16 14:21:00 +01:00
e98b60f335 Merged PR 4050: Onboarding MRR Model Joaquin Ossa 2025-01-16 11:09:58 +00:00
095bfb8ab1 removed UNSET billing_countries Joaquin Ossa 2025-01-16 11:35:39 +01:00
6aafd605b2 Merged PR 4077: Propagate account code and account name for Xero - reporting models Oriol Roqué Paniagua 2025-01-16 10:04:41 +00:00
b58d165eff removed mas value test and month_name Joaquin Ossa 2025-01-16 11:01:41 +01:00
105f2aee45 Added schema Joaquin Ossa 2025-01-16 10:27:48 +01:00
5bf2fba4cf Found the issue that was excluding some deals Joaquin Ossa 2025-01-15 16:35:02 +01:00
261c6d3c49 Updated logic of model Joaquin Ossa 2025-01-15 12:03:25 +01:00
28f7486634 Added booking fee and currency to model Joaquin Ossa 2025-01-15 09:00:36 +01:00
b063454409 commit wip Joaquin Ossa 2025-01-14 16:42:49 +01:00
1db8a050ce creates onboarding mrr model Joaquin Ossa 2025-01-14 11:48:44 +01:00
77a70d21a4 commit wip schema Joaquin Ossa 2025-01-13 17:26:34 +01:00
d0406e975a commit wip to rebase Joaquin Ossa 2025-01-13 16:11:19 +01:00
92c0574374 commit uri's query Joaquin Ossa 2025-01-13 12:34:09 +01:00
ae4f656d54 Merged PR 4060: New fields to int_kpis__dimension_deals Joaquin Ossa 2025-01-14 16:35:27 +00:00
32251fa5e9 addressed comments Joaquin Ossa 2025-01-14 17:25:59 +01:00
42cea78b2c fixed test value Joaquin Ossa 2025-01-14 16:51:49 +01:00
1de5a6d33e new field to int_kpis__dimension_deals Joaquin Ossa 2025-01-14 16:48:49 +01:00
4654aad54c wip Joaquin Ossa 2025-01-14 16:46:07 +01:00
c91a27e976 Merged PR 4039: Bulk update tests keys Pablo Martín 2025-01-13 15:01:37 +00:00
c3c628aec4 change "tests:" to "data_tests:" Pablo Martin 2025-01-13 16:00:35 +01:00
db1edf7a1c update schema definitions for yaml files Pablo Martin 2025-01-13 15:57:34 +01:00
b3ba2b5fa0 Merge branch 'master' of ssh.dev.azure.com:v3/guardhog/Data/data-dwh-dbt-project Pablo Martin 2025-01-13 15:29:54 +01:00
366127489d YOLO 3 Pablo Martin 2025-01-13 15:29:24 +01:00
c545636c64 YOLO LOLO Pablo Martin 2025-01-13 15:28:18 +01:00
583975f7d5 YOLO Pablo Martin 2025-01-13 15:27:52 +01:00
6e631e79b0 Merged PR 3970: bump versions to 1.9 Pablo Martín 2025-01-13 11:36:54 +00:00
33d4f18165 Merged PR 4034: BUGFIX: Ensure id_role are lower case Oriol Roqué Paniagua 2025-01-13 11:27:29 +00:00
3fe9ac140e Merged PR 4031: Host Resolutions KPIs bugfix Oriol Roqué Paniagua 2025-01-13 09:19:24 +00:00
6ace9230e9 Merged PR 4020: Expose new KPIs Oriol Roqué Paniagua 2025-01-10 10:07:00 +00:00
1217c92337 Merged PR 4018: PMS data to reporting Joaquin Ossa 2025-01-10 08:57:07 +00:00
13bb35ec70 PMS data to reporting Joaquin Ossa 2025-01-10 09:51:29 +01:00
f8a1742dd7 Merged PR 4017: PMS data for Account Managers Overview Joaquin Ossa 2025-01-10 08:45:19 +00:00
a0ee26e018 pms data for Account Managers Overview Joaquin Ossa 2025-01-10 09:17:29 +01:00
580b194be7 Merged PR 4009: Adding PMS info for Account Margin report Joaquin Ossa 2025-01-10 07:39:06 +00:00