Skip to Content
0 Votes

Wiki source code of Friday 14 February 2025

Version 4.23 by Haekal Yusril Faizin on 2025/02/13 12:28
Hide last authors
Abdurachman Putra 1.1 1 = Weekly Report 14 February 2025 =
2
3
Abdurachman Putra 2.4 4 == (% id="cke_bm_29973S" style="display:none" %) (%%)Data Engineer ==
5
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)**
Abdurachman Putra 3.1 34
35
36 ----
37
38
Abdurachman Putra 2.4 39 )))
40
41
steven hasan 3.2 42 == (% id="cke_bm_29973S" style="display:none" %) (%%)Data Analyst ==
Abdurachman Putra 1.1 43
Abdurachman Putra 2.2 44 >What Have You Done in This Week?
45
46 (((
Abdurachman Putra 3.1 47 {{success}}
Abdurachman Putra 2.2 48 What Have You Done?
Abdurachman Putra 3.1 49 {{/success}}
Abdurachman Putra 2.2 50
steven hasan 3.2 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.
Abdurachman Putra 1.3 55
Abdurachman Putra 3.1 56 {{warning}}
Abdurachman Putra 1.3 57 What Issues You Have?
Abdurachman Putra 3.1 58 {{/warning}}
Abdurachman Putra 1.3 59
steven hasan 3.2 60 1. **Metabase Limitations** – Limited chart options and flexibility in customization, particularly a lack of aggregation functions.
Abdurachman Putra 1.3 61
Abdurachman Putra 3.1 62 {{info}}
Abdurachman Putra 1.3 63 What Next You Will Do? (Optional)
Abdurachman Putra 3.1 64 {{/info}}
Abdurachman Putra 1.3 65
steven hasan 3.2 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.
Abdurachman Putra 1.3 71
Abdurachman Putra 3.1 72 **What Support You Need? (Optional)**
steven hasan 3.2 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.
Abdurachman Putra 1.3 78 )))
79
80
Abdurachman Putra 3.1 81 ----
Abdurachman Putra 2.2 82
Abdurachman Putra 2.1 83 == Data Analyst & AI ==
84
Abdurachman Putra 2.2 85 >What Have You Done in This Week?
86
87 (((
Abdurachman Putra 2.3 88 {{success}}
Abdurachman Putra 2.2 89 What Have You Done?
Abdurachman Putra 2.3 90 {{/success}}
Abdurachman Putra 2.2 91
Haekal Yusril Faizin 4.3 92 **AUTOMARK**
Abdurachman Putra 2.1 93
Haekal Yusril Faizin 4.20 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%**
Haekal Yusril Faizin 4.17 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.**
Haekal Yusril Faizin 4.3 96
Haekal Yusril Faizin 4.7 97 **MCN**
Haekal Yusril Faizin 4.3 98
Haekal Yusril Faizin 4.20 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)**
Haekal Yusril Faizin 4.7 101
Haekal Yusril Faizin 4.14 102 **Automation**
Haekal Yusril Faizin 4.7 103
Haekal Yusril Faizin 4.20 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**
Haekal Yusril Faizin 4.13 106
Haekal Yusril Faizin 4.15 107 **Others**
Haekal Yusril Faizin 4.14 108
Haekal Yusril Faizin 4.15 109 1. Reqeust + enhance dashboard merck
110 1. Request dkonsul data for online doctors, transactions, prescriptions, Dexa prescriptions, comparison new users january
Haekal Yusril Faizin 4.17 111 1. Request data ICD-10
Haekal Yusril Faizin 4.3 112
Abdurachman Putra 2.3 113 {{warning}}
Abdurachman Putra 2.1 114 What Issues You Have?
Abdurachman Putra 2.3 115 {{/warning}}
Abdurachman Putra 2.1 116
Haekal Yusril Faizin 4.22 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
Haekal Yusril Faizin 4.23 118 1. Need to enhance the accuracy to around 90%
Abdurachman Putra 2.1 119
Abdurachman Putra 2.3 120 {{info}}
Abdurachman Putra 2.1 121 What Next You Will Do? (Optional)
Abdurachman Putra 2.3 122 {{/info}}
Abdurachman Putra 2.1 123
124 1. xxx
125 1. xxx
126 1. xxx
127
Abdurachman Putra 2.4 128 **What Support You Need? (Optional)**
Abdurachman Putra 2.2 129
Abdurachman Putra 2.3 130
Abdurachman Putra 2.1 131 )))