Changes for page Friday 14 February 2025
Last modified by dennis yoshikawa on 2025/02/14 01:23
From version 
2.3 
2.3
edited by Abdurachman Putra
on 2025/02/13 09:42
on 2025/02/13 09:42
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,58 +1,85 @@ 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 6 >What Have You Done in This Week? 7 7 8 8 ((( 9 +{{success}} 9 9 What Have You Done? 11 +{{/success}} 10 10 11 11 1. xxx 12 12 1. xxx 13 13 1. xxx 14 14 17 +{{warning}} 15 15 What Issues You Have? 19 +{{/warning}} 16 16 17 17 1. xxx 18 18 1. xxx 19 19 1. xxx 20 20 25 +{{info}} 21 21 What Next You Will Do? (Optional) 27 +{{/info}} 22 22 23 23 1. xxx 24 24 1. xxx 25 25 1. xxx 26 26 27 -What Support You Need? (Optional) 33 +**What Support You Need? (Optional)** 34 + 35 + 36 +---- 37 + 38 + 28 28 ))) 29 29 30 -== Data Analyst == 31 31 42 +== (% id="cke_bm_29973S" style="display:none" %) (%%)Data Analyst == 43 + 32 32 >What Have You Done in This Week? 33 33 34 34 ((( 47 +{{success}} 35 35 What Have You Done? 49 +{{/success}} 36 36 37 -1. xxx 38 -1. xxx 39 -1. xxx 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. 40 40 56 +{{warning}} 41 41 What Issues You Have? 58 +{{/warning}} 42 42 43 -1. xxx 44 -1. xxx 45 -1. xxx 60 +1. **Metabase Limitations** – Limited chart options and flexibility in customization, particularly a lack of aggregation functions. 46 46 62 +{{info}} 47 47 What Next You Will Do? (Optional) 64 +{{/info}} 48 48 49 -1. xxx 50 -1. xxx 51 -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. 52 52 53 -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. 54 54 ))) 55 55 80 + 81 +---- 82 + 56 56 == Data Analyst & AI == 57 57 58 58 >What Have You Done in This Week? ... ... @@ -62,27 +62,78 @@ 62 62 What Have You Done? 63 63 {{/success}} 64 64 65 -1. xxx 66 -1. xxx 67 -1. xxx 92 +**AUTOMARK** 68 68 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 + 69 69 {{warning}} 70 70 What Issues You Have? 71 71 {{/warning}} 72 72 73 -1. xxx 74 -1. xxx 75 -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% 76 76 77 77 {{info}} 78 78 What Next You Will Do? (Optional) 79 79 {{/info}} 80 80 81 -1. xxx82 -1. xxx83 -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 84 84 85 -What Support You Need? (Optional) 128 +**What Support You Need? (Optional)** 86 86 87 - 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. 88 88 )))
