1.Overview

Superset is an open-source modern data exploration and visualization platform.

Link: https://insight.galaxyedu.io/superset/welcome/

2. How to build dashboard

Step 1: Query to get data → Save dataset

  1. Choose database, schema
  2. Write code SQL to get data
  3. Run to check your result
  4. Click button beside "Save"
  5. Save dataset
  6. Save as new or Overwrite existing

Step 2: Create dashboard

Step 3: Create new chart

  1. Choose a dataset (step 1)
  2. Choose chart type
  3. Click button Create New chart
  4. Add the name of chart, select time range, metrics, filters,...
  5. Save

Step 4: Edit dashboard

  1. Click button Edit dashboard
  2. Drag and drop to edit chart size and position
  3. Discard or Save your chart.

Step 5: Share

Share the dashboard by generating a public or private URL, or embed it in other web applications.

3. Dashboard

3.1. View

3.1.1. Choose dashboard

3.1.2. Filter


3.1.3. View query

3.1.4. Download data from chart

3.2. Edit

3.3. Create

4. Chart

4.1. View

4.1.1. Choose chart

4.1.2. Filter

Note: Please do not save if you only want to view the chart.

4.2. Create

5. Query




Database

Schema

Description

CORE

icanid

merchant, users

icanpayment

bank transfer, billing, transaction

subscription

Product plan

ICAN Kid

icankid

Link

Report

user_report

cash in, paid user 4 BUs