Apache Superset

What is Apache Superset?

Superset is a modern BI app with a simple interface, feature-rich when it comes to views, that allows the user to create and share dashboards.

This app is simple and doesn’t require programming, and allows the user to explore, filter and organise data. The best part is… it’s Open Source!

What will you learn in this course:

In This Course, Participants will learn about:

Basics of Oracle VM Virtual box

How to Install Oracle VM Virtual box in Windows

How to Download & Install Ubuntu Studio with Oracle VM Virtual box in Windows

How to Install Apache Superset in Ubuntu Studio Virtual Machine

How to create basic charts i.e Filters, Pie Chart, Donut Chart, Line Chart, Bar Distribution Chart, Partition Diagram, Tree Map, Big Numbers with Trend line

Table view, Pivot Table, Time Series Stacked etc.

Finally creating Dashboard with the charts

Apache Superset Course Outline

1. Install Apache Superset

Overview of Apache Superset Features and Architecture

Install Apache Superset in Windows

Intall Apache Superset in Ubuntu.

2. Database Installation

Install Mysql Database in Windows and Ubuntu

Install Postgres Database in Windows and Ubuntu

3. Configure Prouction Database

Set Database for CSV upload

Connecting Your Own Data Sources

Setup Production database for data analysis and data visualization

4. SQL for Data Analysis (SQL in Postgres)

SQL 1. Querying Data

Select – shows you how to query data from a single table.

Order By – guides you on how to sort the result set returned from a query.

Select Distinct  – provides you a clause that removes duplicate rows in the result set.

SQL 2. Filtering Data

Where – filters rows based on a specified condition.

Limit – gets a subset of rows generated by a query.

Fetch– limits the number of rows returned by a query.

In – selects data that matches any value in a list of values.

Between – selects data that is a range of values.

Like – filters data based on pattern matching.

Is Null – checks if a value is null or not.

Table & column aliases – describes how to use table and column aliases in the query.

SQL 3. Joining Multiple Tables

Joins – shows you a brief overview of joins in PostgreSQL.

Inner Join – selects rows from one table that has the corresponding rows in other tables.

Left Join – selects rows from one table that may or may not have the corresponding rows in other tables.

Self-join – joins a table to itself by comparing a table to itself.

Full Outer Join – uses the full join to find a row in a table that does not have a matching row in another table.

Cross Join – produces a Cartesian product of the rows in two or more tables.

Natural Join – joins two or more tables using implicit join condition based on the common column names in the joined tables.

SQL 4. Grouping Data

Group By – divides rows into groups and applies an aggregate function on each.

Having – applies the condition for groups.

SQL 5. Performing Set Operations

Union – combines result sets of multiple queries into a single result set.

Intersect – combines the result sets of two or more queries and returns a single result set that has the rows appear in both result sets.

Except – returns the rows in the first query that does not appear in the output of the second query

5. Exploring and Visualizing Data

Filters

Bar Distribution Chart

Pie Chart

Donut Chart

Line Chart

Time Series Stacked Chart

Partition Diagram

Tree Map

6. Create your own dashboards

7. Handle Admin Features

Users

Role

Permission

8. Share Dashboard