# Analytics Articles

> Real-time analytics architecture: Streaming ingestion and sub-second dashboards. Why batch is obsolete and how to handle event streams at scale.

Filter by Topic:

[All Posts (45)](/blog.md) [Engineering (31)](/blog/tag/engineering.md) [Architecture (21)](/blog/tag/architecture.md) [Performance (14)](/blog/tag/performance.md) [Product (13)](/blog/tag/product.md) [Altertable Agent (12)](/blog/tag/ai-agents.md) [Open Source (10)](/blog/tag/open-source.md) [Data Stack (9)](/blog/tag/data-stack.md) [Analytics (7)](/blog/tag/analytics.md) [AI (4)](/blog/tag/ai.md) [Culture (3)](/blog/tag/culture.md) [Generative UI (2)](/blog/tag/generative-ui.md) [Agents (2)](/blog/tag/agents.md) [Semantic Layer (2)](/blog/tag/semantic-layer.md) [Cousteau (1)](/blog/tag/cousteau.md) [MCP Apps (1)](/blog/tag/mcp-apps.md) [Agentic UI (1)](/blog/tag/agentic-ui.md) [Model Context Protocol (1)](/blog/tag/model-context-protocol.md) [Pricing (1)](/blog/tag/pricing.md)



Real-time analytics architecture: Streaming ingestion and sub-second dashboards. Why batch is obsolete and how to handle event streams at scale.

[![A Semantic Layer in DuckDB](/assets/blog/2026-11-02-semantic-layer-in-duckdb.jpg)](/blog/2026-11-02-semantic-layer-in-duckdb.md)

[NOVEMBER 2ND, 2026](/blog/2026-11-02-semantic-layer-in-duckdb.md)

[Sylvain Utard](/blog/2026-11-02-semantic-layer-in-duckdb.md)

## [A Semantic Layer in DuckDB](/blog/2026-11-02-semantic-layer-in-duckdb.md)

[Engineering, Open Source, Semantic Layer, Analytics](/blog/2026-11-02-semantic-layer-in-duckdb.md)

[A semantic layer inside DuckDB: define metrics once in SQL, and every query, from an analyst or an AI agent, gets the joins and aggregations right.](/blog/2026-11-02-semantic-layer-in-duckdb.md)

[READ ARTICLE](/blog/2026-11-02-semantic-layer-in-duckdb.md)

[![Local Decisions in DuckDB](/assets/blog/2026-10-29-local-decisions-in-duckdb.jpg)](/blog/2026-10-29-local-decisions-in-duckdb.md)

[OCTOBER 29TH, 2026](/blog/2026-10-29-local-decisions-in-duckdb.md)

[Sylvain Utard](/blog/2026-10-29-local-decisions-in-duckdb.md)

## [Local Decisions in DuckDB](/blog/2026-10-29-local-decisions-in-duckdb.md)

[Engineering, Open Source, AI, Analytics](/blog/2026-10-29-local-decisions-in-duckdb.md)

[Jev sparked a wave of decision models. We tried a compact open model inside DuckDB, routing support messages with SQL and checking its confident mistakes.](/blog/2026-10-29-local-decisions-in-duckdb.md)

[READ ARTICLE](/blog/2026-10-29-local-decisions-in-duckdb.md)

[![Forecasting the AI Hype](/assets/blog/2026-10-26-forecasting-the-ai-hype.jpg)](/blog/2026-10-26-forecasting-the-ai-hype.md)

[OCTOBER 26TH, 2026](/blog/2026-10-26-forecasting-the-ai-hype.md)

[Sylvain Utard](/blog/2026-10-26-forecasting-the-ai-hype.md)

## [Forecasting the AI Hype](/blog/2026-10-26-forecasting-the-ai-hype.md)

[Engineering, Open Source, AI, Analytics](/blog/2026-10-26-forecasting-the-ai-hype.md)

