Changes for page Friday 14 February 2025
Last modified by dennis yoshikawa on 2025/02/14 01:23
From version 1.1

edited by Abdurachman Putra
on 2025/02/13 09:34
on 2025/02/13 09:34
Change comment:
There is no comment for this version
To version
4.20


edited by Haekal Yusril Faizin
on 2025/02/13 12:27
on 2025/02/13 12:27
Change comment:
There is no comment for this version
Summary
Details
- Page properties
-
- Parent
-
... ... @@ -1,1 +1,1 @@ 1 - Main.PTGUE.WebHome1 +Weekly Report.February .WebHome - Author
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki. surya1 +XWiki.haekalfaizin - Content
-
... ... @@ -1,6 +1,130 @@ 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 + 8 +((( 9 +{{success}} 10 +What Have You Done? 11 +{{/success}} 12 + 13 +1. xxx 14 +1. xxx 15 +1. xxx 16 + 17 +{{warning}} 18 +What Issues You Have? 19 +{{/warning}} 20 + 21 +1. xxx 22 +1. xxx 23 +1. xxx 24 + 25 +{{info}} 26 +What Next You Will Do? (Optional) 27 +{{/info}} 28 + 29 +1. xxx 30 +1. xxx 31 +1. xxx 32 + 33 +**What Support You Need? (Optional)** 34 + 35 + 36 +---- 37 + 38 + 39 +))) 40 + 41 + 42 +== (% id="cke_bm_29973S" style="display:none" %) (%%)Data Analyst == 43 + 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}} 57 +What Issues You Have? 58 +{{/warning}} 59 + 60 +1. **Metabase Limitations** – Limited chart options and flexibility in customization, particularly a lack of aggregation functions. 61 + 62 +{{info}} 63 +What Next You Will Do? (Optional) 64 +{{/info}} 65 + 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. 71 + 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. 78 +))) 79 + 80 + 81 +---- 82 + 83 +== Data Analyst & AI == 84 + 85 +>What Have You Done in This Week? 86 + 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}} 114 +What Issues You Have? 115 +{{/warning}} 116 + 117 +1. Database 118 + 119 +{{info}} 120 +What Next You Will Do? (Optional) 121 +{{/info}} 122 + 123 +1. xxx 124 +1. xxx 125 +1. xxx 126 + 127 +**What Support You Need? (Optional)** 128 + 129 + 130 +)))