This feature is handy for quick ad hoc analysis of spreadsheet data. You can upload CSVs to query and visualize in Metabase. You can also refer to models in SQL queries, just like we did above with saved questions. If you find that you’re using the same saved question over and over as your starting data for new questions, you may want to convert that saved question to a model, which will let you add metadata like column descriptions and column types. For example, you could build a model for “Active users”, or “Priority orders”, or however you want to model your business. You can use them to pull together data from multiple tables, with custom, calculated columns, and column descriptions and other metadata, to create great starting data for people to ask new questions. Models are built with questions from either the query builder or the SQL editor. WITH gizmo_orders AS # Create models to use as starting data for new questions For example, to reference question 123 like so: Like query builder questions, you can use the results of models or saved questions as starting points for new questions, just as you would a table or view. For questions written in SQL, you can use variables in your code to create SQL templates, including field filter variables that can create smart dropdown filters. Use the native query editor to compose questions in the database’s native query languages (typically SQL for relational databases, but also other query languages for data sources like MongoDB and Google Analytics). Questions asked with the query builder can start with a model, a raw table, or with the results of a saved question, and you can convert them to native SQL at any time. Query builder questions automatically get a drill-through menu applied to their visualizations, allowing people to click on a table or chart to drill through the data. Plus, people who don’t know SQL can duplicate your question and use it as a starting point for another question. With custom expressions, you can accomplish pretty much anything you’d be able to do with SQL: join tables, create custom columns, filter and group results, compare time series, and more. Use the Notebook editor to ask more sophisticated questions. You can use Metabase’s query builder to filter and summarize data. And once you’ve connected your data sources, Metabase gives you a lot of tools to explore them. Metabase supports a lot of different databases, and ships with a Sample Database for you to play around with. Metabase also makes it easy to share questions and dashboards with the rest of your team.Īt a high level, we’ll walk through the features that let you: You can save your questions, and group questions into handsome dashboards. Metabase lets you ask questions about your data, and displays answers in formats that make sense, whether that’s a bar chart or a detailed table. Metabase is an open-source business intelligence tool that you can connect to many popular databases. Metabase has a lot of tools in its toolkit (and we can’t cover everything here), but even seasoned Metabasers will benefit from a tour of its feature set - especially since we add major new features at a regular clip.īut first, what is Metabase? What is Metabase? This is the “what comes in the box when you install Metabase” article.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |