How to analyze an A/B test with SQL
Analyze an A/B test with SQL: count users and conversions per variant, calculate lift, run a two-proportion z-test, and avoid the mistakes that fake wins.
Max MusingFondateur et CEO de Basedash- Max MusingFondateur et CEO de Basedash
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.
Max MusingFondateur et CEO de BasedashHow to build an OKR dashboard that tracks against live data
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.
Max MusingFondateur et CEO de Basedash
How to build dashboards on SQL Server data
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.
Max MusingFondateur et CEO de Basedash
“Nous avons évalué Omni et d'autres outils BI, mais la rapidité pour obtenir un insight avec Basedash est inégalée.”
Greg Demoge
Co-fondateur et CPO · FullEnrich
Lire l'étude de cas →
“Pour une entreprise aussi soucieuse de sécurité que la nôtre, Basedash a immédiatement fait tilt. Des rapports qui prenaient des semaines sont prêts en quelques heures.”
Claudio Godoy
AI Agents Lead · Taxfyle
Lire l'étude de cas →
How to calculate net revenue retention (NRR)
Net revenue retention tracks recurring revenue kept and expanded from existing customers. Learn the NRR formula, how to calculate it in SQL, and benchmarks.
Max MusingFondateur et CEO de Basedash
Do you need a data catalog? A practical guide for lean teams
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.
Max MusingFondateur et CEO de Basedash
SQL query builders: visual, code, and AI, and when to use each
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.
Max MusingFondateur et CEO de Basedash
DAU, WAU, and MAU: how to measure active users without fooling yourself
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.
Max MusingFondateur et CEO de Basedash
How to build dashboards on Databricks data
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.
Max MusingFondateur et CEO de BasedashSQL for product managers: the queries that actually matter
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.
Max MusingFondateur et CEO de Basedash
Spreadsheets vs databases: when to make the switch
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.
Max MusingFondateur et CEO de Basedash
Data analyst vs data scientist vs data engineer: which roles does your team actually need?
Data engineers build pipelines, analysts answer business questions, scientists model and predict, business analysts translate needs. Here's who to hire when.
Max MusingFondateur et CEO de Basedash
How to run a data audit: a practical checklist for lean teams
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.
Max MusingFondateur et CEO de Basedash
What a BI tool actually costs: a total cost of ownership breakdown
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.
Max MusingFondateur et CEO de Basedash
The SQL style guide: conventions that keep team queries readable
A SQL style guide is the naming, formatting, and structure rules a team agrees on so shared queries stay readable. Here's what to standardize, and why.
Max MusingFondateur et CEO de Basedash
Data validation: what to check and where to enforce it
Data validation checks that data follows your rules before you trust it. Here are the rule types, where to enforce each one, and how to catch bad data early.
Max MusingFondateur et CEO de Basedash
Nous pouvons vous aider à migrer vos données et tableaux de bord depuis n'importe quel outil.