Avatar
🧠

Organizations

    • 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
    page Created Mon, 25 May 2026 00:00:00 +0000
    • k
    page Created Mon, 25 May 2026 00:00:00 +0000
  • page Created Mon, 25 May 2026 00:00:00 +0000
  • 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.
    page Created Mon, 25 May 2026 00:00:00 +0000
    • 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.
    page Created Mon, 25 May 2026 00:00:00 +0000
  • 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.
    page Created Mon, 25 May 2026 00:00:00 +0000
  • 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
      • Personal
    • 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.
    page Created Mon, 25 May 2026 00:00:00 +0000
  • 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
      • 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.
    page Created Mon, 25 May 2026 00:00:00 +0000