Project register / 2026
Work
A compact index of implemented systems, their evidence base and the limits of what each public repository can prove.
01Multi‑Channel E‑commerce Sales Pipelineหนึ่ง dashboard จาก marketplace exports ที่ไม่เหมือนกัน
Power Query/M pipeline and Power BI model for aligning Shopee, Lazada and advertising exports into one inspectable reporting layer.
SIMULATEDPower BI reporting / Power Query data cleaning / E-commerce reporting
Impact: Creates one comparable reporting layer so a team can inspect channel performance, payout and advertising signals without stitching exports by hand.
ข้อมูลตัวอย่างเป็น synthetic/anonymized demonstration data — not client performance.
Shopee Thailand AnalyticsMarketplace analytics for sales, customers, campaigns and delivery
SQL analysis modules and a documented Power BI/DAX model for examining sales, customer behavior, campaigns and delivery performance.
SIMULATEDSQL analytics / Power BI dashboard / E-commerce sales analysis
Impact: Turns separate commercial and logistics questions into a shared analytical model for clearer review of sales, retention, campaigns and delivery.
กรณีศึกษานี้ใช้ข้อมูลจำลอง; displayed figures are not Shopee or client internal results.
Finance ETL PipelineFrom e-statement PDF to an auditable data pipeline
A Python pipeline design for extracting KBank e-statements, validating transactions, loading PostgreSQL idempotently and preserving operational audit records.
EVIDENCE LEDPython ETL / PostgreSQL data pipeline / Operational reporting automation
Impact: Creates a repeatable path from statement input to validated, traceable records, reducing ambiguity when financial-data loads are retried or reviewed.
KBank-specific parser scope; do not imply broad multi-bank production support.
TIMELIMITOffline-first desktop deadline instrument
An Electron/TypeScript desktop widget that makes long-term deadlines visible through timestamp-based time calculation, deduction rules and local persistence.
EVIDENCE LEDDesktop MVP / Electron / Offline internal tool
Impact: Keeps a long-term deadline visible and derived from the current timestamp, so local users can review remaining time without relying on a drifting counter.
No claim of independently verified public CI execution, signing or hardened production security.