Apache Superset for Data Engineers (Hands On)

Apache Superset is a modern data exploration and visualization platform. Apache Superset is a modern, enterprise-ready business intelligence web application. It is fast, lightweight, intuitive, and loaded with options that make it easy for users of all skill sets to explore and visualize their data, from simple pie charts to highly detailed geospatial charts.

One of the most valuable technology skills is the ability to analyze huge data sets, and this course is specifically designed to bring you up to speed on one of the best technologies for this task, Apache Superset! The top technology companies like Google, Facebook, Netflix, Airbnb, Amazon, NASA, and more are all using Apache Superset!

Introduction

• Apache Superset

• Apache Superset Architecture

Installation

• Ubuntu (Linux)

Connecting to Database

• Install Database Drivers

• Database Connection String

• Access Database table in Apache Superset (MySQL)

• Enabling Upload a CSV

• Obtaining & loading data

• Table Visualization

Creating Chart and Dashboard

• Line Chart

• Bar Chart

• Area Chart

• Time Series Bar Chart

• Pie Chart

• And many more charts

Frequently asked Questions

• FAQS for Apache Superset

Superset provides:

• An intuitive interface for visualizing datasets and crafting interactive dashboards

• A wide array of beautiful visualizations to showcase your data

• Code-free visualization builder to extract and present datasets

• A world-class SQL IDE for preparing data for visualization, including a rich metadata browser

• A lightweight semantic layer which empowers data analysts to quickly define custom dimensions and metrics

• Out-of-the-box support for most SQL-speaking databases

• Seamless, in-memory asynchronous caching and queries

• An extensible security model that allows configuration of very intricate rules on who can access which product features and datasets.

• Integration with major authentication backends (database, OpenID, LDAP, OAuth, REMOTE_USER, etc)

• The ability to add custom visualization plugins

• An API for programmatic customization

• A cloud-native architecture designed from the ground up for scale