Book Image

Apache Superset Quick Start Guide

By : Shashank Shekhar
Book Image

Apache Superset Quick Start Guide

By: Shashank Shekhar

Overview of this book

Apache Superset is a modern, open source, enterprise-ready business intelligence (BI) web application. With the help of this book, you will see how Superset integrates with popular databases like Postgres, Google BigQuery, Snowflake, and MySQL. You will learn to create real time data visualizations and dashboards on modern web browsers for your organization using Superset. First, we look at the fundamentals of Superset, and then get it up and running. You'll go through the requisite installation, configuration, and deployment. Then, we will discuss different columnar data types, analytics, and the visualizations available. You'll also see the security tools available to the administrator to keep your data safe. You will learn how to visualize relationships as graphs instead of coordinates on plain orthogonal axes. This will help you when you upload your own entity relationship dataset and analyze the dataset in new, different ways. You will also see how to analyze geographical regions by working with location data. Finally, we cover a set of tutorials on dashboard designs frequently used by analysts, business intelligence professionals, and developers.
Table of Contents (10 chapters)

Directed force networks

By using a directed force network, we can analyze the value of the imports nations exchange with each other. The time granularity of this dataset is in years. The time filter box available in Superset is easy to interpret and use for time columns that are more granular than yearly. Just select the clear option on it; we will not use it:

The time filter box

In the Query box, select the exporter column as the Source and importer column as the Target. The Metric function we choose will be irrelevant. Because this is time series data we are dealing with, we will inspect the trade flow between the nation entities for a specific year only. Therefore, there will be only one record for each exporter, importer directed relationship. You can use AVG or any other Metric function; the result will be the same:

Setting parameters for trade imports that spiked after...