Skip to Content
0 Votes

Wiki source code of Friday 14 February 2025

Version 4.14 by Haekal Yusril Faizin on 2025/02/13 12:23
Show last authors
1 = Weekly Report 14 February 2025 =
2
3
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)**
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. 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 report
106
107
108 Reqeust + enhance dashboard merck
109
110 1. dkonsul: request data dokter online, dapat trx, meresepkan, meresepkan dexa, comparison new users january
111 1.
112 1.
113
114 {{warning}}
115 What Issues You Have?
116 {{/warning}}
117
118 1. xxx
119 1. xxx
120 1. xxx
121
122 {{info}}
123 What Next You Will Do? (Optional)
124 {{/info}}
125
126 1. xxx
127 1. xxx
128 1. xxx
129
130 **What Support You Need? (Optional)**
131
132
133 )))