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 MusingFundador e CEO da Basedash- Max MusingFundador e CEO da 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 MusingFundador e CEO da 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 MusingFundador e CEO da 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 MusingFundador e CEO da Basedash
“Avaliamos a Omni e outras ferramentas de BI, mas a velocidade até o insight com a Basedash é incomparável.”
Greg Demoge
Cofundador e CPO · FullEnrich
Ler o estudo de caso →
“Para uma empresa tão preocupada com segurança quanto a nossa, a Basedash conectou instantaneamente. Relatórios que levavam semanas ficam prontos em horas.”
Claudio Godoy
AI Agents Lead · Taxfyle
Ler o estudo de caso →
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 MusingFundador e CEO da 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 MusingFundador e CEO da 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 MusingFundador e CEO da 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 MusingFundador e CEO da 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 MusingFundador e CEO da 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 MusingFundador e CEO da 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 MusingFundador e CEO da 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 MusingFundador e CEO da 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 MusingFundador e CEO da 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 MusingFundador e CEO da 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 MusingFundador e CEO da 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 MusingFundador e CEO da Basedash
Podemos ajudar você a migrar dados e dashboards de qualquer outra ferramenta.