Chinh (lelouvincx) lelouvincx

• https://chatgpt.com/g/g-p-68c64703caf48191b0583c8a6857f08c-chinh/c/69100b0f-d6c4-8323-8b01-de7b169cf129

• https://gemini.google.com/app/dabc4a0a978845c1

• Keynotes

  • Slowly Changing Dimensions (SCD) refer to how you store historical changes in data
  • Type 0: retain original
  • Type 1: overwrite data
  • Type 2: add new row for historical record
  • Type 3: add new column stand for previous value and current value
  • Type 4: keep the main dimension table for current data, while moving all historical changes to a separate history table
  • Type 6 (1+2+3=6): create new row but also overwrite current state column

• k

• https://gemini.google.com/share/f5ebbad97a43

• Không hiểu sao quan cảnh rất giống trong Ghibli, nhìn rất thơ mà nét nào ra nét nấy.

• Vài bức ảnh chụp được

  • Con chuồn chuồn màu đỏ xinh ghê

  • https://media.secondbrain.lelouvincx.com/2026/04/d974844edd7e3ca2f6766202a3dd18e7.png

  • https://media.secondbrain.lelouvincx.com/2026/04/66bef276e3dfdc62379611575bad9974.png

• Nhìn căn nhà giống trong truyện tranh

  • https://media.secondbrain.lelouvincx.com/2026/04/bec3a65711ad14207108b4f84056d418.png
  • https://media.secondbrain.lelouvincx.com/2026/04/4f8a777db7397ec4a53df316e565323d.png

• Cái cây này giống trong truyện của Nguyễn Nhật Ánh

  • https://media.secondbrain.lelouvincx.com/2026/04/d8070c4a0a490404e1e2fa0339a649a7.png

• Quả chò rơi xuống từ mái nhà

  • https://media.secondbrain.lelouvincx.com/2026/04/94b4d09b2f00191ea46de9b28c26e878.mp4

• Ấn tượng rất tốt về nơi này, giống như vừa lạc 1 chuyến vào thế giới Ghibli vậy. Sẽ quay lại vào năm sau, vì tầm này được lợi thế là đi rừng không có muỗi/côn trùng, khô ráo (hơi nóng ẩm tí) và không mưa ngập.

Plan for week 10 (Ampcode)

• P1
  • Add2Cart
    • ((69a2a14f-91e8-49be-be93-da1c506869aa)) (carry-over from friday, push Anurag).
    • ((69a2a1cc-94ff-4e02-972e-3b4d720b63ce))
  • Internal
    • ((69a42ffd-22c7-4b43-8b34-0f663743abcf))
    • ((69a2a1cc-fc1f-4802-ba56-48183fa9e9a5))
• P2
  • Internal
    • ((697889da-2e31-4c43-9676-81a898db1ea6))
  • Presales
    • ((69841d05-88ea-4209-82ca-30b11b26e91c))
• P3
  • Duty Support
    • Document MedEnterprises performance use case on metrics sheet.
  • Personal
    • Learn logseq’s internal query, and potentially build a skill to query tasks faster.
    • Estimate timeline for teacher Thanh.

• P1
  • Internal
    • Review MRR PR holistics/dbt#812 — awaiting author’s remaining fixes.
    • DE-202 trial-first vs call-first — share POC with Vincent/Sriram.
• P2 – Should Do
  • Internal
    • DE-201 PR Workflow enhancement — continue commenting.
    • Fix excluding internal testing Zoho accounts (DAT-524) — lingering since week 7.
    • Continue Cross-Model Calculation — timing may still be premature (docs revamping not far enough).
• P3 – Nice to Have
  • Presales
    • Read Modeling Patterns docs; watch Taxdome onboarding call; learn embedded analytics use case; compare ChatGPT solutions Omni vs Holistics.
  • Teaching
    • Figure out set-based thinking curriculum; find football dataset for Duc Anh; checkout pudding.cool resources; research visualization resources.
  • Personal
    • Consider a Flashcard app for learning English words.

