https://benn.substack.com/p/no-really-everything-becomes-bi
https://benn.substack.com/p/go-crazy-folks-go-crazy
Full context moved to [[Lead Funnel by Sales Motion]]
TODO Fix the temp bridge table
Approach: Treat atc_price_history as alternative to retailer_current_pricing.
Current state: using a table bridge_product_retailer as a mapping between atc_price_history and retailer_current_pricing. The result is when querying historical prices, Redshift has to join a long path from master_product -> retailer_current_pricing -> bridge_product_retailer -> atc_price_history just to query the historical price, while expect to join master_product to atc_price_history => leads to slow performance.
The only difference between those 2 is that atc_price_history contains historical price, while retailer_current_pricing contains present price. But similarly they are fact tables telling the price of a product inside a retailer.
DONE Onboarding call Fluent Data
DONE Answer Sriram about trial-first vs. call-first
DONE Add skill for querying holistics dataset
DONE Answer Quinn on tracking admin edits to tenant subscriptions
DONE Setup claudecode
Back to work with IVE’s new album!
Found a dashboard as code solution Shaper
BARCHART, PIECHART, etcSELECT 'Sessions per Week'::LABEL;
SELECT
date_trunc('week', created_at)::XAXIS,
category::CATEGORY,
count()::BARCHART_STACKED,
FROM dataset
GROUP BY ALL ORDER BY ALL;
https://blog.pmunhoz.com/dbt/dbt-defer-optimize-cicd-pipelines
TODO Document all stored procedures in a data lineage and schedule them properly
DONE Optimize Dashboard 4 by filtering prices to latest day
{{embed ((6984ba77-ed0a-4312-a25c-c83021e0606a))}}
DONE Lay comments in Enhance PR Workflow
DONE Airbyte is ready now sync tables to Redshift and Holistics
DONE Retailer Current Pricing
DONE Promotional Group
DONE Product
DONE Advertisement
DONE Category
DONE Check server for Anurag
DONE Investigate Simon’s question
