TrustRadius: an HG Insights company

Metabase

Score7.8 out of 10

50 Reviews and Ratings

What is Metabase?

Metabase aims to bring data tools with the simplicity of consumer products to the crufty world of enterprise business intelligence. Their open source analytics and business intelligence applications connect to most commonly used databases to let anyone in a company ask questions, and create dashboards or nightly emails without knowing SQL. Metabase Enterprise enables the user to embed branded analytics into customer applications.

Top Performing Features

  • Location Analytics / Geographic Visualization

    Location analytics is the visualization of geographical or spatial data.

    Category average: 8

  • Role-Based Security Model

    Role-based access means that access to data is determined by job or position in the corporation.

    Category average: 8.4

  • Mobile Application

    A dedicated app for iOS and/or Android.

    Category average: 7.4

Areas for Improvement

  • Formatting capabilities

    Ability to format output e.g. conditional formatting, lines, headers, footers.

    Category average: 8.1

  • Themeable User Interface (UI)

    A themeable user interface means that a specific visual them can be applied to it

    Category average: 7.8

  • Report Formatting Templates

    Category average: 8.1

Metabase easy to use

Use Cases and Deployment Scope

Metabase is intuitive and easy to use. It connects with the different CRMs we are using at the company, helping us have the right visibility with our data. This data can be shared with the different teams in order for us to take the right actions and improve our business.

Pros

  • Accurate data automatically refreshed
  • Easy to build tables and connect different data points
  • easy to connect via API with different CRMs

Cons

  • The layout could be more modern
  • Would be great to have a drag and drop option to build dashboards

Return on Investment

  • Reduces significantly the wait time to get data results
  • Increase the data visibility as it is easy to share

Usability

Alternatives Considered

Tableau CRM

Next Level Open Source BI Tool.

Use Cases and Deployment Scope

Currently, we're using Metabase to pull reports from the database for our teams for day-to-day meetings and discussions. For us, it was taking a lot of time to pull these reports using Django, and the system was showing limitations. With Metabase, data fetching becomes relatively fast as it interacts with the database directly. Apart from this, the system was quite easy to integrate without the system using APIs and authentication provided by it. We're integrating to show data in a beatified manner now, like using graphs and figures.

Pros

  • We're currently using it to fetch reports for our products, such as daily sales, pipeline, visits, and attendance reports.
  • Data representation from database directly.

Cons

  • Currently, they don't provide page size, i.e., the number of records to be shown at a time in questions, and it isn't very easy. Some filters can implant this.
  • Just like above point there must be option for counting total pages by page size.
  • Query based filters must be provided.

Return on Investment

  • It is serving us whatever we're looking for, and we've recommended many organizations to implement it if they want better data analytics as it provides better functionality than we will build.
  • As a negative it gets difficult to get control over data to be fetch initially.

Usability

Other Software Used

Amazon Transcribe

Metabase: The perfect reporting solution

Use Cases and Deployment Scope

We use it for all of our internal reporting, across each department, and are the centralised data team for creating reports and managing data and access. Metabase is the perfect tool, as it is scalable, and the levels of granular permissions mean that it is easy to give access to the data colleagues need to do their jobs most effectively.

Pros

  • Visualisation
  • Simplicity
  • Permissions

Cons

  • Report Types
  • Updates
  • Colour/Branding

Return on Investment

  • Departmental Reporting - allows each department to measure and track KPIs
  • Visibility - everyone has access to the data they need and context on the rest of the business' goals
  • Churn - Helps to predict churn from our partners given their sales and forecasts

Alternatives Considered

Looker

Other Software Used

Notion, Google BigQuery, Todoist: To-Do List & Task Manager

Great BI and Data Tool

Pros

  • Store Data
  • Make Querying easy
  • Quickly ingest data from many sources

Cons

  • Natural language querying could be a little easier
  • easier to edit queries
  • easier joins

Return on Investment

  • We can make great reports for our customers quickly
  • We can store customer data dynamically
  • we can create customer specific metrics

Alternatives Considered

Microsoft Power BI, Python IDLE and Mode Analytics

Other Software Used

Carta (formerly eShares), Pilot.com, Airtable

Usability