Advanced Metabase features for data analysts
Set up alerts, annotate charts with events, model data, templatize SQL queries, customize click behavior, and more.
Get notified when results cross a goal line
You can set up an alert on a question so that Metabase will send you an email or Slack message when the question returns results that cross a goal line. You can also send the results to a webhook.
Share dashboard results via email and Slack
Set up a dashboard subscription to send the results of a dashboard via email or Slack. On Pro and Enterprise plans, you can filter results for different groups.
Make data easier to query with models
You can create models to clean up messy raw data and make it easier for people to ask questions.
Speed up loading times by caching results
You can store the results of questions so Metabase can return them much faster. Check out:
Customize what happens when people click on dashboard charts
Questions built with the query builder get the drill-through menu built into their charts. But you can change what happens when people click on dashboard cards. Customizing click behavior is especially useful for adding functionality to questions written in SQL. You can:
- Send people to a custom destination (like another dashboard, or to an external URL).
- Open up the drill-through menu.
- Update a value in a dashboard filter.
Check out Interactive dashboards.
Annotate charts with events and timelines
You can add events on time series. You can use events to mark dates where something happened: an email campaign or outage or office party that got out of hand. You can group events into timelines to keep related events together. Events are useful for explaining spikes in the data, so you don’t have to answer for the umpteenth time why sales went way up in April.
SQL templates
Insert variables into your SQL and Metabase will create a filter widget for you. Also: check out field filters that create “smart” filters, with dropdown lists or date ranges.
You can also save bits of SQL to reuse in other queries. Check out SQL snippets.
X-ray models, tables, charts, and more
Visit a model or table, hit a button, receive charts. You can save these auto-generated charts as a dashboard, or just use any of the charts as starting points to find the answers you’re looking for. Check out X-rays.
Index models so you can search for individual records
When you’re editing metadata for a column in a model, you’ll see a toggle called Surface individual records in search by matching against this column. If you flip this toggle on, people will be able to search in Metabase for those records. If, for example, the field contains a list of customer names, you can index that column so that people can just search for customer names in the Metabase search bar. You can also X-ray.
Check out the docs for indexing fields on a model.
Upload CSVs for ad hoc exploration
Instead of tinkering with a spreadsheet, upload a CSV to Metabase and query the data with the query builder, the SQL editor, or even X-ray it.
Export results and dashboards
You can download the results of a question as .json, .csv, .png, or .xlsx files, or export a dashboard as a PDF.
And a bunch of other stuff
Metabase is designed to be simple and intuitive, but it has a lot of depth. Consider spending way too much time reading our docs and Learn articles.
Next: Beyond BI: other problems you can solve with Metabase
Use Metabase as a database browser, or a publishing platform, or a lookup tool, or a quick business intelligence tool, or as just a way to field frequently asked questions.