Preview Apache Superset for Data Engineers (Hands On)

Introduction

Introduction to Course

What is Apache Superset?

Business Intelligence

Apache Superset Architecture

Installation and Configuration

Installation Discussion

Installing Apache Superset on Ubuntu 20.04 (Linux)

(Hands On) Step by Step Installing Apache Superset on Ubuntu 20.04

Installing Superset Locally Using Docker Compose

Upgrading Superset (Optional)

(Hands On) Steps to Start and Stop Apache Superset on Ubuntu 20.04

Commands to Start and Stop Apache Superset

(Optional) How to run Apache Superset on Windows using Virtual Machine

Connecting to Databases

Databases supported by Apache Superset

Install Database Drivers

(Hands On) Connection to MySQL and view Data in Apache Superset Part 1

(Hands On) Connection to MySQL and view Data in Apache Superset Part 2

Commands for Connecting to MySQL from Apache Superset

Uploading CSV file Data into Apache Superset

Sample CSV file for MySQL (addresses.csv)

Visualizing Uploaded CSV file in Apache Superset

(Hands On) Connection to Apache Drill and view Data in Apache Superset

Download Resources for Apache Drill

(Hands On) Connection to HIVE and view Data in Apache Superset

Download Resources for Hive

Creating Charts and Dashboards

Line Chart (Hands On)

Big Number with TreandLine Chart (Hands On)

Table (Hands On)

Bar Chart (Hands On)

Area Chart (Hands On)

Time Series Bar Chart (Hands On)

deck.gl Polygon (Hands On)

Pie Chart (Hands On)

Time Series Table (Hands On)

Pivot Chart (Hands On)

Histogram (Hands On)

Big Number (Hands On)

deck.gl Scatterplot (Hands On)

deck.gl Arc (Hands On)

Heatmap (Hands On)

deck.gl Grid (Hands On)

Dual Line Chart (Hands On)

deck.gl Screen Grid (Hands On)

Tree Map (Hands On)

Box Plot (Hands On)

Sunburst Chart (Hands On)

Sankey Diagram (Hands On)

Word Cloud (Hands On)

MapBox (Hands On)

Calender HeatMap (Hands On)

Nightingale Rose Chart (Hands On)

Bubble Chart (Hands On)

Horizon Chart (Hands On)

deck.gl Path (Hands On)

Graph Chart (Hands On)

World Map (Hands On)

Country Map (Hands On)

Pivot Table v2 (Hands On)

HR Analytics Dashboard Project

HR Analytics Dashboard Project Part 1

HR Analytics Project

Data for HR Analytics Project

Download EmployeeAttrition.csv

Download SQL

Data Details

HR Analytics Dashboard Project Part 2

HR Analytics Dashboard Project Part 3

HR Analytics Dashboard Project Part 4

HR Analytics Dashboard Project Part 5

HR Analytics Dashboard Project Part 6

HR Analytics Dashboard Project Part 7

HR Analytics Dashboard Project Part 8

HR Analytics Dashboard Project Part 9

HR Analytcs Dashboard Project Part 10

Olympic Analytics Dashboard Project

Olympic Analytics Dashboard Project Part 1

Olympic Analytics Project

Data for Olympic Analytics Project

Download athlete_events.csv file

Data Details

Olympic Analytics Dashboard Project Part 2

Olympic Analytics Dashboard Project Part 3

Olympic Analytics Dashboard Project Part 4

Olympic Analytics Dashboard Project Part 5

Olympic Analytics Dashboard Project Part 6

Olympic Analytics Dashboard Project Part 7

Olympic Analytics Dashboard Project Part 8

Olympic Analytics Dashboard Project Part 9

Olympic Analytics Dashboard Project Part 10

Frequently Asked Questions

Can I join / query multiple tables at one time?

How BIG can my datasource be?

Why are my queries timing out?

Why is the map not visible in the geospatial visualization?

How to add dynamic filters to a dashboard?

How to limit the timed refresh on a dashboard?

What if the table schema changed?

What database engine can I use as a backend for Superset?

How can I set a default filter on my dashboard?

How do I get Superset to refresh the schema of my table?

Is there a way to force the use specific colors?

What Does Hours Offset in the Edit Dataset view do?

Preview - Apache Superset for Data Engineers (Hands On)