With Metabase
Metabase is an open-source business intelligence tool where you can build graphs and dashboards of your data.
As Metabase puts it:
Business intelligence for everyone Team doesnโt speak SQL? No problem. Metabase is the easy, open-source way to help everyone in your company work with data like an analyst.
Setup
Ensure you have the details of your Hydra instance handy.
Sign up for Metabase.
Seed some sample data
Letโs start by creating a sample table in Hydra and populate it with some data. You'll need to replace your Hydra connection string or set the PGCONN
environment variable.
Create a sample table and seed some data.
Weโve created a table named sample_data
with 50,000 random samples spread out over the last month.
Metabase first launch
Now we can configure Metabase to access our sample data in the Hydra.
Head over to Metabase and log in.
Add your Hydra instance as outlined in the below screenshot.
Once youโve landed at the Metabase dashboard you should see some options to view insights after a few seconds. Take some time to explore Metabase, for example โa glance at Dataโ
Metabase: Queries, Questions and Dashboards
Now letโs combine the features of Metabase and Hydra to explore our sample data.
Queries
You can use Metabase to run ad hoc queries against Hydra. You can access it via New โ SQL query.
For example we can run some summary statistics against our sample data using:
Questions
Metabase allows you to use questions to get answers from your data. Letโs create some questions now, that weโll later turn into a dashboard. You can create questions via New โ Question.
Letโs create four questions:
Number of samples over the last 7 days
Average values of samples over the last 7 days
Average value of samples per day over the last 30 days
Distribution of Samples over the last 30 days
Dashboards
Now letโs combine those questions into a dashboard to give our users at a glance access to these metrics.
Create a new dashboard via New โ Dashboard
Add the four questions created above to the dashboard
Cleanup
Once youโre done exploring Metabase and Hydra you can cleanup the sample data be droping the sample_data
table.
Last updated