1. Metabase Dashboard Examples List
2. Metabase Dashboard Examples For Small Business
3. Metabase Free
4. Metabase Dashboard Examples Pdf
5. Metabase Dashboard Examples For Research

When I joined Reforge a year ago, I found that we were querying our databases manually to do routine analysis. If we wanted to update the team on the number of people who had applied or paid for our programs, we’d run a query against the database and then put the results in a spreadsheet. If we wanted a list of users from our programs by company, we’d run a query and put it in a spreadsheet. While this answered our questions at the time, I felt like we could do a lot better. After having used Looker in my time at HubSpot, I wanted a lightweight solution to help us enable the entire company to have access to critical data about the business and make data-informed decisions. We started using metabase.

Give your new dashboard a name and a description, choose which collection the dashboard should go in, then click Create, and Metabase will take you to your shiny new dashboard. If you don’t want to build a dashboard from scratch, or want to experiment by making changes to an existing dashboard without affecting the original, you can duplicate. You'll want to add this option to the Metabase URL specified in your embedding iframe. For example, if you have a parameter called 'ID,' in this example the ID filter widget would be hidden: /dashboard/42#hideparameters=id If you want, you can also simultaneously assign a parameter a value and hide the widget like this. About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy & Safety How YouTube works Test new features Press Copyright Contact us Creators.

Metabase has been a huge help for me in democratizing access to our data. Metabase connects directly to any databases you want, and it allows anyone in the company (I have chosen not to set up advanced permissions yet) to manually inspect data, do advanced reporting, or view dashboards.

This is an example of what it looks like when someone looks at our program applications table (simple database table that keeps track of applications to our growth programs):

1. My Udemy Course: Build a Full-Stack Chrome Extension with NodeJS and MongoDB: https://www.udemy.com/course/build-a-full-stack-chrome-extension-with-nodejs-an.
2. V0.38.4 / Users Guide / Interactive Dashboards Interactive dashboards. You can customize what happens when people click on questions in your dashboard. By default, when you create charts using Metabase’s graphical query builder, your charts automatically come with drill-through capabilities, which let folks click on a chart to explore further.But if you have a more customized click path in.

Benefits:

• Team members can look at the table as if it were a spreadsheet
• They can apply filters as if it was a spreadsheet
• They can visualize the results more easily than in a spreadsheet

I routinely build reports in metabase that filter to people with a certain condition and send it to teammates. It’s so easy to report on people who work at company X that are in participating in one of our programs. Much better to generate a simple report and then share it with a colleague knowing that it should always be up to date, even if our underlying data is updated.

You can also easily switch between a table view, and many other ways to visualize the data (table, line chart, area chart, bar chart, row chart, scatter chart, pie chart, and a map):

Once you’ve filtered your data set and chosen how to visualize it, it’s easy to then add it to a dashboard of other reports. It’s really nice that you can combine data from multiple databases into the same dashboard, and drag and drop the charts in any configuration you want. This is a dashboard that I setup to monitor the performance of applications submitted to our recent cohort of programs, as well as how people were paying for their spot. It has a segmentation of which programs they’re applying to, how much revenue we’re generated, how we’re comparing to previous periods, and where people are submitting applications from:

There are a ton of other features that I am a huge fan of. Some of them:

• Posting questions to slack at a regular interval:

Or via email:

It has been a huge help for me personally, and this doesn’t even cover all of the ways in which we use it. Best of all, it’s free and open source. We pay to host it ourselves via Amazon Elastic Beanstalk.

This kind of solution comes in incredibly handy in our overall data pipeline, especially when we can point it to a copy of our production database and our analytics data warehouse that is populated by Segment.

Why use Metabase for blockchain analytics?

Here at Anyblock Analytics, we choose Metabase as our primary blockchain visualization tool because it enables business users to answer their questions themselves, rather to wait for precious developer time. This is possible because of the simple Metabase point and click editor so that no SQL query language needs to be used (but it can).

The other great feature is the ease of sharing Metabase blockchain dashboards publicly or with the respective shareholders. The link to do so is generated with two clicks and the graphs can just as easily be embedded into websites or users’ internal applications.

What is Metabase in general?

“Metabase is an open source business intelligence tool. It lets you ask questions about your data, and displays answers in formats that make sense, whether that’s a bar graph or a detailed table.
Your questions can be saved for later, making it easy to come back to them, or you can group questions into great looking dashboards. Metabase also makes it easy to share questions and dashboards with the rest of your team.”

Source: Metabase Website

