23 апреля 2026 г.

Metabase для аналитика

Карьерник — квиз-тренажёр в Telegram с 1500+ вопросами для собесов аналитика. SQL, Python, A/B, метрики. Бесплатно.

Зачем это знать

Metabase — самый популярный open-source BI в startup-мире. Простой setup (Docker), понятный UI, работает с большинством DB. Во многих российских startups и scale-ups — primary BI tool. На собесах спрашивают регулярно.

Что такое Metabase

Open-source BI platform:

  • Connect к БД
  • Questions (queries)
  • Dashboards
  • Models (SQL / semantic layer)
  • Alerts
  • Embedded

Free self-hosted или paid cloud.

Плюсы

  • Open-source. MIT license.
  • Easy setup. Docker one-liner.
  • Non-technical users могут build queries без SQL.
  • Growing community.

Минусы

  • Less polished vs Tableau / Power BI.
  • Complex visualizations ограничены.
  • Performance на huge data — медленнее enterprise tools.

Setup

docker run -d -p 3000:3000 --name metabase metabase/metabase

Открываете localhost:3000 → setup admin → connect DB.

Главные компоненты

Questions

Base unit. Query + visualization:

  • GUI builder (not SQL users)
  • Native SQL
  • Save как question

Dashboards

Collection of questions. Filters, tabs, text blocks.

Models

Reusable base datasets:

-- Model: active_users
SELECT id, email, last_active
FROM users
WHERE last_active > CURRENT_DATE - 30;

Other questions reference model.

Collections

Folder structure для организации.

SQL vs GUI

GUI

Pick table → add filters → group → aggregate. Без SQL.

Good для non-technical, bad для complex.

SQL

Native queries с variables:

SELECT * FROM orders
WHERE created_at > {{start_date}}
AND country = {{country}};

Variables — dashboard filters.

Дашборды

Building

  1. Create questions
  2. Add к dashboard
  3. Arrange, size
  4. Add filters (date, country, etc.)

Filters apply к all questions sharing variable.

Sharing

  • Public link
  • Internal users
  • Embed в другое приложение

Integration

DB support

Postgres, MySQL, ClickHouse, BigQuery, Snowflake, Redshift, SQL Server, SQLite, MongoDB, Druid и другие.

Authentication

  • Email / password
  • Google SSO
  • SAML / LDAP (enterprise)

Pricing

  • Open-source: free, self-hosted
  • Metabase Cloud: $85+/month
  • Enterprise: custom pricing

Для small/mid teams — open-source отлично.

Use cases

Startup MVP analytics

Setup за час, team видит daily metrics.

Internal reporting

Dashboards для teams, бизнес.

Self-service

Non-analysts строят свои queries.

Embedded

Dashboards в customer portal / admin.

Частые задачи

Daily active users

SELECT DATE(created_at) AS day, COUNT(DISTINCT user_id) AS dau
FROM events GROUP BY 1 ORDER BY 1;

Line chart.

Cohort retention

Complex — потребуется native SQL. Metabase Scala — ok.

Funnel

Через conditional aggregation:

SELECT
    COUNT(DISTINCT CASE WHEN step = 'signup' THEN user_id END) AS signups,
    COUNT(DISTINCT CASE WHEN step = 'activated' THEN user_id END) AS activated
FROM events;

Или funnel visualization type.

Revenue dashboard

Hero numbers + trend charts.

vs альтернативы

Metabase

  • Free
  • Easy setup
  • Non-technical friendly

Tableau

  • Better visualizations
  • Expensive
  • Steep learning curve

Power BI

  • Microsoft ecosystem
  • Good for pro users
  • Mid price

Looker

  • LookML semantic layer
  • Very expensive
  • Enterprise

Grafana

  • Monitoring focus
  • Infra metrics
  • Not business BI

Ограничения

Complex visualizations

Custom chart types limited. Для advanced — Superset или вложения.

Real-time

Not real-time. Cache refresh.

Security

Basic row-level security. Enterprise needs — might need Looker или custom.

Troubleshooting

Slow queries

  • Check DB index
  • Materialize base queries as models
  • Cache settings

Broken visualization

  • Column type (number vs string)
  • Null handling
  • Axis scaling

На собесе

«Metabase опыт?» Build dashboards, writing models, SQL variables.

«Metabase vs Tableau?» Metabase — cheaper, simpler. Tableau — richer, enterprise.

«Когда не использовать Metabase?» Complex visualizations, real-time, huge data scale.

Связанные темы

FAQ

Free version full-featured?

Open-source имеет core features. Enterprise — SSO, permissions granular.

Deployment complex?

Simple with Docker. Production — нужна managed DB, backups.

Data в Metabase?

No. Metabase только query layer. Data в вашей DB.

Тренируйте BI — откройте тренажёр с 1500+ вопросами для собесов.

Тренироваться в Telegram