[[Conceptual Thinking]]
[[Recursive CTE]]
[[Parquet Zone Maps]]
“If you can’t solve a problem, then there is an easier problem you can’t solve; find it.”
Tasks
Done
- DONE Answer Joel
- DONE Revise Add2Cart tasks
DONE Add column views count for Joel
DONE Handle 3 use cases of Data Support
Project: [[Duty Support]] Priority: #P3
- Notion Link
- DONE 1. Check with Product (Di, Minh)
- DONE 2. Update to the docs
DONE Reply Vincent
- Summary of Pencil’s use case.
- They want to provide usage analytics of their product for business customers.
- (1) Each customer has their own dashboard: same charts in dashboard, different in data. For example, a typical usage analytics dashboard includes: number of generations, number of exports, number of users, etc. Ideally Pencil’s customer success team does this, else, data team.
- To do this, they have a template dashboard, which is a blueprint of default charts. They duplicate and share it to customers.
- (2) Then some customers may want to add more charts into their own shared dashboard (shareable link). Pencil’s data team helps them.
- (3) Then some customers may want to extract raw data in order to load into data warehouse, Pencil builds API for that.
- From the (1) and (2) use cases, we see there’s a potential of embedded analytics offering: by using embed portal in their app and let Pencil’s customers self-serve.
- Gemini: https://gemini.google.com/u/3/app/e3721b6f4ef2e2a9
- Summary of Pencil’s use case.
DONE Report for 99co’s assets: Dashboards, Reports, etc. Slack
Project: [[Presales]] Priority: #P1
- Models:
99co_dashboards,99co_queries,99co_users,99co_versions,99co_data_imports,99co_data_transforms,99co_schedules,99co_data_sources,99co_last_runs - Dataset:
99co_migration_support_dataset - Dashboard:
99co_migration_support_dashboard - Link: https://internal.holistics.io/dashboards/v4/108100-99co-migration-support-dashboard
- Gemini: https://gemini.google.com/u/3/app/2effcbac71bc3f01
- Models:
/ 2025-12-16
Created Tue, 16 Dec 2025 00:00:00 +0000
Modified Mon, 25 May 2026 06:02:25 +0000