That's why Superset introduces the concept of "indicators". When you draw a monthly statement of transactions, you don't draw each transaction on the graph, but instead represent the total daily transaction value as a bar on the graph. What we care about may be the total transaction amount in a period of time, or the average transaction. Although we store the transaction amount of each order in the data table, we do not care about a single transaction in business analysis. Are you a little confused? But remember, BI tools are usually used to do business analysis. An indicator is a certain statistical result of a field, such as the sum, average, maximum, minimum, etc. The definition of a table in Superset not only includes fields, but also needs to define metrics. Although I am not satisfied in many small places, in general, Superset has well met the company's current needs in data visualization and business reporting.Īfter you connect a database to Superset, you define each table you want to use. We migrated all Dashboards on Looker to Superset a year and a half ago, and the whole process went very smoothly. Before using Superset, we used Looker (a very good commercial BI tool, but it is too expensive). At present, most of the company's reports are on Superset, and there are 50 Dashboards, including nearly 900 charts. To be honest, I was also attracted to the pit by the two golden signs of Airbnb and Apache. Superset was originally open sourced by Airbnb's data team, and has now entered Apache Incubator, which is considered a star-level open source project. Let's take a look at the actual performance of these three open source projects in terms of functionality, ease of use, and documentation. Who doesn't want a product that's easy to use and well documented? In addition to meeting functional requirements, ease of use and documentation are also very important when judging a tool. In addition, I will pay attention to whether it has a REST API, and whether it can create and manage reports through the API, which we will talk about in a future article.
#Metabase vs looker free
From a data security perspective, I don't want every employee to have free access to all Dashboards, so each Dashboard needs to set a different access level. After having the chart, the next step is to format the relevant chart and generate the report page (Dashboard).
The types of charts we need are those that are commonly used, including line charts, column charts, pie charts, etc. Let's start with the functional requirements, our data warehouse uses Amazon Redshift (if you haven't heard of Redshift, think of it as PostgreSQL optimized for big data), so most of the practical use cases are to Visualization of the results of an SQL query. I just tried Metabase, but I think it is a very thoughtful project, so I will also share with you my thoughts on it.Ĭhoosing a tool that fits my needs in terms of functionality is definitely a priority. The first two I have actually used in production environments and will be highlighted in this article.
#Metabase vs looker software
So today, when open source software is so developed, what are the reliable solutions to choose from in terms of data visualization? Today I will introduce three well-known projects, namely Superset, Redash and Metabase.
#Metabase vs looker license
However, for many small companies, the license fee for these services is a lot of overhead, and there is a feeling of "killing a chicken with a knife". Data visualization is the core function of Business Intelligence (BI for short), and there are many mature commercial solutions, such as the old Tableau, Qilk, the new generation of Looker, the domestic FineBI and so on. If you often see a data analysis colleague, execute a query in the SQL client, copy/paste the result into Excel and make a chart, it means that your company lacks a reliable data visualization platform. To tell a story with data, charts are essential.
0 kommentar(er)
