Skip to Content
0 Votes

Changes for page Friday 14 February 2025

Last modified by dennis yoshikawa on 2025/02/14 01:23
From version 3.1
edited by Abdurachman Putra
on 2025/02/13 09:44
Change comment: There is no comment for this version
To version 6.1
edited by Abdurachman Putra
on 2025/02/14 00:52
Change comment: There is no comment for this version

Summary

Details

Page properties
Parent
... ... @@ -1,1 +1,1 @@
1 -Main.PT GUE.WebHome
1 +Weekly Report.February .WebHome
Content
... ... @@ -39,7 +39,7 @@
39 39  )))
40 40  
41 41  
42 -== (% id="cke_bm_29973S" style="display:none" %) (%%)Data Analyst ==
42 +== (% id="cke_bm_29973S" style="display:none" %) (%%)Data Analyst ==
43 43  
44 44  >What Have You Done in This Week?
45 45  
... ... @@ -48,27 +48,33 @@
48 48  What Have You Done?
49 49  {{/success}}
50 50  
51 -1. xxx
52 -1. xxx
53 -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.
54 54  
55 55  {{warning}}
56 56  What Issues You Have?
57 57  {{/warning}}
58 58  
59 -1. xxx
60 -1. xxx
61 -1. xxx
60 +1. **Metabase Limitations** – Limited chart options and flexibility in customization, particularly a lack of aggregation functions.
62 62  
63 63  {{info}}
64 64  What Next You Will Do? (Optional)
65 65  {{/info}}
66 66  
67 -1. xxx
68 -1. xxx
69 -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.
70 70  
71 71  **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.
72 72  )))
73 73  
74 74  
... ... @@ -83,27 +83,78 @@
83 83  What Have You Done?
84 84  {{/success}}
85 85  
86 -1. xxx
87 -1. xxx
88 -1. xxx
92 +**AUTOMARK**
89 89  
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 +
90 90  {{warning}}
91 91  What Issues You Have?
92 92  {{/warning}}
93 93  
94 -1. xxx
95 -1. xxx
96 -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%
97 97  
98 98  {{info}}
99 99  What Next You Will Do? (Optional)
100 100  {{/info}}
101 101  
102 -1. xxx
103 -1. xxx
104 -1. xxx
124 +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
105 105  
106 106  **What Support You Need? (Optional)**
107 107  
108 -
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.
109 109  )))