Brief Introduction
Install Apache Superset, Connect with MySQL/MariaDB/PostgreSQL/ClickhouseDB/Hive/Druid etc, Visualize & Create DashboardDescription
In this Course Participants will learn following Topics
What is Data Visualization and What is Apache Superset
Apache Superset Sample Dashboards-Sales/Purchase/Finance/Project & Portfolio Management/Content Analytics/Global Health Monitoring
How to Create Dashboard in Apache Superset with Drag and Drop Method
How to Install Apache Superset in Ubuntu with Command Line
How to Install Apache Superset with Miniconda in Ubuntu
How to Install Apache Superset in Fedora Workstation
How to Install Apache Superset in OpenSuse
How to Install Apache Superset in Windows 10 Pro (Experimental Only)
How to Install Apache Superset from Source in Ubuntu
How to Install Apache Superset with Docker in Ubuntu (For Reference Only)
How to Install Apache Superset with Helm Chart in Ubuntu (For Reference Only)
How to Install Apache2 in Ubuntu
How to Install MariaDB in Ubuntu
How to Install phpmyadmin in Ubuntu
How to load SQL file in MariaDB with phpmyadmin
How to load LibreCalc file in MariaDB with phpmyadmin
How to Install Database Dependencies for MariaDB/MySQL in Apache Superset
How to Connect MariaDB with Apache Superset
How to Upload CSV file in MariaDB from Apache Superset
How to Install MySQL in Ubuntu
How to Install MySQL Workbench in Ubuntu
How to Upload CSV file in MySQL from MySQL Workbench
How to load LibreCalc file in MySQL with phpmyadmin
How to load SQL file in MySQL with phpmyadmin
How to Upload CSV file in MySQL from Apache Superset (same as MariaDB)
How to Connect MySQL with Apache Superset
How to Install PostgreSQL in Ubuntu
How to Install Database Dependencies for PostgreSQL in Apache Superset
How to Connect PostgreSQL with Apache Superset
How to Upload CSV file in PostgreSQL from Apache Superset
How to Install ClickhouseDB in Ubuntu
How to Install Database Dependencies for ClickhouseDB in Apache Superset
How to Connect ClickhouseDB with Apache Superset
How to Install CrateDB in Ubuntu
How to Install Database Dependencies for CrateDB in Apache Superset
How to Connect CrateDB with Apache Superset
How to Install Database Dependencies for Apache Hive in Apache Superset
How to Connect Apache Hive with Apache Superset
How to Connect Apache Superset with Apache Druid (Previous Version of Superset with Druid cluster)
How to Install Apache Drill in Ubuntu
How to Install Database Dependencies for Apache Drill in Apache Superset
How to Connect Apache Drill with Apache Superset
How to Create Sales Filter in Apache Superset
How to Create Bar Distribution Chart in Apache Superset
How to Create Pie Chart in Apache Superset
How to Create line chart in Apache Superset
How to Create Time series stacked chart in Apache Superset
How to Create Partition Diagram in Apache Superset
How to Create Tree Map in Apache Superset
How to Create Big Numbers in Apache Superset
How to Create Big Numbers with Trend Line in Apache Superset
How to Create Word Cloud in Apache Superset
How to Create World Map in Apache Superset
How to Create Multi Line Chart in Apache Superset
How to Create Table View in Apache Superset
How to Create Pivot Table in Apache Superset
How to Create Calendar Map in Apache Superset
Requirements
- Requirements
- Yes, There are some prerequisites for this Course
- Apache Hive should be installed before connecting to Apache Superset
- Apache Druid should be installed before connecting to Apache Superset
- Participants should not practice all Installations and Database videos in same practice system as it might lead to data inconsistency
- To Perform Practical Exercises as shown in Lectures, Participants need to have Computer with Ubuntu Already Installed (Fresh Installation)
- Practice system should have atleast 8 GB RAM and I7 Configuration to walk through all the scenarios shown in Various Course Videos
- High speed internet
- Should have basic knowledge on how to enter commands in terminal
- Participants should try different Installation Methods of Apache Superset and Databases in separate practice systems else it can create data inconsistency
- Participants should have Theoretical knowledge of Docker Engine, Docker Compose, Kubernetes, Minikube, Helm Charts
- Participants should practice Course videos in Physical Machine Instead of Virtual Machine
- Basic knowledge of Databases is recommended
- It is also expected that Participants should have visited or visit official Websites of Apache Superset (Incubating) and Other Products mentioned in Course to have Complete understanding
- In case of any confusion or query, Please ask any question before/ during/after the course
Knowledge
- In This Course, Participants will learn:
- Basics of Data Visualization
- Basics of Apache Superset
- How to Install Apache Superset with Command Line option in Ubuntu
- How to Install Docker Compose and Docker Engine to Install and Run Apache Superset Docker Image in Ubuntu
- Participants will learn to Install Kubectl, Minikube, Helm to Deploy Apache Superset with Helm Charts in Ubuntu
- Participants will learn to Install Apache Superset from Source in Ubuntu
- Participants will learn to Install Apache Superset in Ubuntu
- Participants will learn to Install Apache Superset in Fedora Workstation
- Participants will learn to Install Apache Superset in OpenSuse
- Participants will learn to Install Apache Superset in Windows 10 Pro (Experimental Only)
- Participants will learn to Install Apache Web Server (Command Line) in Ubuntu
- Participants will learn to Install MariaDB in Ubuntu
- Participants will learn to Install phpmyadmin (Command Line) in Ubuntu
- Participants will learn to Install MySQL in Ubuntu
- Participants will learn to Install MySQL Workbench in Ubuntu
- Participants will learn to Install Database Dependencies for MySQL & MariaDB in Ubuntu for Apache Superset
- Participants will learn to Connect MySQL with Apache Superset in Ubuntu
- Participants will learn to Connect MariaDB with Apache Superset in Ubuntu
- Participants will learn to upload CSV file in MariaDB from Apache Superset in Ubuntu
- Participants will learn to upload SQL in MariaDB from phpmyadmin in Ubuntu
- Participants will learn to upload LibreCalc file in MariaDB from phpmyadmin in Ubuntu
- Participants will learn to upload CSV file in MySQL from MySQL Workbench in Ubuntu
- Participants will learn to upload SQL in MySQL from phpmyadmin in Ubuntu
- Participants will learn to upload LibreCalc file in MySQL from phpmyadmin in Ubuntu
- Participants will learn to Install PostgreSQL with PgAdmin4 in Ubuntu
- Participants will learn to Install Database Dependencies for PostgreSQL in Ubuntu for Apache Superset
- Participants will learn to Connect Apache Superset with PostgreSQL
- Participants will learn to Upload CSV file in PostgreSQL with Apache Superset
- Participants will learn to Install Clickhouse DB in Ubuntu
- Participants will learn to Install Database Dependencies for ClickhouseDB in Ubuntu for Apache Superset
- Participants will learn to Connect Apache Superset with Clickhouse DB
- Participants will learn to Install CrateDB in Ubuntu
- Participants will learn to Install Database Dependencies for CrateDB in Ubuntu for Apache Superset
- Participants will learn to Connect Apache Superset with CrateDB
- Participants will learn to Install Database Dependencies for Apache Hive in Ubuntu for Apache Superset
- Participants will learn to Connect Apache Superset with Apache Hive
- Participants will learn to Connect Apache Superset with Apache Druid (Previous Version of Superset with Druid cluster)
- Participants will learn to Install Apache Drill in Embedded Mode in Ubuntu
- Participants will learn to Install Database Dependencies for Apache Drill in Ubuntu for Apache Superset
- Participants will learn to Connect Apache Superset with Apache Drill
- Participants will learn How to Create Filter for Dashboard in Apache Superset
- Participants will learn How to Create Bar Distribution Chart Visualization in Apache Superset
- Participants will learn How to Create Pie Chart Visualization in Apache Superset
- Participants will learn How to Create Line Chart Visualization in Apache Superset
- Participants will learn How to Create Time Series Stacked chart Visualization in Apache Superset
- Participants will learn How to Create Partition Diagram Visualization in Apache Superset
- Participants will learn How to Create Tree Map Visualization in Apache Superset
- Participants will learn How to Create Big Numbers Visualization in Apache Superset
- Participants will learn How to Create Big Numbers with Trendline Visualization in Apache Superset
- Participants will learn How to Create Table View Visualization in Apache Superset
- Participants will learn How to Create Word Cloud Visualization in Apache Superset
- Participants will learn How to Create World Map Visualization in Apache Superset
- Participants will learn How to Create Pivot Table Visualization in Apache Superset
- Participants will learn How to Create Calendar Map Visualization in Apache Superset