Changes for page Friday 14 February 2025
Last modified by dennis yoshikawa on 2025/02/14 01:23
From version 
2.1 
2.1
edited by Abdurachman Putra
on 2025/02/13 09:38
on 2025/02/13 09:38
Change comment:
There is no comment for this version
To version 6.1
6.1
edited by Abdurachman Putra
on 2025/02/14 00:52
on 2025/02/14 00:52
Change comment:
There is no comment for this version
Show context
Hide context
Summary
Details
-
Page properties
-
- Parent
-
... ... @@ -1,1 +1,1 @@ 1 - Main.PTGUE.WebHome1 +Weekly Report.February .WebHome - Content
-
... ... @@ -1,68 +1,166 @@ 1 1 = Weekly Report 14 February 2025 = 2 2 3 3 4 -== Data Engineer == 4 +== (% id="cke_bm_29973S" style="display:none" %) (%%)Data Engineer == 5 5 6 ->What Have You Done?((( 6 +>What Have You Done in This Week? 7 + 8 +((( 9 +{{success}} 10 +What Have You Done? 11 +{{/success}} 12 + 7 7 1. xxx 8 8 1. xxx 9 9 1. xxx 10 10 17 +{{warning}} 11 11 What Issues You Have? 19 +{{/warning}} 12 12 13 13 1. xxx 14 14 1. xxx 15 15 1. xxx 16 16 25 +{{info}} 17 17 What Next You Will Do? (Optional) 27 +{{/info}} 18 18 19 19 1. xxx 20 20 1. xxx 21 21 1. xxx 22 22 23 -What Support You Need? (Optional) 33 +**What Support You Need? (Optional)** 34 + 35 + 36 +---- 37 + 38 + 24 24 ))) 25 25 26 -== Data Analyst == 27 27 28 ->What Have You Done?((( 29 -1. xxx 30 -1. xxx 31 -1. xxx 42 +== (% id="cke_bm_29973S" style="display:none" %) (%%)Data Analyst == 32 32 44 +>What Have You Done in This Week? 45 + 46 +((( 47 +{{success}} 48 +What Have You Done? 49 +{{/success}} 50 + 51 +1. **Dharma Dexa Phase 2** – Completed the second phase of Dharma Dexa. 52 +1. **Migration from Looker to Metabase** – Transitioning data visualization and analytics from Looker to Metabase. 53 +1. **Redesigned DKonsul Data** – Improved the structure and organization of DKonsul data. 54 +1. **Ad-hoc Requests** – Handled various on-demand data requests. 55 + 56 +{{warning}} 33 33 What Issues You Have? 58 +{{/warning}} 34 34 35 -1. xxx 36 -1. xxx 37 -1. xxx 60 +1. **Metabase Limitations** – Limited chart options and flexibility in customization, particularly a lack of aggregation functions. 38 38 62 +{{info}} 39 39 What Next You Will Do? (Optional) 64 +{{/info}} 40 40 41 -1. xxx 42 -1. xxx 43 -1. xxx 66 +1. **Continue Redesigning DKonsul Data** 67 +1*. Refining the data funnel from consultation → prescription → transaction. 68 +1. **Continue Migration to Metabase** – Ensuring a smooth transition from Looker to Metabase. 69 +1. **Dharma Dexa Phase 3** – Proceeding with the next phase of the Dharma Dexa project. 70 +1. **AppSheet MCN Visit Tracker Dashboard** – Developing and optimizing the dashboard. 44 44 45 -What Support You Need? (Optional) 72 +**What Support You Need? (Optional)** 73 + 74 +1. **Data Validation** – Ensuring data accuracy and consistency. 75 +1. **Dharma Dexa Screening Enhancements** 76 +1*. Assigning a **new screening ID** for each event, especially if different questions and inputs are involved. 77 +1*. Adding **location input (province, city)** for better analysis. 46 46 ))) 47 47 80 + 81 +---- 82 + 48 48 == Data Analyst & AI == 49 49 50 ->What Have You Done?((( 51 -1. xxx 52 -1. xxx 53 -1. xxx 85 +>What Have You Done in This Week? 54 54 87 +((( 88 +{{success}} 89 +What Have You Done? 90 +{{/success}} 91 + 92 +**AUTOMARK** 93 + 94 +1. Deploy, evaluate and making documentation of **Screening Dharma Dexa API** to be accessed by Tech team. The API is deployed at [[https:~~/~~/datalake.ptgue.com/v1/users_dd>>https://datalake.ptgue.com/v1/users_dd]] and the **documentation is already sent to Tech team**. **The API could be accessed using prompt** to retrieve user that relevant to the prompt. Per 13 Feb 2024, **the RAG Accuracy is 87,50%** 95 +1. Deploy, evaluate and making documentation of **master user GUE Ecosystem** to be accessed by Tech team. The API is deployed at [[https:~~/~~/datalake.ptgue.com/v1/users>>https://datalake.ptgue.com/v1/users_dd]] and the **documentation is already sent to Tech team**. **The API is already tested by Tech team and have no issues.** 96 + 97 +**MCN** 98 + 99 +1. Fixing resource spike issue caused by scraping schedule. The issue is already fixed and pass the test for 3 days (wednesday, thursday, and friday). **Scraping time is decreased from 1 minute per user to the maximum of +-20 seconds per user.** **(Pairing with Syifa-DE)** 100 +1. **Repoint, re-align, and redesign the pipeline and database** that being consumed for scrapping.** (Pairing with Syifa-DE)** 101 + 102 +**Automation** 103 + 104 +1. **Implement compliance mapping** with the newest data from compliance team 105 +1. Data, flow, and script validation for user report performance doctor. **The sample report is already validated by dr.Astrid** 106 + 107 +**Others** 108 + 109 +1. Reqeust + enhance dashboard merck 110 +1. Request dkonsul data for online doctors, transactions, prescriptions, Dexa prescriptions, comparison new users january 111 +1. Request data ICD-10 112 + 113 +{{warning}} 55 55 What Issues You Have? 115 +{{/warning}} 56 56 57 -1. xxx 58 -1. xxx 59 -1. xxx 117 +1. There is no info regarding database repointing of MCN from tech team. So, the data is not updated. Already solved by coordinating with Product Team 118 +1. Need to enhance the RAG accuracy to around 90% 60 60 120 +{{info}} 61 61 What Next You Will Do? (Optional) 122 +{{/info}} 62 62 63 -1. xxx64 -1. xxx65 -1. x xx124 +1. Increase RAG accuracy by adding more train query LLM 125 +1. Start daily recurring scraping for tiktok dashboard 126 +1. Start dkonsul insight next week 66 66 67 -What Support You Need? (Optional) 128 +**What Support You Need? (Optional)** 129 + 130 + 131 +=== Summary === 132 + 133 +Berikut ringkasan laporan mingguan dari 14 Februari 2025 yang ditulis oleh Haekal Yusril Faizin. Laporan ini merangkum aktivitas dan isu dari tim Data Engineer, Data Analyst, dan Data Analyst & AI. 134 + 135 +**Data Analyst** 136 + 137 +* Menyelesaikan fase kedua Dharma Dexa. 138 +* Memindahkan visualisasi data dan analitik dari Looker ke Metabase. 139 +* Mendesain ulang data DKonsul untuk struktur dan organisasi yang lebih baik. 140 +* Menangani berbagai permintaan data on-demand. 141 + 142 +**Data Analyst & AI** 143 + 144 +* Menerapkan, mengevaluasi, dan mendokumentasikan API Screening Dharma Dexa untuk diakses oleh tim Tech. 145 +* Menerapkan, mengevaluasi, dan mendokumentasikan master user GUE Ecosystem untuk diakses oleh tim Tech. 146 +* Memperbaiki masalah lonjakan sumber daya yang disebabkan oleh jadwal scraping. 147 +* Merepoint, menyelaraskan ulang, dan mendesain ulang pipeline dan database yang digunakan untuk scraping. 148 +* Menerapkan pemetaan kepatuhan dengan data terbaru dari tim kepatuhan. 149 +* Memvalidasi data, alur, dan skrip untuk kinerja laporan pengguna dokter. 150 + 151 +**Isu** 152 + 153 +* Pilihan bagan dan fleksibilitas yang terbatas dalam kustomisasi Metabase. 154 +* Kurangnya informasi mengenai database repointing MCN dari tim teknologi. 155 +* Perlu meningkatkan akurasi RAG menjadi sekitar 90%. 156 + 157 +**Langkah Selanjutnya** 158 + 159 +* Melanjutkan desain ulang data DKonsul dan migrasi ke Metabase. 160 +* Melanjutkan dengan Dharma Dexa Fase 3 dan mengembangkan Dasbor Pelacak Kunjungan AppSheet MCN. 161 +* Meningkatkan akurasi RAG, memulai scraping berulang harian untuk dasbor TikTok, dan memulai wawasan DKonsul minggu depan. 162 + 163 +**Dukungan yang Dibutuhkan** 164 + 165 +* Validasi data dan peningkatan penyaringan Dharma Dexa. 68 68 )))
