Analytics

These data analytics guides follow the path from a single tracked event to a decision. Most posts include code you can run on a small stack.

For instance, event driven analytics architecture explains the overall flow. Next, PostgreSQL schema design for analytics shows how to store it well. Later posts add AI on top, such as text to SQL with a local LLM. In short, it is analytics for people who build the pipes.

18 articles

28/12/2025 13 min read

From Dashboards to Decision Intelligence: Where Enterprise Analytics Is Heading

Learn what decision intelligence adds to dashboards: data products, metric layers, decision logs, and what must stay human. A practical and honest view.
27/12/2025 15 min read

Multi-Agent Systems for Data Analysis: How to Automate Reports

Build multi-agent systems for data analysis in Python: planner, SQL analyst, reviewer and writer, with budgets, guardrails and…
21/12/2025 19 min read

How to Build a RAG Pipeline to Chat with Your Company Data

Build a RAG pipeline with Ollama and pgvector locally: chunk docs, embed, retrieve, cite sources, and measure answer…
20/12/2025 19 min read

How to Query Your Database with a Local LLM (Text-to-SQL)

Learn text-to-SQL with a local LLM and Ollama: schema prompting, a read-only PostgreSQL role, SQL validation and the…
14/12/2025 18 min read

How to Trigger Automated Actions from Analytics Events

Build automated actions from analytics events in Node.js and PostgreSQL: rules, an outbox, webhooks, idempotent retries and rate…
13/12/2025 18 min read

PostgreSQL Performance Tuning for Analytics: Indexing and Partitioning

PostgreSQL performance tuning for analytics: pick the right index (B-tree, BRIN, partial), partition events by month and keep…
07/12/2025 15 min read

How to Move Analytics from Your App Database to a Data Warehouse

Move analytics from PostgreSQL to a data warehouse with a hands-on ClickHouse plan: ELT vs ETL, CDC vs…
06/12/2025 15 min read

Event-Driven Analytics Architecture Explained

Learn event-driven analytics: producers, a broker, consumers, schemas, delivery guarantees and replay, with a small runnable Node.js example…
23/11/2025 16 min read

How to Build an Analytics Dashboard with React

Build an analytics dashboard with React 19, Vite and Recharts: a data-fetching hook, date filters, and loading and…
22/11/2025 16 min read

Cookieless Analytics: How to Track Users Without Cookies

Cookieless analytics explained: compare daily rotating hashes, localStorage and server-side sessions, with runnable Node.js code and honest accuracy…
09/11/2025 20 min read

Async Event Tracking: Collect Analytics Without Slowing Down Your App

Async event tracking keeps analytics off the critical path. Build client batching, retries, a server buffer, backpressure and…
08/11/2025 21 min read

PostgreSQL Schema Design for Analytics

PostgreSQL schema design for analytics: build the events table, JSONB properties, sessions, users and a daily rollup with…
02/11/2025 21 min read

How to Build Your Own Analytics API in Node.js

Build your own analytics API in Node.js: an Express collector with validation, CORS allow-list and rate limiting, plus…
01/11/2025 16 min read

How to Build a Custom Analytics Dashboard with HTML and JavaScript

Build a custom analytics dashboard with plain HTML, JavaScript and Chart.js: KPI cards, a trend chart and a…