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)

Comparing multiple time series

The time series line chart is useful for visualizing the price trends for every type of commodity together. Using the first dataset that was uploaded, we will visualize prices of commodities over time on the x axis and see how they compare against each other, as follows:

Setting the parameters for the time series chart

Remember to clear the time thresholds in the Time section. Then, select feature as the Group by value, AVG(value) as Metrics, and render the graph:

The time series line chart for all values

The tooltip shows the y axis price values for each commodity type and the units used. We can notice that the highly priced commodities have mostly non-overlapping price ranges. The data extends from January 1980 to June 2018. After the expensive commodities, bananas and oranges have fairly overlapping price ranges. It will be easier to compare...