Changes for page Friday 14 February 2025
Last modified by dennis yoshikawa on 2025/02/14 01:23
From version 
2.4 
2.4
edited by Abdurachman Putra
on 2025/02/13 09:43
on 2025/02/13 09:43
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
-
... ... @@ -31,91 +31,136 @@ 31 31 1. xxx 32 32 33 33 **What Support You Need? (Optional)** 34 + 35 + 36 +---- 37 + 38 + 34 34 ))) 35 35 36 36 37 -== Data Engineer==42 +== (% id="cke_bm_29973S" style="display:none" %) (%%)Data Analyst == 38 38 39 39 >What Have You Done in This Week? 40 40 41 41 ((( 47 +{{success}} 42 42 What Have You Done? 49 +{{/success}} 43 43 44 -1. xxx 45 -1. xxx 46 -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. 47 47 56 +{{warning}} 48 48 What Issues You Have? 58 +{{/warning}} 49 49 50 -1. xxx 51 -1. xxx 52 -1. xxx 60 +1. **Metabase Limitations** – Limited chart options and flexibility in customization, particularly a lack of aggregation functions. 53 53 62 +{{info}} 54 54 What Next You Will Do? (Optional) 64 +{{/info}} 55 55 56 -1. xxx 57 -1. xxx 58 -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. 59 59 60 -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. 61 61 ))) 62 62 63 -== Data Analyst == 64 64 81 +---- 82 + 83 +== Data Analyst & AI == 84 + 65 65 >What Have You Done in This Week? 66 66 67 67 ((( 88 +{{success}} 68 68 What Have You Done? 90 +{{/success}} 69 69 70 -1. xxx 71 -1. xxx 72 -1. xxx 92 +**AUTOMARK** 73 73 74 -What Issues You Have? 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.** 75 75 76 -1. xxx 77 -1. xxx 78 -1. xxx 97 +**MCN** 79 79 80 -What Next You Will Do? (Optional) 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)** 81 81 82 -1. xxx 83 -1. xxx 84 -1. xxx 102 +**Automation** 85 85 86 - WhatSupportYouNeed?(Optional)87 - )))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** 88 88 89 - == Data Analyst & AI ==107 +**Others** 90 90 91 ->What Have You Done in This Week? 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 92 92 93 -((( 94 -{{success}} 95 -What Have You Done? 96 -{{/success}} 97 - 98 -1. xxx 99 -1. xxx 100 -1. xxx 101 - 102 102 {{warning}} 103 103 What Issues You Have? 104 104 {{/warning}} 105 105 106 -1. xxx 107 -1. xxx 108 -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% 109 109 110 110 {{info}} 111 111 What Next You Will Do? (Optional) 112 112 {{/info}} 113 113 114 -1. xxx115 -1. xxx116 -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 117 117 118 118 **What Support You Need? (Optional)** 119 119 120 - 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. 121 121 )))
