Tag
4 articles tagged #Analytics.
P.01ClickHouse is a columnar database designed for analytical workloads. It answers queries over billions of rows in seconds that would take minutes in Postgres. Here's what application developers need to know.
P.02dbt turns SQL SELECT statements into a tested, documented, version-controlled data pipeline. Here's how it works and when you should add it to your data stack.
P.03Most teams pick an analytics tool based on a free trial and then live with that choice for years. Here's an honest comparison of PostHog, Mixpanel, and Amplitude so you pick the right one before the data gets messy.
P.04Running totals, rankings, moving averages, lag and lead comparisons: window functions handle the analytics queries that would otherwise require application-side loops or multiple round-trips. Here's how they work.