Host your own dashboard with Metabase

November 27, 2023
Napptive and Metabase

Data analytics platform on Napptive

Data is one of the most precious assets of the twenty-first century, driving innovation, informing decisions, and shaping the future of technology and business. But extracting value out of an organization’s data requires strategic analysis, advanced technologies, and a deep understanding of the underlying insights to make informed decisions and drive meaningful outcomes.

This is why, in this article, we are going to deploy Metabase, an open-source advanced low-code/no-code business analytics tool to Napptive, which can be easily utilized by everyone to make in-depth analyses on your organization’s data using its dashboards and make inferences to help make proper business decisions that facilitates your organization’s operations and growth.

Deploying Metabase to Napptive

As we’ve discussed in our previous articles on self-hosting applications, Napptive provides a simple, straightforward, yet highly scalable and collaborative deployment and application management solution that can be very beneficial to your organization.

Try the Playground, it’s free!

Napptive enables developer self-service. We encourage you to try our playground and experience accelerated cloud-native development. It’s completely free, all you need to do is simply sign up and get started!

Step 1 – Login to the Napptive Playground

Go to https://playground.napptive.dev and use any authentication methods to log in.

Step 2 – Select your environment

From the dropdown menu at the top left, select the appropriate environment where you want to deploy Metabase. Environments are associated with specific geographical zones, so choose the one that is closer to your final users for the best experience. Using your own zone also enhances security and control for your applications. For this example, we will deploy Metabase on the test environment, but any other environment will also work without any issues. 

Step 3 – Open the catalog to deploy Metabase

The Napptive Catalog provides a series of ready-to-deploy applications including databases, data-scientist tools, development tools, and many more. Open the catalog through the top left-hand side icon on the sidebar, or through the Deploy app button on the top right-hand side corner. If you are interested in learning more, check how you can upload your own applications to the Catalog. Next, search for Metabase and select it.

The next step will show you the application definition that will be deployed allowing you to customize it with your own preferences and requirements.

After necessary modifications, deploy the application and wait for the setup process to complete. 

Click on the URL in the endpoints section to open Metabase

Visit the URL generated and complete the initial setup to start using Metabase.

Adding a database to Metabase for analysis

Metabase provides a straightforward process to add a wide range of data sources for analysis purposes and creating dashboards. Let us add our test database (as added in the OAM definition) to use.

Method 1 – Adding during the setup process

During the setup process, we can add our application data for analysis.

Step 1 – Select the database type 

For our example, we are going with PostgreSQL.

Step 2 – Enter database credentials

For this demo, the example credentials can be found in the OAM definition during deployment in Napptive Playground.

Method 2 – Adding database through Admin settings

Go to Settings > Admin settings go to the Databases tab and select Add Database.

Add the necessary credentials of the database to connect to the database.

Creating Dashboards in Metabase

Dashboards are the primary features of Metabase that enable users to easily infer information from their own data. For the demo, we will use the Upload CSV feature to upload our own data to Metabase for analysis. We are going to use this dataset for this demonstration

Step 1 – Enable the Upload CSV feature. 

First, we have to enable the Upload CSV feature in Admin settings. For this, go to Settings > Admin Settings > Uploads tab.

Step 2 – Select your database and schema and default prefix and enable uploads

Step 3 – Select one collection and click on the upload button to select your CSV.

A Model will be created for your data.

We can see the data has been added and we can explore the data.

Step 4 – Creating a dashboard.

Go to New > Dashboard to create a new dashboard.

Step 5 – Click on Ask a New Question

Step 6 – Build the query as per requirement.

For this demo, we’ll be visualizing a pie chart of the sum of salary based on work location.

Hence, for this query, we are selecting the work location and salary in the USD column grouping them by work location, and calculating the aggregate sum of the salaries.

After building the query, click on visualize.

After successfully creating the required visualization, we can go ahead and save the question to our dashboard.

We can continue to add more relevant questions for metrics to be displayed on the dashboard.

Conclusion

In this article, we have covered the advantages of utilizing the self-hosting Metabase analytics tool on Napptive, to easily integrate existing organization stack and help the business to make effective decisions ahead.

We hope this article has illustrated the ease of deploying a self-hosted Metabase analytics tool completely for free and integrating it with your organization’s application stack to facilitate a smooth business development cycle for your organization’s products and services. We highly encourage you to explore our platform and experience the benefits that Napptive’s IDP provides to your organization.

More like this

The Evolution of Platform Engineering: Past, Present, and Future

The Evolution of Platform Engineering: Past, Present, and Future

In this post, we delve into the history of platform engineering, examining how it has evolved and what the future might hold. We will explore the transition from traditional IT infrastructure to modern platform engineering practices, and predict future trends and...

How to Quantify the ROI of Platform Engineering

How to Quantify the ROI of Platform Engineering

Measuring the Impact Platform Engineering is becoming the new “it” thing in software development, and it’s no wonder why. For starters, if we use an IDP (Internal Developer Platform) we can end up having fewer silos, better reusing components, and reaching an improved...