How to create a Metabase blockchain dashboard?

1. Start: Ask a question

Metabase Dashboard Examples List

2. Choose the way of asking your question

• Simple question is meant for simple requests of data (generally not really helpful with our blockchain data model)
• Customized questions are recommended if you want to easily filter and summarize your data (recommended for beginners / business users)
• Native Queries has to be written in SQL which requires at least basic knowledge in that language (recommended for advanced users / developers

3. Pick your “starting data” (meaning to choose our supported blockchain as the source, see our list of networks on our Network Status Page)

Hint: It is also possible to pick previous questions as data for your next question (Find them here: “Saved questions”)

4. Now you can start to filter, summarize and sort your data (the following screenshot shows the editor for customized question)

5. After you’ve picked your data, you are now able to visualize the results

6. Configure your visualization in different formats

Example: Blockchain analytics to create Metabase dashboard for The Energy Origin – TEO

At the beginning it is essential to be aware of

• what are the objectives of your dashboard,
• what you will require to build your dashboard,
• and how you will achieve these objectives.

The goal of the TEO dashboard was to provide a visualization of the events happening on the TEO smart contract and to analyze them as detailed as possible without knowing the source code or any documentation. General information about the project is available on the website of The Energy Origin – TEO.

The first step is to determine the blockchain on which the project runs. TEO uses the Energy Web Chain (EWC) of the Energy Web Foundation. The EWC is one of over 22 different blockchain in the Anyblock Index, which contains many public blockchains but is also available for enterprise consortia blockchains such as this one.

After the address of TEO had been identified, it is necessary to find out if the ABI for this address is available, as this represents the only way to be able to see what is happening. The Anyblock Index uses the contract’s ABI to translate the hexadecimal raw blockchain data into human-readable event names and formats numbers with the right decimal format.

Once the two requirements, address and ABI, are in place, all events taking place on TEO can now be analyzed and visualized.

This custom question leads to the following diagram by visualizing the outcoming data.

After this time-series chart of all events is done, two fundamental questions immediately come to mind: What do these events represent and who are the addresses which are executing these events?

To answer this question, the next challenge is: How can the individual events be analyzed? This required decrypting the individual certificates of the events, which was only possible as a SQL question, as the parameters are saved in an array in our SQL blockchain data model:

Using this query, it was now possible to filter the number of unique addresses per event via Metabase. For example, it was possible to identify the unique addresses that send out events on TEO.

Metabase Dashboard Examples For Small Business

Finally, all events are shown in a time-series stacked line chart, and also the unique addresses behind the different events are displayed on the dashboard. The viewer is therefore provided with aggregated information about the entire timespan of the smart contract activity, and an additional table about the latest events on TEO provides real-time monitoring capabilities.

Our dashboards can just as easily include the possibility to drill-down on the data with filters.

This enables for example to limit the data shown in the dashboard to a certain interval of dates, show the activities of individual user addresses or check the status of certain transactions. You can find some examples for our interactive dashboards on our website.

Metabase Free

We hope you found this little tutorial on blockchain data science with Metabase useful.

If you have any questions about blockchain analytics and data science in general, want to exchange some tricks working with Metabase or would like insights into a particular smart contract – we’d love to hear from you!

Looking to create an Anyblock account? Takes seconds and it's free!

>> You can also browse related posts below or go back to all posts.

Interested or questions?

Freddy Zwanzger
(Co-Founder & Chief Data Officer)
freddy@anyblockanalytics.com
+49 6131 3272372

Metabase Dashboard Examples Pdf

Related Posts

Metabase Dashboard Examples For Research

• Query Ethereum with SQL

  You can now easily query the Ethereum blockchain using our Anyblock SQL database. Down to the smart contract event level, already enriched and decoded into human-readable text, and updated in real-time with the latest blocks from the Ethereum Mainnet and 22+ other blockchain networks.

• Why reading data from the Ethereum blockchain is hard and how to speed it up

  What is the content of a blockchain and how are smart contract interactions in particular stored on Ethereum? Learn which factors make reading data from the blockchain difficult and how an ETL process gets it into a database for faster querying.

• How to Integrate Blockchain Analytics into Your Business Intelligence Tools

  Join us as we explore the importance of business intelligence (BI) and how Blockchain analytics can deliver better insights and drive more powerful decisions. While Blockchain data may sound difficult to work with, our innovative technology makes it possible to bridge the gap between business and Blockchain data. With our help, using Blockchain data in enterprises is just as easy and straightforward as any other type of data.