Success

What Have You Done?

1. xxx
2. xxx
3. xxx

Warning

What Issues You Have?

1. xxx
2. xxx
3. xxx

Information

What Next You Will Do? (Optional)

1. xxx
2. xxx
3. xxx

What Support You Need? (Optional)

Success

What Have You Done?

1. Dharma Dexa Phase 2 – Completed the second phase of Dharma Dexa.
2. Migration from Looker to Metabase – Transitioning data visualization and analytics from Looker to Metabase.
3. Redesigned DKonsul Data – Improved the structure and organization of DKonsul data.
4. Ad-hoc Requests – Handled various on-demand data requests.

Warning

What Issues You Have?

1. Metabase Limitations – Limited chart options and flexibility in customization, particularly a lack of aggregation functions.

Information

What Next You Will Do? (Optional)

1. Continue Redesigning DKonsul Data
   • Refining the data funnel from consultation → prescription → transaction.
2. Continue Migration to Metabase – Ensuring a smooth transition from Looker to Metabase.
3. Dharma Dexa Phase 3 – Proceeding with the next phase of the Dharma Dexa project.
4. AppSheet MCN Visit Tracker Dashboard – Developing and optimizing the dashboard.

What Support You Need? (Optional)

1. Data Validation – Ensuring data accuracy and consistency.
2. Dharma Dexa Screening Enhancements
   • Assigning a new screening ID for each event, especially if different questions and inputs are involved.
   • Adding location input (province, city) for better analysis.

Success

What Have You Done?

AUTOMARK

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 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%
2. 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 and the documentation is already sent to Tech team. The API is already tested by Tech team and have no issues. 

MCN

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)
2. Repoint, re-align, and redesign the pipeline and database that being consumed for scrapping. (Pairing with Syifa-DE)

Automation

1. Implement compliance mapping with the newest data from compliance team
2. Data, flow, and script validation for user report performance doctor. The sample report is already validated by dr.Astrid

Others

1. Reqeust + enhance dashboard merck
2. Request dkonsul data for online doctors, transactions, prescriptions, Dexa prescriptions, comparison new users january
3. Request data ICD-10

Warning

What Issues You Have?

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
2. Need to enhance the accuracy to around 90%

Information

What Next You Will Do? (Optional)

1. xxx
2. xxx
3. xxx

What Support You Need? (Optional)