Aggregate the most relevant bits of your data, tidy it up, and structure it for a simpler, safer jumping-off point for end-users to get answers than the Wild West of databases, tables, and schemas.
Give more context and signpost your data with more intuitive column names and descriptions to make it easier for end-users to interpret, and put together queries.
Put models in the most obvious spot for people to find and use. Models get the VIP treatment by showing up higher in search results, and live in collections, or dashboards.
Cache the results of models to keep things moving smoothly for your teammates.
Keep track of how your model evolves to make sure it’s still accurate and relevant. View changes, revert to a previous version, and archive outdated versions.
See how your data is being used with a list of items using each model, fields in the model schema, and actions using the model.
In the upper right, click New > Model.
Choose either the query builder or a native query (if you want to use SQL). The advantage of using the query builder is that Metabase will be able to fill out some of the metadata for you; if you use SQL, you’ll have to fill out that metadata manually.
Select the data you want to include.
Tweak the metadata to make the model easier to use. Give columns clearer names, edit field names, and add descriptions.
Create and save your query.
Add your model to a collection or somewhere visible to your team and let them know it’s ready to use.
OR, create a model from a saved question by clicking the … menu and selecting Turn into a model.