Learn about installing Apache Superset on your local (with Docker), Learn about the complete working of Apache Superset
This course starts with the basics of Data Analytics world i.e. what is Data Exploration, Data Visualization and Data Analytics , how these 3 are closely related and what is the thin line between them. We explain what is Business Intelligence because Superset is widely used for Business Intelligence.
What you’ll learn
- The core concepts of Data Engineering i.e. Difference between Data Exploration vs Data Visualization vs Data Analytics. With focus on Data Exploration.
- What is Apache Superset and how it is different from the paid BI tools like Tableau, Power BI and Looker.
- Understanding the Apache Superset Architecture in detail, focusing on the end to end flow between the components.
- Exploring Apache Superset in Detail understanding what is Dashboard, Charts, DataSets,SQLLabs,.
Course Content
- Introduction –> 5 lectures • 18min.
- Apache Superset – Features ,Architecture and the E2E flow of Data in Superset –> 3 lectures • 19min.
- Apache Superset Setup –> 1 lecture • 27min.
- Walkthrough of the Apache Superset which we have just setup –> 4 lectures • 12min.
- In Detail understanding of Dashboards | Charts | Datasets | SQL –> 5 lectures • 1hr 39min.
- Making Different Charts –> 5 lectures • 1hr 26min.
- Connecting Apache Superset to Different Databases –> 4 lectures • 1hr 10min.
- Making your own Custom Metrics, Calculated Columns and Custom Queries –> 3 lectures • 32min.
- Advanced Analytics in Superset –> 4 lectures • 47min.
- RBAC – Role Based Access Control in Superset –> 2 lectures • 24min.
- Working with Configurations –> 1 lecture • 10min.
Requirements
This course starts with the basics of Data Analytics world i.e. what is Data Exploration, Data Visualization and Data Analytics , how these 3 are closely related and what is the thin line between them. We explain what is Business Intelligence because Superset is widely used for Business Intelligence.
Then it shows how to install the superset with the help of Docker Desktop . We learn Docker Desktop installation steps as well.
We load the already available Examples in Superset, by following simple commands.
Once we are in Superset this course walks through each and every UI element in detail , explaining the end to end flow as well i.e. how Dashboarding <>Charting<>Dataset<>SQL work in tandem
We Learn the different charts in detail (first learning the categorization of charts)
We also learn how to connect to other Databases like Postgres and MySQL
We also upload our own dataset in form of Excel
We learn what is semantic layer and what are custom metrics and calculated columns.
We learn the Role Based Access System in Detail (with the local setup of Superset)
We learn how to setup some config settings, especially around how to enable the MapBox API and also how to setup the Max Row Limit.