Peta Metro
Kota Metro Spatial Data Explorer
Reverse-engineered Kota Metro's public spatial data into one interactive map: 62 layers (RDTR zoning, road networks, sanitation, demographics) with data-driven thematic styling, concise attribute popups, and a 'drop a pin from a Google Maps link' feature. Built as flat HTML + MapLibre and deployed as a Cloudflare Worker with a small link-resolver endpoint.
dbt Lecture
Analytics Engineering Course Material
Interactive lecture material for teaching dbt & analytics engineering — from models and ref() to testing and docs. Packaged as an easy-to-follow slide site, complete with a ready-to-run PostgreSQL dataset via Docker.
Countangga
3D Staircase Calculator
A staircase construction calculator: enter floor height, width, number of landings, and turn direction (L / U) — it instantly computes the count and dimensions of each step, visualized in real-time 3D that highlights the part you're editing. So builders and renovators don't have to guess.
Countramic
Ceramic Tile Calculator
Work out how many tiles a room needs, no drama: enter the room size and the tile size, and get the number of boxes required plus leftover cuts. A small tool that actually gets used on-site.
Interactive SQL Class
Master SQL from Scratch
A free SQL practice platform built under tukangdata.com — think LeetCode but for SQL. Learners solve real query problems organized by topic (Selection, Filter, Aggregation, Conditional, Union, Join) against a live PostgreSQL dataset, with an inline query editor, instant evaluation, sample expected output, hint system, and a real-time class leaderboard tracking who's passed, attempted, or skipped each problem.
Asset Monitor
All-in-One Market Dashboard
An all-in-one monitoring dashboard tracking Gold (IDR/gram), USD/IDR exchange rate, and Brent Crude Oil prices in real-time across multiple timeframes (1H to 20T+). Includes a portfolio valuation tool that calculates total holdings from owned gold grams and USD positions, plus a curated news feed filtered by asset class.
Spark + Airflow Bootcamp
Data Engineering with Docker
A comprehensive Docker-based data engineering environment featuring Apache Spark for distributed data processing, Apache Airflow for workflow orchestration, and Apache Kafka for real-time streaming. Includes PostgreSQL database, Jupyter notebooks, and DataHub for data governance. Designed for the Dibimbing Data Engineering Bootcamp with complete containerization setup.
Advanced SQL Course
PostgreSQL Learning Repository
A comprehensive PostgreSQL project for a 3-day intensive SQL course using the classic dvdrental dataset. Features Docker setup with PostgreSQL 17, SQLPad for web-based SQL queries, and pgAdmin for database management. Includes advanced SQL topics covering window functions, CTEs, subqueries, and analytical queries with progressive examples and case studies.
LJSport.id
E-commerce Back-End
LJSport.id is a custom apparel company specializing in jerseys and sportswear. A high-performance landing page with 90+ SEO score, achieving #1 ranking for 'lj sport' search term. Additionally, I built a comprehensive dashboard for order management, invoice processing, and tracking.
Racephoria
Realtime Race Scoreboard
Implementing an automated scoring system using Google Sheets and Apps Script, with real-time data synchronization to a Next.js dashboard. The system features a secure backend API to protect sensitive spreadsheet URLs, while providing a modern UI built with Shadcn and Tailwind CSS for optimal user experience.
Tikum
Pushbike Timing & Scoreboard
Developing a high-performance scoring system leveraging Google Sheets and Apps Script, with real-time data synchronization to a Next.js dashboard. The system implements a secure backend API to protect sensitive spreadsheet URLs, while delivering a modern UI built with Shadcn and Tailwind CSS. Achieved perfect 100 Lighthouse SEO score through optimized metadata, semantic HTML, and performance enhancements.