
SQL window functions: the analytics queries that actually matter
Window functions calculate across related rows without collapsing them, which is how you write running totals, rankings, and period-over-period growth in SQL.
This page is available in Français.
This page is available in Español.
This page is available in Português (Brasil).

Window functions calculate across related rows without collapsing them, which is how you write running totals, rankings, and period-over-period growth in SQL.

An OKR dashboard shows each key result's baseline, target, current value, and pace against live data. Learn how to build one that updates itself, not by hand.

Send a live Basedash dashboard or chart to a client, investor, leader, or contractor with one link. They can open, filter, and sort it without a Basedash account.

How to build dashboards on SQL Server: connect a BI tool safely, avoid blocking your production database, and choose live queries vs a read replica or copy.
“We evaluated Omni and other BI tools, but the speed to insight with Basedash is unmatched.”
Greg Demoge
Co-founder & CPO · FullEnrich
Read case study →
“For a security-conscious company like ours, Basedash instantly clicked. Reports that took weeks are ready in hours.”
Claudio Godoy
AI Agents Lead · Taxfyle
Read case study →

Net revenue retention tracks recurring revenue kept and expanded from existing customers. Learn the NRR formula, how to calculate it in SQL, and benchmarks.

Most lean teams don't need a dedicated data catalog yet. Here's what one does, the signals that mean you actually need it, and a lightweight alternative.

Tasks is AI that reads your company's real data and turns it into a prioritized to-do list — specific, actionable work with a why-now, an expected outcome, and instructions. Ship a task, and Basedash tracks how your metrics move and learns. Now in research preview.

A SQL query builder lets you build database queries without hand-writing SQL. Compare visual, code, and AI query building, and learn when to use each.

DAU, WAU, and MAU count unique active users over 1, 7, and 30 days. Learn how to define active, calculate each in SQL, and read the stickiness ratio.

How to build dashboards on Databricks: connect a BI tool to a SQL warehouse, the cold-start trap that makes dashboards feel broken, and how to control cost.

Product managers don't need to master SQL. Learn the five query patterns that answer most product questions, plus when to reach for a BI tool or AI instead.

Use a spreadsheet for quick, small, one-off analysis. Move to a database when data is shared, large, or a source of truth. Here's how to tell and migrate.

Data engineers build pipelines, analysts answer business questions, scientists model and predict, business analysts translate needs. Here's who to hire when.

Subscribe to any dashboard or chart in Basedash and get a fresh snapshot delivered on a schedule — to your inbox or a Slack channel. Pick a cadence like every Monday at 9am, choose who receives it, and the report just shows up. Reports that come to you.

A data audit is a periodic review of what data and dashboards you have, who owns them, and whether they're accurate and actually used. Here's how to run one.

The license is usually 30-60% of what you pay for a BI tool. Here's the full total cost of ownership: implementation, warehouse compute, people, and add-ons.