Chinh (lelouvincx) lelouvincx

Notes

• Tasks

• Done

  • {{embed ((69670f76-e398-42cb-9763-e56dbcc4f404))}}
  • {{embed ((695e13a2-4937-40df-8f61-7b1af0981cbb))}}
  • DONE UI/UX feedback for AI team after my trial yesterday

• DONE Weekly sync #2026-01-16

Notes

• https://www.1keydata.com/datawarehousing/processes.html

  • Very good reference data warehousing’s terms & processes.
  • Mentioned once in [[Data Modeling]]

• https://www.ssp.sh/blog/diary-of-a-data-engineer/

  • Now bro emphasizes on the importance of [[Data Modeling]]

• Tasks

• Done

  • {{embed ((69671001-f0b8-41c0-9f99-f9706404e7cb))}}
  • {{embed ((694b5e14-1dff-4e10-b325-ed0dae46e467))}}
  • {{embed ((695e13a2-4937-40df-8f61-7b1af0981cbb))}}
  • DONE Write a quick update for Simon about the dashboard progress

• DONE Help a Thi with the dbx proposal on dblineage

Notes

• Idea: Takes semantic layer as center, we provide data for other frontend/UI rendering apps via an API. Every business-related data definitions stay inside Holistics.

  • https://www.notion.so/holistics/RFC-2794-External-Metric-Layer-Interface-2bcf89dc7e4980248860dc04099f51a0

• Tasks

• Done

  • DONE Support Hometime (Clark) in show rows with null data

• DONE Develop dashboard 4

  • Materialize the key retailer_current_pricing concat
  • Pre-calculate Price Matrix

Notes

• Add2Cart Dashboard Implementation Process

  • This is a 5-step process designed to translate dashboard prototype into performance Holistics assets.
  • Metric first, structure second.
  • Start by attempting to define logic in the metric layer (AQL). Only push logic upstream to the AML when you hit hard limitations (like filter conflicts or complex nested aggregations).
  • 1. Prototype Deconstruction
    • Before coding, map the dashboard inputs to outputs.
    • Inputs: What are filters (Date, Primary Retailer)?
    • Outputs: What dimensions are shown (Competitor Retailers)?
    • Check:
      • If I filter by Input A (Coles), does Output B (Woolworths) disappear? If conflict, need a scope pattern (step 3), but define your metrics first to see exactly what they need.

• Tasks

• Done

  • {{embed ((695f172d-3b9f-447f-a5fe-d76f67fa0d00))}}
  • {{embed ((6923d401-6764-4172-90e9-3ff64a3b7a9b))}}

Tasks

• Done

  • DONE Remove duplicated dashboard in hooli embed portal

• DONE Answer Anurag

• Stratascratch vs Datalemur

  • Datalemur is cheaper than Stratascratch: $60/year vs. $159/year.
  • Alternatives
    • Interview Query
      • Better 48-hour take-home exercises.
      • More expensive: $204/year.
    • Maven Analytics’ Data Playground
      • Hosts raw CSV data files for specific business domain.
      • Can self-host the platform with dbt and Metabase.

• Daily Journal Template

• Notes

• Tasks

• Partly today

• Done

Notes

• I hate AI-generated posts. Recently I see that on facebook 80% posts are chatgpt generated.
• Hence I should write things on my own, at least not 100% AI generated because I don’t want to read those posts.

Notes

• Year End Party 2025 Impressions

• Tasks

• Done

  • {{embed ((695b8d40-6f80-473c-85ca-cc40313ec77a))}}
  • {{embed ((695f172d-3b9f-447f-a5fe-d76f67fa0d00))}}
  • DONE Alternative for Zero-ETL Integration

• DONE Prepare weekly update

• Update:

  • Dashboard 3, 4, 5 (Pricing):
    • We started working on the remaining dashboards (3, 4, 5).
    • For starter, we’ve mapped out the UX, Logic flow and KPI definitions based off the Lovable prototype. This helps us clarify the business logic in first place.
    • Ask:
      • Please help review the KPI Definitions section to align on the logic (link).
    • Once aligned, we’ll go ahead with the implementation.
  • ETL:
    • The Zero-ETL approach requires adjustment, we recommend pivoting to Fivetran (free plan) as an alternative.
    • This does not block current dashboard development.
    • I am syncing with Anurag today to ensure the new data schema aligns with dashboard requirements.

• Next:

• New docs: filter_direction

• Tasks

• Done

• {{embed ((694b5e14-1dff-4e10-b325-ed0dae46e467))}}

• {{embed ((695f172d-3b9f-447f-a5fe-d76f67fa0d00))}}

• DONE Check TerryWhite use case Notion

• Treat customer/sales problem at highest priority. Not the message from 9AM but respond at 3PM.
• [[Gaps and Islands]]

• Tasks

• Done

  • DONE The 3rd dashboard

  • Do some feedback to the team and we’re good to go.

    • NOTE: Feedback can’t do conditional formatting with price_rank.
    • NOTE: Feedback can’t hide measures in the pivot chart.
    • NOTE: Feedback in pivot chart, can’t sort columns by custom order.
• DONE Data support for Hometime