[We classified a million Hacker News submissions with Jev and forecast daily AI chatter with Timestral in DuckDB, comparing all four model sizes.](/blog/2026-10-26-forecasting-the-ai-hype.md)

[READ ARTICLE](/blog/2026-10-26-forecasting-the-ai-hype.md)

[![Event Paths in DuckDB](/assets/blog/2026-09-17-journeys-in-duckdb.jpg)](/blog/2026-09-17-journeys-in-duckdb.md)

[SEPTEMBER 17TH, 2026](/blog/2026-09-17-journeys-in-duckdb.md)

[Sylvain Utard](/blog/2026-09-17-journeys-in-duckdb.md)

## [Event Paths in DuckDB](/blog/2026-09-17-journeys-in-duckdb.md)

[Performance, Engineering, Open Source, Analytics](/blog/2026-09-17-journeys-in-duckdb.md)

[Discover observed paths through event data with JOURNEYS, a native DuckDB operator for start-to-end routes including incomplete journeys.](/blog/2026-09-17-journeys-in-duckdb.md)

[READ ARTICLE](/blog/2026-09-17-journeys-in-duckdb.md)

[![Stop Batching Analytics](/assets/blog/2025-12-30-stop-batching-analytics.jpg)](/blog/2025-12-30-stop-batching-analytics.md)

[DECEMBER 30TH, 2025](/blog/2025-12-30-stop-batching-analytics.md)

[Sylvain Utard](/blog/2025-12-30-stop-batching-analytics.md)

## [Stop Batching Analytics](/blog/2025-12-30-stop-batching-analytics.md)

[Analytics, Architecture, Performance](/blog/2025-12-30-stop-batching-analytics.md)

[Why we're forcing analytics through complex batch pipelines when append-only data should work like logs. The warehouse constraint that stopped making sense.](/blog/2025-12-30-stop-batching-analytics.md)

[READ ARTICLE](/blog/2025-12-30-stop-batching-analytics.md)

[![Semantic Layers in 2025](/assets/blog/2025-07-01-state-semantic-layers-2025.jpg)](/blog/2025-07-01-state-semantic-layers-2025.md)

[JULY 1ST, 2025](/blog/2025-07-01-state-semantic-layers-2025.md)

[Sylvain Utard](/blog/2025-07-01-state-semantic-layers-2025.md)

## [Semantic Layers in 2025](/blog/2025-07-01-state-semantic-layers-2025.md)

[Semantic Layer, Architecture, Analytics](/blog/2025-07-01-state-semantic-layers-2025.md)

[We tested four semantic layer approaches: Looker, Omni, Cube.dev, and dbt MetricFlow. Here's what we learned about each.](/blog/2025-07-01-state-semantic-layers-2025.md)

[READ ARTICLE](/blog/2025-07-01-state-semantic-layers-2025.md)

[![From Dashboards to Dialogue](/assets/blog/2025-06-24-from-dashboards-to-dialogue.jpg)](/blog/2025-06-24-from-dashboards-to-dialogue.md)

[JUNE 24TH, 2025](/blog/2025-06-24-from-dashboards-to-dialogue.md)

[Sylvain Utard](/blog/2025-06-24-from-dashboards-to-dialogue.md)

## [From Dashboards to Dialogue](/blog/2025-06-24-from-dashboards-to-dialogue.md)

[Altertable Agent, Product, Analytics](/blog/2025-06-24-from-dashboards-to-dialogue.md)

[Most dashboards are never opened twice. They clutter stacks, lag behind questions, and bury insight in clicks. We're replacing dashboard sprawl with AI agents.](/blog/2025-06-24-from-dashboards-to-dialogue.md)

[READ ARTICLE](/blog/2025-06-24-from-dashboards-to-dialogue.md)

## Interested in learning more about Altertable?

[Start free](/sign-up)

[Web version](https://altertable.ai/blog/tag/analytics)
