Metabase

September 19, 2024 | service

#

tags

, ,

Metabase is the BI tool with the friendly UX and integrated tooling to let your company explore data on their own.

URL github

Highlights #

Used 50k companies
Self service analytic possible
Uses #

Installing service using #

ref

Linking it to domain #

You can run ./https.sh from the root directory and follow the guided setup in order to link a domain and provide an HTTPS certificate.

Steps #

in the domain setting configure a subdomain to point to the droplet IP
`./https.sh` you will be asked to enter the domain and https redirect settings, after the tests are successfully completed, the metabase application will be accessible at https://test-bi.azmx.sa
https.sh can be used else where to setup https domain
- os: Ubuntu, - dependencies: certbot (package that create and renews ssl certificate)

#!/bin/bash

echo "Metabase setup requires a domain name. If you do not have one yet, you may"
echo "cancel this setup, press Ctrl+C. This script will run again on your next login"
echo "--------------------------------------------------"
echo "Enter the domain name for your new Metabase site."
echo "(ex. metabase.analogpond.com) do not include www or http/s"
echo "Before doing this, be sure that you have pointed your domain or subdomain to this server's IP address."
echo "--------------------------------------------------"

a=0
while [ $a -eq 0 ]
do
 read -p "Domain/Subdomain name: " dom
 if [ -z "$dom" ]
 then
  a=0
  echo "Please provide a valid domain or subdomain name to continue to press Ctrl+C to cancel"
 else
  a=1
fi
done

export dom=$dom

echo "server
    server_name $dom www.$dom;

    access_log /var/log/nginx/shiny.access.log;
    error_log /var/log/nginx/shiny.error.log;

    location /
      proxy_pass http://localhost:3000;
      proxy_read_timeout 20d;

" | tee /root/metabase.nginx.backup

envsubst < /root/metabase.nginx.backup | tee /etc/nginx/sites-available/metabase
ln -s /etc/nginx/sites-available/metabase /etc/nginx/sites-enabled/metabase
rm /etc/nginx/sites-enabled/default
rm /root/metabase.nginx.backup

nginx -t
systemctl reload nginx

certbot --nginx -d $dom
echo "Metabase has been enabled at https://$dom  Please open this URL in a browser to complete the setup of your site."

Connecting to API source of data #

Why it is good idea to do ETL and save the data in Database for creating reports with Metabase

Details #

I’ve done quite a lot of work with REST API data sources using PowerBI. I’ve also done similar work in Metabase by loading the data into SQL Server, then creating views for Metabase.

As attractive as the notion of a REST API data source is, it only works for non-trivial datasources if there is some form of transformation layer. PowerBI has this as part of it’s data load, Metabase doesn’t. If you want to use REST API with Metabase (a good idea), the only practical way is to use some form of ETL tool. I use CURL to extract the json data, then load into MS SQL tables using stored procedures. It’s a bit of a pain to initially setup, but can then easily be done on an automated schedule. ref

Metabase fundamentals #

Questions #

ref

A question is a
- query,
- its results, and
- its visualization.
If you’re trying to figure something out about your data in Metabase, you’re probably either asking a question or viewing a question that someone else on your team created.
In everyday usage, question is pretty much synonymous with query.

What can be done with questions? #

questions can be asked using query builder or by native query editor, sql.
questions can be saved to collections
questions can be added to dashboard as card
email or slack alert on questions
share the results of questions with team
convert saved question to model
questions can be accessed through API as well

Caching system #

ref Allows caching the queries locally, in Metabase, to avoid hitting the database frequently or to improve the performance of the query results.

fine grained question specific caching is possible with Enterprise pro version.

Supported #

ref

License cost #

https://www.metabase.com/pricing/

OCR of Images #

2023-06-16_09-23-00_screenshot.png #

Droplet IP A test-bi.azmx.sa directs to 147182.241.227 3600 More V

2024-06-05_23-02-34_screenshot.png #

Amazon Redshift BigQuery Druid Google Analytics Your H2 MongoDB Hi,J. MySQL PostgreSQL Presto Snowflake Spark SQL e username and password.Ifyou don't ample dataset you can get started SQLServer SQLite

2024-09-19_10-13-27_screenshot.png #

There'sa Metabase for everyone. Choose how you're planning to use Metabase 2 Internal analytics Customer-facing analytics Open Source Everything you need to self-host your own instance of Metabase. Free Starter Pro Enterprise Extra help with procurement and access to professional services. Custom pricing Starts at $15k/year A fully-supported and managed cloud- Extra features helpful for managing hosted instance of Metabase. $85 month + $5 month per user First 5u users included lots of users and compliance. $500 month + $10 month per user First 10usersi included Get installation instructions Community support forum Self-hosted deployment Start free trial Da 3-day email support Cloud deployment Start free trial 3-day email support Cloud or self-hosted deployment Talk to: sales Priority support Cloud or self-hosted deployment Choose because your team needs easy-to- The core Internal Analytics experience ready to deploy on your servers. Unlimited queries, charts, and dashboards Also includes Static Embedding with the "Powered by Metabase" badge. Use of any official, partner, or community data source connectors Choose because you want everythingin Open Source plus: The core Internal Analytics experience deployed on ai fast, reliable, and secure cloud Automatic upgrades, patches, backups, andi monitoring all done for you Unlimited queries, charts, and dashboards Custom domains hosted iny your region Also includes Static Embedding with the "Powered by Metabase" badge. Full support from our team of experts for any of our 20+ official and partner data source connectors Choose because you want everything in Starter plus: Single-sign and user-group permissions mapping via SAML, LDAP or JWT Granular row- and column-level permissions vial Data Sandboxing Granular results caching controls for faster, more responsive dashboards Create separate staging and production environments with content and configuration version control via Serialization Understand how your instance is being used via Metabase. Analytics Customize the appearance of your instance, including custom colors and fonts Also includes Interactive Embedding and Static Embedding, without the Choose because you want everything in Pro We'll work with your procurement teami tol help you get Metabase A dedicated named success engineer with: 1-day email SLA Includes custom user pricing,helpful for scaled Interactive Embedding Optional access to additional Professional Services use BI: plus: