Data Engineering Articles
Pipelines, warehouses, and the plumbing that makes data trustworthy. dbt, Snowflake, BigQuery, ELT patterns, and how to scale infra without runaway costs.
![[REVIEW] Looker Studio vs Power BI 2026](https://valiotti.com/wp-content/uploads/2026/06/looker-studio-vs-power-bi-2026-hero-768x512.png)
Looker Studio vs Power BI: the short answer Pick Looker Studio if your stack is Google, GA4, Google Ads, BigQuery,…
Airbyte vs Fivetran: the short answer Pick Fivetran for managed reliability when engineering capacity is the constraint and the budget…
ClickHouse vs Snowflake: the short answer Pick ClickHouse for real-time analytics on event data above roughly 1 TB per day,…
A practical 2026 roadmap for mid-level data engineers in the US: the skills that still matter, the ones AI made…
This is a walk-through of one consulting engagement, not a theoretical piece on AI tooling. The brief was small enough…
I spent three years writing about Redash. The first post in late 2018 framed it as on-demand analytics with a…
When we adapted Slava Shestopalov’s “10 rules for better dashboard design” in late 2020, the list felt close to definitive.…
The 2026 head-to-head moved past features. Pricing, real concurrency, and operational fit decide it. List prices, TCO scenarios, the Fivetran…
Five engineers on Max plans, two months of receipts, and three rollouts (Fivetran, Metabase, MetaLens) with concrete time and cost…
How to set up dbt Labs' official MCP server with Claude Code, including a real legacy-project audit story, the read-only…
The marketing director walks into a planning meeting on Monday with a proposed packaging change for the company’s flagship product.…
How to set up Fivetran's official MCP server with Claude Code, with a real client case study (HelpScout to BigQuery),…
Practical guide to wiring Google's MCP Toolbox for Databases into Claude Code for BigQuery work. Setup commands, the .mcp.json block,…
Practical guide to running OpenClaw for a data team. Self-hosted on a Hostinger VPS, ChatGPT OAuth for primary inference, Moonshot…
A practical walkthrough of using Metabase MCP with Claude Code on real client projects: dashboard audits in seconds, SQL from…
A consumer manufacturer’s marketing director wakes up one Tuesday with a one-point margin lift opportunity. The category data says it.…
Two analysts can look at the same dataset and report numbers that are 2x apart, both correct. The arithmetic mean…
Every consumer business with a planning function has a forecast that runs eleven months a year and breaks the twelfth.…