Skip to Content
0 Votes

Wiki source code of Friday 14 February 2025

Version 4.21 by Haekal Yusril Faizin on 2025/02/13 12:27
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.21 117 1. Database repoint
Abdurachman Putra 2.1 118
Abdurachman Putra 2.3 119 {{info}}
Abdurachman Putra 2.1 120 What Next You Will Do? (Optional)
Abdurachman Putra 2.3 121 {{/info}}
Abdurachman Putra 2.1 122
123 1. xxx
124 1. xxx
125 1. xxx
126
Abdurachman Putra 2.4 127 **What Support You Need? (Optional)**
Abdurachman Putra 2.2 128
Abdurachman Putra 2.3 129
Abdurachman Putra 2.1 130 )))