• DONE Prepare technical use case for Favored Live

  Project: [[Presales]] Priority: #P1

  • Has a use case when he wants to design tables in dbdiagram and then an automatic export to Holistics AMQL
  • Export a dashboard widget via API
  • Use Action to trigger the app’s backend to select them into a list

• Before doing any data project, must align with business users on entity definitions/conceptual design and metrics

  • Apply for both [[Add2Cart]] and [[Internal]]

• DONE Review S3 directory structure

  Project: [[Add2Cart]] Priority: #P1

  • 1P vs 3P semantics: Shopee Supermarket (1P) vs marketplace sellers (3P). We need a flag (retailer_kind) to separate them for analytics.
    • Do we actually need that flag? -> Ask Simon
  • Promo provenance & stacking: Distinguish platform-funded vs seller-funded components (voucher, coins, shipping). This affects “current price” calculations and must be modeled, not inferred.
  • Country scoping: Shopee operates per country. Decide if platform_id is global with a country attribute, or country-scoped IDs
  • In the backend I see there’s Platform, but on the mock dashboards I dont see it. Is it some intention behind hiding the platform?
  • The barcode is used to match the same product across different platforms, of course, within the same retailer.
  • Barcode vs. retailer code
  • One app: one product and it shows different price per different retailers
  • Simon knows his responsibility and how to move things forward. I’d better the same as him.
  • I think he’s a person I can learn more from, not only add2cart.

• DONE Reply Natalia Jay

Notes

• Accidentally check my linkedin profile today, surprise that I have been in Holistics for 1 year

  • https://media.secondbrain.lelouvincx.com/2026/01/74e34fb6d87b2876e4942592d239feb6.png

• And then I realize the 1 year and 6 months at KMS does not too memorable, I didn’t grow much at that time.

• Tasks

• DONE Call Clarity Pediatrics

  Project: [[Presales]] Priority: #P1

• DONE Data tracking for OpenAI

  Project: [[Internal]] Priority: #P3

• DONE Import 2 tables from dbdocs into bigquery Project: [[Internal]] Priority: #P2

• How to educate yourself like Ivy Ledge students

• Actually I’m usually ask AI about unknown unknown
  • It’s like a searching tool to expand unknown unknowns, then I note into my knowledge base, and use them as ingredients for later knowledge/insight

• In customer discovery call, the diff between a PM and a Sales is

• The PM

  • Answers questions as-is, what feature are available and not, he answers it clearly
  • """ Is there in the future coming a different table group levels? Because then I actually see a little solved for what Thomas could, then we can just drill down higher, et cetera. Is there, since it’s only roadmaps, is this coming more nested table groups?
  • -> More nested table groups. No, we don’t have a nested table group right now. """
  • Call link: https://copilot.clari.com/call/eb2fc127-ea39-47f1-9a62-7d05812b822b

• The Sales

Notes

• [[Leap of Faith]]

• Tasks

• DONE Product research dblineage Project: [[Weekathon 2025]] Priority: #P1

Notes

• Mental model of SQL, and also relational databases:

  • [[Set-based thinking]] instead of row-based thinking
  • Relational database is built on [[Set Theory]] and [[Relational Algebra]]

• Tasks

• {{renderer :todomaster}}

• DONE Guide Huy how to run dbt/jaffle-shop

  Project: [[Weekathon 2025]] Priority: #P1