Pinned

1. Backlog

   A. Work

   • Internal

     • TODO Handle multi-currency exchange rates for MRR

     • Current pricing setup

       • Zoho’s base currency = SGD. Plans are priced in SGD, exchange rate is hardcoded in Zoho (example, 1 EUR = 1.4 SGD).
         • https://media.secondbrain.lelouvincx.com/2026/04/010ee2b4db27a9bc68da91d54a03a681.png
       • Plans are created in Zoho Billing with prices in SGD (base currency). Zoho doesn’t allow creating products in EUR/USD directly.
       • A manual exchange rate is set in Zoho (e.g., 1 EUR = 1.4 SGD).
         • Why? To prevent customers’ purchase amount can potentially fluctuate over time, the team does not use live rate in Zoho.
         • Customers see stable local currency prices on their subscription.
         • This is updated periodically (~yearly) to stay close to market rates.
       • The same plans are mirrored in Holistics App’s Tenant Admin.

     • Customer payment flow:

   page

2. Projects

   List of projects

   • [[Add2Cart]] — Cross-functional project for the Add2Cart professional service: data pipeline, performance optimization, dynamic markdown, and S3 setup
   • [[AI]] — Holistics AI squad work: test suites, AI feature trials, squad coordination with Dat/Tram
   • [[Docs]] — Holistics documentation improvements and revamping
   • [[Duty Support]] — Rotating on-call data support for Holistics customers (Zendesk tickets, impersonation, troubleshooting)
   • [[Freetime]] — Low-priority reading and exploration done in spare time
   • [[Internal]] — Holistics internal data team work: dbt, MRR reporting, CI, tracking
   • [[Logseq]] — Improvements to this second-brain system: automation, backlog structure, weekly reports
   • [[Misc]] — One-off tasks that don’t fit other projects
   • [[Personal]] — Personal tooling, side projects, migration, self-hosting, learning
   • [[Personal Productivity Analysis]] — Personal productivity monitoring: ingest weekly reports + journals into DuckDB (consistent schema with [[Personal Finance]] for later consolidation), build dashboard to track throughput, carry-overs, project mix, priority hit-rate, presales W/L, tooling ROI — drive data-driven planning and 1-on-1 decisions
   • [[Presales]] — Holistics presales support: customer demos, solution proposals, competitive analysis
   • [[Read]] — Reading and studying: articles, books, courses, youtube
   • [[Smartclass]] — Personal side project: an ed-tech app with frontend (shadcn/ui) and releases
   • [[Teaching]] — Mentoring and teaching data/SQL: composing projects (Olist), visualization, set-based thinking

   page