Plan for week 13 (Mar 23 – Mar 29, 2026)

• P1 – Must Do
  • Presales
    • Onboarding call 3 with Basata — DONE. Shared Date Drill use case, reported Auto Mapping Filter issue.
    • Share the embedded dashboards document for different customers — carry-over from call 3. Excalidraw
  • Internal
    • Review what Hieu wrote on MRR, help him communicate with growth team (2 items: dashboard alignment + currency exchange rate).
    • Create an agent skill for fixing data pipelines (dbt) for #data-ops-bot.
    • Investigate failed dbt assets in #data-ops-bot — DONE. Root cause identified (scheduling order + LEFT JOIN bug), SQL refactored, Notion doc written, DAT-569 created.
    • Create a new GitHub account for work — DONE. Next: update Logseq automation to switch between credentials.
• P2 – Should Do
  • Internal
    • Review Thuan’s PR #845 on DE-208 / mart_product__dataset_datamodel_dimensions — open, feedback shared, needs final approval.
    • Revise phase 2 of MRR problem — PR #812 merged, 2.1 fixed. Remaining: static exchange rate (1.1/1.2), domain mapping (2.2), duplicated companies (2.3).
    • Ingest Calendly data into warehouse (DAT-283) — ongoing. Calendly vs ReadAI assessed as complementary. Pending: standardize source pipeline + unified dbt models.
    • Check back Census usage estimate to confirm free tier — due Mar 26.
    • DAT-555 resolution — decide whether to remove fct_job_queue_performance; write Notion doc for team review.
    • Fix excluding internal testing Zoho accounts — DAT-524, lingering since W7.
  • Add2Cart
    • Waiting for Anurag to ingest 6 countries’ Retailer tables into Redshift (airbyte_schema_*). Then fix “history-only 589 retailers” issue.
  • Teaching
    • Brazilian dashboard Dash 2 (Shipping Overview) + demo video for Yen — carry-over.
  • Docs
    • Fix markdown files missing for index pages — DONE. PR #1443 merged.
• P3 – Nice to Have
  • Internal
    • Run first AI-for-data-ops-bot cycle — partially done (investigated DAT-569 with agent, documented for Thuan). Next: formalize as reusable agent skill.
  • Presales
    • Read Modeling Patterns docs.
  • Personal
    • Change to a more professional work avatar.
    • Consider a Flashcard app for learning English words.
• Focus days suggestion
  • Block Tue–Wed for Calendly ingestion + MRR phase 2 planning. Adjusted: Wed–Thu for MRR review + growth team alignment.
  • Fri: wrap up PR #845 review, Calendly pipeline coding.

Plan for week 14 (Mar 30 – Apr 4, 2026)

• P1 – Must Do
  • Add2Cart
    • Ingest countries data into Retailers table — carry-over from W13 Friday. Complete Redshift SP/table audit (unused SPs + orphan tables identified). Schedule this Monday morning when fresh.
  • Internal
    • Create an agent skill for fixing data pipelines (dbt) for #data-ops-bot — carry-over from W13. Build on DAT-569 investigation + Thuan’s debugging process doc.
    • Final approval on Thuan’s PR #845 (DE-208 / mart_product__dataset_datamodel_dimensions) — changes requested in W13, needs follow-up review.
  • Presales
    • Prepare and attend onboarding call 2 with [[Showbie]].
    • Follow up with Basata on next onboarding session.
    • Polish embedding documentation — reduce friction for prospects setting up embed portals. Increasing lead volume makes this urgent.
• P2 – Should Do
  • Internal
    • Visualize schedule of all data lineage (airbyte, data import, prefect sync, dbt table-level, census/fivetran activations) — new backlog item from W13.
    • Continue Calendly data pipeline (DAT-283) — standardize source pipeline, build unified dbt models.
    • Fix excluding internal testing Zoho accounts (DAT-524) — lingering since W7. Timebox: max 2h or explicitly deprioritize.
    • Review Hieu’s exchange rate document when ready — waiting from W13.
  • Presales
    • Investigate Showbie performance concern — raised with Huy in W13, wait for next call then investigate if needed.
  • Add2Cart
    • Document project and guide setup for other countries.
    • Project retro with team (Dong).
  • Teaching
    • Brazilian dashboard Dash 2 (Shipping Overview) + demo video for Yen — carry-over from W12.
