Wiki source code of Friday 14 February 2025
Version 4.12 by Haekal Yusril Faizin on 2025/02/13 12:20
Hide last authors
author | version | line-number | content |
---|---|---|---|
![]() |
1.1 | 1 | = Weekly Report 14 February 2025 = |
2 | |||
3 | |||
![]() |
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)** | ||
![]() |
3.1 | 34 | |
35 | |||
36 | ---- | ||
37 | |||
38 | |||
![]() |
2.4 | 39 | ))) |
40 | |||
41 | |||
![]() |
3.2 | 42 | == (% id="cke_bm_29973S" style="display:none" %) (%%)Data Analyst == |
![]() |
1.1 | 43 | |
![]() |
2.2 | 44 | >What Have You Done in This Week? |
45 | |||
46 | ((( | ||
![]() |
3.1 | 47 | {{success}} |
![]() |
2.2 | 48 | What Have You Done? |
![]() |
3.1 | 49 | {{/success}} |
![]() |
2.2 | 50 | |
![]() |
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. | ||
![]() |
1.3 | 55 | |
![]() |
3.1 | 56 | {{warning}} |
![]() |
1.3 | 57 | What Issues You Have? |
![]() |
3.1 | 58 | {{/warning}} |
![]() |
1.3 | 59 | |
![]() |
3.2 | 60 | 1. **Metabase Limitations** – Limited chart options and flexibility in customization, particularly a lack of aggregation functions. |
![]() |
1.3 | 61 | |
![]() |
3.1 | 62 | {{info}} |
![]() |
1.3 | 63 | What Next You Will Do? (Optional) |
![]() |
3.1 | 64 | {{/info}} |
![]() |
1.3 | 65 | |
![]() |
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. | ||
![]() |
1.3 | 71 | |
![]() |
3.1 | 72 | **What Support You Need? (Optional)** |
![]() |
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. | ||
![]() |
1.3 | 78 | ))) |
79 | |||
80 | |||
![]() |
3.1 | 81 | ---- |
![]() |
2.2 | 82 | |
![]() |
2.1 | 83 | == Data Analyst & AI == |
84 | |||
![]() |
2.2 | 85 | >What Have You Done in This Week? |
86 | |||
87 | ((( | ||
![]() |
2.3 | 88 | {{success}} |
![]() |
2.2 | 89 | What Have You Done? |
![]() |
2.3 | 90 | {{/success}} |
![]() |
2.2 | 91 | |
![]() |
4.3 | 92 | **AUTOMARK** |
![]() |
2.1 | 93 | |
![]() |
4.5 | 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% |
![]() |
4.7 | 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. |
![]() |
4.3 | 96 | |
![]() |
4.7 | 97 | **MCN** |
![]() |
4.3 | 98 | |
![]() |
4.12 | 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 us |
![]() |
4.7 | 100 | |
101 | |||
![]() |
4.3 | 102 | Reqeust + enhance dashboard merck |
103 | |||
104 | 1. dkonsul: request data dokter online, dapat trx, meresepkan, meresepkan dexa, comparison new users january | ||
105 | 1. implement compliant mapping | ||
106 | 1. validation data & user report perofmance doctor | ||
107 | |||
![]() |
2.3 | 108 | {{warning}} |
![]() |
2.1 | 109 | What Issues You Have? |
![]() |
2.3 | 110 | {{/warning}} |
![]() |
2.1 | 111 | |
112 | 1. xxx | ||
113 | 1. xxx | ||
114 | 1. xxx | ||
115 | |||
![]() |
2.3 | 116 | {{info}} |
![]() |
2.1 | 117 | What Next You Will Do? (Optional) |
![]() |
2.3 | 118 | {{/info}} |
![]() |
2.1 | 119 | |
120 | 1. xxx | ||
121 | 1. xxx | ||
122 | 1. xxx | ||
123 | |||
![]() |
2.4 | 124 | **What Support You Need? (Optional)** |
![]() |
2.2 | 125 | |
![]() |
2.3 | 126 | |
![]() |
2.1 | 127 | ))) |