How do I install and launch metabase locally?

## Quick Start with Docker (Recommended) 1. Ensure Docker is installed and running. 2. Run: `docker run -d -p 3000:3000 --name metabase metabase/metabase` 3. Open http://localhost:3000 in your browser. ## Alternative: JAR File 1. Download `metabase.jar` from https://www.metabase.com/start/oss/jar 2. Create a directory, move JAR there. 3. Run: `java --add-opens java.base/java.nio=ALL-UNNAMED -jar metabase.jar` 4. Access http://localhost:3000. ## Setup Wizard - Follow prompts: Create admin account (email/password). - Add Sample Database (auto-included H2 DB with orders, products data). - Skip other DBs for now.

How do I explore data with the query builder?

1. Click **New > Question**. 2. Select Sample Database. 3. Pick a table (e.g., Orders). 4. Use **Summarize** to group by Created At (by month) and count. 5. Switch to **Visualize** > Line chart. 6. Save as 'Monthly Orders'. **Key Features:** - **Filter**: Add conditions like Quantity > 10. - **Browse data**: View table schemas, X-ray for auto-insights. - **Notebook editor**: Step-by-step query building.

How do I master visualizations and custom columns?

1. **New Question** on Orders table. 2. Join Products table on Product ID. 3. Summarize: Sum Quantity * Price as 'Revenue' (custom column). 4. Group by Category. 5. Visualize as Bar chart. **Advanced:** - Custom expressions: `[Quantity] * [Price]`. - Trends, comparisons (YoY). - Try pie charts, maps (if location data). Save multiple questions.

How do I build interactive dashboards?

1. **New > Dashboard**. 2. Add saved questions as cards. 3. Arrange layout, resize. 4. Add **Dashboard filter** (e.g., Date range, Category picker). 5. Connect filters to cards. 6. Add text card with Markdown. 7. Subscribe to PDF/email. **Tips:** Pin X-ray results, enable cross-filtering.

How do I model data and organize collections?

1. **New > Model** from Orders + Products join. 2. Add custom column 'Revenue', filter test data. 3. Set semantic types (e.g., Currency for Revenue). 4. Save model. 5. Create **Collection**, move dashboard/models there. 6. Set permissions (if multi-user). **Next:** Explore SQL editor, actions, embedding.

Learn Metabase: Query & Visualize Data in 5 Steps

🧰

Instant Toolkit

3 artifacts

📋
Step-by-Step Guide

1

Quick Start with Docker (Recommended)

Ensure Docker is installed and running.
Run: docker run -d -p 3000:3000 --name metabase metabase/metabase
Open http://localhost:3000 in your browser.

Alternative: JAR File

Download metabase.jar from https://www.metabase.com/start/oss/jar
Create a directory, move JAR there.
Run: java --add-opens java.base/java.nio=ALL-UNNAMED -jar metabase.jar
Access http://localhost:3000.

Setup Wizard

Follow prompts: Create admin account (email/password).
Add Sample Database (auto-included H2 DB with orders, products data).
Skip other DBs for now.

Why this step matters:

-Establishes a hands-on environment to experiment freely
-Enables immediate interaction with real data for practical learning

15-30 minutes

Docker, Web Browser, Java (for JAR)

$0

Definition of Done

•Metabase running at localhost:3000
•Admin account created
•Sample Database connected and browsable

Common Mistakes to Avoid

❌ Port 3000 already in use

→Use `-p 3001:3000` and access localhost:3001

❌ Java version incompatible

→Install latest LTS Java JRE

❌ Docker not running

→Start Docker Desktop or service

2

Following along, or just reading? 👀

Spin up a personalized “learn Metabase” plan you can save, check off, and return to anytime — unlimited on the free trial.

Start free trial →

3

4

5

🎥
Suggested Videos

Getting started with Metabase

How to create a dashboard

A tour of Metabase for beginners

📚
Learning Resources

📖 Online Courses

Metabase Data Visualization & BI Platform

beginner

Udemy

Metabase an Open-Source Business Intelligence Platform

beginner

Paid

Udemy

📖 Recommended Books

Metabase Up and Running

beginner

by Tim Abraham

🌐 Helpful Websites

Official Metabase Documentation

documentation

Full guides on installation, queries, dashboards

Metabase Learn

tutorials

Video tutorials and step-by-step guides

Metabase GitHub

repository

Source code, issues, and community

🛠️ Useful Tools

Metabase OSS

Business Intelligence

Open-source BI tool for queries and dashboards

Metabase Cloud

Business Intelligence

Hosted version with free trial

Learn Metabase: Query & Visualize Data in 5 Steps