• P3 – Nice to Have
  • Internal
    • DAT-555 resolution — decide whether to remove fct_job_queue_performance; write Notion doc.
    • Upgrade dbt-core of repo dbt to the same version as prefect (compatible).
  • Presales
    • Read Modeling Patterns docs.
  • Personal
    • Self reflection and update CV.
    • Read Levels of Detail in Communication — from W13 recommended resources.
• Focus days suggestion
  • Mon: Add2Cart Redshift ingestion (deep work, fresh Ampcode tokens). Thuan’s PR #845 final review.
  • Tue–Wed: Calendly pipeline + agent skill for dbt ops bot (minimize context switches).
  • Thu: Presales calls (Innerspace, Basata follow-up). Polish embedding docs.
  • Fri: Zoho accounts fix (timeboxed), backlog grooming, weekly report.

Plan for week 15 (Apr 6 – Apr 10, 2026)

• P1 – Must Do
  • Internal
    • Calendly data pipeline (DAT-283) — elevated to P1 from W14. Currently only demo/onboarding calls ingested; need all 50+ event types. Growth team needs this for sales rep performance and Lead Funnel sales motion enrichment.
    • Zendesk debug → pivoted to upgrade plan (3 options written, WAITING review).
  • Presales
    • Onboarding call 1 with Jonas Chorum — moved to Apr 9. Continue dynamic data source demo prep.
  • Add2Cart
    • Project retro with anh Dong — carry forward to W16.
• P2 – Should Do
  • Internal
    • Create agent skill for fixing dbt data pipelines in #data-ops-bot — carry-over from W13.
    • Fix excluding internal testing Zoho accounts (DAT-524) — lingering since W7. Timebox: max 2h.
    • DAT-571 Zendesk upgrade plan — get review and decide on option (Fivetran vs Prefect orgs-only vs Airbyte upgrade).
    • DAT-555 — get PR reviews for dbt #849 and internal-aml-project #69 (remove fct_job_queue_performance).
    • Contribute to Holistics skills and internal-skills repos.
  • Docs
    • Polish embedding documentation — ask anh Tai and anh Huy to clarify scope.
  • Add2Cart
    • Get anh Huy’s review on D4 countries guidance document (WAITING).
• P3 – Nice to Have
  • Presales
    • Read Modeling Patterns docs.
  • Internal
    • Lead Funnel by Sales Motion (DAT-560) — review and make a plan; context page created.
    • Upgrade dbt-core of repo dbt to match prefect version.
  • Personal
    • Self reflection and update CV.
• Progress vs plan (as of Tue)
  • DONE: DAT-569 snowplow fix (PRs merged, deployed, backfill success).
  • DONE: Add2Cart countries ingestion.
  • DONE: DAT-555 downstream models written (waiting PR review).
  • DONE: Lead Funnel context page consolidation.
  • DONE: Zendesk upgrade plan written (3 options).
  • NOT STARTED: Calendly pipeline, agent skill, DAT-524, embedding docs.
  • MOVED: Jonas Chorum call → Apr 9. Add2Cart retro → W16.
• Focus days suggestion (updated)
  • Tue (today): Data sync meeting. Follow up on DAT-555 PR reviews. Lead Funnel planning.
  • Wed: Calendly pipeline deep work (P1). DAT-524 timeboxed 2h morning. Embedding docs scope with anh Tai/Huy.
  • Thu: Jonas Chorum demo prep. Holistics skills repo contribution. D4 review follow-up with anh Huy.
  • Fri: Calendly pipeline continued. Backlog grooming. Agent skill for dbt ops bot.