introduce

This tutorial is based less on the official user tutorial record in Superset version 0.37.

This is a series

  • Use Docker to explore Superset BI data visualization platform and Docker Compose to build a local secondary development environment

Explore the data using Apache Superset

In this tutorial, we will introduce key concepts in Apache Superset by examining a real data set that contains a flight of employees of a UK organization in 2011. Information for each flight is as follows:

  • Passenger department. In this tutorial, departments have been renamed “Orange,” “Yellow,” and “Purple.”
  • The cost of airfare.
  • Tourist class (economy, Premium Economy, business and first class).
  • Is the ticket one-way or round trip?
  • Date of travel.
  • Information about the place of origin and destination.
  • The distance between the starting point and the finishing point, measured in kilometers (km).

The CSV upload function was enabled

Edit examples database records in Databases list:

Select Allow Csv Upload

Then, click the save button at the bottom.

Get and load the data

Tutorial_flights.csv data download

Enter the following values here:

  • The Table Name:tutorial_flights
  • The CSV File:tutorial_flights.csv
  • The Database:examples
  • The Parse Dates:Travel Date

Finally click the save button at the bottom.

Table visualization

Displays the number of flights and cost per travel class.

Create a Chart

Select the data source tutorial_flights

Select the visual type as Table

Click CREATE NEW CHART

Fill in the following fields in turn:

  • The Time Range:No filter
  • Grouping:Travel Class
  • Indicators:COUNT(*) SUM(Cost)

Then, click the RUN button at the top:

Click the SAVE button:

Save the chart and enter the following values:

  • Save as:Tutorial Table
  • Add to new Kanban board:Tutorial Dashboard

Click Save and go to kanban

Kanban basis

You can also edit kanban

Pivot Table

You will create a table showing monthly airfare expenses for the first six months, by department and by class of travel.

  • Data sources:tutorial_flights
  • Chart type:Pivot table
  • Time field:Travel Date
  • Time granularity:month
  • The Time Range:2011-01-01.2011-06-30
  • Indicators:SUM(Cost)
  • Grouping:Time
  • Column:Department.Travel Class

Save the diagram

The Line Chart (Chart) shows that

We will create a line chart to see the average airfare calculated on a monthly basis across the data set.

  • Data sources:tutorial_flights
  • Chart type:Line Chart
  • Time field:Travel Date
  • Time granularity:month
  • The Time Range:No filter
  • Indicators:AVG(Cost)
  • Grouping:Ticket Single or Return

Save the diagram

Markup

This component allows you to write Markdown text.

Markdown Cheatsheet

The editor

Filter box

We’re going to create a filter that allows us to see which flights are departing from certain countries.

Save the diagram

Release panel

Reference & Thanks

  • The official documentation

To be continued…

🏆 technology project phase iii | data visualization of those things…