Chinh (lelouvincx) lelouvincx

Done

• DONE Support Adam from superb to use advanced filter

• DONE Review the performance case https://holistics.slack.com/archives/C95QEV4JF/p1761560212688339

Done

• DONE Write 1on1 note

• DONE Understand their intention of reviewing the dashboard

Note

• Business idea

  • Edtech.
  • In data analytics/business intelligence.
  • Mang company use case về cho các bạn học hands-on.

• https://youtu.be/uOcKF-aLHyw?si=aH8XLIFM4HdzqVpL

  • Ask with faith.
    • Believe you can get what you want by asking, like a child.

• Try to dig deeper into other BI tools

  • Try to dig deeper into other BI tools (PowerBI, Looker, Metabase) to understand customers better.
  • Also to speak their language.

• Done

  • DONE Call with Pencil

• DONE Prepare meeting note of Pencil

Note

• Metrics vs Measures

  • Current docs dont differentiate too well these 2 terms. But in calls, Vincent/Chukwudi mentions pretty frequently. So I think it worth spend time articulating this. Hope this helps.

• Done

  • DONE Prepare meeting with Pencil

• DONE Draft in linear about engineer team’s need (no need to write the how)

Done

• DONE Set up hackmd and github for Yen

Note

• Fussy’s use case

  • Figure out all customers that have had a specific product category combination, what’s the distribution of each category looks like.

• Archive some articles

  • Text to SQL Evaluation Techniques: A Comprehensive Guide: https://www.snowflake.com/en/engineering-blog/cortex-analyst-text-to-sql-accuracy-bi/
  • SWE-Bench Verified: https://openai.com/index/introducing-swe-bench-verified/

• Done

  • DONE Prepare a document to align our understanding and communication, then ask a Huy to review

Note

• Anurag

  • Means love, affection in Sanskrit (India and South Asia).
  • In vietnamese, similar to Ái.

• Done

  • DONE Write a query to list all objects from a dashboard of Aurora

• DONE Change the connection on Holistics from serverless to Redshift cluster

  • Grant all privileges for user ‘holistics’.
  • Create a test table and load dump data into.
  • Tear down the EC2 instance -> recreate and setup the holistics connection -> ssh into the instance -> change user’s password -> apt update -> make sure can connect to redshift from the instance.
  • 

• DONE Establish the new reverse tunnel connection with Holistics

• Done

  • DONE Check to find all relevant items such as Shareable Link, Data Alerts,… of a user & the dashboard

Note

• Comfort Zone

  • Stretch - Reflex - Recharge.

• Done

  • DONE Setup the Holistics connection

• DONE Document the process (only important highlights) and update them afterwards

• DONE Conceptual Modeling

Note

• Triangle of Talent

  • https://www.shaanpuri.com/essays/triangle-of-talent

• Connecting Redshift

  • Hi Simon and Anurag,
  • Now we have the Redshift (serverless) access, we need to connect it to Holistics.
  • There are two ways for Holistics to connect:
    • 1. Direct connection (public endpoint + IP allowlist)
    • 2. Reverse SSH Tunnel (no public exposure)
  • The best practice here is using the reverse SSH tunnel. We have set up Redshift for some customers using this way. Some benefit:
    • No Exposing of Private Network.
    • Data Encryption in Transit.
  • Document: https://docs.holistics.io/docs/connect/connect-tunnel
  • Meanwhile, we’re analyzing the shared dump file as well as the product pricing info.
  • Happy to jump on a quick call to finish the setup.

• Done

  • DONE Communicate the problem space of adding the Redshift Serverless data source to Holistics

• DONE Try to synthesize the conceptual business model of Add2Cart (data modeling)