Index 9 case studies · 6 lab studies

Work with evidence.

Analytics systems, models, and decision tools. Professional work protects confidential data; project exercises remain clearly labeled.

01 Selected systems

Professional and project-based systems with explicit role, evidence, and decision context.

01 / Future Creative Network (Maleo)Confidential

Campaign monitoring dashboard for a SilverQueen campaign, recreated with synthetic data, showing actual-vs-KPI gauges, a track score, and best-performing content

Professional Experience · Marketing and creative analytics

Social Media Analytics and Reporting Automation

Led 30+ client-facing reports and strategy decks while building a repeatable social-media analytics pipeline from multi-platform data into automated spreadsheets, KOL scrapers, and BI dashboards.

Role

Data Analyst

Published evidence

30+ reports · 3 brand deep dives · 3 campaign dashboards

02 / SkintificConfidential

NEXUS Domain Intelligence dashboard showing category scorecards and a category-breakdown table with synthetic data

Professional Experience · Beauty and personal care (e-commerce)

NEXUS — Business Intelligence and Decision Platform

Built an internal BI platform on Google Apps Script and BigQuery that gives commercial and marketing teams governed self-serve analytics — visual query builder, RBAC with row-level security, executive dashboards, and a sales-extrapolation engine.

Role

Data Analyst

Evidence

Centralized governed access to warehouse data for non-technical teams

03 / SkintificConfidential

Pricing tracker dashboard showing a daily summary snapshot and per-SKU price comparison across channels with synthetic data

Professional Experience · Beauty and personal care (e-commerce)

NPD Price Tracking Automation and Dashboard

Built an Apps Script tool that snapshots new-product prices daily across online and offline channels, compares them against target SRP, and renders a dashboard so the commercial team can spot pricing gaps without manual data entry.

Role

Data Analyst

Evidence

Replaced manual daily price checks with an automated snapshot

04 / Lifepack.idConfidential

Lifepack doctor registry dashboard showing aggregate qualification and university distributions

Professional Experience · Healthcare / health-tech

Health-Tech Data Infrastructure and Dashboards

Supported reliable data integration and built decision-ready reporting for a health-tech operation navigating evolving business needs.

Role

Data Analyst

Evidence

Developed and maintained more than 10 dashboards and reports

05 / Lifepack.idFeatured commercial study

Editorial visualization of a seven-kilometer delivery margin threshold

Professional Experience · Healthcare / health-tech

Delivery Margin Distance Analysis

Analyzed delivery distance against net margin to identify where the existing delivery-price structure stopped covering operational cost.

Role

Data Analyst

Evidence

Identified 7.17 km as the furthest observed distance associated with positive net delivery margin in the analyzed sample.

06 / PT Gajahpangan Jaya MakmurConfidential

FMCG dashboard, visualization, coding, and data-processing evidence from the project portfolio

Professional Experience · FMCG

FMCG Operational and Profit Optimization

Used operational and commercial analysis to support production scaling, channel expansion, and more coordinated supply-chain decisions.

Role

Data Analyst

Published evidence

1,567% capacity growth · monthly profit <IDR 100M to >IDR 700M

07 / ID/X Partners x Rakamin AcademyProject-Based Internship

Loan default model results showing ROC and Kolmogorov-Smirnov evaluation charts

Project-Based Internship · Financial services

Loan Default Prediction

Developed and evaluated a Random Forest model for loan-default prediction, achieving an AUC of 0.857 and KS statistic of 0.5675 on the project dataset.

Role

Data Scientist project participant

Evidence

Random Forest AUC of 0.857 on the project dataset

08 / Kimia Farma x Rakamin AcademyProject-Based Internship

Kimia Farma sales dashboard showing invoice, sales, product and customer reporting

Project-Based Internship · Retail healthcare

Retail Sales Datamart and Dashboard

Designed a sales datamart and dashboard workflow to turn transaction, customer, and product data into clearer commercial reporting.

Role

Big Data Analytics project participant

Evidence

Defined a composite sales key

09 / Fairatmos hiring assessmentTechnical Assessment

VM0010 forest carbon methodology recommendation and implementation pathway

Technical Assessment · Climate tech / forestry

Forest Carbon Methodology Assessment

Assessed methodology options for an Indonesian logging concession and translated selected approaches into implementation, monitoring, and certification plans.

Role

Candidate analyst

Evidence

Compared methodology options

02 Dashboard Lab